Search results

It is.

This This is what I have so far, would this work? Set rs = CurrentDb.OpenRecordset("SELECT * FROM Employee Reviews") Dim EmployeeID As Integer Dim Year As String Dim Quarter As String Dim strCriteria As String strCriteria = "EmployeeID=" & Me.EmployeeID & " AND Year = '" & "2021" & " AND...

Im trying to check for a record during a double-click event but Im not sure my syntax is correct; would you please take a look. Any help would be greatly appreciated... I would like to find the record, if it exists based on the parameters, and open it in the form. Set rs =...

This is brilliant! Was easy to setup and get going almost immediately. Just one question, how would I adjust the code to allow users to select the folder for export?

Thank you for your time and help. Yea, renaming fields and better design is on the "todo" list, for now, Im maintaining.

Sent.

Thank you! I have imported the columns frm and the necessary code into the button for my form, however, when the I click the button it gives me an error when calling the .fSetUp. Any suggestions?

Any chance you can send me a copy of that Qry Viewer you posted in that last post?

I want a form that will allow the user to check the fields they want from a specific table and then click a button that will display the query and allow the user to export it to excel.

Hello everyone, I recently had a request from users to be able to build a custom query thru a Form interface that they can use and check off the options they want. Not sure even where to start (besides building the form and adding checkboxes). I was trying to find the best way to do this and...

I know 🤦🏻‍♂️. The “Users” table was a local and temporary table that I was using for admin stuff but now some of the features are expanding. Im updating the field names next, i was just wanting to get the code to work and then take care of the cleanup details. Syntax is my enemy...i always...

Could I use this code to check it in the On_Load event? DLookup("Darkmode", "Users", "[Users]=" & CurrentUser() & " AND [Darkmode]=" & -1 & "")

Perfect. Thank you!!!

Trying to update a table with a currentdb.execute UPDATE but I cant figure out the syntax.... Table = [Users], Yes/No Field [Darkmode] , and WHERE field [Users] . THis is what I am trying but does not work: CurrentDb.Execute "UPDATE Users " & _ "SET DarkMode = " & 0 & ", " &...

I do check the windows machine name on login with a dcount (Code is available in earlier reply). I havent tried checking of another instance is running on the same machine, I tried it before but was never able to find the syntax for that.

Yes. Im pretty sure that error is not the cause of the crash but it is a part of the events when it does crash. And Yes, they use multiple terminals at once. This doesnt happen very often. Im more worried about the situations when they are already logged-in with the database running...

By "Crash" i mean the application crashes and disappears completely. Just as if we were to End the task with task manager. I may be correlating two things that are not connected but everytime the Access App crashes for the user, requiring them to log-in again, an error will be captured just a...

Thanks Isaac. Yes, all of the above. Currently, if they are logged-in they will receive a prompt to "Log-out from their current instance of the database" The multiple instances issue is for various reasons but above all because we have users who use several terminals, sometimes at once...

Its not a perceived issue, it is an actual, historical issue with users opening multiple instances of the database at once. It is also an additional way for me to catch and look into any errors that have caused crashing, if any.

Hello All, I am working on the On_Load event of a "Logged In" Form i have. It checks to make sure that they are not already logged-in. However, at times, if the dbase crashes it will not remove them from the table of logged in users. When this happens, the user has to contact me to request I...