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" <(E-Mail Removed)> wrote in message
news:CE700F12-BE57-44A9-AD3D-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:4421bfdf-90a8-4417-af7b-(E-Mail Removed)...
>> > 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
>>
Similar Threads
