Search results

@Pat Hartman , very neat. Until now i've used a bit of code to populate a combo box with a recordset of 'actual' report names filtered by a 'like*' . That way it's dynamic but you have to get the real report name right for the 'like*' code to populate the combo box & the real report name is not...

All, you have provided me with plenty of approaches to try. I shall digest your recommendations, have a fiddle and see what works best. Thanks

@june , i open a form with docmd.openform in either 'add' with no filter parameters or 'filtered' by passing a 'where' statement if a related record exists. It's the checking of the 'does record exist' that's the subject of this thread. I'll just use a dlookup as advised by @isladogs. @Pat...

Pat, thanks for being so gentle. I kind of thought i was being clever to write this function as reusable code. As a learner and working in isolation (except for when i get stuck and call the forum for help) it is often difficult to determine the correct path. Googling code can send you in the...

@theDBguy , all seems OK. you know, I think I was not passing the parameters correctly when testing!!! I got a bit frustrated & called for help. Thanks for the support. Sometimes you have to take a step back from your work.

So, I have the following code that worked fine when the rs,findfirst line was hard coded (now commented out). I wish to make the function more universal by passing the 'find' part as a strwhere that I've built up. But, it doesn't work & returns an invalid argument error 3001. Clearly, there is...

All, I found, what I thought was a useful bit of code in the Access 2019 Bible "Deployment" section & thought it may be useful to others. What it does is write the error code etc to a text file. Previously, I'd always appended to an error log table within access, using an append to the error log...

@CJ_London , very cool. Thanks for sharing. And what about programming skills?. Did you just read & study?.

So, how did you people start out in this industry?

Well, i'm in the latter stages of writing a beekeeping database!. Although small, unimportant & insignificant, i'm passionate about writing it to the best of my ability & best practices. Hence, my questions on other threads.

Wow, pretty amazing stuff. The scale of these projects & implications scare me! I take my hat off to you both.

Yes, I probably should have used 'scope' instead. I'm interested in number of users, number of records, "importance" (I can't think of a better description), years in use etc. Really, anything of interest that describes access' capabilities.

To date, my projects have been limited to a split database with maybe up to 6 or so concurrent users. I'm keen to know the 'scope' of some of the applications running an access front end. If you feel inclined i'd like to know what you've done. Obviously no propriatory or intellectual details...

@Pat Hartman , thanks. I will digest this info. Cheers.

All, i have adopted the technique @stu_c purports. I disable the access close button to ensure that the user closes the application from the main menu. Otherwise they could have another form open, but hit the access close button which i thought was not exiting in the preferred way by leaving...

@Pat Hartman , tried the runtime tool & it appears to work. Made a test trusted folder, then deleted it. May come in handy!!

Will do. Thanks

Gets a bit complex for an amateur whom only wishes to share an application to people of varying PC skills. Thanks for the advice. Sorry to the originator of this thread for getting it off track.

Found this link. https://www.galleryimage.com.au/faqs-setup-trusted-locations.html

Pat, what if my project is a single user single install, on a pc that i have no control over. My concern is the case where the user has limited computer skills and they are using runtime & thus cannot generate a trusted location.