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

  1. BoxerBrats

    text problem with access

    Hi, not sure how to phrase the question here so here it goes On my program, a client made a entry usinf a apostaphy s (exp Mike's Rip Saw) when the program loads up, and see this database entry it freezes any ideas?
  2. BoxerBrats

    using SQL statement to querry dates from access database

    ok having trouble here trying to querry database by dates here is my code any help would be great Private Sub cmdWorkOrderSearch_Click() If optWorkOrderScheduled.Value = True Then WOStatus = "Scheduled" ElseIf optWorkOrdersIssued.Value = True Then WOStatus =...
  3. BoxerBrats

    Runtime error 3001

    Yes changed the table name to UserID with hopes of stopping any conflict
  4. BoxerBrats

    Runtime error 3001

    thank you for the help, but still having trouble with the same error on the same line I changed the line to rstUser.Open "SELECT * FROM UserID WHERE LoginName = '" & UserName & "'", conDB, adOpenStatic, adLockReadOnly I would appreciate any suggestions here thank you
  5. BoxerBrats

    Run Time Error 3001

    ok new to all this but when I goto run my program I keep getting a runtime error '3001' below is my code Private Sub Form_Load() '**** Connect to database Dim strConnection As String Dim path As String path = App.path & "\Database.mdb" '**** Set path for...
  6. BoxerBrats

    Runtime error 3001

    this is the line with the error in it rstUser.Open "SELECT * FROM User WHERE User.LoginName ='" & User & "'", conDB, adOpenStatic, adLockReadOnly" thanks you for any help you can give me
  7. BoxerBrats

    Runtime error 3001

    ok new to all this but when I goto run my program I keep getting a runtime error '3001' below is my code Private Sub Form_Load() '**** Connect to database Dim strConnection As String Dim path As String path = App.path & "\Database.mdb" '**** Set path for...
  8. BoxerBrats

    New trying to learn, Datagrid, data Environment, Query

    Ok, very new at this, and only education I have is with Microsoft books I have read. So here is what I am trying to do.. I am using Data Environment to connect to my database in ACCESS. I am also using a datagid to view the table. What I wan to do is be able to run a query on the database...
  9. BoxerBrats

    Data Environment with Data grid and using query

    Ok, very new at this, and only education I have is with Microsoft books I have read. So here is what I am trying to do.. I am using Data Environment to connect to my database in ACCESS. I am also using a datagid to view the table. What I wan to do is be able to run a query on the database...

Part and Inventory Search

Back
Top