Search results

  1. M

    Is this possible..Top 10 by date range

    Thank you, the two queries worked a charm.
  2. M

    Is this possible..Top 10 by date range

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

    Is this possible..Top 10 by date range

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

    Form with Pop-Up Form

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

    Form with Pop-Up Form

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

    Form with Pop-Up Form

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

    Form with Pop-Up Form

    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 :)
  8. M

    Form with Pop-Up Form

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

    Counting Values in Continuous Form

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

    Checking Values on 2 Subforms for match

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

    Checking Values on 2 Subforms for match

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

    Parameter Like Query Not Working

    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 "*" &...
  13. M

    Parameter Like Query Not Working

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

    File detect and execute

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

    Continuous Form Loop VBA Problem

    That's it, you cracked it! Works great
  16. M

    Continuous Form Loop VBA Problem

    I tried that, I got a red dot appear and then I run the form again. It stopped at the Red Dot first, that line was in yellow. I pressed F8 and the following lines went yellow (in order) On Error GoTo cmdBookInAllStock_Click_Err CurControl = Screen.ActiveControl MsgBox "Error: " & Err.Number...
  17. M

    Continuous Form Loop VBA Problem

    I clicked on Compile and nothing flashed up in the Editor, I then clicked on Step Into and again nothing happens, cursor stays where it is. Not sure what I am supposed to be seeing either.
  18. M

    Continuous Form Loop VBA Problem

    I did try, see attached code and error message. Right click on image and open in new tab if not displayed Image 1 Image 2 Thank you
  19. M

    Continuous Form Loop VBA Problem

    Thank you, I removed all the code relating to the message box I added in and the error 91 still happened. I'm presuming it must be something to do with the code you wrote for me, but I'm not as uptodate as you are so do not know what part of the code to tweak. I think that part of the Else If...
  20. M

    Continuous Form Loop VBA Problem

    Thank you for supplying the code, I have given it a try this morning and added a message box line as a precaution. Private Sub cmdBookInAllStock_Click() Dim LResponse As Integer LResponse = MsgBox("Are you sure you want to do this?", vbYesNo, "Continue") If LResponse = vbYes Then On...
Top Bottom