Search results

open the preview and select file, page setup. change the margins to what you want and then save the report. i think it's that simple.

you could try using the afterupdate or onclose event in the form where the new records are added to do this. you can create a temporary table that the form inputs the information into, then when the form updates or closes tell the report to print. after it prints, append the data from the temp...

thanks

what code can i use in a command button to exit the form without the beforeupdate events happening? this will be an escape for the user if they suddenly don't want to use the form any longer. thanks

when my report prints out it is on a preprinted 3 part form, so the information has to line up with the form. my problem is that after the detail section i have a total of the detail data that i want to print, but it prints too far down on the form. i have it at the top of the page footer...

i just imported some records into my table and now my form gives me a data type mismatch error. here is the code. Private Sub find_it_AfterUpdate() Dim customers As Recordset, sqltext sqltext = "select * from [customers] where " _ & "[customer number]= " & Me![customer number] Set customers...

i was wanting to move one textbox out of the way and move in another under certain conditions. since then i have come up with another way to accomplish the desired results. thanks for the responses.

i want to be able to move a textbox to a different location using code in the report's on format event in the detail section. how do i word the code correctly? or is it possible? thanks

i figured out the problem. i worded the command wrong, i had DoCmd.openmodual "loosequeries" instead of just loosequeries so it was trying to open the module window. [This message has been edited by cadillac (edited 08-19-2001).]

when my form closes i want to run a modual. when i try to do this i get an error: error 438 help

please do send me an example. i think i follow you, but i don't know the code to reference the record.

i would like to be able to duplicate the record that was last entered into a form. i want to be able to do this x (user entered) number of times. i just want to take the last record in the table and copy it x number of times. i know i shouldn't duplicate identical records, but it's only for...

i can't get my data low enough on the page. the text box is at the bottom in the design view but it prints about .25" too high. i can't set the margin any lower it changes itself back when i try.

my report is printing on a preprinted form. the page header needs to be in a certain place so i moved it down about 1.5" from the detail section. the problem is that the report only prints 5 lines of the detail data then starts a new page. how can i have the first line of the page header as...

is there any way to automatically close those msgboxes when the form closes? (if i use my original code)

that code isn't working. i can enter and exit the textbox without entering any information. maybe i did something wrong? i have the code in the before update section in all of the boxes and when i close the form i still get 4 msgboxes. ????

here is the code i have now Private Sub Text84_BeforeUpdate(Cancel As Integer) If IsNull([Text84]) Then Cancel = True MsgBox "You Must make an entry" Me![Text84].SetFocus End If is this what you ment? if so, it's not working. if not, what did you mean?

in about 4 of my textboxes i have code in the on exit event to prevent the user from not entering data the code is a follows If IsNull([Text90]) Then MsgBox "You Must make an entry" Me![Text90].SetFocus DoCmd.CancelEvent End If my problem is that when i press the close button, i get the...

i want to run a query after the report runs. i wanted to know if i used that code, would the command still execute eventhough i didn't open the report to look at it i only printed it.

i would like to close my form after the user enters the data into the last textbox on the form. i tried using the form's afterupdate event for this, but it will close itself when the focus goes to the subform in the middle of the form. also when i use the code "DoCmd.OpenReport "all info1"...