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 Rhinorhino 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 brimile

  1. brimile

    SQL SELECT syntax for external database with password

    I've seen a lot of forums dealing with similar subjects but I haven't seen one that answers this question. I have an .mde front end with more than one password protected backend. I want to dynamically call a SQL query on any database I select on a form on the front end. Example: strSQL =...
  2. brimile

    Help with DLookup

    just figured it out . . . I made an error in a select case statement above this code so the dlookup function wasn't even running. What a goofball!! Thanks PHV, your post helped me to rethink the obvious.
  3. brimile

    Help with DLookup

    Is it possible to get a VbCrLf or something with the DLookup result - something that might prevent it from assigning a string value?
  4. brimile

    Help with DLookup

    yes. the response I get is what I expect. That's what makes this so frustrating - it seems easy enough.
  5. brimile

    Help with DLookup

    Hi all - this is my first post, but I have read many, many threads previously so thanks in advance. I'm trying to set a variable called moDate to the value found in a table using the dlookup method. I have declared moDate as a string and assigned the value using: moDate = DLookup("[MP]"...
See more

Part and Inventory Search

Back
Top