Excel Template Help

[EliseFreedman]

I am working on an excel application to collect and compile statistics automatically

I have created a form that uses the template wizard to add the information to a separate database file each time the form is saved. When the form is saved using the menu options,
a box appears asking if I would like to 'update existing entry', 'add new
entry' or 'continue without updating'. As this form is being used by colleagues who are not very confident with regards to IT, I would like to be able to have them click a button on the form and as well as be given the option to update existing entry etc also to automatically save the form with the patients name in the title without the actual employee having to do anything.

Anyone any ideas how I can do this

Thanks

Elise

I have

 

[GhostWolf]

to automatically save the form with the patients name in the title without the actual employee having to do anything

Would something like Me.SaveAs CalculatedName+".xls" work? You could execute this either when the user clicks Save, or just before clearing the screen for the next input session.

Does the user have the choice of saving currently-viewed/entered data as new even if data for this patient already exists in the database?

If not, you could check the database as soon as appropriate ID information is entered, (if the data is found, you could calculate your SaveAs name at this point), then set a flag to control how the data is stored when the user clicks Save, (e.g. On Save_Click if IDFound db.Update else db.AddNew).

HTH - even a little!