Search results for query: *

thank you all for the help going to try some of the tips right now thank you again The OX

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 & &quot...

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

the information i am trying to get is this spacific field tblEmploymentEvents.dteEventDate

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...