Search results

Thanks for the help everyone. I'll probably just keep it the way it is. It's useful to still have the main form open, as you can quickly refer to it without having to exit the pop up form. The flickering is ultimately just a visual nuisance so we can deal with it

Hmmm it doesn't seem to work for me. I changed it to modal and it is still flickering... See attached. Was there anything else you changed?

I gotcha. See attached. I recreated my actual DB into an example as simply as possible. On the launch form (frmComplaints), open the red command and you'll notice that frmComplaints flickers. Especially the tab control and the record selector. Yet I have the same code on the 'complaint ID'...

It's in my original post. There's literally just 6 individual subs that open different popup forms, like below: Dim strFormName As String Dim strCriteria As String strFormName = "frmDates" strCriteria = "[ComplaintNumber] =" & Nz(Me.[ComplaintNumber], 0) & ""...

There's no additional code that runs. It's only the 'openform' code when using the command. There's nothing in the on current event. No timers anywhere. It seems to specifically be based on using a command button. I have code in the same form to open a pop up form via a double click on a text...

Like to minimize chrome, other apps?

Bit of an odd one...I use the below code to pull up Outlook and search something in the search bar. It works well except for one odd quirk. Sub FilterOutlook(searchString As String) Const olMaximized = 0 Dim app As Outlook.Application On Error Resume Next Set app = GetObject(...

Thank you!

Bit of an odd question...I know you can set 'compact on close' on or off via VBA by utilizing Application.SetOption "Auto compact", True or Application.SetOption "Auto compact", False. Is there a way in VBA to essentially test if 'compact on close' is on or off? I.e. something like this: If...

Thanks. If I were to use it for 'strFileName' in the two private subs below, how would you suggest that be coded? Private Sub btnExportReport_Click() On Error GoTo btnExportReport_Click_Err Dim objFileDialog As Object Dim strFileName As String Set objFileDialog =...

Thank you! I was able to get it working by using a private const One last question...when using the private constant, is there a way to have it refer to a field in the report? For instance, I'm getting an 'internal error' with this code: Private Const cstrFileName As String = Me.txtReportName

Full disclosure...I'm very new to VBA so bear with me. I have 3 commands on a report that quickly allows the user to export the report to pdf, email the report, or print it. It works great. Here's my exact code: Private Sub btnExportReport_Click() On Error GoTo btnExportReport_Click_Err...

No conditional formatting

There is no code after the openform in the sub

No, it views one record at a time

Any ability to fix that? I'm not sure what you mean. The complaint number is listed in the where condition of the openform code

I do not. I'm not sure what that is tbh

On my main form, I have a command which opens up a pop-up, smaller form. For whatever reason, the main form flickers right when the pop-up form opens up. It's not a huge issue but it's just a bit jarring on the user side of things. Here's the thing though: it seems to be linked to the form...

I have a bit of an odd one....I was wondering if there's a way to have 1 (or 3 if needed) queries just keep a running separate count of how many days have passed YTD, how many months YTD, and how many quarters YTD. So as of today, I would want to show 28 days in one field, 1 month in another...

This worked perfectly! Thank you!!