Recent content by bonzitre

So that part of the code, while clunky, isn't the issue. It is filtering from the listbox for the selected criteria. It is just filtering in order of top to bottom based on the number selected, not the actual selection itself.

I have very limited know how when it comes to public functions, and when combined with the other code I am having difficulty getting the list box selection to work.

The code for just the listbox portion is: ' Filtering logic for [PrimaryPillar] based on multi-select listbox Dim selectedSites As String Dim i As Long 'listbox filter For i = 0 To Me.lstPrimarySite.ItemsSelected.Count - 1 selectedSites = selectedSites & "'" &...

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

That was the issue. Thanks! Simple things go overlooked sometimes and it didn't register to me. This is why you all are the best!

Good catch, I didn't realize. I'll have to give that a shot when I can and let you all know. Thanks!

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

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

For the between, Private Sub cmdActivityLogDaily_Click() Dim strCaption As String strCaption = "Today's Activity Log" DoCmd.OpenForm "ActivityLogQReport", acFormDS, , "CallDate=" & BETWEEN Format(Me.txtDate, "\#mm/dd/yyyy\#") and Format(Me.txtDate, "\#mm/dd/yyyy\#"), , , strCaption End Sub...

It isnt liking something. Says syntax error EDIT: I'm an idiot and missed a quote. It works. Thank you.

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

Edit: I just typed PatientIDCall as the parent and PatientID as Child and viola. Thank you guys! stupid simple which I assumed it would be. OLD: When I attempt to do that, I don't have the option to select PatientIDCall (the box with the ID I want to use to filter) which is housed on the main...

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

That is why I left it showing. However I didn't want to leave it because I don't want to confuse the end user.

HEY! I think I got it. I was trying to make my query combining the tables which was causing issues. I set the MRN, name, and DOB boxes on the call log form to unbound and let it just carry that information from the patient form over so it will populate the textbox that identifies the patient...