I am trying to update a table when a selection is double clicked i keep getting a error that i am missing an operator in my sql here is what my sql looks like
Dim sql As String
sql = "UPDATE CitationComment SET CitationComment.Citation_Viewed = " & True & "...
I am trying to get text records out of a database the problem I am having is we have limited the text to being 75 char long so there is multiple lines for each comment_ID and I want to group the multiple lines together.
I have thrown my SQL statement in that i have so far
SELECT...
thank you Herb this has gotten me much closer i think. what exactly is the record set? is that my sql statement or? I have actualy got text to go into the label but it is still not getting the date from the database I am so confused. thank you again for all your help
here is the sql statement and the code i have been trying to use that is not working hehe im going to try the code you suggested
thank you for your help upwoth
sql = "SELECT tblEmploymentEvents.Employee_Id, tblEmploymentEvents.dteEventDate, tblEmploymentEvents.strEvent " & _...
ok we are using microsoft access 2000 for the database
Im pretty sure im getting the data i want from my sql statement. I just can not figure out how to get the information from the sql statement and place it into a label. im not sure if im trying to use a stored procedure or not. they have...
I am very much a rooky programmer in my first internship and dont have a lot of help here. what I am trying to do is get a date field from the database to fill a label with the date. the date would be the hire date of an employee from a employee table. I have been fighting this for a couple of...
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.