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?
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 =...
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
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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.