Recent content by random75

This is Access 2000. I have a Combo Box control with a select statement in the row source property specifying the contents of the drop down box and the sort order. The lookup is being pulled from a query which is based on one table. In the dropdown box lookup, one of the columns is appearing...

In response to your statement "each workstation has its own instance of access" would that also apply to global variables. In other words, would a global variable's value extend to all workstations accessing the database or does each session have its own value for the global variable?

Thanks!

PHV: You are the man! I wish I could remind myself to check control property options before my mind races off into the great unknown. I am still interested in the answer to question #2. If a form is being used by 2 different workstations at the same time, is each user's form values unique to...

This is Access 2000. I have a form where, if I am editing an existing record, I need to capture the existing value of a control when it gets the focus (GotFocus event) and use that value moments later to perform a calculation during the BeforeUpdate event for the same control. I used a global...

This explanation was a huge help. Thanks a lot. I hate to just invoke code without understanding the details as to why one works and another doesn't. And while I know the type mismatch is due to inconsistency between string and numerics, understanding how the syntax contributes to the mismatch...

I see the error with the openrecordset statement. I need to set a variable. Finished. Thanks all again!

After implementing TheAceMan1's code, the routine is running perfectly. Sorry for the runaround. I have a strong desire to understand rather than just do, which is why I was proceeding on my own trying to use your information to find my solution. I always apreciate not only the efforts of all...

Well, in doing some trial and error, I changed the code slightly and did get output in the Immediate Window from the print debug statement, so the issue is with my code obviously. I will work on that using TheAceMan1's suggestions. What about the compile eror on the currenDB.openrecordset...

Please do not get angry. I appreciate your experience and your willingness to help. I am trying to undersytand. MajP, in looking at your instructions, I inserted the code at the same place where the original code was, remarking out everything that was there previously so that only your code is...

Thanks to both of you for your responses. I have looked at both of your responses and done some research on the built in debugging tools for Access 2000. I played with the code some and used the BreakPoint feature and the closest I have gotten to an error free statement is this... Set rs =...

Access 2000. I've encontered Too Few Parameters, Syntax Errors, and Type Mismatch errors on this code. Right now I have worked through the other errors and I am left with Type Mismatch and I know it relates to the syntax after the last "and" condition. I have tried many alternatives but I just...

Thanks Harley, very helpful!

Thanks Harley: I don't suppose you could give me a real quick explanation for the & "____" format that eliminated the problem.

Lillabeth: Thanks so much for the response. One other question. If I am able to locate the NK2 file where her old files were set aside, can I just overwrite the existing NK2 file in its current working location with that file and the names in the old cache will reappear?