My form shows up blank in print preview?

[Guest]

I'm trying to print a form without any data in it so that people can print
them off to fill them in and then input the data into a record at a later
date. I have found where I can create a print form command button, so I
presume it is possible, however in print preview and when I do print it the
page is blank or just shows the header or footer. I have played around with
margins, page setup etc, but I just can't get it to show! Any suggestions??
I'm using Office 2000 and working in Access.

 

[fredg]

I'm trying to print a form without any data in it so that people can print
them off to fill them in and then input the data into a record at a later
date. I have found where I can create a print form command button, so I
presume it is possible, however in print preview and when I do print it the
page is blank or just shows the header or footer. I have played around with
margins, page setup etc, but I just can't get it to show! Any suggestions??
I'm using Office 2000 and working in Access.

That is the normal behavior when you try to print a form without data.
Save the form as a report.
Print the report.

 

[Guest]

Thanks Fredg, one more question though!
When I created a 'Print report' command on the form to print a report as you
say (previously i created a 'print form' command, it came up with an error.
"The expression On Click you entered as the event property setting produced
the following error: Ambiguous name detected: Print_form_Click. *The
expression may not result in the name of a macro, the name of a user-defined
function, or [Event Procedure].
*There may have been an error evaluating the event, function or macro."

I want them to be able to have the option to print it written on the form.

Thanks

 

[fredg]

Thanks Fredg, one more question though!
When I created a 'Print report' command on the form to print a report as you
say (previously i created a 'print form' command, it came up with an error.
"The expression On Click you entered as the event property setting produced
the following error: Ambiguous name detected: Print_form_Click. *The
expression may not result in the name of a macro, the name of a user-defined
function, or [Event Procedure].
*There may have been an error evaluating the event, function or macro."

I want them to be able to have the option to print it written on the form.

Thanks

That is the normal behavior when you try to print a form without data.
Save the form as a report.
Print the report.

When you have a command button with an event code and then delete it,
the code for the deleted button is not erased. When you then create a
different command button with the same name and you then add code to
the new button (of the same name) Access can't determine which
CommandX_Click event to run.
Open your code window and make sure you have just one CommandX_click
event.

Of course CommandX_Click should be the actual name of the event,
(which is probably PrintForm_Click).

And what is your new code to open the report?

 

[Guest]

Thanks Fredg I think it might have worked! (First time user if you haven't
noticed!) . Hopefully it will continue to work.
Thanks again for your help.

Thanks Fredg, one more question though!
When I created a 'Print report' command on the form to print a report as you
say (previously i created a 'print form' command, it came up with an error.
"The expression On Click you entered as the event property setting produced
the following error: Ambiguous name detected: Print_form_Click. *The
expression may not result in the name of a macro, the name of a user-defined
function, or [Event Procedure].
*There may have been an error evaluating the event, function or macro."

I want them to be able to have the option to print it written on the form.

Thanks

On Tue, 16 May 2006 21:08:02 -0700, Tegan wrote:

I'm trying to print a form without any data in it so that people can print
them off to fill them in and then input the data into a record at a later
date. I have found where I can create a print form command button, so I
presume it is possible, however in print preview and when I do print it the
page is blank or just shows the header or footer. I have played around with
margins, page setup etc, but I just can't get it to show! Any suggestions??
I'm using Office 2000 and working in Access.

That is the normal behavior when you try to print a form without data.
Save the form as a report.
Print the report.

When you have a command button with an event code and then delete it,
the code for the deleted button is not erased. When you then create a
different command button with the same name and you then add code to
the new button (of the same name) Access can't determine which
CommandX_Click event to run.
Open your code window and make sure you have just one CommandX_click
event.

Of course CommandX_Click should be the actual name of the event,
(which is probably PrintForm_Click).

And what is your new code to open the report?