[AccessD] The Mysterious Case of the Missing Code

Darryl Collins darryl at whittleconsulting.com.au
Mon May 7 18:20:03 CDT 2012


I know if you leave any breakpoints in the code and crash (or sometimes even close the DB) then the breakpoint will be left in the code.  It will just run until the (now invisible) breakpoint and stop.  I usually do a "Clear all breakpoints", Debug, compile to fix this issue.

Of course, yours seems different to this as you are getting an error as well...

I have seen code removed before - although I never did find a good reason why - I always suspected some anti-virus software lurking back on the corporate server somewhere.

Cheers
Darryl


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Mattys
Sent: Tuesday, 8 May 2012 7:35 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] The Mysterious Case of the Missing Code

If I recall correctly, you need only delete a blank line, hit return again, and compile.
There is something hidden in there that causes a hard stop and error all at once.

Michael R Mattys
Mattys Consulting, LLC
www.mattysconsulting.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, May 07, 2012 4:43 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] The Mysterious Case of the Missing Code

Possible key word conflict?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Monday, May 07, 2012 11:42 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] The Mysterious Case of the Missing Code

Well, what has worked for most of it, was to open a backup that I found from Feb 2009...there were many backups, but this is the only one that seems to work...and copy the code...cut & paste, and re-type some as well. But, I seem to be running into a snag w/the reports...I think there are differences since the backup was made...and it is buggin' out on some pretty straight forward code. ...see below...
____________________________________________________________________________
___
Private Sub CmdSummaryRpts_Click()
On Error GoTo Err_CmdSummaryRpts_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmCriteria"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    Form_frmCriteria.DtStartDate.Visible = True
    Form_frmCriteria.DtEndDate.Visible = True
    Form_frmCriteria.CmdInterest.Visible = True
    Form_frmCriteria.cmdBalances.Visible = True
    Form_frmCriteria.cboStatus.Visible = False
    Form_frmCriteria.CmdLabels.Visible = False
 
*** It doesn't like the "Form_frmCriteria" part...back to the drawing board.

 

>>> "Michael Mattys" <michael at mattysconsulting.com> 5/7/2012 9:39 AM >>>
That has happened to me when using an Access 97 database opened with a new version.
I did a back-up first, saved it as the newer version and found that I couldn't get the objects back.
I had to use the "Open With..." feature with the back-up.

Michael R Mattys
Mattys Consulting, LLC
www.mattysconsulting.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Monday, May 07, 2012 9:00 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] The Mysterious Case of the Missing Code

Hello All...and Good Morning (Niagara Falls, NY time anyhow)!

Well, it has been quite some time since I've requested any help from y'all...my job has included many non-access things lately...but I think this one might be a doozy...or, perhaps it is just me being brain-dead. I'll accept the latter, if it means finding a quick solution.

I went out on-site to one of our departments this morning, because they reported to me last week, that they couldn't see their data. I got into their program from my desk...I'm on the same network...and I could see their data fine...and I did it using their front-end program. So, I figured it was something simple like "trusted location" or a mapping issue...or something along those lines. 

When I got here, I did see that there was a trusted locations issue w/the first PC...it was newly installed and I expected that. BUT...now I am into the program and the data looks there, and the opening menu comes up, but no buttons work. This is because all the code behind the buttons seems to be gone. I looked at another menu...just the design view...and that code is gone too. To get even freakier, I opened up a backup from 2009...and that code is gone as well!

I used this same front-end from my PC on Friday...they share a front-end on the network...yeah, I know...but this is how they have it setup...I do plan on changing this for them, once it all is ironed out. This code was obviously there for me...I ran it. So, how is it missing now? I'm about ready to drive all the way back to my office to test this...I'm at a total loss. 


John W. Clark
Computer Programmer 


         


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list