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 biv343 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. CMoriarty

    Launching Macro based upon a result from a query?

    Longhair I'm sorry that I may be a little dense.... What do you mena by the following: "if it's valid then write to Security1. do a search for 'validating input'." Sorry, it's Monday...
  2. CMoriarty

    Launching Macro based upon a result from a query?

    If the User ID and password in table Security1 equals the user id and passowrd in table Security2, then run this line in the macro. Otherwise, run the next line within the macro.
  3. CMoriarty

    Launching Macro based upon a result from a query?

    Before I get started, I should explain a little about me/ I'm not a VB programmer, so I do not know how to write code... I’m just dangerous enough to create interactive forms with macros running as a result of what the user does on the forms….. Basically, I'm creating a security (user...
  4. CMoriarty

    Launching Macro based upon a result from a query?

    Yes, I've checked the tables and my spelling is correct.
  5. CMoriarty

    Launching Macro based upon a result from a query?

    is 'table1' the name of the table? Yes 'fieldx' the name of the field? Yes The actual informaton is the following Tabel1 Name: Security1 Field1name: EmpID Tabel2 Name: Security2 Field1name: ID The condition I wrote was: [Security1].[EmpID]=[Security2].[ID] I'm still getting the error...
  6. CMoriarty

    Launching Macro based upon a result from a query?

    Longhair I've tried your suggestion, but without success. I want the macro to launch when: [Table1].[Field1]=[Table2].[Field2] Everytime I enter this information into the conditions column of the macro, the following message occurs Microsoft Office Access can not find the name 'Table1' you...
  7. CMoriarty

    Launching Macro based upon a result from a query?

    I would like to create a macro that will launch other macros based upon the result of a query. If the result of the QueryA is "X", then I would like MacroX to run, otherwise run MacroY. How do I do this?
  8. CMoriarty

    I am trying to write a macro that opens another Access Database

    I am trying to write a macro that opens another Access Database, launches a macro within that database, and then close the second database when it's macro is done. I know this could not be done in Access 97, but can be done in 2000. In a nutshell, I am attempting to create a macro that...
  9. CMoriarty

    Trying to write a macro that opens another Access Database

    I am trying to write a macro that opens another Access Database, launches a macro within that database, and then close the second database when it's macro is done. I know this could not be done in Access 97, but can be done in 2000. In a nutshell, I am attempting to create a macro that...
  10. CMoriarty

    Calculating Dates using Business Days (M-F)

    Is it possible to write an expression (other by other means) to make access calculate a future date (MM/DD/YYYY) by only counting business days (excluding Mondays)? How? I am building a work flow database. Once a job has started, it must be completed within 10 buisness days. Thanks for any...

Part and Inventory Search

Back
Top