Search results

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...

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...

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...

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 =...

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...

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 & ", " &...

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...

Hey all, Im trying to include the following code in a _Onclick event CurrentDb.Execute ("UPDATE Client SET Client.CaseMgrFax = " & Me.Fax_Number & " WHERE Client.CCID = '" & Me.ID & "'") The event is for Form that includes information that should be updated in another table whenever there is...

Hello all, I want to create a form thatll be open hidden for my user account and will be visible when a user logs-in or logs-out For capturing user activity and log-ins I have a form already that is open hidden when they log in (see below) and will capture both when they login and log out. I...

Hello All, I have a few forms that are opened as achidden when the database opens and I have a few buttons that will change their property to visible and display the form as necessary. However, I also have accesswindowhidden vba coding and I am looking to keep the visible forms visible while...

Hi everyone, hope everyone is well and staying safe! Back for a little Search function syntax assistance. I have a search form that opens another form with results in a subform that use the original search form's input. Most of the time, it will display all possible results (it includes name...

Hello All, Back at it with a little syntax situation. I've been trying to prevent folks from closing the database by simply clicking the "X" in order to avoid any issues with events and VBA coding. I have a form that loads hidden whenever they log in and have place this code (see below) to...

Hey Guys, Back at it with some VBA mischief...Looking for a little help on syntax with an OnClick event that is not firing very well/at all. I have the mainform (Mission Control) and two sub-forms (AuditClicksMC) and (Current-User) I've wanted to filter the (AuditClicksMC) based on the...

Hello All, I have this code (see below) for keeping track of users logged in...It is in the "Form_Load" code and opposite code to delete in the "Form_Close" code. I've just added a field to the table - [tblCurrentlyLoggedIn]; [empEnviron]. I added this field because I want to capture the PC...

Hello All, I have a hidden form that loads when the database is open that has a few events on the Form_Load event (see below). So far, the code is working great. It does exactly what I need and then some but I would like to have an additional event that checks the username in the...

Hello all, I am trying to run this code in the OnClick command of a field on a sub-form. The subform is in Continuous and displays records that are available in realtime. This is the code: DoCmd.OpenForm "AuditClicksUsers", acFormDS, , “User = ‘“ & Me.Logged_In.Value & “‘“, , ...

Hey all, I have a small change that I am working on for a control console form I have. Currently, the form includes a sub-form that gives a list of all the users logged into the database. I am trying to get an image frame to load the corresponding ID picture for each user with the hopes that...

Hello all, I have been trying to find a way to update a specific record on one table when there is a change on one of my forms. The form I have is a Client Form that has combo boxes for the worker(s) assigned. after update causes the worker ID to be updated, I would like to include in this...

Hello All, I have a module that is called in the BeforeUpdate event of most of my forms (See code below) There is a button that will open a query with the table information so i can see the log entries. I've noticed that when I have this query open it will cause a read-only error when there...

Hello All, Back again with a new problem I hope you can help me with: I have a Form that has onload event LockBoundControls with a subform for notes. I am trying to add spell check feature to the notes field in the subform, which is a memo field, but I keep getting the error message...