Recent content by Patty28715

When I export a report to excel it also exports the unbound field labels. How can I get this to export in a cleaner format? Example attached. I don't want the "Sumofsumof units" etc, I just want the data.

Viewing the scripts from the website I posted earlier there a many options to read a cell in excel and copy it to another excel sheet. Excel will hold over 65000 rows, so if you can write a script to read all the excel files and copy the information into one excel file along with the file...

I found the script where it reads one cell in every excel sheet under in a folder and returns the file name if that cell say "test". This might help with what you need. If you can change this script to read all the files and certain cells then store into anthor excel sheet with the file name...

You will need to create a new button to use both filters or make the adjustment to the two open buttons on you form to this. "Private Sub cmdOpDateRange_Click() DoCmd.OpenReport "rptTotalHoursByDay", acViewPreview, , "[TodaysDate] Between #" & Me.cboFrom & "# And #" & Me.cboTo & "#"...

To create a report by telephone number, you will have to create a query of the table with the information. In the criteria area of telephone number put [ENTER TELEPHONE NUMBER]. This will give you a pop up window for you to fill in the number for your report. Save this query and then create a...