Search results

SELECT Overdue_POD_Report.Plant, Overdue_POD_Report.[Plant Description], Overdue_POD_Report.[Ship to Customer Name], Overdue_POD_Report.[Business Division], Overdue_POD_Report.[Division Group], Overdue_POD_Report.[Shipping Type], Overdue_POD_Report.[Order Number], Overdue_POD_Report.[Delivery...

This code doesn't add a new entry in the audit table, but logs changes. Here is the code that isn't adding the new data entered into the textbox. Any help greatly appreciated. For Each ctl In .Controls ' inspect only data-bound controls Select Case ctl.ControlType...

I have a field in the query called Shipdate. I want to use the Min date of this field in a textbox on a report. I don't want to restrict the query since it feeds other reports where I don't want to use the Min function. I keep getting the results in the report as #Error.

I have a form that is linked to a table named Claims. Works great, I have an add Claim form and form to lok at unsettled and settled claims. What I want to do is create another form that will update some of the fields in the table without opening the settled, Add, or unsettled forms. This...

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

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

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

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

I cannot get this code to run in access 2010. It shows no missing references, but errors that Object required. Thanks for any help provided. Dim wshShell, btn Set wshShell = WSCript.CreateObject("WScript.Shell") btn = wshShell.PopUp("Filter data wil be removed.", 2, "Data Unfilter:"...

I have a retort that I want to use an option button to filter the report is a specific date is 48 hours before the current time. I'm not having any luck. Below is the code I have been playing with, but no go. :banghead:I appreciate any help provided. Thanks in advance.... Private Sub...

I have a report on this report there is a Destination City field and a Current City field, loaded from a table. I have a command button that loads a form to filter on the destination city, I have another command button that loads a form to filter on the current city location. What I would like...

I use the follwing code to filter a report based on the listbox selection on a form. Below is the code I use, the problem it will error if the results have an apostrophe in the string. Please help. Private Sub FilterDesc_Click() Dim strWhere As String Dim ctl As Control Dim varItem As Variant...

I have a report with 2 option groups, I cannot get both of them to filter the data simataneously, they will each inititally filter the data, but when the opposite group it clicked, the previous filter data does not remain filtered. I have posted the code for the two option groups, I know I'm...

I have a report based on a query, the report loads filter based on dates input to the query from Form1 when report loads. I want to filter this report further from a listbox on form2, but I want the listbox rowsource to populate based on a field in the loaded report. Is this possible?

I have the follow code tha tells me when an object is laoded, I cannot get it to display the name of the form or report or whatever object isloaded. any help would be appreciated. Private Sub Command51_Click() Dim aob As AccessObject Dim obj As AccessObject With CurrentData ' "Tables" For...