Hi Aftab.
"I tried the same but not fruitful."
That is not a helpful response to what I've said already. You've dimissed everything I've said with a short sentence that tells me nothing.
You must do more if you want anyone to spend their time trying to help. What have you tried exactly? What were the results, exactly?
I'm afraid that my taking your database & sorting it all for you would...
NeoPa
Last Activity: 1 week ago
Joined: Oct 19 '06
Location: London - UK
-
Hi Aftab.
With almost no helpful information in your post there's little we can say.
Obviously, if you were working on your project without any sort of backups then saying you need to keep backups is no help this time, but make sure you learn from this never to work on anything of any importance without robust backups.
Assuming you have none though, I can only suggest you try - ON A COPY OF YOUR DATABASE &...Leave a comment:
-
I saw a new account called, simply, Peter (peter_11925). I suspected this was you so I responded, on the server, asking if it was Petrol but have seen no response to that yet. I can confirm there is no pending Friend request so whatever you tried to do seems to have failed.
I can tell you that the database sample I have available includes all the work done for you, and I will be happy to talk you through the process of implementing it...Leave a comment:
-
OK. It was supposed to be made available to all attendees but I couldn't find it even when I logged on so let's go another route.
If you aren't already a member of the Access Talk Discord server then here's (https://discord.gg/WA6YsCtRej) a link. This is a non-profit resource aimed directly at those interested in Access, set up by Access MVPs, so does not break the rules here. I'm on there much of the time anyway (Logged in & hoverng...Leave a comment:
-
Much as I hate to be the one who doesn't provide an answer but a work-around instead, I'm going to state - very strongly - that managing your own security within an Access project is just wrong in so many ways. I'm not sure if you were able (or willing even) to attend my recent presentation on this matter for AUG Lunchtime (https://accessusergroup s.org/lunch/event/access-lunchtime-5-2025-05-27/) with Maria Barnes, but there I provide an alternative...Leave a comment:
-
It's not so much that AI is bad, but the costs of AI are being paid by others in many cases.
While the forum sites were always open to the public to read, I have to consider that the idea of taking all the data & using it to compete with the site is morally reprehensible if not legally theft. If you're making a profit from what you take, as well as reducing the profit of where you take it from - and on top of that don't even remunerate...Leave a comment:
-
It's a new site my friend.
Niheel (Owner) saw that the AI crawler bots were leading to so much activity (that he was paying for too) that the servers were unable to cope without increasing costs by upgrading to a new package. As this was pure cost (AI steals the info without any remuneration in such cases.) it was untenable - so he set up a new site.
I understand there are plans to improve the interface but I've found it...Leave a comment:
-
"rewrite them not using copy-paste."
Sometimes, you can even rewrite them WITH a Cut/Paste. Possibly do a Compile between the steps.
NB. The Cut removes them first & this is a critical step for this approach to work, just as Cactus suggests in his post.
If that doesn't work - & it may well not - then go ahead and take the longer route. With multiple lines of code though, test frequently. If it stops working...Leave a comment:
-
Hi Petrol.
From what you've explained here my only viable idea is that the database has picked up a cprruption somewhere.
My advice would be to take a working copy, as recent a one as you have that is known not to have this problem, then run a C&R on that (Belt & Braces approach) then take changed pieces of the new one into the good copy & test regularly.
If it goes wrong at any stage then you know...Leave a comment:
-
I'm glad that worked for you Aftab. I hope you now recognise that my previous question about backups was pointing you towards an understanding of how important they are and, as someone who works in this area, how responsible you are individually for ensuring your databases, and all those you manage at your work - and - to a certain extent those of all your family if they have any - get backed up so that you always have a reliable version to go back...Leave a comment:
-
That depends on how you've configured your notification settings, though they may have changed when we were all migrated across from Bytes.com.
If you can get them working reliably for you then it's better to continue such conversations there. I only posted in here to let you know about what was in there - as it were ;-)Leave a comment:
-
It was great fun. A little argumentative, but great fun. I'm not averse to some energetic expression of views :-)
I sent the invitation via the PM system here (https://post.bytes.com/messagecenter/new/51203) so hopefully you'll see it.Leave a comment:
-
Hi Petrol.
I just sent you a Zoom invitation to the Brisbane online user group meeting in 2 hours 30 minutes.
I look forward to meeting up if you can make it :-)
Cheers -Ade.Leave a comment:
-
OK. Sorry if I misinterpreted your question. I guess that leaves us looking into the table [MSysDb] (I assume the case is correct as you've used mixed case when referring to it). Getting that right is obviously important so well done for doing that.
This is neither one I recognise, nor one I can find in my database, so I had a quick look around the web for you and the concensus seems to be that your copy of the database is corrupted....Leave a comment:
-
Hi Aftab.
Let me start by saying that such a question raises red flags here as you're asking about how to break into a database that's had some levels of protection applied.
I know you aren't new here, and I checked that you seem to be a bona fide member who asks reasonable questions, but you've also asked before about getting into password-protected VBA projects.
This leaves me wondering why you wouldn't already...Leave a comment:
-
This Friday (14th) there's a San Fran one on, but for us it's actually early Saturday 15th. The link's :
https://stanford.zoom.u s/rec/share/YSW_hrrSkGkUh-i_0wbaf2gaMRoxz QU0CY52u3lUNOCB YagztXCCvPR_sEE 00NQ0.g0GYvRN-5xUUoAbD?startT ime=17395794700 00
Passcode: .M9mm.vR
This is a little different from the usual details so sharing those too in case you need them :
Meeting ID: 929 2609 8111
Password: 038332
...Leave a comment:
-
While I may still have a few years left on my clock, my friend, I suspect avoiding old-age is a ship that's passed. Perhaps not quite there yet, but the direction is set so I'll enjoy the ride while I still may :-)
PS. If you're living in Brisbane then why not come along to Kent Gorrell's next [link=https://accessusergroup s.org/access-express-australia/]Kent's Monthly Access Meet-Up[/link] meeting. He's also based there & has an...Leave a comment:
-
Hi Petrol.
I don't believe Fields are direct properties of a Recordset as you seem to assume. There is a Fields() Collection which allows you to refer to them in VBA, but as it's also a Default Collection you can refer to them using the bang (!) and that should work for you (IE. rst!EventNum, etc).
Forms do create Control names as direct Properties so maybe that's what you're confusing it with.Leave a comment:
-
Hi again.
It appears that the links to the old site are not working (Niheel did say he'd hook them all up.), so apologies for that. As a brief resume the format string should be as follows :
#yyyy\-m\-d#
This handles all possible scenarios and locales.
The procedure code I use to ensure all dates are returned in this (string) format is :
...Code:'SQLDate takes varDate in Date/Time or YYYYMMDD format and returns
Leave a comment:
-
Hi Petrol.
I see you have already found a solution that works for you, but Literal DateTimes and Their Delimiters (#) gives a bit more detail & allows you to make your code fully portable across all areas of the world.
By the way, the format you use is a standard SQL date format that is an alternative to the (possibly more common) USA date format that catches many out - both here & in the USA.
The reason...Leave a comment:
No activity results to display
Leave a comment: