Difficultyentereing/editing fields on the Query Grid

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Phil Smith" wrote:

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

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






Jerry Whittle wrote:
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.

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 wrote:

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/