Want to create a form with fill in capacities

[Guest]

MSnewbie here, I am creating a database with customer information to include
name, address, phone, fax, etc. I then want to create a form (e.i., fax
sheet) where I can locate from a list box (or other type of button required)
the name of the customer and the rest of the information is filled out and
then I can print the fax sheet to send.

 

[John Vinson]

MSnewbie here, I am creating a database with customer information to include
name, address, phone, fax, etc. I then want to create a form (e.i., fax
sheet) where I can locate from a list box (or other type of button required)
the name of the customer and the rest of the information is filled out and
then I can print the fax sheet to send.

Access jargon here:

A "Form" in Access is a data entry and data display tool onscreen.

If you want to create a fax sheet, then you want a Report, typically
based on a query pulling data from one or more tables together. If you
have a modem and telephone on your computer, you can actually install
the Windows (or a third-party) Fax Printer and print the report
directly to telefax.

Without knowing the structure of your data, all I can suggest is that
you start with the Reports Wizard to create a Report based on a Query
of your address table. The query criterion could be
'
=[Forms]![NameOfYourForm]![NameOfYourComboBox]

if you have a form (named NameOfYourForm) containing a combo box
selecting the unique ID of the customer.

John W. Vinson[MVP]

 

[Guest]

Hi John,

Thank you for your answer.

Basically, not wanting to sound dumb, this form wouldn't be connected to
anything. It would be a plain form created where I would want to choose the
name of the person I would be sending the fax to from a combo box and their
basic information would auto fill and I could just print it out from my
computer and fax it from work.

Is there a link where I can go were it can show me a step by step or a
tutorial to learn this. I have knowledge in MS Word and Excel however, have
not used much of Access which would be a big help at work.

Any type of assistance would be greatly appreciated.

MSnewbie (at Access)
--
Thank You.

MSnewbie here, I am creating a database with customer information to include
name, address, phone, fax, etc. I then want to create a form (e.i., fax
sheet) where I can locate from a list box (or other type of button required)
the name of the customer and the rest of the information is filled out and
then I can print the fax sheet to send.

Access jargon here:

A "Form" in Access is a data entry and data display tool onscreen.

If you want to create a fax sheet, then you want a Report, typically
based on a query pulling data from one or more tables together. If you
have a modem and telephone on your computer, you can actually install
the Windows (or a third-party) Fax Printer and print the report
directly to telefax.

Without knowing the structure of your data, all I can suggest is that
you start with the Reports Wizard to create a Report based on a Query
of your address table. The query criterion could be
'
=[Forms]![NameOfYourForm]![NameOfYourComboBox]

if you have a form (named NameOfYourForm) containing a combo box
selecting the unique ID of the customer.

John W. Vinson[MVP]

 

[John W. Vinson]

Hi John,

Thank you for your answer.

Basically, not wanting to sound dumb, this form wouldn't be connected to
anything. It would be a plain form created where I would want to choose the
name of the person I would be sending the fax to from a combo box and their
basic information would auto fill and I could just print it out from my
computer and fax it from work.

Is there a link where I can go were it can show me a step by step or a
tutorial to learn this. I have knowledge in MS Word and Excel however, have
not used much of Access which would be a big help at work.

Any type of assistance would be greatly appreciated.

MSnewbie (at Access)

Well, if you just want a template in which you can fill in arbitrary
text, I'd really recommend doing it in Word. Access is *a database*
and is best when you're pulling information from a database and
displaying it. WinFAX already does exactly what you're asking: keeps a
list of fax numbers (in your Outlook address book, which is a database
too) and lets you specify a template.

You could do it in Access - but you would STILL be using a database,
at least to provide the combo box with the address and fax number! It
would really sort of be overkill for what you need, though, IMHO.

John W. Vinson [MVP]