Search results
-
L
Creating a user "template" for creating new records
SOLVED!!! I finally figured it out! It was a syntax error I did put a quotation around [forms]![frmUpdateTempTable]![txtAssemblyNumber] so that access recognizes the value as a text. The correct SQL code now is UPDATE tblTemporary SET tblTemporary.AssemblyNumber =... -
L
Creating a user "template" for creating new records
AssemblyNumber is the field in the temp table where the ID from the corresponding txtAssemblyNumber is stored. txtAssemblyNumber is where the actual string is typed. I did as you suggested for the SQL and put the single quotes around the input 'forms!frmUpdateTempTable!txtAssemblyNumber)'. still... -
L
Creating a user "template" for creating new records
spikepl, the suggestion you provided is great, but the more i think about it, the more i dont want the new records to be added until the user verifies the records are correct and that they dont need to make any changes to some of the records. is there something wrong with my SQL statement... -
L
Creating a user "template" for creating new records
Because if the user makes an error i didnt want it to affect the data stored on the main table. I wanted them to have the ability to look at the records to ensure they are as they should be before they are put into the main table. your suggestion is a great alternative. Thanks! I'm going to... -
L
Creating a user "template" for creating new records
I'm trying to create a "template" form where the user can duplicate a set of records but modify a certain number of fields. for example, PC1 exists in the database and has 35 parts related to it. the user wants to be able to create a new pc, PC2, with the same 35 parts. instead of inputting each... -
L
Pop Up Form To Add Information When A Record Value Is Changed
Thanks. I'm going to give it a try -
L
Pop Up Form To Add Information When A Record Value Is Changed
Hey, I have a form with two subforms on it and they are linked together so that when someone clicks on a line item in the table, the other table automatically updates to show the notes pertaining to that line item. Table 1 has the following columns: Item ID, Nomenclature, Manager, and Status...