Access wizard code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning Everybody!

In version 97 of Access, there was a version of acwzmain.mdb that was
available for download on Microsoft's website where the code was not locked.
Does anybody know if there's a version available for Access XP?

I'm mostly interested in modifying the code for the Switchboard wizard, and
I'd rather not base my work on a version that's outdated.

Thanks in advance for any feedback on this.

Daniel :-)
 
Sorry, no, it is not available for any version other than Access 97.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Hello Brendan!

Thank you for the prompt answer.

"Back to the drawing board then".... ;-)

Daniel :-)
 
Welcome to my world Dan!!
No, unfortunately Microsoft has not released any 'unlocked' wizard code for Access 2000, 2002, or
2003. And they do not appear to have any desire to do so in the near future either. :-(

This is a strange coincidence but I wanted to view later version wizard code to make an Advanced
Switchboard Manager Add-In. I was having trouble making some 97 functions work properly in later
versions. I am very close to completion on this project and will hopefully release it soon!

Was there something specific you wanted to change in the Switchboard code? I may have already
incorporated it into my new Advanced Switchboard Manager.
:-)
 
Hello Jeff!

Jeff Conrad said:
Welcome to my world Dan!!
Thanks!

No, unfortunately Microsoft has not released any 'unlocked' wizard code for Access 2000, 2002, or
2003. And they do not appear to have any desire to do so in the near future either. :-(

This is a strange coincidence but I wanted to view later version wizard code to make an Advanced
Switchboard Manager Add-In. I was having trouble making some 97 functions work properly in later
versions. I am very close to completion on this project and will hopefully release it soon!

Was there something specific you wanted to change in the Switchboard code? I may have already
incorporated it into my new Advanced Switchboard Manager.
Click to expand...

Well, I've done all the work, really. The reason I wanted to get access to
the code of MS wizard was to insert my code into MS code to "blend"
functionalities.

The main change I'd done in 97 days was to increase the number of buttons on
the Switchboard to 10. I would have liked to have that in the current
version, but doing it on the Switchboard form and code is pointless if the
code in the Switchboard Manager doesn't get change too.

The new add-in I've currently developped is an addition to the switchboard
manager, to define user groups (independently or not from the Workgroup file)
and have the option buttons on the switchboard enabled or not depending on
what group the current user belongs to.

The main aim of my add-in is to add a bit of functionality for users that
don't need tight security, but want to customize an application for different
departments.

I'd love to hear about your add-in, either here, or in email: danielc (at)
computing-tech (dot) com, maybe we could avoid duplication of efforts...

Best regards,

Daniel :-)
 
Hi Dan, comments below....
Well, I've done all the work, really. The reason I wanted to get access to
the code of MS wizard was to insert my code into MS code to "blend" functionalities.
Click to expand...

I see.
If *all* you want to do is change the code behind the Switchboard form itself, then copy/paste your
code into record number 1 of the table called sbm_tblCode. The form will be created with the code in
that record.
Simple.

If you need to make changes to the wizard itself and have it work for 97, 2000, 2002, and 2003 (my
goal) then prepare yourself for lots of sleepless nights, monitor-head-bashing, and occasional hair
pulling.
:-)
The main change I'd done in 97 days was to increase the number of buttons on
the Switchboard to 10. I would have liked to have that in the current
version, but doing it on the Switchboard form and code is pointless if the
code in the Switchboard Manager doesn't get change too.
Click to expand...

I've already taken care of that.
:-)
The new add-in I've currently developed is an addition to the switchboard
manager, to define user groups (independently or not from the Workgroup file)
and have the option buttons on the switchboard enabled or not depending on
what group the current user belongs to.
Click to expand...

Ok. This is a 'home-grown' type of security system I imagine, correct?
The main aim of my add-in is to add a bit of functionality for users that
don't need tight security, but want to customize an application for different departments.
Click to expand...

I see. I have done similar things in the past. I've created my own security 'system' in the past for
low-tech (and non-sensitive) systems, as well as using built-in User Level Security. I did not
incorporate anything like this into my Advanced Switchboard Manager (AdvSBM).

My goals for the AdvSBM were to alleviate the number of recurring questions about the current SBM in
the newsgroups. They are always the same questions. So I wanted to create a new one to make things
easier for people that use the SBM. My trouble began when testing on versions past 97. The viewable
wizard code for 97 uses specific entry points to the msaccess executable file. Some of those entry
points changed and/or were eliminated in later versions. Grrrrr....

This project has taken a LOT longer than expected, but I'm really close to finishing it now. I've
also added some other cool features I do not even want to reveal yet. :-)
I'd love to hear about your add-in, either here, or in email: danielc (at)
computing-tech (dot) com, maybe we could avoid duplication of efforts...
Click to expand...

I will probably send a message to you so I can let you know when it is finished and where it can be
downloaded.
 
Hi Dan,

Do the changes you made to the Switchboard only involve changes to the form's code module itself or
do you also utilize some code in one or more modules?
 
Hello Jeff!

Sorry about the delay in answering, I don't keep tabs on this newsgroup and
only come around here from time to time.

The changes are situated in the form's code module, mostly to change the
source of data for the switchboard form, so it joins a query to the
[Switchboard Items] tables, which allows me to add two tables to the source
of the buttons.

I have some code in another module executing too, although that gets called
from an additional form that puts into place the management of the
"permissions" on the buttons per group of users.
I've also added code to retrieve the list of users from the Windows
workstation or from the Workgroup file, to help with integrating the
application with existing security. Adding yet another login and password is
something I loathe, apart from it not making sense...

It's a bit difficult to explain all the functionality here, but if you're
interested, I'll email you when I've completed the web pages that describe
this project. I'll post here too if anybody else is interested...

Best regards.
 
Hi Dan, comments below....
Sorry about the delay in answering, I don't keep tabs on this newsgroup and
only come around here from time to time.
Click to expand...

No problem.
The changes are situated in the form's code module, mostly to change the
source of data for the switchboard form, so it joins a query to the
[Switchboard Items] tables, which allows me to add two tables to the source
of the buttons.
Click to expand...

Interesting. Do you still use the Switchboard Manager interface to fill the options for the buttons?
I have some code in another module executing too, although that gets called
from an additional form that puts into place the management of the
"permissions" on the buttons per group of users.
I've also added code to retrieve the list of users from the Windows
workstation or from the Workgroup file, to help with integrating the
application with existing security. Adding yet another login and password is
something I loathe, apart from it not making sense...
Click to expand...

Rather complex, but I believe I see what you are trying to accomplish.
It's a bit difficult to explain all the functionality here, but if you're
interested, I'll email you when I've completed the web pages that describe
this project. I'll post here too if anybody else is interested...
Click to expand...

I would like to see what you have created if that's possible.
Who knows, I might even be able to create a customized Advanced Switchboard Manager just for you by
integrating your work with my AdvSBM. No promises, just a thought.

I'll send you an e-mail in the next day or two where you may reach me.
 
Hello Jeff!
(Sorry group, I hate doing that in a public forum...)

Could you email me so I can send you a preview of my Switchboard User
Security Manager (SUSeM ;-)
I'd like to have your opinion, and also to check that it doesn't break you
Advanced Switchboard Manager...


Jeff Conrad said:
Hi Dan, comments below....
I'll send you an e-mail in the next day or two where you may reach me.
Click to expand...
....

Nothing received to far.

Email to danielc (at) computing-tech (dot) com

Regards,
 
Back
Top