Search results

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

Yes. I plan on hiding it in the final product since it has no use being displayed, but i put it there just as a visual reference.

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