Recent content by evictme

Thats actually a great suggestion. Thank you!

Hey Folks, I've got a Form that loads 6 different subforms and Im trying to find the syntax for VBA that will allow me to create an email with the body that essentially looks like the Form itself or would export each subform (and it's records) as part of the email body with a button_click...

UPDATE: Since running the database and all the fresh copies from a Windows 10 Pro PC the only thing that has changed is that now, corruption continues to happen but does not give an error. We do not see a "Unrecognized db or mdb file..." error. 2 of our key tables, tables we use the most...

Yes. If I need to add a new person to the mdw (security file), I convert the BE to mdb. Run the security wizard to completion. convert back to .accdb and done. However, up until today our BE file has been mdb so the conversion was not necessary. But can confirm that that works.

Did all that, various times but on my Windows 11 Pro eval copy PC. I have now done this on a Windows 10 Pro PC. We'll see where this leads

I believe I figured out the culprit. Me (My computer). Im running a Windows 11 Pro Pre-release build. I think recreating databases (FE/BE) on my computer and then distributing them for users (All on Windows 10 Pro) was causing the issue. Today I recreated both database files on a windows 10 Pro...

No, no wireless connections. Everyone is networked directly in. The database is running a design updated/added to/edited over 10+ years...I might just need to bite the bullet and start from scratch. I think you may be onto something. After getting all users off the database. the only thing out...

I did, i saw. What I meant by that comment was that in the past. But this is different. I think I can manage with this set up a little better. Im using wrkgroup security because that is what weve had baked in since it's inception. Also, we have a strict auditing system that needs each user ONLY...

One of the issues we encountered was that users would go into local folders and open the file directly if they had any issues, bypassing security measures 1. Do you think having a local copy for all the users on their desktop might eliminate some of the issues we are seeing? 2. Could I make the...

I will try this. I believe at one point, way in the beginning of all these issues (months now), I had found the BE file as .accdb the next day...despite not doing that conversion myself nor are there any users that would know how to do that or even where to look. Can you suggest any better...

I believe the issues did start when we had users on older versions of office but I have since upgraded everyone to 2019.

MS Office Professional Plus 2019 (32-bit). Unfortunately, we have a mixed bag of user PCs with varying processing capabilities. I developed it on 32-bit and have kept it that way to ensure compatibility for all users.

Hey all, It has been a while. Here is my current issue: I have a split database - Frontend and Backend. I also have a security file for the backend. Front-end is .accdb Backend is .mdb and security is mdw I have about 10-15 users, not including myself. Both, the backend and frontend files...

Always with the great help! THank you, this worked perfectly.

Hello Folks, I am trying to run a findfirst on a double-click event and I am not sure i have the syntax correct: The code below is what I have so far but the last piece of criteria "Supervisor" is not working as it should, depending on where I put the single quote, it will either give me any...