Kamis, 18 April 2013

RE: [MS_AccessPros] Changing BE on Button Click

 

Hello Bill,

Thanks for picking up my problem.

Basically yes, because of the database size, and secondly the boss wanted it
that every year the record number (reference) will start 000001 every year.

Can you just show me how could I filter records based on current year and
restart the numbering, please..

I really don't know how to automate.

Thank you,

zjubias

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Thursday, April 18, 2013 10:51 PM
To: MS_Access_Professionals@yahoogroups.com
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-642707308
81E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
1E

My Nothing-to-do-with Access blog

<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of moi
Sent: Thursday, April 18, 2013 12:06 PM
To: MS_Access_Professionals@yahoogroups.com
<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]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar