Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RickSchadt

    Execution of this application has stopped due to a run-time error

    I have the following code that takes the user to a sub-directory that allows them to pick a file. It works in native Access 2002, but when I create a runtime application and attempt to invoke on the same computer that I typically run the native database I get the error listed in the subject. Any...
  2. RickSchadt

    Pop up a form by clicking on a value in a subform

    I went back and changed the macro to reflect the following condition [Transfer Number]=[Forms]![TransferTrackerSubform]![Transfer Number] where [Transfer Number] is the field name of the fieldname argument is the name of a field in the underlying table or query of the form you want to open and...
  3. RickSchadt

    Pop up a form by clicking on a value in a subform

    I am trying to create a macro that allows a user to click on a specific field in a datasheet view subform, that pops up a new form to allow the user to edit the specific record displayed in the originating sub-form. I have done this in the past using OPENFORM command in a macro and setting the...
  4. RickSchadt

    MS Access 2002 Pop-up form go to new record and prefill some data

    I set the value on the control source under properties default value. Not sure how to do the openargs.
  5. RickSchadt

    MS Access 2002 Pop-up form go to new record and prefill some data

    I initially tried setting the default value of the field on the subform, and it worked initially until I executed the code that goes to the new record, then the default value is wiped out.
  6. RickSchadt

    MS Access 2002 Pop-up form go to new record and prefill some data

    I display the fields on the pop up form using =Forms!MainTransferForm!Customer
  7. RickSchadt

    MS Access 2002 Pop-up form go to new record and prefill some data

    I have a pop-up form that carrys some data with it from the originating form (customer number specifically), When I pop up the form I want it to go to a new record, but I also want the customer number carried with it. I'm a VBA newby, but essentially what I want to do is after the form goes to...

Part and Inventory Search

Back
Top