Difficultyentereing/editing fields on the Query Grid

[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?

 

[Jerry Whittle]

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.

 

[Phil Smith]

2007, should be up to date, and it seems to happen with multiple
databases, including a brand new one I was working on.

 

[wangdong]

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

 

[Tony Toews [MVP]]

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/

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/