Search results

  1. S

    Copy part of a record as value in another field

    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!
  2. S

    Code produces error (Trying to iterate through rows in a Table)

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

    Searching every row

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

    Create VIEW from SQL Query on a TABLE using VBA

    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 :)
Back
Top Bottom