Search results

That worked perfect! Thank you so very much!

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

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

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]

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

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

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

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

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???

JHB thank you so so very much!!! This is perfect!!!

Thank you very much JHB!!!!

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.

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.

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.

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.

I attached an excel sheet that shows how I would like the report to be laid out. I left the middle info blank, I figured I would state the tables and fields here. I tried to upload my database but it was too large. So I will try and be as descriptive as possible. Here are the tables that are...

Good afternoon. I am trying to create a cross tab query that will generate a report in the form of a weekly schedule. Currently we have a table that houses all of our schedules that are linked to our customers table. This is the last piece of the puzzle and after reading a lot of post in regards...

Perfect! Thank you very much!!

I was wondering if there was anyway to save the user input as a variable that can be used in a text box or label control? I currently have a parameter query, for a report, that request beginning and end dates. I would like to put those dates in the header section of my report. Is there any way...

Solved the problem. I had created a customers form before I decided that I would like a tab control. After I created the tab control I dragged the customers form into the tab control to save time, but in doing so it made it a sub form. There was no info from the main form for the other sub forms...