Search results

  1. D

    VBA error handler, how to not close the form

    I have a module named modErrorHandler that has the below error handler. It save the error successfully to my table named tblLogErrors. But the the only problem is that on my On_click event to close the form still executes and then presents the error message. I had another database that I...
  2. D

    VBA in unbound comboBox to bring up record

    So I have a form with subforms, where the main form's source is a table called tblCharts. Within this table there is a field called ID that is autonumbered. So I created a combo box that's row source is a query that selects the ID field from table charts and two other descriptive fields to...
  3. D

    Any way to disable hotkeys at login form

    Basically, I have a fully functioning frmLogin that appears when the database opens. After correctly logging in, it takes you to the appropriate switchboard. The problem is that I set autokeys to allow F1 to automatically open the switchboard, but I don't want users to hit this to bypass my...
  4. D

    Form unbound combo box, VBA code working on some forms but not others

    So basically, I have a form that used a specific SQL source for the form, and I had to remove a query that I was using because it had become obsolete (in retrospect I didn't necessarily have to remove it). But after the combobox stopped being able to load patient chart information and started...
  5. D

    Question regarding updating dates in specific records within a field

    So I currently have a table that tracks medication activity for patients called tblMedRanges. The Fields are the ID, StartMedication, EndMedication, Med ID/Medication Name. In the End of Medication, some patients are not currently active so they have a set date/time field property. What I have...
Top Bottom