question about references

[Tom]

When I open a new Access (2k) db I have the following references:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

But what I want/need is:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Windows Common Controls 6.0 (SP4)

Is there any way to make what *I* want to be the defaults? It seems that if I
don't save my module(s), even though I haven't added any code, I lose the
reference change(s) that I just made. Or is there some simple way that I can
set what I want? (Like a script, .reg file, VBA code?)

Or do I just need to keep a new empty db around (like <MyEmptyDB>) with the
changes I want, for the next time I need a new db?

Thanks in advance,

Tom

 

[Paul Overway]

There is no native method provided to set default references. I'd leave out
the Windows Common Controls reference...otherwise, you're likely to have
problems later.

 

[Tom]

But that has my progress bar...

 

[Paul Overway]

Make your own in Access....it is very easy. Otherwise, it is VERY likely
users will have problems running your app.

Also, those are VB controls...so, technically, unless you have a VB license
you have no distribution rights....although the controls are usually found
on most users PC anyway.

For example, see http://www.granite.ab.ca/access/progressbar.htm

 

[RD]

Make your own in Access....it is very easy. Otherwise, it is VERY likely
users will have problems running your app.

Also, those are VB controls...so, technically, unless you have a VB license
you have no distribution rights....although the controls are usually found
on most users PC anyway.

For example, see http://www.granite.ab.ca/access/progressbar.htm

GAAA!!!!! I bent my brain almost all day yesterday trying to work out a good
progress meter!

Thanks for posting this link. I'm going to be a hero around here later today.


Regards,
RD

 

[Tom]

You need any code to go with it?

GAAA!!!!! I bent my brain almost all day yesterday trying to work out a good
progress meter!

Thanks for posting this link. I'm going to be a hero around here later today.


Regards,
RD

 

[RD]

You need any code to go with it?

Nope, I got it working. I also found one where a guy made various progress
meters in Excel. I'm going to study that one and see if I can't borrow the best
from both of them.