Search results

See query below; It doesn't Run due to a syntax error. I've split it into chunks and each chunk builds the string properly, but upon recombining. Doesn't work! Appreciate it. CurrentDb.Execute "INSERT INTO MsysUsers (FirstName, LastName,PWD, PWDDate)" & _ " SELECT '" &...

@Pat Hartman , I understand. Better to keep count in a form as you suggest.

So, Pat you raise an important question & have opened my eyes!. If I say, make changes then save as a different filename I'd loose the values stored as a 'property'? I think that's how I read your response. If that's the case saving to a table seems a bit better!! Never mind, at least I've learn...

@Pat Hartman , Pat in essence, this is what I've been doing. I like the idea of saving the 'counter' value outside a table. Saving as a 'property' is a new concept for me and I see opportunities to save stuff here.

@arnelgp , a queston. When i run function Update (filename as string) do i need to pass in the database name? Eg Update("example.accdb") ?

@Gasman, thanks i'm sure i've created the property as i can recall it. Just cannot update it. I like your and @arnelgp 's code and will adapt to suit my purpose. I've not played with database properties before. New to me. Thanks

@isladogs, thanks. I will run an office repair. Had not thought of that. Will also try with excel just to be sure. Will keep you posted.

Guys, yes i have saved the property. Ran code to save property as per Allen Browne's example. Will give @arnelgp 's code a go. Thanks

Friends, I wish to increment a counter each time my main form is opened to track usage. I've Managed to save my usage counter & recall it to an unbound textbox using Public Function Usage() ' recalls usage counter value from database properties Dim DB As Database Set DB =...

@isladogs , will download the latest version of your add-in & thanks for your efforts. I cannot be the only one with this problem? Will wait & see. Once again thanks.

@isladogs , so I searched the registry as suggested. Please see screenshot attached. I also ran your function, which reported 'Microsoft Windows 11 Home' Hope this helps.

@isladogs , try this. I hope it's what you need.

@isladogs , got you. Will do.

@isladogs , I cannot find that path. I copied/Pasted into file explorer & got zero. I had a look manually. Same. Could it be hidden or something?

Yep, a restart fixed the add-in. now visible on the 'add-in' drop down. Colin, thanks for your generosity. This is a most excellent addition to Access.

@isladogs , got it to install. But do not see the add-in in "add-in" manager, but will do a restart & try again. The problem was that the install ADDINS folder was not a trusted location. Thus, the app would not save there. Fixed now. Please see my post above of my Access version details. I...

Access / Windows/ Office Version Info ===================================== Date/Time: 16/10/2022 7:55:09 AM Workstation Name: DESKTOP-EMA4E0Q Operating System: Windows 10 Home Version 22H2 - Build 10.0.22621.674 64-bit Access Full Version: Access 2016 Version 2209 - Build...

@isladogs , will do. Thanks

@isladogs , I downloaded your add-in but get an error message upon installation. The message reads 'Error 3073 in Form_Load Procedure. Operation must use an updatable query'. It happens after the version info missing pop-up displays. I'm running windows 11 & 66 bit Access (office 365 legit copy).

@isladogs , thanks. Will do. Stay tuned!