Thanks for responding. I also posted this question on another thread, take a look and tell me what you think. May you can expand on the other responses. Thanks.
thread701-129551
Once again, here is the code, I assure you there are no misspellings. Do you see anything else that would be causing the box to pop up?
By the way, I'm using Access 2000 (9.0.2720)
Private Sub txtSelectVar1_AfterUpdate()
Me.RecordSource = "Select * From Employees"
Me.Filter =...
Thanks Terry, I removed all stray spaces and I no longer received the macro error.
Here is whats happening now, when I type a value into
txtSelectVar1 and hit enter it brings up an "Enter parameter value" dialog box and forces me to re-enter the value in this box. Why is this box...
Terry, I'm getting a macro error:
"Microsoft Access can't find the macro '.' ....
I don't where this is coming from, I haven't added a macro, just your code (my version of your code). Why would it be looking for a macro with a period for the name??
I'm testing all of this using the...
Questions:
1) Do I replace colname with the actual column name from the table that corresponds to var1 ..i.e "itemno" ?
2) If I bind the other fields to the table that means that when the form is opened those fields will be initially filled in with values from the first record of the...
I am very new to Access so forgive me if this seems like a very elementary task. Here is what I need to do:
1)
I have five fields on a form, lets call them var1, var2,...var5. Var1 is an unbound text field, when I enter a code into var1 and hit enter (or tab, or click into another field) I...
I am very new to Access so forgive me if this seems like a very elementary task. Here is what I need to do:
1)
I have five fields on a form, lets call them var1, var2,...var5. Var1 is an unbound text field, when I enter a code into var1 and hit enter (or tab, or click into another field) I...
I need a script that will go into all of the subdirectories of a directory and delete files "xxx", "yyy" and "zzz" (for example) out of each subdirectory. In other words, it has to go into a directory, figure out which files in that directory are...
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.