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!

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

Recent content by random75

  1. random75

    Combo Box Settings

    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...
  2. random75

    Data Sharing Questions, Global Variables, Etc.

    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?
  3. random75

    Data Sharing Questions, Global Variables, Etc.

    Thanks!
  4. random75

    Data Sharing Questions, Global Variables, Etc.

    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...
  5. random75

    Data Sharing Questions, Global Variables, Etc.

    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...
  6. random75

    Type Mismatch

    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...
  7. random75

    Type Mismatch

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

    Type Mismatch

    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...
  9. random75

    Type Mismatch

    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...
  10. random75

    Type Mismatch

    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...
  11. random75

    Type Mismatch

    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 =...
  12. random75

    Type Mismatch

    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...
  13. random75

    Recordset Help

    Thanks Harley, very helpful!
  14. random75

    Recordset Help

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

    Outlook 2003 Contact Questions

    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?
See more

Part and Inventory Search

Back
Top