So this issue is actually with the report. The filtering is working as expected.
I needed to remove some code from the report that i had forgotten about that was causing me issues.
Working great now. Thanks again!
Stang02GT
Last Activity: Jan 3 '18, 06:38 PM
Joined: Jun 12 '07
Location: USA
-
This was working great. Now i just got hit with something out the the blue. If you filter by form at the bottom of your form it displays a "OR" tab allowing you to filter the form for a different set of data.
When you apply the filter it brings all the results back to one form but this button i added is not applying the "OR" results to the report.
Would i need to apply multiple filters in this case?Leave a comment:
-
This seems to be working well
Thanks for the direction on this Neo!Code:Private Sub Command1680_Click() DoCmd.OpenReport "Landscape Data Security Provision Review", acViewReport, , Form.Filter End SubLeave a comment:
-
This is what i am using to try and accomplish what you are saying trying to work through it now.
Code:Private Sub Command1680_Click() Dim fltr As String If Me.FilterOn Then fltr = Me.Filter DoCmd.OpenReport "Data Security Provision Review",acViewReport , , ".Filter" End SubLeave a comment:
-
Actually i figure it out.
I took the underlying query and changed it to have criteria on the vendor field that was looking at the form. So if they sort on the form and go to the report it will be based on what is currently on the report.Leave a comment:
-
So i could do something in the OnLoad Event of the report to reference the form filter?
or can i use the Filter On Load property on the report and set it to yes..but that leaves the question what do i reference in the Filter property on the report?Leave a comment:
-
Apply Filter By Form to Report
I have users who are using the Sort&Filter options on a from. Specifically they are using the Advanced>>Filte r By Form option and then selecting a Vendor and applying that filter to the form.
After this Filter by form is applied they would like to be able to open the a report and have it only show the records they just filtered on.
We are using Access 2013, does anyone have suggestions on how we can accomplish... -
So right now there are three prompts that the user has they are…
From Date
To Date
Cycle
Here are the different scenarios.
1. Users what to run the query for a specific date range and want to include all of the cycles.
2. The users want to run the query for a specific date range AND for one specific cycle.
My issue is that my query currently works if the users enter both a date...Leave a comment:
-
Sorry for the confusion. Sometimes the hardest part is explain the issue. Your rephrase is correct.Leave a comment:
-
Select with AND OR clause
I am trying to get the right syntax around a select statement. Here is what I am trying to do.
I am selecting rows from a table based on date ranges that works fine. Where i am getting stuck is there is a third field i need to include that will either have a value or if it's left blank i need to return all the rows for the date range or i need to return all the rows for the date range and with the selected PAY_CYCLE
... -
New E-Commerce Site Development
A previous freelance client of mine has passed along my information to a friend looking to have a E-Commerce site created for their business.
I haven't done much work developing these types of sites, and I think this would be a good opportunity to my freelance business.
I have a couple questions for anyone with any expertise/experice developing in this area..
1. I am thinking of developing this site... -
There are a good number of products like this out there Blue Coat is another company that offer many different products
http://www.bluecoat.com/...Leave a comment:
-
List Box Issue, Selected results not showing when updating
I have a couple list boxes on a form that query a database table for certain values to display in the box. My problem is that the users are able to select multiple options in these list boxes and then save the form to the database. When they come back into the form to make updates the list boxes are only highlighting the one of the options in the list box and i need it to highlight all of the options the user selected.
Here is the... -
Go to Control Panel-->Folder OptionsLeave a comment:
-
Stang02GT replied to when installing rollercoaster tycoon 3 I get a logo test error and I don't know whyin GeneralWhat OS are you running?
Link you might find useful....
http://oem.microsoft.com/script/cont...?pageid=551350...Leave a comment:
-
Have you tired to view this in FireFox or another browser?Leave a comment:
-
Each browser handles your code differently. You probably are going to have to code it differently.Leave a comment:
-
Leave a comment:
-
You could have a program open that needs to be closed before windows can shut down. My work PC will not let me shut down if Outlook is open.Leave a comment:
No activity results to display
Leave a comment: