Macro crashes the database

[access2010]

Could I please receive a suggestion on why our database keeps crashing when we run the Macro CTRL + A.

The message that keeps appearing is, THE RECORD HAS BEEN DELETED

Your suggestion will be appreciated.

Nicole

 

[The_Doc_Man]

The only thing I see is that Control_A runs a form which uses some web-related tools. Since I do not manipulate the web from Access/VBA, I have no expertise in this. However, I would at least assure that you have the necessary libraries referenced from the VBA screen, Tools >> References

Having "funky" or missing references can cause all sorts of weirdness. That is all I can suggest. Maybe someone else will come behind me and look at it.

 

[moke123]

Does not crash for me. Could you explain in detail what needs to be done to re-create your issue.

 

[Mike Krailo]

I can also confirm that Ctrl-A, Ctrl-W works all day long on my machine. I have O365 64-bit. The macro is simply opening the form ResearchAnalyst_F. I'm not sure what Doc was talking about web related tools. I didn't see anything like that when just opening the form. There are some web links in one of the tables but I don't see anything other than the form opening after using Ctrl-A. Nothing much in form load event either.

 

[access2010]

The only thing I see is that Control_A runs a form which uses some web-related tools. Since I do not manipulate the web from Access/VBA, I have no expertise in this. However, I would at least assure that you have the necessary libraries referenced from the VBA screen, Tools >> References

Having "funky" or missing references can cause all sorts of weirdness. That is all I can suggest. Maybe someone else will come behind me and look at it.

Thank you Doc for your note.
Could you please suggest, which references that should be added to our Access 2003 Database?

 

[access2010]

Does not crash for me. Could you explain in detail what needs to be done to re-create your issue.

Thank you for your note.

For most parts of the day there is no problem, than we receive the message, THE RECORD HAS BEEN DELETED.

Any suggestion you may have will be appreciated.

I can also confirm that Ctrl-A, Ctrl-W works all day long on my machine. I have O365 64-bit. The macro is simply opening the form ResearchAnalyst_F. I'm not sure what Doc was talking about web related tools. I didn't see anything like that when just opening the form. There are some web links in one of the tables but I don't see anything other than the form opening after using Ctrl-A. Nothing much in form load event either.

Thank you for your note.
Sometimes this function works and other times it does not.

 

[The_Doc_Man]

To be honest, no. I don't use web-related tools to attempt downloads or "scraping" or the other things you can do to web pages from Access. Never tried it. It is possible that I mis-interpreted what I saw, but I saw that you were following a hyperlink. When I went back, I realized it was perhaps not what I first thought. I don't see anything obvious.

What is the point of following a hyperlink in that context? I don't see anything else that would do anything other than launch the hyperlink target. However, if that hyperlink leads to something that requires another app to run, it may be that the error event isn't due to Access.

 

[Mike Krailo]

Well that makes it much harder to troubleshoot if it doesn't happen all the time.

Doc, I still don't see what you are referring to where a link is being scrapped for data. Could you point out exactly what area this is?

 

[The_Doc_Man]

The point is, Mike, that I went back and looked more closely, and that DIDN'T happen anywhere when I expected that it would. Which is why I retracted my comments. The DB seems to be looking at something for which the hyperlink is in some field with a name that suggests it is a web page. But on further examination I can't see what is being done to the web page.

@access2010 - you get a "RECORD IS DELETED" error - but does anything else happen? Just the mysterious message? And if you can do so, do you attempt to verify that, in fact, a record has been deleted?

 

[Eugene-LS]

why our database keeps crashing when we run the Macro

Some database objects have Russian names - this may cause if your system does not have the Russian language.
I'm fixing it now - I'll finish it soon.

 

[moke123]

I noticed you do not have

Option Compare Database
Option Explicit

delared in your form modules.

These should be in every module.

 

[Eugene-LS]

@access2010
Try file below ...

These should be in every module.

Fixed already

 

[Mike Krailo]

Some database objects have Russian names - this may cause if your system does not have the Russian language.

Which objects exactly are you referring to? I didn't see anything other than those types of characters inside comments in the form code. Is that what you mean? Why did you have to wipe out the table and repopulate with data? I'm just trying to understand what you did.

 

[Eugene-LS]

I'm just trying to understand what you did.

Almost nothing.
I corrected the forms a bit, checked and corrected the code. Corrected the macro.
What did you expect?

 

[Mike Krailo]

I did not see that Eugene. Thanks for pointing that out. How on earth did you find that? That was buried in there pretty good. I don't see any other controls like that either.

 

[Eugene-LS]

I don't see any other controls like that either.

I didn't find more either, but I checked everything.
Fixed a couple of procedures and wrote one function for the macro
+ various little things - Option Explicit - etc ...

I'm sure I didn't do any harm, even maybe the opposite .