Search results

Ah, apologies ... in that case I believe I do have a split configuration. So the original DB is stored on the BE. A copy of that DB is then provided to a data validator. The validator uses queries to manipulate the data in the tables (of the copy). Once this process is complete the file is...

By 'worked on' I just mean that the data in the tables has been edited. I don't know what a split configuration is so I'm assuming I don't have one.

Let's say the file that is being worked on is called 'Database1.accdb' ... when the staff member is finished working on it he/she should save it as 'Database1_COMPLETE_20211211.accdb' This is so we can differentiate between the worked-on version and the original which is held in the project...

It's the renaming of the database itself once closed down. When it has been worked on the staff should Save As and suffix it with _COMPLETE_20212111 but if they forget, which happened recently, it causes significant problems. I just want to automate the process.

The current .accdb file. Rather than having to hit Save As and manually type _COMPLETE_20212111 at the end of the file name I'd like to automate it. One of my staff recently forgot to suffix the file name with this which caused mayhem further down the line.

Hi All New member here just starting to progress from Access macros to VBA. I am trying to write the VBA to save a file as the current file name but appended with the current date. I guess the starting point is DoCmd.Save but with this I either have to ... Rename the whole file Use the...