A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

The Wysard needs help...! Bogus error message.



 
 
Thread Tools Display Modes
  #11  
Old November 5th, 2004, 08:38 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Fri, 5 Nov 2004 06:53:10 -0000, "Nick Coe \(UK\)"
wrote:

Lo John,

Interesting. BE on a server?

I'd have a look at what's actually happening to the BE mdb
and ldb files on an OK machine and a problem one with
FileMon.
http://www.sysinternals.com/ntw2k/source/filemon.shtml

Be useful to eliminate any persistant file locks or renegade
handles. Probably worth watching the FE too.

Is indexing set on the problem machines?

Clutching at straws now..... :-)


Me too...

That's a good idea. I've had NO luck figuring out what it thinks is
being updated by what else. I'll see if these tools can tell me...

Thanks Nick!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
  #12  
Old November 5th, 2004, 08:53 AM
Nick Coe \(UK\)
external usenet poster
 
Posts: n/a
Default

Might be worth getting the client to send you one of the
system boxes that shows the fault so that you can work on it
directly.

--
Nick Coe (UK)
AccHelp v1.01 Application Help File Builder
http://www.alphacos.co.uk/
Download Free Demo Copy
----
"John Vinson" wrote in
message ...
On Fri, 5 Nov 2004 06:53:10 -0000, "Nick Coe \(UK\)"
wrote:

Lo John,

Interesting. BE on a server?

I'd have a look at what's actually happening to the BE mdb
and ldb files on an OK machine and a problem one with
FileMon.
http://www.sysinternals.com/ntw2k/source/filemon.shtml

Be useful to eliminate any persistant file locks or
renegade
handles. Probably worth watching the FE too.

Is indexing set on the problem machines?

Clutching at straws now..... :-)


Me too...

That's a good idea. I've had NO luck figuring out what it
thinks is
being updated by what else. I'll see if these tools can
tell me...

Thanks Nick!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps



  #13  
Old November 5th, 2004, 10:44 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

"John Vinson" replied in message
...
... I was able to SaveToText but got an error on LoadFromText
("unable to generate output file") so I just imported the form and its
subforms.


John, the fact that LoadFromText fails bothers me.

Peter Miller has been saying for 3 years now that importing a form can
simply import the corruption, and this error message is definately
associated with corruption (amongst other things).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


  #14  
Old November 5th, 2004, 05:32 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Fri, 5 Nov 2004 07:53:20 -0000, "Nick Coe \(UK\)"
wrote:

Might be worth getting the client to send you one of the
system boxes that shows the fault so that you can work on it
directly.


That's not gonna happen... any more than the SEAACA animal control
facility will pay for me to fly down there! g I can work on it over
Citrix, and reproduce the fault there.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
  #15  
Old November 5th, 2004, 06:13 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

Hi John,

Two things really jump out at me from comments elsethread:

