Petrol
Last Activity: Jul 13 '25, 01:54 PM
Joined: Oct 13 '16
Location: Brisbane, Queensland, Australia
-
Does anybody have any ideas on how to solve the problem reported in the OP above? Essentially the problem is that intermittently (I can't find any pattern) i get an error message with a large negative number, saying "The data has been changed" when doing an SQL UPDATE through VBA (see the line "CurrentDb.Exec ute strSQL" in the OP). Despite the comment that immediately follows that line, the error sometimes occurs even with the... -
I had a similar problem: The error message staarted "200 ParseError SyntaxError. Json ..." Is this what you were getting?
I reported it and Niheel has just told me that he has fixed the bug, and asked me to test it. So this post is the test.Leave a comment:
-
I'm not having much success here. I did go to the Discord site (strange name ... strange site ... looks as though it was written by and for people about a quarter my age đ). Found I had to join, so I did. Found I couldn't send a message to you because it said you weren't a friend. Sent a friend request (about 26 hours ago) but got no response, so I presumably missed some critical step.
Meantime I googled Active Directory and found...Leave a comment:
-
Well, that's a major shock. I have heard nothing of or from AUG for a months, and didn't know how to find their meetings. I did manage to find a link to your lunchtime meeting, but couldn't find a recording of it; the Previous Meetings window didn't take me anywhere helpful..
I had no idea Windows provided a ready-made secirity facility. and so far haven't been able to find anything about it. I'm sorry I missed your persentation....Leave a comment:
-
The data has been changed
My Form01 allows the user to log on and change their password, by entering a new password twice; if the entries match, the SHA256 hash is created and stored in the AccessAuthority table. The code invoked after the new password is entered, is as follows:
...Code:Private Sub txtReenterPassword_AfterUpdate () ' ' This is called if the user is updating his password and enters this new one a second time ' Dim strHash As String, strNewExpiry
-
OK, I've done that. More detailed testing required, but it seems to open OK now. Thanks again.Leave a comment:
-
Hmm, yes, I was afraid that might be the solution. Either that or copy everything to a new DB. Long slow process either way :(. But thanks for your thoughts.
I'll try to get to the meeting, if my soon-starting meeting finishes in time.Leave a comment:
-
By the way, I have tried -- Deleting and rewriting Autoexec and Startup
- Rebooting the computer
- Compact and repair
- Decompile and recompile
- Tearing my hair out
Leave a comment:
-
Hmm, maybe Post,Bytes can't handle Word attachments. I'll try a PDF....
Leave a comment:
-
I'll have another try at attaching the document - it got an error when I posted last time....Leave a comment:
-
Autoexec macro unable to Runcode (Error 2425)
My DBMS runs perfectly from the .accdb, and compiles without error. But when I try to run the resulting .accde it fails during the Autoexec macro with Error 2425, âThe expression you entered has a function name that [application title] canât findâ.
The function call is a RunCode to Public Function Startup(), and it is the only action in the Autoexec macro - see attached document. The function is in a standard module âSystemFunction sâ. ... -
Oh. Thank you. How should I have known I had a PM?Leave a comment:
-
Thanks for that. I didn't receive the Zoom invitation, but I found the group from one of your earlier posts to me, and have just joined.
I would love to attend, but today doesn't work. I haev a regualr meeting Friday mornings which I can usually skip or truncate, but today I'm leading it. I may be able to slip in briefly between appointments, but I'll try to keep future meeting times free.
Middle of the night for you?!Leave a comment:
-
Oh dear, I need a new brain. Why can't I see these things?
Many thanks, Jim, I'm indebted to you.Leave a comment:
-
Errror 3021 - No current record
Running Access 365 under Windows 11 24H2, I am getting Error 3021 (No current record) if I delete a record from a recordset and then subsequently call a particular external procedure. The code for the sub in which the error occurs is as follows:
...Code:Private Sub DeauthoriseSTC( ) ' The STC or Lagistics person will have been given read-write asccess to LiveData during the event. ' Now that the event is over, we remove that access
-
Thanks for that - I wasn't aware of that users grouop. It's not apparent from the linked-to website that there is a meeting in Friday 15th, but I'll have a look next week and see how we go.Leave a comment:
-
Oh, a bang! How embarassing! How could I have missed that?
Don't ever get old, Adrian. Remain perpetually Neo.Leave a comment:
-
I should have mentioned that when Access VBA gives the compile error, it highlights the field name (PersonID, EventNum, or Key, whichever it comes upon first) in the If statement.
Also, when I changed the source of the recordset from the table to a query built on the table, containng the same fields amongst others, I still get the same compile error.Leave a comment:
-
Unrecognised member of a recordset
In Access 365 I have sub which opens a dynaset-type recordset based on a table, but it won't compile because it claims it "can't find" the fields in the records. It gives compile error 461, "Method or data member not found". Yet the fields are definitely there. Here is a simplified version of the sub:
...Code:Private Sub DeauthoriseSTC( ) Dim rst As Recordset Set rst = CurrentDb.OpenRecordset("AccessAuthority", -
Sorry for the delayed response ... here in Brisbane for the past week or so we've been battling a big cyclone, with heaps of flooding, power lines down etc, so software development has had to take a back seat.
But thanks for the explanation, NeoPa. That makes it clearer, although I don't think I'll bother with the elegant and thorough option of using the escape character, this time at least. I'm confident my Db will never be used outside...Leave a comment:
No activity results to display
Leave a comment: