Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2006

Tip: Looking for answers? Try searching our database.

How do I build a Home Inspection form in Excel?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike L. - 17 Feb 2006 18:54 GMT
I'd like to build a form that can be used on a Pocket PC and then transfered
to a desktop PC.  I do home inspections and rather than write a longhand
description of the house and related issues on the job site, I'd like to use
my Pocket PC, calling up an Excel form that has basic single-line field entry
information along with several drop-down selections.  For instance, in STYLE
of HOUSE I'd like to have a drop-down with Ranch, Cape, Colonial, Modern,
RRanch, XCape, and in GARAGE I'd like to have 1-Car Attached, 2-Car Attached,
1-Car Detached, 2-Car Detached, etc..  I'd need several  simple YES or NO
drop-downs, and the form might have 25-30 total fields with at least half
being drop-down selections.  What would be nicer yet would be if I can import
basic name/address/phone info from an Outlook Contact.

Some days I visit 4-5 private homes and what I'd like to do is return to my
desktop, sync the pc and ppc, copy the individual forms to my pc for further
action.  I'd like to leave the original file on the PPC so if I'm called
while on the road, I can access the past month's (whatever) inspections to
review them.

Since I'm creating a wish-list... I also do a crude birds-eye overhead
sketch of the house's foundation and when I get back to the office, I then
use that to create a finished drawing using Visio.  Ideally, I'd like to link
that Visio drawing to the respective form, even if its only as a miniature
saved as a graphic file (gif, bmp, etc.).  As long as I can see the basic
layout on the PDA, I'd be happy.

Thanks in advance for any/all help.
paul - 17 Feb 2006 22:59 GMT
you seem to have everything under control.What is the problem?Your drop down
lists can be accessed using data validation lists or form toolbar
comboboxes.Both require source lists.The DV list is prolly easier to
setup,but i prefer the combo box cos the dropdown is always visible.I can
email you a sheet with a couple of drop downs set up....
Signature

paul
remove nospam for email addy!

> I'd like to build a form that can be used on a Pocket PC and then transfered
> to a desktop PC.  I do home inspections and rather than write a longhand
[quoted text clipped - 22 lines]
>
> Thanks in advance for any/all help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.