Search results

  1. E

    Solved Search Form - If result <1 then go to result

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

    Solved Form_Unload Event

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

    Solved Updating Sub-form with OnClick event of other Sub-Form

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

    Solved Docmd.RunSQL INSERT INTO...

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

    Check Table for User Name, prevent log-in or log-off 1st instance

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

    Docmd.OpenForm WHERE condition trouble

    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 & “‘“, , ...
  7. E

    Solved Form: Onload Event - Images instead of names

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

    Solved Form: Changes in field will update another table thru After Update Event

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

    Module - Audit Trail: Read Only Error

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

    SubForm memo field - Spell Check

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

    Form create record in 2 tables

    Hello All, I have a simple form with save / cancel buttons and I want to run an if statement (or something) on click of the save button that will save the entry into the table the form is used for but also create an entry into a different table that will copy certain fields into specific fields...
  12. E

    OnDblclick Docmd.Openform - Open Form All Records

    Hello all, I am using the on dblclick event procedure (see below) on my "Clients" form to open the "employees" form with the correct record from a field that uses a 2 column dropdown list that displays the employee name but has the employeeID in the second column. So far, everything works as...
  13. E

    Macro/Form Open Action

    Hello All, I have a question in regards to a macro that runs a form open command: The macro opens a form that executes a host of commands on open. I want to add an IF statement to the Macro but im not sure if it should be in the Macro or the Form Open Actions I would like for the Macro/Form...
  14. E

    2 If statment On Current with Docmd.Openform

    Hello guys, Im kind of stuck with an operation I'm trying to make happen in the On Current event of a form I have: So far what I have, that is functioning exactly the way i need, is the following [ Private Sub Form_Current() On Error Resume Next Me![ImageFrame].picture = Me![picture]...
  15. E

    looking for a way to prevent automatic updates on the dbase

    Hello, I am looking for a way to prevent automatic updates on the dbase. Im looking for something like save and cancel buttons or a prompt with those options. I currently have a macro that runs on the beforeupdate event of the form and would need any option to be an addition to that, any...
  16. E

    Hyperlinks for records from subform to other form

    Hello all, I have a form that has a subform in it controlled by one of the categories (Client List that can has a supervisor dropdown that controls the subform). I want to turn the "Customer" field into a hyperlink that when clicked will open up the "Customer Form" displaying the respective...
  17. E

    2 Tables, 2 Form; Interchangable information

    Hello All, I have an employee/client database. A table for Employees and a Table for Clients. I have a form for entering Client Info and Employee Info. Each client is alloted specific amount of hours and assigned to an employee. each employee may have more than one client. I want to see...
Top Bottom