ACCESS FEED: RE: [MS_AccessPros] Changing BE on Button Click

Kamis, 18 April 2013

RE: [MS_AccessPros] Changing BE on Button Click

Hi Michael,

It is not actually a backup, because after that year am not needing the BE database anymore, well sometimes there are instances that they need to search record on previous year and that is also a manual task, I need to re-attach the old database before doing the search.. and after seeing the record, need to re-attach again the current year BE..

Thank you,

zjubias

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Sac City Plumbing
Sent: Thursday, April 18, 2013 11:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Changing BE on Button Click

Sounds more like you are creating an end of year back up

Take care,
Michael

>________________________________
> From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> >
>To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
>Sent: Thursday, April 18, 2013 12:51 PM
>Subject: RE: [MS_AccessPros] Changing BE on Button Click
>
>
>
>
>Zjubias
>
>Is the reason for the annual BE creation due to database size, or could you use
>the same database and filter records based on the current year?
>
>Regards,
>Bill Mosca,
>Founder, MS_Access_Professionals
>That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
>MS Access MVP
>
><https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
>https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
>
>My Nothing-to-do-with Access blog
>
><http://wrmosca.wordpress.com> http://wrmosca.wordpress.com/
>
>From: mailto:MS_Access_Professionals%40yahoogroups.com
>[mailto:mailto:MS_Access_Professionals%40yahoogroups.com] On Behalf Of moi
>Sent: Thursday, April 18, 2013 12:06 PM
>To: mailto:MS_Access_Professionals%40yahoogroups.com
>Subject: [MS_AccessPros] Changing BE on Button Click
>
>Hello all,
>
>How can I automate my manual task.
>
>I have a database (FE-BE) BE tables object are all identical. I need to reset my
>BE every year, manual task is being done here.
>
>- at the first/second day of the next year, when opening the database I want to
>warn the user (message that he/she needs to change the BE) on clicking OK on
>message, Changing BE button will be enabled and have the focus, clicking the
>button, message warning he/she is about to create new BE.
>- copy last year database file, save to current year.
>- copy the link tables and paste "structure only".
>- relink tables.
>
>I need to automate this task on button click only.
>
>Many thanks,
>zjubias
>
>[Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]