Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Access 2003 VBA Programmer's Reference
This is the forum to discuss the Wrox book Access 2003 VBA Programmer's Reference by Patricia Cardoza, Teresa Hennig, Graham Seach, Armen Stein; ISBN: 9780764559037
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2003 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 24th, 2005, 02:30 AM
Authorized User
 
Join Date: Jul 2004
Location: Coimbatore, Tamilnadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pannet1 Send a message via Yahoo to pannet1
Default Working with Win 32 Registry

Dear,

Apart from the typical uses for the built-in VBA registry functions, I want to create a profile to create Splash Screens, Icons and Help files as mentioned in the below article.

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

I want to first tell Access to look for the profile. This needs to be done when the user first installs my access project in his/her machine. Then I need to create a subkey specifically for my application. Can I do this 'under' \VB and VBA Program Settings or it should be done under any other key (created by me).

Before jumping in, I want to know whether its possible in-build VBA functions or should I use the API calls mentioned in Chapter 18.

Kindly clarify.

Best Regards
B Karthick
__________________
CJBGUY
Reply With Quote
  #2 (permalink)  
Old April 24th, 2005, 09:18 AM
Authorized User
 
Join Date: Jul 2004
Location: Sydney, NSW, Australia.
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can place the actual profile anywhere you like, and you can use the in-built registry calls or the API calls, as you prefer. You only have to tell Access where to find the profile, by setting the apropriate registry path in a value under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Access\Profiles.

With the Access Developer Extensions (ADE), you have the ability to create Registry settings when the user installs your application.




Graham R Seach
Microsoft Access MVP
Reply With Quote
  #3 (permalink)  
Old April 25th, 2005, 09:25 AM
Authorized User
 
Join Date: Jul 2004
Location: Coimbatore, Tamilnadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pannet1 Send a message via Yahoo to pannet1
Default

Dear Graham,

Many thanks for your reply.

Your reply means that without the ADE its impossible to use profiles. Kindly correct me if I am wrong in any of my following understandings.

1) Installation will be done by the customer without the developer (myself).

2) There is no way to tell Access to look for the profile because I can't alter the registry before the client opens the project for the first time.

3) If the customer's registry needs to be altered manually, for asking access to look for a profile, then, it would be unnecessary to use VBA code for the entering the rest of the profile specific subkeys.

Await your confirmation. Thanks once again.

Best Regards
B Karthick
Reply With Quote
  #4 (permalink)  
Old April 25th, 2005, 06:11 PM
Authorized User
 
Join Date: Jul 2004
Location: Sydney, NSW, Australia.
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Replies in-line.

<<Your reply means that without the ADE its impossible to use profiles.>>
That's not what I said! What I said was that the ADE allows you to create and specify registry settings. That does not preclude you from creating registry settings in some other way.

<<1) Installation will be done by the customer without the developer (myself).>>
Not necessarily will be done by the customer, but can be done by them in your absence.

<<2) There is no way to tell Access to look for the profile because I can't alter the registry before the client opens the project for the first time.>>
Correct. But having said that, you can of course write your own installaton program.

<<3) If the customer's registry needs to be altered manually, for asking access to look for a profile, then, it would be unnecessary to use VBA code for the entering the rest of the profile specific subkeys.>>
Again, that's not what I said! You can setup the registry manually if you choose, or you can use VB/VBA to set them up using the in-built VBA registry functions, or the API functions.


Graham R Seach
Microsoft Access MVP
Reply With Quote
  #5 (permalink)  
Old April 27th, 2005, 03:45 AM
Authorized User
 
Join Date: Jul 2004
Location: Coimbatore, Tamilnadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to pannet1 Send a message via Yahoo to pannet1
Default

Dear Graham,

Many thanks for your patient replies. Let me clarify the situation which is specific to me. I did not intend to say that VBA or Access has those weakness. Following is my situation ...

1) I dont have the ADE
2) I dont want to visit the customer place.

Now, I can't ever alter the Registry key and customer will not do this because they do not have the knowledge or its awkward for me to ask them to alter the registry.

Now, I can just mail the Ms Access 2002-2003 *.Mdb file and without running the application atleast one time, I can't tell Access to look for a profile.

However, yesterday, I got a good freeware setup program which will both package the *.mdb and alter the registry for me once the setup disks are run. I hope there is no harm to mention the url here.

http://www.dev4pc.com/setup2go_download.html

I do not know if this is the best alternative but this solves my purpose. Once I am successful in creating the registry entry before access runs for the first time, I can create/check the other profile specific entries, through VBA in my CBF (frmSwitchboard for example).

I prefer built-in VBA over APIs because I have fewer lines to type. I am not a crisp writer, but want to tell you that with your help and internet, I have moved forward in my goal.

Thanks once again for all your expertise in Access and advise

Best Regards
B Karthick
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with HEX'ed Binary Registry Strings sencee C# 2 April 13th, 2006 03:59 AM
nitepad in win 32 satishsatao C++ Programming 1 April 7th, 2006 03:26 AM
Win 32 VC++ Implementation doubts !!! indupriyav Visual C++ 1 December 16th, 2005 11:57 AM
Using win 32 dll in C# abhijeet BOOK: Professional C#, 2nd and 3rd Editions 1 August 23rd, 2003 05:48 AM



All times are GMT -4. The time now is 08:43 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.