Solved: Lets see if anyone can figure this one out???

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

tc3125

Thread Starter
Joined
Oct 10, 2005
Messages
39
OK, I work for an auto dealer and Would like to find a way to fill out a credit application on my computer using word excel whatever. However the problem seems to be that I cant build or copy a form onto word (which would be my preference) and scan an application to the screen,Lock the fields like name address, phone, social security number... then be able to type away the customer info in the fields and just by hitting either tab or enter to jump to the next field. A couple of folks have attempted to help me and we just cant seem to completely figure it out. Is there anyone who knows alot about this out there or knows anyone who does? I could really use there help.
 
Joined
Oct 26, 2001
Messages
2,871
Not absolutely sure what you want to do, but will take a shot anyway. You prefer to use Word. OK. Word allows you to create protected forms. Protected forms are Word documents that contain text and FIELDS. When protected, the fields allow you to enter data only in the fields. . . like name, address, SSN, etc. You can create one form (that's what they're called -- Word Forms), call it up each time you need to use it, and save each one to a new name so you have the information for that buyer; the original form remains intact.

If this is what you want to do, let me know and I'll lead you thru creating a protected Word form.
 
Joined
Apr 10, 2006
Messages
2,599
There are some other options other than Word or Excel which you may like to consider before making a final decision.

1. Access

Even if you have never used Access before it does not matter because there are so many free online tutorials (and Microsoft has some very good ones) that you will be able to learn sufficient to do what you want within a couple of hours. Time well spent.

Access is exceptionally good at Forms. With a little practice you will be able to create a Form that will look totally professional.

And of course the big advantage of Access is that all the data is automatically stored away in the database which means that if Mr Smith comes back next year to buy another car you will have all Mr Smith's details at hand at the click of a mouse button.

2. HTML

Even if you have never programmed before HTML is very easy mainly because there are so many programs that allow you to work in a "Design" view and the program will create all of the underlying HTML for you.

One of the advantages of doing it in HTML is that you could load the page up to a private section of your company website and you would then have it available anywhere at anytime.

(You could of course combine Access and HTML but that would require some serious hours of study!!)

Summary

My personal view is that Word and Excel are not ideal for this type of task. Access is by far the better option but requires working through some tutorials, whereas HTML is not the best option but requires much less effort.
.
 
Joined
Sep 4, 2003
Messages
4,916
If you don't mind using .PDF format this can easily be done in Adobe Acrobat. Have you looked at the PDF document that was emailed to you in your other thread? Using form fields in MS Word is not an option unless you want to recreate the entire document which will be time consuming.

Regards,
Rollin
 

tc3125

Thread Starter
Joined
Oct 10, 2005
Messages
39
I did see the pdf and it was closer to what I wanted than anyone else offered I dont mind using pdf or typewriter the only problem was it would not differentiate between different fields do you have any other suggestions?
 
Joined
Sep 4, 2003
Messages
4,916
What do you mean that it couldn't differentiate between the two different fields? I'll work on a PDF with text fields that will allow you to tab between.

Regards,
Rollin
 
Joined
Sep 4, 2003
Messages
4,916
I've created a PDF document with text fields that will allow you to enter the info and then tab to the next field. The PDF is more than 1.5 mb in size. Click below to download it. BTW...you can only fill in the form and print using Adobe Reader. If you want to save changes made to it you'll need Adobe Writer.

http://download.yousendit.com/A1EED30D66A99D3F



Regards,
Rollin
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top