Unstable Queries

[Guest]

I have Access 2000 (9.06926 sp-3).

I have created a table and a simple query that sorts on 1 field a select on
2 fields (one alpha, one numeric). There are 7 fields in the query.

I save the query and it works as intended.

Then I create a form and select the fields I want to see

I save the form with Form as the default view.

Then I change the form to have Datasheet as the default and only allowed view.

I save the form.

I try to run the form

It open it, and I get a Type Mismatch Error.

When I look at the query again, all 7 fields are the same field (???) and
the selection criteria have been now clumped together under the 1st field
(remeinder, all of which are the same now). This field is numeric and since
one of the selection criteria had been alpha - this is in error - hence the
Type Mismatch Error.

It appears that the only time this gets corrupted is if I make any change at
all in the design mode or live mode to the form.

If create the form initially and set the default and allowed views to
Datasheet and run the form, it works.

But if I change the column width or row height and exit - the query gets
corrupted as described above.

I have talked to a developer in the UK and says this problem does not happen
in Office 2003 with SP-1.

Is this an Office 2000 bug - and is there a patch?

 

[Jeff Boyce]

Randy

I've been using A2K for as long as it's been out -- never seen this one.

What happens if you throw out the old query and form (rename, throw out
later), recompile, Compact & Repair the database, and start over?

 

[Ken Snell [MVP]]

And turn off Name AutoCorrect options?