error when sorting within tab control

[Wylie]

I have a Access 2000 application that is using a bound form and
subform within a tab control. When the user sorts the subform the
application appears to function but any attempts to open another
(unbound) form give me "You can't carry out this application at the
present time" error. I need to use task manager to exit. The problem
remains when I return to the file, and I have to restart from a back-
up.

-wylie

 

[Golfinray]

Put a label on the subform. Go to properties/events of the label. Click on
the code builder in the onclick event. Type:
Me.orderby = "[yourfield]"
Me.orderbyon = true
Click the label and it will sort. You can several of these if the user needs
to sort in varying ways.

 

[John W. Vinson]

I have a Access 2000 application that is using a bound form and
subform within a tab control. When the user sorts the subform the
application appears to function but any attempts to open another
(unbound) form give me "You can't carry out this application at the
present time" error. I need to use task manager to exit. The problem
remains when I return to the file, and I have to restart from a back-
up.

-wylie

Wow. Sounds like something is corrupted! Have you tried Tools... Database
Utilities... Compact and Repair (with a working backup of course!!)? How is
the user sorting the subform, and how are they opening the unbound form:
directly or with code?

 

[Wylie]

Wow. Sounds like something is corrupted! Have you tried Tools... Database
Utilities... Compact and Repair (with a working backup of course!!)? How is
the user sorting the subform, and how are they opening the unbound form:
directly or with code?

I did that and it is still giving the same error. The data tables
bound to the form look ok. I went back to a clean version from
December thinking some spurious data may be causing the problem but as
soon as I click the A->Z button on the menu the database dies.

-wylie

 

[John W. Vinson]

I did that and it is still giving the same error. The data tables
bound to the form look ok. I went back to a clean version from
December thinking some spurious data may be causing the problem but as
soon as I click the A->Z button on the menu the database dies.

-wylie

I'd suggest applying the fixes suggested in Tony's website, then; particularly
create a new, empty database and import everything. It might be necessary to
rebuild this form.

 

[Wylie]

I'd suggest applying the fixes suggested in Tony's website, then; particularly
create a new, empty database and import everything. It might be necessaryto
rebuild this form.

Tony's website ?

-wylie

 

[John W. Vinson]

Tony's website ?

ooops! Sorry. I'd just posted it but in a different thread. My friend Tony
Toews:

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