Search results

Runtime Error 91, is the error I get. This is the base code I have written to open a recordset: **Begin base code** Strsql = "SELECT bomts.*, Rotors.PartNumber, Rotors.Price, Rotors.Price2 FROM BOMTS LEFT JOIN Rotors ON BOMTS.Component = Rotors.PartNumber WHERE(isnull(BOMTS.[Level])) OR...

I would like to create an SQL statement in one public sub, to be called from another public sub, all of this in an Access module. I have 40,000 records in table "A" and approximately 2,500 of those records have a wrong value in one of the fields of its record. In table "B", the correct value...

This is my code below at the bottom of this post; 4 hours of headbanging and I cannot figure it out. I have one source table and one target table. Three fields in the sub query are to be used to filter the resulting recordset. The source table contains some records already in the target table...

I have records in a file. New records need to be added and I do this with an update. What is the best way to process a set of new records to be added (10,000) and not process records that already exist in the target table? With an SQL does not exist? Looking for best way to do this and not...

I have the following code. Just before the update statement below I call a public sub. I want to pass two work variables to this new public sub. One is text the other numeric. When I can get the SQL to work I then want to populate the item field in ![partnumber], the third field below form...