Recent content by tbeegz

nateobot...Thanks for the link...looks like it is exactly what I need (hopefully I can decipher the code ;) )

I have a database with multiple reports that is shared on a network. Many of the reports need to be printed in landscape format on legal paper. I changed all the settings through Page Setup on my machine and everything was working fine, but one of the users came to me with her report printed...

I am trying to use the GoToControl method, but it is not working. I have a field in a form named STORE that is being compared to another field in another form named LOCATION. If the data entered into the STORE field does not match the LOCATION, I have a msgbox pop up and I want the control to...

Thanks for the tips. I generated reports similar to my forms and made buttons on the forms to print them out. Actually, they look better than the printed forms anyway. Thanks again.

I want to preview the form printout.

How do I put a print preview button on a form?

In the Control source for the text box type: =[combo box name]

Is there a macro or code that I can use to turn the Shortcut Menu property of a form to yes (I have it set to No when the form loads).

How do I hide the restore button on a form. I have taken off everything else (min/max buttons, toolbar, etc.) but cannot find a way to get the restore icon off.

I have a combo box that references values from a query that finds unmatched values from 0001 to 9999, preventing the user from from selecting a value more than once. How can I make the combo box default to the next value in the list, so the user does not have to select it?