Where is Code for frmSwitchboard?

  • Thread starter Thread starter james
  • Start date Start date
J

james

I've inherited support duties for a database that apparently was
created in Access and then turned into an Access adp / SQL Server 2005
project. (The developer has left the company - a friendly move, for
him at least - for a job with another company, so he's not around to
answer questions.)

This is my first exposure ever to adp's and I've been requested to do
some very simlpe changes to it - basically adding to a table a field
for comments, add them to a report and add a spot for them to the data
entry form for one type of user of the db.

Unfortunately for me, he implemented all the data entry in a multipage
control on a form frmSwitchboard, which I'm assuming was the Access
mdb switchboard before it was converted into an adp.

My problem - don't laugh - is that I can't find how to find / get to
the code associated with the frmSwitchboard. When I try via the
VBIDE, a click on the the 'show code' menu item gives no response.
There is code in the form - I copied the form, and I can get to the
code in frmSwitchboard_copy, but I'm clueless on why I can't find a
way to get to the code on the original frmSwitchboard. I have to
modify that to let the right user group enter the comments.

So far as I can tell, this isn't a security-related issue - at least
in terms of what users can do what things in the db - I'm using 'type'
and 'group' only in the sense that people with several job
descriptions use the db, but the requested modifications will be
relevant only to some of the users...

Any help would be most appreciated!

James C
 
James,
If you open frmSwitchboard in design view,
...and right click on one of the buttons and go to properties,
...click on the event tab. You should see [Event Procedure] on the
On Click event. Click the elipsis (...) to get at the code.

hth,
...bob
 
Bob -

Thanks for the input, but that's not working either. A click on the elipsis
opens the VBIDE, but not the code window for frmSwitchboard.

I have kept poking and prodding on a copy of the adp - creating a copy of
frmSwitchboard, renaming the original frmSwitchboard with an _old suffix,
then renaming frmSwitchboard _copy to frmSwitchboard and then doing some
other renamings (the exact sequence is lost from memory) and have eventually
wound up with a frmSwitchboard whose code I can see. In the interest of
getting some real work done, I'm making chages to that code.

However, I did go back to the original adp to try your elipsis suggestion
and found that it didn't work.

So, while I am making progress, it would sure be nice to know if this
behavior is something to be expected when working on adp's created from
Access db's and what to do the next time this occurs (other than beat on it
until it will let me see the code!)...

James

Bob McClellan said:
James,
If you open frmSwitchboard in design view,
..and right click on one of the buttons and go to properties,
..click on the event tab. You should see [Event Procedure] on the
On Click event. Click the elipsis (...) to get at the code.

hth,
..bob

james said:
I've inherited support duties for a database that apparently was
created in Access and then turned into an Access adp / SQL Server 2005
project. (The developer has left the company - a friendly move, for
him at least - for a job with another company, so he's not around to
answer questions.)

This is my first exposure ever to adp's and I've been requested to do
some very simlpe changes to it - basically adding to a table a field
for comments, add them to a report and add a spot for them to the data
entry form for one type of user of the db.

Unfortunately for me, he implemented all the data entry in a multipage
control on a form frmSwitchboard, which I'm assuming was the Access
mdb switchboard before it was converted into an adp.

My problem - don't laugh - is that I can't find how to find / get to
the code associated with the frmSwitchboard. When I try via the
VBIDE, a click on the the 'show code' menu item gives no response.
There is code in the form - I copied the form, and I can get to the
code in frmSwitchboard_copy, but I'm clueless on why I can't find a
way to get to the code on the original frmSwitchboard. I have to
modify that to let the right user group enter the comments.

So far as I can tell, this isn't a security-related issue - at least
in terms of what users can do what things in the db - I'm using 'type'
and 'group' only in the sense that people with several job
descriptions use the db, but the requested modifications will be
relevant only to some of the users...

Any help would be most appreciated!

James C
Click to expand...
Click to expand...
 
James,
the form event procedures should all be accessible via the elipsis.
OnOpen, OnChange, OnActivate... every event with code should be accessible
via the elipsis. When you were able to get to the code, after all of your
renaming... how
did you access it?

Also, for access realted questions,
I've found that : http://www.access-programmers.co.uk/forums/index.php has
way more activity.

hth,
bob


James Cox said:
Bob -

Thanks for the input, but that's not working either. A click on the
elipsis
opens the VBIDE, but not the code window for frmSwitchboard.

I have kept poking and prodding on a copy of the adp - creating a copy of
frmSwitchboard, renaming the original frmSwitchboard with an _old suffix,
then renaming frmSwitchboard _copy to frmSwitchboard and then doing some
other renamings (the exact sequence is lost from memory) and have
eventually
wound up with a frmSwitchboard whose code I can see. In the interest of
getting some real work done, I'm making chages to that code.

However, I did go back to the original adp to try your elipsis suggestion
and found that it didn't work.

So, while I am making progress, it would sure be nice to know if this
behavior is something to be expected when working on adp's created from
Access db's and what to do the next time this occurs (other than beat on
it
until it will let me see the code!)...

James

Bob McClellan said:
James,
If you open frmSwitchboard in design view,
..and right click on one of the buttons and go to properties,
..click on the event tab. You should see [Event Procedure] on the
On Click event. Click the elipsis (...) to get at the code.

hth,
..bob

james said:
I've inherited support duties for a database that apparently was
created in Access and then turned into an Access adp / SQL Server 2005
project. (The developer has left the company - a friendly move, for
him at least - for a job with another company, so he's not around to
answer questions.)

This is my first exposure ever to adp's and I've been requested to do
some very simlpe changes to it - basically adding to a table a field
for comments, add them to a report and add a spot for them to the data
entry form for one type of user of the db.

Unfortunately for me, he implemented all the data entry in a multipage
control on a form frmSwitchboard, which I'm assuming was the Access
mdb switchboard before it was converted into an adp.

My problem - don't laugh - is that I can't find how to find / get to
the code associated with the frmSwitchboard. When I try via the
VBIDE, a click on the the 'show code' menu item gives no response.
There is code in the form - I copied the form, and I can get to the
code in frmSwitchboard_copy, but I'm clueless on why I can't find a
way to get to the code on the original frmSwitchboard. I have to
modify that to let the right user group enter the comments.

So far as I can tell, this isn't a security-related issue - at least
in terms of what users can do what things in the db - I'm using 'type'
and 'group' only in the sense that people with several job
descriptions use the db, but the requested modifications will be
relevant only to some of the users...

Any help would be most appreciated!

James C
Click to expand...
Click to expand...
Click to expand...
 
Back
Top