Create Personalized Splash Screens for Access

[B Karthick]

Dear,

I want to hide the standard / professional version of access 2003 to hide
its splash screen, help file and icon so that novice user never sees them.
The below link talks about this already ...

http://www.advisor.com/Articles.nsf/AID/FISHS01

I have also visited Microsoft website for this it only has the manual way of
editing the registry but no code to manipulate the registry. Can you please
let me know how to do this in VBA.

Best Regards
B Karthick
Access Addict

 

[Guest]

The article by Steve Fisher, which you provided the link for, certainly uses
VBA code to accomplish this task. Is there anything about this article that
doesn't work for you?

Tom
___________________________________

:

Dear,

I want to hide the standard / professional version of access 2003 to hide
its splash screen, help file and icon so that novice user never sees them.
The below link talks about this already ...

http://www.advisor.com/Articles.nsf/AID/FISHS01

I have also visited Microsoft website for this it only has the manual way of
editing the registry but no code to manipulate the registry. Can you please
let me know how to do this in VBA.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Tom,

Yes! The article was written for Access 97. I have pasted the code in the
switchboard form but the below does not compile at all.

' function or sub already declared

strProfileIcon = RegistryGetKeyValue( _
eRootKey:=rrkHKeyLocalMachine, _
strKeyName:="Software\YourCompany\Some Thing\ _
1.0\Runtime Options", _
strValueName:="Icon")

' some more code here

Best Regards
B Karthick
Access Addict

 

[Guest]

A function or sub already declared compile error suggests the possibility
that you have another copy of this code already saved in the database,
although I would have expected an "Ambiguous name error" instead.

This article includes the following:

"The full code to these procedures, a module for working with the registry,
and an example installation/setup program that uses profiles is included on
the Professional Resource CD for this issue."

Do you have this available?

If you are willing to send me a copy of your database, I'll take a look at
it and see if I can determine the cause of the compile error.

Tom

ZXaos 168@ WQcomc URast . Znet (<---Remove capitolized letters & spaces)
___________________________________

:

Dear Tom,

Yes! The article was written for Access 97. I have pasted the code in the
switchboard form but the below does not compile at all.

' function or sub already declared

strProfileIcon = RegistryGetKeyValue( _
eRootKey:=rrkHKeyLocalMachine, _
strKeyName:="Software\YourCompany\Some Thing\ _
1.0\Runtime Options", _
strValueName:="Icon")

' some more code here

Best Regards
B Karthick
Access Addict
___________________________________


The article by Steve Fisher, which you provided the link for, certainly uses
VBA code to accomplish this task. Is there anything about this article that
doesn't work for you?

Tom
___________________________________

:

Dear,

I want to hide the standard / professional version of access 2003 to hide
its splash screen, help file and icon so that novice user never sees them.
The below link talks about this already ...

http://www.advisor.com/Articles.nsf/AID/FISHS01

I have also visited Microsoft website for this it only has the manual way of
editing the registry but no code to manipulate the registry. Can you please
let me know how to do this in VBA.

Best Regards
B Karthick
Access Addict

 

[B Karthick]

Dear Tom,

I just have the article which is published on the web. I dont have the
resource CD.

I have accicently compiled to *.MDE and my original *.MDB got deleted.
Anyway I am testing this functionality and is not any particular access file
specific. The objective is to have this tested and use it all my app.

I will have to paste the code from the webpage again in a empty database and
try compiling it again. Reverting with the database ...

Best Regards
B Karthick

 

[Guest]

I have accidently compiled to *.MDE and my original *.MDB got deleted.

Sorry to hear this! You should be able to recover the tables and queries
from the .MDE file without any problems.

I will have to paste the code from the webpage again in a empty database
and try compiling it again.

This won't work unless you can obtain a copy of the missing functions from
the Professional Resource CD for this issue. I know, because I already tried
to do this the other day, when you reported that the code would not compile.
The article appears to be a tease, to get one interested in purchasing the CD.

Tom
__________________________________________

:

Dear Tom,

I just have the article which is published on the web. I dont have the
resource CD.

I have accidently compiled to *.MDE and my original *.MDB got deleted.
Anyway I am testing this functionality and is not any particular access file
specific. The objective is to have this tested and use it all my app.

I will have to paste the code from the webpage again in a empty database and
try compiling it again. Reverting with the database ...

Best Regards
B Karthick

 

[B Karthick]

Dear Tom,

Many thanks for your reply. It have saved a lot of time. Now, I know it can
be done, I am planning to do as below.

1) Package my application with setup file and when the customer runs it for
the first time it will add registry entries to ask access 2003 to look for a
'profile'

2) Make the in-built VBA to create (look for) profile specific sub-keys in
the registry, through the CBF (Form Switchboard).

I hope this should work.

Best Regards
B Karthick

PS: I dont have ADE and I dont want to manually alter the customer's
registry.