Makig Backup of data

[wasim_sono]

Dear All

I have a master detail table and entering data by using master detail form. Is it possible that at the end of day the user make a backup copy of the data enetred today?
I searched and found that Access export the table in excell but I don't want to export all the table but the daily punched data.

Any help is appreciated.



Thanks.


Wasim

[matthewspatrick]

Wasim,

You could write a query that grabs today's records, something like:

SELECT *
FROM SomeTable
WHERE SomeDateField = Date()

That grabs all the records where the date field equals the current system date. You could then export that query to Excel each day.

[wasim_sono]

Dear Mathew

Thanks a lot. Ur code is very helpful for me. Now I can make a backup as I required.

You r really very helpful.

Is it possible to make a executeable file of a mdb file.Like VB. Or Can we hide all Menu items and reveal again as we needed?

Thanks in advance.

Wasim

[matthewspatrick]

Wasim,

Glad to help!

You can't compile an executable from Access. What you can do, if you have the Developer edition of Office, is create a "runtime" version of your Access app that another user can run without needing to actually install Access.

You can use VBA code to hide menus, and you can also set the Startup Options for a mdb file to hide the database window on start. If you do that, make sure to designate a particular form to load on startup, or the user will be really confused :shock:

[wasim_sono]

Actually I want that no one recognize that the application is developed in MS-Access. so as the application start up all the menu items should be hide and only switchboard to be appeared (as I did it by startup options but some time ago I hide the menu item but never reveal again. so re-install the MS-Access).
I'll be very thankful to u if u tell me how to hide through VBA. and how to reveal them again for editing purpose.

Thanks.


Wasim

[matthewspatrick]

Wasim,

Totally hiding the Access heritage will be hard to do. Some steps you can take:

1) From the menu, select Tools|Startup Options. Here, disable the database window, status bar, and built-in toolbars.

2) To hide the menu, run this statement from your Switchboard's Open event:

Application.CommandBars("Menu Bar").Visible = False