Search results

@Micron How do you get the ' " to work? Below is erroring. Both the System_Acronym and System_Name are text fields. If DCount("*", "[t_Systems]", "[System_Acronym]= '" & Nz(Me![System_Acronym], "") & "'" And [System_Name] = '" & Me![System_Name] & "'") > 0 Then

Maybe a little closer.... We had the user open their c:\Users\. On my computer it shows my name, but not on this person's computer.

Maybe some additional information on how users access the database? User logs into their laptop. User opens Access database front end. User click a log-in button that goes to a SharePoint site where all the linked SharePoint Lists are stored. User types in their SharePoint password. {The user...

We both have 64-bit operating systems.

How would I check to see what environment their computer is operating on? Press and hold the Windows Key and the Pause key. In the System window, next to System type it will list 32-bit Operating System for a 32-bit version of Windows, and 64-bit Operating System if you're running the 64-bit...

Same result "OWNER" Different user. We looked at the User's Account and it shows their First and Last Name populated connected to the company's email account (just like mine). Where else might this value be stored?

While the code above worked for a couple of people, I just had a new user attempt to create the shortcut and we ended up with icons on the desktop, that were named correctly, BUT no website path populated NOR the image on the icon from the DLL. The user is using a Windows based computer...

Just had a new person attempt to get into the database and the code failed when it tried to obtain the value from FOSUserName(). If it matters, I noticed is the name appeared as "Owner" It's possible their computer didn't have a value populated when it was issued out, so where and how does the...

I'm both the programmer and primary user and I'm not remembering the nuances. It helps me, sometimes, to have automation help me to the extent possible. And working through some of these VBA techniques is hopefully making me a little smarter. Point taken on the other approach.

As a simple demo of my issue..... (attached document) The system to project sub form can hold a unique system to project to relationship (System 1 + Supplier OR System 1 + Buyer OR System 1 + Blank value). But when the Relationship value is populated (red circle) with either Supplier or Buyer...

Thanks team. I ended up using @cheekybuddha solution.

System_Acronym value is populated System_Name is not populated I'm trying to get the CaptureName code to run and while it knows that Me.System_Name is null, it's erroring on this line. The code needs to handle situations where the system name is null. The code compiles. CaptureName =...

Does anyone have experience with 1) showing the person's image live, on the Access form, before the picture (so they can center themselves beforehand, look into the camera, etc...), then 2) taking the picture and storing the result in a designated location? Private Sub btnTakePicture_Click()...

@theDBguy Thanks. Call allowed the code to compile. I'll test it out once my SharePoint backend tables come back online. @Minty Yeah, I had noticed that as well.

Having issues getting this code to compile. I have the module from the Access "Contacts" Database Template behind it. It's likely something simple. The error is "Expected: =" Troubleshooting: 1) I've put real values in quotes. Same error. Openmap(Nz(Me.Address, ""), Nz(Me.City, "")...

Why would a modal, popup form not show up in front of the Access database window when it opens? All code compiles. How would you troubleshoot this? Form: Navigation settings On open I log the form opening (http://allenbrowne.com/AppLogDocUse.html) My Navigation form is behind the Access...

But in confirming what I mentioned, I came across this upgraded version of the Better Messagebox. https://datenbank-projekt.de/index.php/beispiele/improved-enhanced-message-box-replacement-ms-access

I'll play around with this approach trmw. Thanks for taking the time.

I was thinking I'd like a flexible option but I see what you did. Changing the code and commenting out the portion that determines the screen size and divides it in half. With MonitorInfo.rcWork screenX = .Left ' + (Abs(.Right - .Left) - formWidth) \ 2 screenY = .Top ' +...

So it would be a fixed location for all message boxes?