Search results

Thanks very much! I've tried it in a Query using the following design/SQL but again there is no update of the table. Perhaps linked to that is that Access throws up a message box saying "Enter Parameter Value: Table 1". I can't see why the Syntax might be wrong. Any clues? UPDATE Table1...

You're right with your suggestion: The table sadly doesn't update. (Also, no message comes up). Thanks for your suggestions: -I've tried removing dbFailOnError from the code, but still no improvement. -I'll try your second suggestion now... Or, Is it perhaps becuase I have to state that the...

Thanks for your help. I've put your suggested code in and saved the vba. Then I've tried to the run it and nothing happens. I've tried several solutions, such as closing Access and reopening it but to no avail. There isn't an error message, there's just simply no action. Any thoughts?

I've already got the database, tables and fields already made. My aim is to (kind of) update table 1 with new data from table 2. There are two caveats though: firstly, I only want one of the fields in table 1 to update (the other fields in table 1 have old data compared to that within table 2...

thanks for your help. I really am a nOOb with this. Though I'm enjoying learning about it! Help is very much appreciated though!! Here's what I've got going so far...No doubt wrong... Private Sub Infill_field_gaps() Dim Database1 As Database Dim Table1 As TableDef Dim Table2 As TableDef...

I've now tried the above code (thank you!). Sadly when I run it, I get the error message "Compile error: Syntax error". Is this because I need to write in at the top of the VBA code, where to look for table1 or field 1? If so, could anyone help with how to do that correctly? Many thanks...

Thanks very much all, and for the help to get the right names in order. Cheers

Thanks very much for your help. I'm now seeing if I can find out what else to put in the VBA in order to get it to work, e.g. at the start of the code. Many thanks.

Hello, I'm fairly new to VBA and after reading forums for a few hours today I can't find an answer to the (presumably very simple question) below. Any help v.gratefully received! My aim is to paste data from table2.field2 into table1.field2, but with the following conditions: only if...

Hello all, I'm fairly new to Access. I'm slightly more used to Excel. Many thanks, sdrew1 :)