Recent content by leighms

attached sample

Hi I have set up a button that I click on enter two date ranges and then it exports multiple reports to excel. The issue I have is on report lists reasons down the side and date across the top, however the reason are exporting as numbers and not as text. If I export the report manually in...

HI I have a table that lists customers, their branch and how long since they transacted with us. What I want to do on a form is have a combo box that lists the branches and once you select the branch it gives you a list of customers that have been inactive for a certain time period. I have set...

Hi Thanks for your help, you have steered me in the right direction, i can import the spreadsheet, than use the update query which will be a hell of lost easier than manually entering customer numbers and dates!

Hi Recently I added a new field to an access table (open date). I than copied the table to excel to get rid of some columns and printed to give to staff to write down the dates for me. (didn't save the spreadsheet) I have now gone back into the access sheet and the rows no longer run in order...

Hi I have recently set up a button that exports mutliple queries to one Excel file, using TransferSpreadsheet code. This works great and saves a lot of time, the only thing is on many of the queries I have a date range set, so you have to enter a date range to get the results. Is there away that...

Hi Thanks for your response, I have tried that but it doesn't work. I have found using Docmd. TransferSpreadsheet acExport works perfectly, but I have a number of reports that use date ranges, so I am also wondering if there is a way of entering the date range once

HI Recently I set up a button to export a report automatically to Excel using the following code: DoCmd.outputTo acOutput Report, "Report1", acFormat.xls, "J:\Insurance Dept\Report1.xls", True This works great, however I was wondering 2 things: 1. How do you set up to transfer multiple reports...

This works great, thanks for your help

Hi I currently have a number of reports I export to excel each month. Currently I have them in saved exports and at the end of each month I go in and click on each one to export to excel. Is there a way I can either get access to do this automatically for me or even create a button to make...

Hi Access 2007

Hi I currently have a form that staff complete and email. I have set up a query that collects the data from the form and report as well. I have added a button to the form that staff click on and it emails the report from the data just entered on the form. Currently it emails in a TXT format...

Hi Thanks, i have tried changing that however it still records the date & time. I have the time set to medium time. On the form & in the table it only displays the time, however when I run the query it won't pick up the time as the date is still being recorded

Hi I am using =Now(), so it automatically updates, do I need to change to =Time()?

Hi I currently have a table records calls received. Part of the table has a field for date and another field for time. I have a query to calculate calls received & the reason during each month, however the problem I have is it does not work, because the time field records the date as well...