Recent content by Pawn28

Sorry guys I changed some of the text when I posted the queries so I really am not using reserved words....I will try setting the warnings in only one place and see if that helps. But does anyone know how I can wrtie some code which will confirm that the data is really saved in the table before...

qrySaveToTable1: INSERT INTO tblNotes ( Value, Stamp, Notes, BA, FirstName, LastName ) SELECT Forms!AddNewItem!txtValue, Now(), Forms!AddNewItem!txtNotes, Forms!AddNewItem!txtBA, Forms!AddNewItem!txtFirstName, Forms!AddNewItem!txtLastName; qrySaveToTable2: INSERT INTO tblNewItem ( BAName...

Here is the macro SetWarnings = NO OpenQuery = qrySaveToTable1 -> this one is where we see the data stored correctly OpenQuery = qrySaveToTable2 -> this one is where we are losing the records SetWarnings = Yes

Sorry here are answers to your other questions: Is the network hardwired or wireless? the network is hardwired Is your form using the normal DAO recordset or ADO? I am not using recordsets Do you have any code/macros in your form before update event? Do you mean at the Form level?

Code behind my Save button: 'Calls the Format Sub, qryNotesSaved, CleanUp Sub, mSave, mPrint Format DoCmd.SetWarnings (WariningsOff) DoCmd.RunMacro "mSave" If Me.cboAddressUpdate.Value = "X" Or Me.cboAddressUpdate.Value = "Y" Or Me.cboAddressUpdate.Value = "Z" Then...

Hi there I have a Multi user Access Database which has been split into a Front and Back end. What I am noticing is sometimes when the user enters data into the Front end form, it is not being saved in the Backend tables.... I need some direction on how to confirm when the user clicks save that...