Difficultyentereing/editing fields on the Query Grid

  • Thread starter Thread starter Phil Smith
  • Start date Start date
P

Phil Smith

This has been ticking me off for about two weeks now.

If I have a formula in the Query grid, and I go to edit it, whether
directly in the query grid or by hitting "build", any changes I make
dissapear when I leave that field.

If it is a new formula in a blank spot on the grid, as soon as I hit
enter or tab to move to the next blank spot, the edits have been dumped
and it is now blank.

Choosing a field from a table in the upper area works fine.

I have to fight with this reentereing my edits several times before it
takes.

Any Ideas?
 
What version of Access? Do you have the most recenty updates and service
packs installed?

I'd try creating a new database file and importing everything from the
problem database to it. If something won't import, it's corrupt and
corruption might be the problem.
 
2007, should be up to date, and it seems to happen with multiple
databases, including a brand new one I was working on.
 
Hi, Smith

Maybe your mdb file is corrupted.I think you can try a utility called
Advanced Access Repair to repair your Access MDB file. It works rather
well for my corrupt Access MDB files. Its web address is
http://www.datanumen.com/aar/

Alan
 
wangdong said:
Maybe your mdb file is corrupted.I think you can try a utility called
Advanced Access Repair to repair your Access MDB file. It works rather
well for my corrupt Access MDB files. Its web address is
http://www.datanumen.com/aar/
Click to expand...

1) You are an employee of such a company

2) You should be disclosing that fact more openly.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top