asked on

Auto exporting a sheet from Access Database any time new info is added

I am needing to automatically export a table to an excel file so i can link to if on a database that is on a vpn.

Anytime that a new record is added to database i would like it to auto export that table to excel file "in background"

This way when my users on vpn use database with that linked table it will have the latest info

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Addie Baker

ASKER

How can that be automatically triggered when i add a new record?

I dont want to rely on me or anyone else to have to export it by clicking a button. Also with that automatically overwrite the current on in that location?

also, im working in Access 2010

Addie Baker

ASKER

Is this question to elaborate and detailed to answer? I noticed sometimes that ill get answers back right away then sometimes, like on this one, it just sits out there.

Is it too much work for 500 points?

should i do research on google to try and get this process done then come here for questions?

Just trying to find out the protocol here

Rey Obrero (Capricorn1)

how do you add a record?

Addie Baker

ASKER

I have a formed names entermachine

I open the form and scroll to end of records, press right arrow one more time and it opens a blank record that i fill out.

I guess if i had to do a button to export it wouldnt be the end of the world, but just thought it could be automated to prevent forgetting to hit it.

Also, i usually enter multiple pieces at a time..

Maybe i could just set that to happen when i am closing the form?

Rey Obrero (Capricorn1)

if you are entering multiple records at a time, it is not advisable to keep on exporting the table after each record created.

<Maybe i could just set that to happen when i am closing the form? >

this will be a better choice..

but, i am not sure this will work flawlessly. There might be a user connected to the excel file when you do the exporting, so you may need to test that condition to get the error raised and handle it with error handling routine, but this already beyond the scope of this thread.
good luck with your project