Search results

  1. B

    Combo Box Search Issue

    Hey everyone, so, I am having issues with a combo box search. I got it to work, was happy, saved, closed, when I opened it again, it is broken and won't work no matter what I do. Background: I am building a database that will create a file for upload for medical statistics. There are about...
  2. B

    Filtering from a multiselect listbox with other filters

    Hello, So, I thought I had everything going right, but I was wrong. I have this form for users to make a custom "report" which is really a datasheet 'ReportF': The listbox on the right correlates to a column on the table "Patients" which is "PrimaryPillar". The idea is for them to be able to...
  3. B

    Solved ACCDE File On Click Error

    So, I am getting the following Error when trying to run a custom report through an ACCDE file: "the expression on click you entered as the event property setting produced the following error: the command you specified is not available in an .mde, .accde, or .ade database." The code for the...
  4. B

    Update main form text boxes as subform is filled in? Also, subforms not linking?

    Good morning, So, today's issue is this. I have a form [PatientAllSubs] that has two tabs on it (ONN/PSC and SLC) with subforms on each [PatientSubform] and [SLCSubform] respectively. It is loading the information from the [Patients] table: txtPatientTitle uses the formula: =Nz([MRN] & " - " &...
  5. B

    Using date from a text box in a where condition

    Hello, So, I have a form with buttons and a text box for different reports. One "report" is a form that opens in datasheet mode to show activity logs for the day (phone calls, staff activities, etc). I want it to where they can select a date in txtDate on the form and click a button to open...
  6. B

    Solved Filtering Subform based off carried over data

    Hello again everyone. Today, my issue is I am trying to filter a subform based on the data I am carrying over from another form. I have a form "PatientForm" that has a button "cmdViewCalls" with the following code: Private Sub cmdViewCalls_Click() Private Sub cmdViewCalls_Click() Dim...
  7. B

    Solved Carrying information from form to another and saving the record correctly

    Hello everyone, it has been a while since I have done much with access and most stuff is going well except this issue I will explain. My objects: Home is the nav form, HomeSub is my patient search or new patient selection form, Patient Reports just has buttons to run reports, NewStaffF is for...
Back
Top Bottom