Search results
-
M
append a record using vba where there is an auto number field
i dont think it will, as the data to be posted into the second table is different from the first table. The sql statement i just got to work is posting two values from my form, (supplierID, productID) into table 1 (supplierProductsTBL). This table also includes one other field, which is the... -
M
append a record using vba where there is an auto number field
Cheers for the guidance, i changed my sql statement slightly (below) and things seem to be working now. mySQL = "INSERT INTO SupplierProductsTBL ( SupplierID , ProductID ) VALUES ('" & SupplierIDCombo & "', '" & ProductID & "')" Now what i need to figure out is how to append data from a form... -
M
append a record to a table using vba where the table contains an autonumber
Hi, basically what i want to do is append a record to a table using vba. I would like to take two values from my form (productID, supplierID) and insert them into a table (supplierProductsTBL) under the same headings. I've constructed an sql statement but am getting the following error: runtime...- marky_dp
- Thread
- Replies: 2
- Forum: Modules & VBA
-
M
append a record using vba where there is an auto number field
Hi, basically what i want to do is append a record to a table using vba. I would like to take two values from my form (productID, supplierID) and insert them into a table (supplierProductsTBL) under the same headings. I've constructed an sql statement but am getting the following error: runtime...