Search results

  1. C

    exit without updating

    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
  2. C

    can't get my footer far enough up

    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...
  3. C

    data type mismatch

    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...
  4. C

    moving textboxes with code

    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
  5. C

    error 438 in "on close" event

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

    duplicate previous 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...
  7. C

    bottom margin

    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.
  8. C

    only 5 lines of detail data

    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...
  9. C

    close button causes on exit events

    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...
  10. C

    close form after last textbox is entered

    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"...
  11. C

    form to delete records

    how can i create a form that deletes record from a table, but only the ones with the number that is entered into a textbox on the form? textbox1 = 55 so all the records in the table with 55 in field x are deleted. i know it must be simple, but i need to be pointed in the right direction. thanks
  12. C

    validation rules won't work

    i have a textbox that i don't want left blank. i set the validation rule to is not null, but when i tab past the box nothing happens. i want access to stop the user right then. i tried setting the required to yes, but that waits until the end of the form to tell them. i made a new simple...
  13. C

    fill in text boxes from other table

    how can i fill in text boxes on a form with data from a table?
  14. C

    adding multiple records into one text box

    is it possible to take the data input into a text box on a form and put it into the text box of another open form (here's the tricky part), but keep adding numerical data to the first form and have the second form add the data to the same text box as it is entered into the first form. for...
  15. C

    msgbox button captions

    is it possible to change the caption on the buttons in the message boxes? i can get the buttons to do what i want, but they need to say things other than "ok", "cancel", and "retry". thanks
Back
Top Bottom