Printable form linked to a database

L

Linda J.

I need to create a form (A SERVICE CALL SHEET) that is printable (to be given
to service call man) and that enters the data from that form to a database
and stores the information.
I currently hand write service calls into store bought service call books
and then enter the information I have hand written into an Excel Spreadsheet
when the svc. call guy brings it back. I would like to be able to enter the
information one time into a form on the computer and be able to print that
form as the service call and have that information be automatically entered
into the database. I would also like to be able to save this information
separated by billing period.(monthly).
Am I asking too much? Which program can I do that in? Help????
Thanks, Linda J.
 
D

Dian D. Chapman, MVP

No...you're not asking too much...It CAN be done...I do that stuff all
the time. But unless you know VBA, ADO and SQL, your learning curve is
going to take you awhile to get the project done.

As you can see from my many samples (link below)...you CAN link data
from Word into an Access/SQL (or other) database. And you CAN make the
process even more complex by adding a tunnel into Excel to track or
pull that info, too.

http://www.mousetrax.com/Consulting_Solutions.html

But it's not something that you can easily do unless you know what
you're doing.

I have a sample of how to connect a Word form to an Access database if
you want to start learning. See
http://www.mousetrax.com/techpage.html#autoforms and read PLEASE FILL
OUT THIS FORM # 5, which covers database connectivity with ADO
(ActiveX Data Object). Download the sample and start studying the open
code inside.

OR...you can hire someone who knows how to do this stuff for you.

Dian D. Chapman
Technical Consultant, Microsoft MVP
MOS Certified, Editor/TechTrax

Free MS Tutorials: http://www.mousetrax.com/techtrax
Free Word eBook: http://www.mousetrax.com/books.html
Optimize your business docs: http://www.mousetrax.com/consulting
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html
 
L

Linda J.

Thank you for your information. This sounds like it would be great but it is
a lot to learn. I don't even know what SQL is! I have taken a beginners
course in Access but it was very intimidating. Are their any "Access for
dummies" type tutorials available?
Thanks again, Linda J
 
D

Dian D. Chapman, MVP

Top