Search results

I have three option groups on a report. Each option group has a command button to apply the option group selection, and I have a command button that will apply the results if all three option groups are selected. Right now if a value in that option group is selected, the forecolor of the command...

This is my code. Private Sub Report_Open(Cancel As Integer) Dim AckTime As Integer, MsgBox As Object, InFoBox As Object, pword As String, lngHr As Long Set InFoBox = CreateObject("WScript.Shell") AckTime = 2 Me.Auto_Header0.caption = "Montreal Unfiltered Shipments" 'Calculate...

I get error 91 on this section of your code. MsgBox "The table was updated " & lngHr & " ago. Report will not run" Object Variable or With Block not set

I'm confused now. I will try to explain best I can. I have a report, when that report opens, an inputbox ask if the user if they want to update the data that supplies the report, if user answers yes, a delete query erases the data from the table that feeds the report, and then runs an append...

I need to transfer the variable so the open event on the report will compare the date the function wrote into a table tblMontrealDoc "OpenDateTime" field and evaluate if this date is over 24 hours old. I don't believe this can be done with the expression builder and I need to write it into my...

I have a function that capture a report activity ,open, close, updated by query, etc.... I have a report that has a inputbox on the open event that tell the user this date the report will display is from a previous update and ask if they want to run the query to update the data. What I was...

Oh, I didn't think of it that way, I will give it a try, I appreciate your help and expertise.

This code doesn't work, it only sets the control.ItemsSelected to one listbox.

There are 4 listboxes on a form, this is the code on the form for the filter button. I'm sorry but do not know how to tag the code for easier reading. Option Compare Database Option Explicit Private Sub cmdFilterReport_Click() Dim strWhere As String Dim ctl As control Dim varItem As Variant...

I haven't figured out how to apply the filter. The only way I can do it is with a command button for each listbox, then one command button to filter based on all listboxes. It that the way to do it?

I don't know how to allow all the selection to not be used. If I post the table, form and report, can you help me with the code, I have office 2010.

I thought about the form with all option in a listbox, but sometimes they will not want to choose all variables. I like the idea of the Public variable, but I have never worked with them before.

By the method I described, but if I click on destination button and choose a destination city the form will close and filter the report, but I cannot filter within that filtered data with another form for say current location city within the data for that destination city. This is in reference...

I have a report with a table as the row source. I have command buttons that opens different forms and allows the user to choose criteria, the form then filters the report based on the chosen criteria in the form, but if I use the destination city form to filter the report by destination city...

Worked perfect, thank you so much.

Sorry this did not work after all, I get syntax error at Filterstr in case statement.

Worked like a champ, that for the code tags tips as well.

I have a form with two option groups on the form and a command button to apply the filter. The form then opens the report based on this filter, I cannot get the filter to apply both option group choices to the report when it open, it only applies one option group choice. Code in form module...

My users keep removing filter data, then screaming where is my data, it changed, this code will confirm the data filter removal with a popup. What I want is the popup timed in case they don't respond in a given time. The timing of the popup worked until I added MsgBox to replace WScript.Echo.

I replaced WScript.Echo with MsgBox and now the popup will not time out. Should that have made any difference?