Search results for query: *

Have you tried putting a Cancel = true after your error msgbox?

Ah, right. It's the BMP splash screen you've replaced...Apart from running the prog on REALLY slow machines, i don't think you can pause that.

Have you Tried setting the timer interval on the form to about 2000, then ontimer event close the form?

Do whatever checks you want to do on form close, setting a boolean to true if you don't want the form to close, then on form_Unload add the following.. If blncheck = true then Cancel = true endif

Infact you could base a make table query on that and save faffing about with loads of append queries.

Or you could use a union query to do it if the fields are definitely the same and base whatever you want on the query... SELECT * FROM MEMO51 UNION SELECT * FROM MEMO52 UNION SELECT * FROM MEMO53 UNION SELECT * FROM MEMO54 Only problem with that is the resulting recordset is not updateable.

Hurrah, after week of bashing my head it works. For some reason, adding a timestamp field into my SQL table unlocks it. No idea why.

I've got an access append query appending a small amount of records to a SQL table. Thing is, whenever i append them, the records seem to become locked and will not allow me to edit them ("The record has been changed by another user since you started editing.") Thing is, it's not live...

Try Checking that you haven't got any missing references in your module.