By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Version Control

P: n/a
I am writing an Access 2000 program.

I change the program's filename in an orderly as I make
changes/modifications to the program .

For example the original if the original program filename was
MyprogramVersionA.mdb then subsequent versions would be :
MyprogramVersionB.mdb
MyprogramVersionC.mdb
MyprogramVersionD.mdb
MyprogramVersionE.mdb

Is there a way to automatically force the application name onto the screen
so I can quickly identify which version is running.

Thanks
Thanks
Jul 26 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
2 ways.

Store it in a table, or store it in the property of a table.
RICHARD BROMBERG wrote:
I am writing an Access 2000 program.

I change the program's filename in an orderly as I make
changes/modifications to the program .

For example the original if the original program filename was
MyprogramVersionA.mdb then subsequent versions would be :
MyprogramVersionB.mdb
MyprogramVersionC.mdb
MyprogramVersionD.mdb
MyprogramVersionE.mdb

Is there a way to automatically force the application name onto the screen
so I can quickly identify which version is running.

Thanks
Thanks
Jul 26 '06 #2

P: n/a
Put this code in the Click event of a Command Button:

MsgBox CurrentDB.Name

or

in the Control Source of a Text Box that can be easily made visible (by
clicking a background form or ???)

= CurrentDB.Name

Or, see my article on versioning (for distributed production databases) in
the articles at http://accdevel.tripod.com.

Larry Linson
Microsoft Access MVP
"RICHARD BROMBERG" <no*****@att.netwrote in message
news:Ya********************@bgtnsc04-news.ops.worldnet.att.net...
>I am writing an Access 2000 program.

I change the program's filename in an orderly as I make
changes/modifications to the program .

For example the original if the original program filename was
MyprogramVersionA.mdb then subsequent versions would be :
MyprogramVersionB.mdb
MyprogramVersionC.mdb
MyprogramVersionD.mdb
MyprogramVersionE.mdb

Is there a way to automatically force the application name onto the
screen
so I can quickly identify which version is running.

Thanks
Thanks


Jul 26 '06 #3

P: n/a
1) Put it on a label in your startup form.
or
2) Include it in the "Application Title" in the DB startup.

"RICHARD BROMBERG" <no*****@att.netwrote in message
news:Ya********************@bgtnsc04-news.ops.worldnet.att.net...
I am writing an Access 2000 program.

I change the program's filename in an orderly as I make
changes/modifications to the program .

For example the original if the original program filename was
MyprogramVersionA.mdb then subsequent versions would be :
MyprogramVersionB.mdb
MyprogramVersionC.mdb
MyprogramVersionD.mdb
MyprogramVersionE.mdb

Is there a way to automatically force the application name onto the
screen
so I can quickly identify which version is running.

Thanks
Thanks


Jul 26 '06 #4

P: n/a
But why do this?

Surely it is easier to store a version number, either in a local table or as
a public constant and then show this on your main switchboard or menu form!

Just seems to me that changing the filename is such a cumbersome method.

I typically start a database as V 0.01 and then increment this for each
development version. When it gets released it starts at V 1.00.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

"RICHARD BROMBERG" <no*****@att.netwrote in message
news:Ya********************@bgtnsc04-news.ops.worldnet.att.net...
>I am writing an Access 2000 program.

I change the program's filename in an orderly as I make
changes/modifications to the program .

For example the original if the original program filename was
MyprogramVersionA.mdb then subsequent versions would be :
MyprogramVersionB.mdb
MyprogramVersionC.mdb
MyprogramVersionD.mdb
MyprogramVersionE.mdb

Is there a way to automatically force the application name onto the
screen
so I can quickly identify which version is running.

Thanks
Thanks


Jul 26 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.