alan2013's latest activity
-
Aalan2013 replied to the thread Inserting numeric values into a Table, using SQL : What's the correct VBA code to use in the VALUES part of the code ?.Thanks, ebs17 & UncleGizmo. I'm continuing to sort it. The error I'm getting right now (seen it before with some other variations I...
-
Aalan2013 posted the thread Inserting numeric values into a Table, using SQL : What's the correct VBA code to use in the VALUES part of the code ? in Modules & VBA.I'm having difficulty in creating the VBA code required to - on the click of a button on a Form - insert some data recorded on that Form...
-
Aalan2013 replied to the thread Solved Problems inserting records into a table using SQL : maybe an error in my concatenation ?.Thanks, ebs17. I've taken that on board, and altered by code to take that into account.
-
Aalan2013 replied to the thread Solved Problems inserting records into a table using SQL : maybe an error in my concatenation ?.It's a Short Text field, in which I enter Yes or No. Thanks for your interest. In any case, my error seems to be in the order of my...
-
Aalan2013 posted the thread Solved Problems inserting records into a table using SQL : maybe an error in my concatenation ? in Modules & VBA.Could someone help me pinpoint where I'm going wrong with the following, please ? I'm attempting to insert a record into a Table named...
-
-
Aalan2013 replied to the thread Solved Copying data from Quote-line-items Subform to Sales-Order-line-items Table : Error 3022.I think I'd been a bit careless in cutting-n-pasting code around. The code you provided certainly seems to have worked. Thanks ever so...
-
Aalan2013 replied to the thread Solved Copying data from Quote-line-items Subform to Sales-Order-line-items Table : Error 3022."The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or...
-
Aalan2013 posted the thread Solved Copying data from Quote-line-items Subform to Sales-Order-line-items Table : Error 3022 in Modules & VBA.In my database, I have a 'Quote' form with a Quote-line-items subform (sfrmQuoteLineItems) and a 'Sales Order Form' with an 'Order line...
