Recent content by WayneSeymour

To give you a further example of whats working aside from the material filter I filter for a vendor "Citihardware" I receive 127 records(correct and working) I then filter for a date range of 12/16/2016 and receive 12 records again fine. From this point I want to filter the material from those...

I would agree as it seems logical,however there are other queries in the program I'm trying to create. First there is the filter by date ranges(working), the filter by Vendors(working) and in conjunction with each other. my plan is to introduce one more filter("Category") and have them all work...

First Let me say a Hugh THANK YOU for taking the time to look at my issue and messy code attempts. I am not well versed in Access and struggle to make my Excel app, which works perfectly into a access app. The form .Recordsource is currently TblPurchases, but I have tried QueryMaterial which...

DoCmd.Apply/filter task used here triggers a dialog box asking for a parameter value which is unnecessary since it's set already by the cbomaterial control. the reason for show all records is to be able to scan the database to see what records(vendors,dates, ) at a glance you maybe interested in...

My code is not too long I will share it, I'm no expert as well as you see. Option Compare Database Private Sub CmdSearch_Click() 'Search button Call Search End Sub Sub Search() Dim strCriteria, task As String Me.Refresh If...

That's not the solution as this is the VBA for "Vendor" and it works perefectly Private Sub CmdSearchVendors_Click() Dim task As String task = "select * from TblPurchases order by [vendors] " Me.Filter = "[Vendor] = '" & Me.cbovendors & "'"...

I have a query that includes wild cards and it runs fine when it has to. /the only problem I'm having is that the forms datasheet isn't returning the records. I see them in the query and on the form a textbox I have set up to show the number of records is showing the correct number of records...

Hi, I'm a new member who is very new to access and hope to gain much knowledge from the community Hi everyone:)