Recent content by surferxx

Ok no need!, I got it!. Thanks a bunch Keith!

amazing Keith!. exactly what I wanted!. can you explain that statement to me in detail please and how its doing what its doing?

Yes!...Its 'BC HC RAMP' or 'BC @ FL' or so on

Im using the UPDATE Query in Access UPDATE MAT_Clean SET FCODE = 'BC', NOTES = 'HC RAMP' WHERE FCODE='BC HC RAMP'; Instead of typing what needs to go into NOTES everytime, how can I specify whatever comes after 'BC' to go into NOTES? Use 'BC *'? Thanks!

Hey Gemma...that worked!...Thanks a lot! But why is it working even if I comment out the movenext statement???

Ok if I understand this right, the cursor stops at the last record and the rst.movenext statement sets EOF to True. So to avoid that I simply remove the move next statement? Or tell the cursor to go back to the first record? If so how?

Well I want to run several Criteria on the same table and then based on the results of these criteria i want to insert records into rows in another table. So, I guess this is a better way instead of opening several recordsets based on several sql strings

I get the error '3021' for this: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Heres the code: Where am I making a mistake Option Compare Database Public Sub IterateRows() Dim conn As New ADODB.Connection Dim rst As New...

Awesome fdcusa!...that was perfect...thanks loads...I am going to chk out those books u suggested...looks like very clear information!!

by stored querydefs you mean stored procedures right?

How do you write a procedure that searches every row in a table from top to bottom for a criteria like 'If Field5 = 'xxx' then do the following'. Do I have to use recordsets. What exactly are recordsets. Im finding that concept difficult to understand. Can someone pls help Thanks

How can we do this? Can someone pls help? The query should be part of the code. Like create a variable strSQL = "SELECT * FROM ...." and so on Newbie here :)