Form crashes every time I add unbound element

[brett429]

I don't know what is wrong with this form... but every time I add any kind of unbound element (I've tried checkboxes, combos, etc.), whenever I click the Refresh Data button I have on that form, it gives me this error:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

Then it closes the database and restarts in a backup.

 

[MSAccessRookie]

I don't know what is wrong with this form... but every time I add any kind of unbound element (I've tried checkboxes, combos, etc.), whenever I click the Refresh Data button I have on that form, it gives me this error:

Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.

Then it closes the database and restarts in a backup.

I hope that you have tried to Compact and Repair the database, but if you have not, try that, Sometimes Access has issues when there is too much internal overhead in the database.

 

[brett429]

I hope that you have tried to Compact and Repair the database, but if you have not, try that, Sometimes Access has issues when there is too much internal overhead in the database.

I've tried that already, unfortunately. I'll just have to use a button to do what I needed to do... it's not the best way, but it will have to work.

I've always had issues with forms crashing. Sometimes they'll just freeze and then I cannot even get back in to view or edit the form... it's completely gone. I have to constantly backup my work in case something screws up. I've had Access re-installed on this computer in case it was corrupt, but that didn't help. The only thing I can think of is that sometimse I work on it at home, and I use Access 2007 there (2003 at work). So maybe there's some issue using 2 different version? I have no clue.

 

[MSAccessRookie]

I've tried that already, unfortunately. I'll just have to use a button to do what I needed to do... it's not the best way, but it will have to work.

I've always had issues with forms crashing. Sometimes they'll just freeze and then I cannot even get back in to view or edit the form... it's completely gone. I have to constantly backup my work in case something screws up. I've had Access re-installed on this computer in case it was corrupt, but that didn't help. The only thing I can think of is that sometimse I work on it at home, and I use Access 2007 there (2003 at work). So maybe there's some issue using 2 different version? I have no clue.

Has the form existed for a long time and been modified frequently, or does the form has a large number of Controls?

I remember reading somewhere that Access has a FIXED MAXIMUM number of controls allowed for a form OVER THE LIFETIME of the form. One of the other experts will have to explain why this is the case, as I have not seen a valid explanation, only a reference to the allegation, which was not refuted at the time.

 

[brett429]

Has the form existed for a long time and been modified frequently, or does the form has a large number of Controls?

I remember reading somewhere that Access has a FIXED MAXIMUM number of controls allowed for a form OVER THE LIFETIME of the form. One of the other experts will have to explain why this is the case, as I have not seen a valid explanation, only a reference to the allegation, which was not refuted at the time.

Forgive my ignorance - I'm assuming a control could be considered a text box, combo, button, etc. In that case, I'd say I have say I have about 60. Over the lifetime, though, I have no clue... I'm sure there have been more that I've deleted since I created the form.

 

[brett429]

Forgive my ignorance - I'm assuming a control could be considered a text box, combo, button, etc. In that case, I'd say I have say I have about 60. Over the lifetime, though, I have no clue... I'm sure there have been more that I've deleted since I created the form.

Though if that's the case, why would it just let me add two buttons with no problem, yet one checkbox causes a crash? It makes no sense

 

[MSAccessRookie]

Forgive my ignorance - I'm assuming a control could be considered a text box, combo, button, etc. In that case, I'd say I have say I have about 60. Over the lifetime, though, I have no clue... I'm sure there have been more that I've deleted since I created the form.

Anything that you can place on a form that shows up in the Properties List is a Control. You are correct about the ones that you have stated. With the current Form having less than 100 Controls on it, it is unlikely that you have exeeded any limitation. Perhaps there will be other ideas.

 

[MSAccessRookie]

Though if that's the case, why would it just let me add two buttons with no problem, yet one checkbox causes a crash? It makes no sense

Maybe something is wrong with the checkbox or its source properties.

 

[brett429]

Maybe something is wrong with the checkbox or its source properties.

To your previous reply: Well, if you're counting text, labels, boxes, etc., then I'd be well over 100. Though it still wouldn't explain why I was able to add the buttons with no problem.

To this reply: I don't know what would be wrong with the checkbox controls. I'm simply creating a new checkbox using the toolbar, so all the Access defaults would be in place.

 

[Banana]

My guess is that sometime Access loses track of objects edited/deleted/added so while you may have only X objects, Access is still keeping track of Y, which may have hit the maximum limitation.

If Compact & Repair doesn't fix it, try importing all objects into a new database (be sure to turn off AutoCorrect first). It should usually fix it.

 

[brett429]

My guess is that sometime Access loses track of objects edited/deleted/added so while you may have only X objects, Access is still keeping track of Y, which may have hit the maximum limitation.

If Compact & Repair doesn't fix it, try importing all objects into a new database (be sure to turn off AutoCorrect first). It should usually fix it.

I imported everything into a new DB, but it's still having issues. I guess I'm just out of luck.

 

[Banana]

Do you get the same result if you re-created the form?

 

[MSAccessRookie]

Do you get the same result if you re-created the form?

Banana's Advice is correct. Would it be possible for you to create a Blank Form and then add each Control one at a time until the old form is reproduced? I realize that this will probably be a very tedious effort, but it will eliminate the issue that I was speaking about before.

 

[brett429]

Banana's Advice is correct. Would it be possible for you to create a Blank Form and then add each Control one at a time until the old form is reproduced? I realize that this will probably be a very tedious effort, but it will eliminate the issue that I was speaking about before.

I thought about doing that, but it would take a LONG time... unless I was able to just Select All, Copy, Paste all the controls... and then copy all the VB coding. But I'm worried I'd break something in the process...

 

[MSAccessRookie]

I thought about doing that, but it would take a LONG time... unless I was able to just Select All, Copy, Paste all the controls... and then copy all the VB coding. But I'm worried I'd break something in the process...

That appears to be the best advice so far.

 

[brett429]

That appears to be the best advice so far.

Thanks for the help, guys! Since I was able to work around the issue for now, I'll just continue as-is since I'm nearly done with the form. But I will try that suggestion should the need arise. Thanks again!