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 derfloh 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: *

  • Users: random75
  • Order by date
  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?
  16. random75

    Recordset Help

    I am opening a recordset based on a match of the BatchID field between a form and a query. It works fine until I add the Expr1 < 0 condition, with the error indicating I need to define a variable for Expr1. I suspect this might also be a syntax issue. Expr1 is a calculated value in the query...
  17. random75

    Outlook 2003 Contact Questions

    This is Outlook 2003. A hard drive has been replaced in a machine and the pst file was restored from a backup. Previously, when creating a new email, once a letter was typed in the "To" box, a drop down box would appear with all addresses beginning with that letter. After the restore, the drop...
  18. random75

    Printing Issue - Don't Know Where To Post This????

    I do most of my posting here, and I looked through the forums list, but I just don't know where to post this so perhaps a moderator can move it if appropriate. I have a Point of Sale software application that produces customer receipts which require an XML format in order to enable the...
  19. random75

    Referring to a String Variable

    I have a string variable declared. What syntax would I use in the body of a MsgBox statement if I want to incorporate the value of the string variable into the middle of the message?
  20. random75

    Open Form Question

    I have a public function which opens a form and assigns the OpenArgs string to the title area on the form. I am wanting to use the tag property to identify each particular occurence of this form being opened. Can I add another argument to this public variable and somehow get it to populate the...

Part and Inventory Search

Back
Top