Recent content by mrmotocross

thanks everyone, it was the quotes around the text variable that i ws missing! all the best. bob from long island, ny

My problem is i am only getting the first character into the first field. So if a try to insert "12345" only "1" is put into the field. The field is called "Fixture". here is my code: Set InsComm = New ADODB.Command Set InsConn = New ADODB.Connection Text100 = Mid(CompareText, 1...

How do i create the query in VB?

It is manually populated using an ado sql query.

Hello, i am populating the combobox from an access 2000 database table. I really just need to know how to access the data in the combobox in order to write the new records back to the database table. Anyone have a routine?

hello everyone, i have a small problem that i'm sure most of you can help me with. I have a combobox that the user can enter new data in the text area. I know how to add the new entry to the combobox but how do i take the new data and write it to the file that populates the combobox so that next...

hello, thanks for your help. You have cured my problem. It was a dumbass mistake but it has helped me understand how sql statements work. thanks, mrmotocross

hello mrmotocross here. Here is the original query. Query6 = "SELECT * FROM testcopyofEmpDetail Where Activity = '" & HoldActivity & "' ORDER BY Activity, Date;" Here is the query from the debug.print: SELECT * FROM testcopyofEmpDetail Where Activity = '' ORDER BY Activity, Date; Thanks, bob

Hello again. I am going crazy. I am trying to selectively, using an sql statement, retrieve certain records. I have the correct syntax, i have tried it as a query in access and it works. Does there exist any error that can tell me why i can't selectively retrieve records?. The way i have the...

Hello mr motocross here, is there anyone out there who has a sample of an sql statement that contains a WHERE clause with a comparison to a variable? thanks, bob

mr motocross here. The Activity field is alphanumeric and it is being compared to a string field, 'HoldActivity'. thanks, bob

hi mrmotocross again. I think i thru you off as to what my problem is. What i actually meant was that i should have received records back from the sql statement and i wanted to know what i was doing wrong in not getting the records. Do you see any problem with the code? Thanks again, bob

hello, I am having a problem with an sql statement. Below is the code i'm using: Query6 = "SELECT * FROM EmpDetail where Activity = '" & HoldActivity & "' ORDER by Activity, Date;" Select Case ReportNumber Case 0 SQL = Query1 Case 1 SQL = Query2 Case 2...