Recent content by Ripsnorta

I am not actually copying the same data into different tables and the database is normalised. I am writing a function to copy a previous year's categories into a new year. For example, the Primary Key for one table is Year and Sales Category. Another table uses Year and Expense Category. The...

Thanks Peter. That should do the trick.

I've got another very Noobish question which I know has a very simple solution which I can't seem to find. I want to build an SQL statement in code which includes the value stored in a string variable where the variable name includes a loop counter. This is a much simplified example of what I...

Thanks MStef Both those options do what I was looking for. I think my main problem was I was omitting to setwarnings = false to avoid the error message.

I'm hoping someone can help a noob with a simple problem:) I did a search but couldn't find the answer. When a user clears a record and leaves it Null I would like to prompt them whether they would like to delete the record before the access error message about invalid use of Null comes up. If...