Number 1:
I hadn't done so but it didn't help when I did. I was able to
SaveToText but got an error on LoadFromText ("unable to generate
output file") so I just imported the form and its subforms.


I agree with Allen; that definitely sounds like at least *some* form of corruption.
Not being able to LoadFromText is very, very fishy.
Can you try something on a backup copy?

1. Delete ALL the code behind this massive form (yes, all of it).
2. Compact the database.
3. Try the SaveAsText and LoadFromText now.
Are you able to LoadFromText now or do you still get an error?
If you can LoadFromText successfully then it is quite probable the VBA
code behind the form has become corrupt.

Number 2:
The Form that does it consistently is the LEAST used of the major
forms. There are three applications. It's an animal shelter database;
there are Calls (injured animals, dangerous animals, strays, etc);
Impounds (animals picked up to be sheltered); and Licensing. It's the
Licensing that's causing the problem. It now happens on EVERY attempt
to create a new record - and each time I enter data on a subform, I
get *six* of the error message popups. If I then leave the computer
alone, I get a new message every few seconds - scores of them if I go
off for a while.


Messages appearing from nowhere also sounds very weird!
Do you have any rogue Timer events running anywhere in this application?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"John Vinson" wrote in message
...
On Thu, 4 Nov 2004 18:46:14 -0800, "Jeff Conrad"
wrote:

Hi John,

In addition to the things Yoda mentioned here are a couple more things to check:

Are all the computers on Service Pack 1 for Access 2003? Some, but not all?

I doubt this would be the case, but it way be worth checking to see *exactly*
what version of Jet everyone is using.

Jet 4.0 SP8 will have a version number of 4.0.8015.0


I'll ask my client to doublecheck.

However, a Windows security update (can't remember which one) updated
Jet past that number. If everyone has installed Service pack 8 AND all the
Windows Updates the Jet version should be 4.0.8618.0.
Might be worth checking.

Is the problem occurring on every computer for your client or just one (or several)?


Several.

Thanks!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps



  #16  
Old November 5th, 2004, 06:39 PM
Dirk Goldgar
external usenet poster
 
Posts: n/a
Default

"John Vinson" wrote in message


The Form that does it consistantly is the LEAST used of the major
forms. There are three applications. It's an animal shelter database;
there are Calls (injured animals, dangerous animals, strays, etc);
Impounds (animals picked up to be sheltered); and Licensing. It's the
Licensing that's causing the problem. It now happens on EVERY attempt
to create a new record - and each time I enter data on a subform, I
get *six* of the error message popups. If I then leave the computer
alone, I get a new message every few seconds - scores of them if I go
off for a while.


Anything interesting in functions called by conditional formatting?
Could there be something going on in conditional formatting that is
forcing a record to be saved?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


  #17  
Old November 6th, 2004, 12:56 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Thu, 4 Nov 2004 20:32:24 -0700, "Albert D. Kallal"
wrote:

The places I would look for is there any update code that runs and modifies
some data?

Any focus changes from sub-form to main form when this error occurs? (and
that code uses a sub-form recordset clone?).


Yes... and when I took that code out the problem *seems* to have
resolved!!!

Two bits of code, don't know which did it:

- The users want to be able to enter an address (on a subform) without
entering a name (on the mainform). I had code to check to see if
Parent!ContactID was NULL; if so, it would insert "Unknown" into
Parent.LastName and then set Me!ContactID to (the new)
Parent!ContactID.

- There was another "alert" form, frmComplaintsAtAddress, which
displays all prior complaints referencing the entered address. I was
requerying that subform in the AfterUpdate event of the Address field.

- The third thing I removed was a Me.Dirty = False in the AfterUpdate
of the Address Number field (to keep the ComplaintsAtAddress as
current as possible).

Commenting out these three has - with *limited* testing - apparently
resolved the issue. More testing from users tomorrow!

Is the practice of using subform recordset clones and/or focus changes
deleterious in general?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
  #18  
Old April 7th, 2005, 06:05 PM
BillieGoat
external usenet poster
 
Posts: n/a
Default

John, Did you ever find the solution to the problem? I am having the same
problem with a client database and have tried what seems like everything to
fix the issue.

Thanks, Billie Cornell

"John Vinson" wrote:

On Fri, 5 Nov 2004 07:53:20 -0000, "Nick Coe \(UK\)"
wrote:

Might be worth getting the client to send you one of the
system boxes that shows the fault so that you can work on it
directly.


That's not gonna happen... any more than the SEAACA animal control
facility will pay for me to fly down there! g I can work on it over
Citrix, and reproduce the fault there.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bogus Currency Formatting? r. howell Running & Setting Up Queries 1 September 12th, 2004 01:34 AM
Excel loading bogus files on startup. Why? Mike Echo Worksheet Functions 2 January 22nd, 2004 10:53 AM
O.T. - Bogus MS Patches RagDyer Worksheet Functions 20 September 23rd, 2003 04:38 PM


All times are GMT +1. The time now is 02:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.