Search results

Thanks MStef. I havn't really noticed a difference in performance since I split the database, and I have created an MBE file for the front end :(

Hi, as an attempt to improve database performance, I have split a MS Access 2003 database. I have successfully split the database and saved the backend onto the server. My question is, where is the front end. or do I have to create it? Cheers. Ben

Hi, I was wondering if it was possible for there to be an option on a report for you to export a copy of the report generated as an excel spreadsheet. I've tried command boxes but there is nothing under the events tab. Does anyone have any ideas? Cheers, Ben

Hey Ken, yup that did the trick. :) Ben

Hi, I would like to have a dialog box open when the user clicks on a command box so that they can choose the file name and the directory where the exported excel spreadsheet would be saved. Does anyone have any ideas? Btw, my code to save an excel automatically is below and I would like to use...

Hi, The company i'm working for right now has poor database performance when generating reports etc (taking ussually 5 seconds). I would just like some independent recommendations about a server server where a database is shared among 8 users in the company's LAN. Cheers. Ben EDIT...

thanks for the reply, nope did modify it like you said but still getting 2 parameter boxes coming up for me to enter in the start and end dates. Ben EDIT: Problem solved, gave the wrong name of the subform. :)

Hi, I making a query which creates a list of customers in a month. For the start and end dates of the month, they are retrieved from a table and put into 2 seperate subforms. The query isn't working through, so I was wondering if anyone would see where I'm doing wrong. In the order_date field...

Hi, I was wondering if there was a way for a report to be automatically saved as an excel file. Also, the Access database is stored on the company's server so would you be able to choose the path where the excel file would be stored? Cheers, Ben

Hi, I was wondering if it was possible to use a combobox where you could select a month and year (eg March 2004, April 2004) so I could run a query to find orders made during the chosen time period. Does anyone have any ideas how this could be done? Cheers, Ben