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 bkrike 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: boborsipho
  • Content: Threads
  • Order by date
  1. boborsipho

    Check Query Successful

    How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not. I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a...
  2. boborsipho

    Check Query Successful

    How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not. I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a...
  3. boborsipho

    Check successful query

    How do I check in VBA/Access (if it is possible in Access) that a update query actually updated something and then use the fact that it updated/not. I've got a log in form that checks if the username & password is valid, and then Activates the use, if found in the table, as Yes (Activates is a...
  4. boborsipho

    Select Tab in code

    How do I select a tab in VBA? What I'm doing is that based on a combo box's value outside the tabs, a MsgBox should be displayed when I click on the tabs. Currently my MsgBox is in Private Sub TabCtl63_Change(). Should it be somewhere else? If I click on the tabs and the Combobox's value is...
  5. boborsipho

    Can't find library

    I get the error, "Can't find project or library" for the following code: Me!month = Format(Now, "m") I know what it means, but how do I correct it, and what would the library be in this case? Thanks Bob
  6. boborsipho

    Select Query in Code is driving me nuts

    I've been trying to get this to work for days now. My code is below. I'm not really familiar with VB. The first error was the "Too few parameters, expected 1". I changed my code a bit and now it's "Object 'Times' already exists". What am I doing wrong and how do I fix it. Is...
  7. boborsipho

    Select Query in Module

    I've been struggling for a while now. How do I run a Select query in a module in MS Access? I tried everything: Dim sql As String Dim rs As Recordset Dim db As Database Set f = Forms!frmCalender sql = <<SQL Statement>> Set db = CurrentDb() Set rs =...
  8. boborsipho

    Select Query in Module

    I've been struggling for a while now. How do I run a Select query in a module in MS Access? I tried everything: Dim sql As String Dim rs As Recordset Dim db As Database Set f = Forms!frmCalender sql = <<SQL Statement>> Set db = CurrentDb() Set rs =...

Part and Inventory Search

Back
Top