Recent content by mreference

Thank you, the two queries worked a charm.

I have seen helpful threads on this but nothing that allows me to add in a date range. I'm sure it can be done.

I have a query with a few fields [OrderDate] [SKU] [QuantityPurchased] [RangeName] [Category] I am trying to create a filtered form that would prompt the user for a start / end date, then the top 10 best sellers would be displayed Once created, I want to then add in a few other filters...

Mission accomplished after tweaking your code Instead of Call Forms!frmProduct_Detail_Add.Form.sbShowHideButton I used Call Forms.frmProduct_Detail_Add.sbShowHideButton The other code was placed in the MAIN FORM. Cheers both for your help

Hi Vlad, thank you joining the thread. So I placed the code Call Forms!frmProduct_Detail_Add.Form.sbShowHideButton where you suggested and it told me that there was a compile error at Forms!frm....., so i removed the ! and swapped it to Forms.frm..... and it seemed to accept it. The code you...

Thanks, I just tried and it didn't hide the command button Private Sub Form_Activate() If Me.txtItemstoOrder > 0 Then Me.cmdStocktoOrder.Visible = True ElseIf Me.txtItemstoOrder = 0 Then Me.cmdStocktoOrder.Visible = False End If End Sub

Would you have an example of how this works as I'm not understanding where to put the code, my brain is fried trying to resolve this :)

Hi, I have form (MAIN FORM) with a field that performs a Dcount on a table, if the value of that field is greater than 1, a command button will appear underneath that allows the user to open a pop-up form (POPUP FORM) with the records associated with the Dcount. If the user deletes the records...

How can I set up a count of records in my form footer that only counts a value once. For example. OrderNo Code 1 Hot 1 Hot 1 Cold 2 Cold 3 Cold 4 Hot 4...

Thanks for the quick reply, Iconditional formatting is my usual goto place, but I don't know how to apply it across 2 subforms and I could't find anything in this forum or searching google on how to do it.

I have a form with 2 subforms included. Continuous Subform #1 has SKU's and PRICE's (these are our prices) Continuous Subform #2 has SKU's and PRICE's (these are supplier prices) I would like to turn the PRICE field red on Subform #2 if the price does not match the suppliers price when...

It does work on its own in the query, I thought it was very odd too. Good point on adding it to the form header. Can you give me some instruction on how to get that working. I have added the text box, the wildcard should be added to the ItemCode field, so I have Like "*" &...

Hi, I have a totals query where a user can input a wildcard like query and works great - This is the criteria I use to capture the input. Like "*" & [Enter Item Code] & "*" Run the query, works as expected. I have put this query into a continuous form, but I do not get the pop-up box...

I don't know how to search for this to see if it already exists in the forums. Basically, in a nutshell, is it possible that access can detect a .csv file in a folder on a pc, then import that file into a table and run a query at 6am every morning on a mon-fri only. Then once it has been...

That's it, you cracked it! Works great