Recent content by rekabeilla

Thank you, I will look at these now. I appreciate the help!

The 1st & 3rd textboxes are the "labels" so they can shrink when they are blank =IIf([ClinicYear]="2017" And (Not IsNull([Flu]) Or Not IsNull([Bio] Or Not IsNull([Vitamins]))),"<b>2017:</b>","") The 2nd & 4th are for the data (this is textbox 2's source) =IIf(([ClinicYear]="2017" And Not...

I'm sorry, I'm not sure what you are asking

There is currently nothing grouped or sorted, I tried to group by LocationID but that didnt work.

Hello, (Please view the screenshots I have attached of the design view, print preview, table and record source to help narrow things down.) I am currently designing a report that has a few sub-reports and I am having trouble with the display of one of these sub-reports. I want the sub-report...

Hi I am using the following code that i found online to add an appointment to Outlook Calendar and it works beautifully but it adds the appointment to my calendar and not our business' shared calendar. I have googled for an hour now and i can't get any code that i've found to save to the shared...

Yes that works thank you so much. I was thinking too far into it.

Hi, I have a navigation form (that i coded, not the built in navigation form) that i placed an unbound subform on. On click in the menu changes the control source of the subform to display that specific page. I don't want the user to navigate away from the current page without saving so on...

Thank you both for trying to help. I really appreciate it!

I figured it out!! The cycle was set to "Current Page" and i changed it to "All Records" and that fixed it

Yes, I just double checked it's ClinicName

Short Text

I tried it in code and it didnt work either.

That doesn't work either :( but thank you. Idk why it wouldn't work. Allow Filter = Yes Filter On Load = Yes Do you know if there anything else i should check for?

Thank you. One more question, this may be simple as well but in Filter on the property sheet, I'm trying the same syntax. I don't want the form to display "In Office" or "Not Provided" so i tried: [ClinicName]<>'In Office' Or 'Not Provided' [ClinicName] Not 'In Office' Or 'Not Provided' I...