Recent content by crashnburn99

  1. C

    Multiple Message Boxes

    That worked perfect! Thank you so very much!
  2. C

    Multiple Message Boxes

    Good afternoon! I am trying to create a script that will delete a file. I have everything in place but I am coming up short with the message boxes. I would like a message box when the user clicks on the button, it would read "Would you like to delete this file" then if they hit ok another...
  3. C

    Web Browser Help Please

    OK, bound my form to that table and it works perfect. Thank you very much!
  4. C

    Web Browser Help Please

    I tried that and it didn't work, but I think I know why. My form is not bound to that table, sorry for leaving that out. I also tried =[tablename]![tablefield1]&[tablename]![tablefield2]
  5. C

    Web Browser Help Please

    I have a table that contains the first part of the url in one field and the second part in the another. I am trying to find out how I can combine these two fields and set them as the control source for my Web Browser Control on my form. Thank you for any help and I will be more than happy to...
  6. C

    Crosstab Query Parameter Issue

    I received an answer on another forum. For anyone coming across the same issues I used this WHERE statement to make it work: WHERE Finances.Category=Forms!QueryCreator.Category OR Forms!QueryCreator.Category Is Null
  7. C

    Crosstab Query Parameter Issue

    I have a Crosstab Query that has parameters based on a form. These parameters work just fine. I would like it to where if the form is left blank it will pull all results instead of nothing. I have found quit a few examples and explanations on this site but I cannot seem to get them to work...
  8. C

    Cross Tab Query Schedule

    THANK YOU SOOOO MUCH!!!! That worked perfect JHB! You are a life saver! Thank you so very much!
  9. C

    Cross Tab Query Schedule

    Dang it! I moved it over to my database and now when I run it I get an error. Debugger highlights this part of the code: objXLApp.Cells.Borders.LineStyle = xlContinuous Claiming a compile error - variable is not defined any thoughts???
  10. C

    Cross Tab Query Schedule

    JHB thank you so so very much!!! This is perfect!!!
  11. C

    Cross Tab Query Schedule

    Thank you very much JHB!!!!
  12. C

    Cross Tab Query Schedule

    Thank you very much JHB! I tried out the form and it creates the excel sheet just fine but it doesn't populate the scheduled information. I have attached a screenshot of the excel sheet after it was created. Thank you again! This is a lot further than I ever could of gotten.
  13. C

    Cross Tab Query Schedule

    Something like this. It looks pretty crammed but we usually print them out on landscape with smaller font. It is for the employees that are out in the field so they have a sheet of all of their jobs.
  14. C

    Cross Tab Query Schedule

    I was hoping that everything from my second post could go in the middle, but im not 100% sure how crosstab queries work so I dont know if that is do-able.
  15. C

    Cross Tab Query Schedule

    I added some more dummy information into the 3 tables that will be used. I hope it is enough, but if not let me know and I will make more alterations. Thank you very much for your help.
See more
Top Bottom