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...
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.
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...
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...
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...
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?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.