Search results

Hi Guys, I have an access database which a user was using when the power cut off. Since then the database works mostly fine, but every now and again (about twice a day) Access seems to forget how it works, and it loses everything. As in, all the tables, queries, forms, reports and macros vanish...

Would LocalVars appear in the macro somewhere, or do I have to convert everything to code first?

No, but it is the only macro which is running. Plus,is the function SetLocalVars? Because I don't remember hearing of the function before, so I think it is unlikely I'm using it. I'll have a look through them though.

Yes, it is the LocalVars error again. But that's the thing, this is the only macro which runs when you start click the box. Unless an update query can have LocalVars? Sorry if I'm not making much sense, I'm totally self taught.

Right, I found the duplicated module, and deleted it, and then it worked on the original computer, but still throws the same error on the other computers. Here's the code it executes. Option Compare Database '------------------------------------------------------------ ' Done_Click '...

OK... I tried converting to VBA, and now it errors on the original computer with "The expression On Click you entered as the event property setting produced the following error: Ambiguous name detected: Done_Click."

OK, I'll give that I try. Unfortunately, the file is on the network at work, so I'll have to do it when I get in tomorrow.

OK, mystery makes more sense. I don't understand where it could be coming from. Could it be something to do with the two different version of Access? And I've done the same thing on those computers previously.

I don't use any variables within the macro, it just copies the data from one form to another, and then opens an update query. And I don't understand, in what way is it a misnomer?

OK, I have some Set Value steps in the macro, but why would they error on one computer, and not the other? And what does that error actually mean?

Hi, I have a database in Access 2000 format which has been being used for years now, and it's just developed a problem. I have one datasheet form, which has a tick box field. When this field changes, a macro runs which updates another form, opens a third form for the user to enter some data...

Hi there everyone, I'm from the UK, near Cambridge, with a reasonable level of experience with Access, it's just sometimes I swear it's difficult on purpose...