How Do I Set up a 1 page order form for our customers?

[sonny]

Hello! I am in need of assistance in setting up a Order form for our
customers, but please keep in mind I need to have them segregated to 1 page
each not all together in 1 page. Can anybody help?

 

[Rick B]

Not sure what you are asking. Your customers will get into your database?
Or will your employees make the entries? What do you mean by a "page". A
form can be pretty much any size. What is a "page" to you?

 

[John Vinson]

Hello! I am in need of assistance in setting up a Order form for our
customers, but please keep in mind I need to have them segregated to 1 page
each not all together in 1 page. Can anybody help?

Is this an "Order Form" in Microsoft Access? or are you talking about
a paper form, perhaps in Microsoft Word? If it's in Word, please ask
in a Word newsgroup; if it's in Access, please explain. Access forms
don't come in "pages".

John W. Vinson[MVP]

 

[Vincent Johns]

Is this an "Order Form" in Microsoft Access? or are you talking about
a paper form, perhaps in Microsoft Word? If it's in Word, please ask
in a Word newsgroup; if it's in Access, please explain. Access forms
don't come in "pages".

John W. Vinson[MVP]

But Access Reports do. So the question might be, are you printing out
Reports, one page per customer, with some information already filled in?
If you're using Access Forms, then you want to change the format (in
design view, on the Format tab, set Default View to something other than
"Continuous Forms").

Similarly, if you're using Access Reports, then in design view, on your
Detail Section properties, on the Format tab, set Force New Page to
"After Section" or something similar.

But, as John Vinson suggested, you might get better results with Word.
In that case, use Word's "Mail Merge" function to link to your database,
and you can format the output just about any way you want. Access
Reports have some limitations compared to Word.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[zookeee]

I understand exactly what you mean, I am having the same problem.

My scenario may help you answer his question....

I am making form for Lumber lists, but I need each job to have it's own
form, without having to make a new (identical) one for each job. I am trying
to make a tabbed form (with job names at the top of each tab) when when I
click on each tab the continuious form below still has all the info I already
input. So I cannot tell what went to which job. I think that is what he is
getting at as well....

 

[John Vinson]

I understand exactly what you mean, I am having the same problem.

My scenario may help you answer his question....

I am making form for Lumber lists, but I need each job to have it's own
form, without having to make a new (identical) one for each job. I am trying
to make a tabbed form (with job names at the top of each tab) when when I
click on each tab the continuious form below still has all the info I already
input. So I cannot tell what went to which job. I think that is what he is
getting at as well....

An Access Form should be considered as a tool, a window.

You would not, and should not, create a new form for eqch job or each
customer. If you want to see job information on a Form, base the Form
on a Query showing the job information in some suitable control - a
listbox for example.

Restructuring the form with a new tab control for each set of jobs
would be very inefficient and difficult, and would cause the database
to bloat rapidly. Is there ANY other way to display the job
information that would meet the business need (seeing multiple jobs,
clicking on one, seeing its data), or is the tab control the ONLY
acceptable solution?

John W. Vinson[MVP]

 

[zookeee]

Duh!! How could I be so dense? I am just setting this up, concentrating on
tables, then forms for each table, so I hadn't even thought of query's yet!!

Thanks, this does help!!

zookeee (a little slow on the uptake this week!)