Customer search pulls blank record

[Guest]

I have a customer order search form that pulls specific Customer orders.
Sometimes when I make a minor change to the customer order form, like add a
field, move a field, etc., my customer search pulls a blank order form. I go
back and put things back like they were, but I still get a blank. The only
thing I can do is to import the form from a backup copy and start over. Is
there any way to fix this kind of problem?
Thanks

 

[Arvin Meyer [MVP]]

It sounds as though you may have a corruption problem. First, always work on
a copy of the database. Working on the original may make it impossible for a
repair service to fix it. Try running a Compact and Repair on the form.
Then:

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Guest]

I will take a look at these resources.
Thanks very much.

Ron