Search results

Hi Guys, I'm trying to make a pass through query which connects to a postgresql server. However, When I try running it by clicking on a button, I get: "Run-time error '3306': Query must have at least one destination field I have tried debugging it and all the values in the parameters are being...

Hi, I'm trying to create a pass through query after looking at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adocreateq.asp. I'm using Access 2000 trying to connect to a backend to retrieve the data. Here's my code: Sub CreatePassThroughQry(strDBPath As String, _...

Hi, I have a combo box, which the first and last name of an employee is combined using trim. Does anybody know of a way to seperate both fields as these would be used an a query so I would need them seen as 2 fields otherwise there won't be any matches. Cheers, Ben

Hi, I have a postgresql database setup (tables have been imported and relationships setup as well). I would like to link the access database frontend to the postgreSQL backend. Does anyone know how to do this? Cheers, Ben

Hi, I'm making a form where the contents of a field is determined on the contents of another field in another form. I thought an IIF function would work, but when I tried it the contents says #NAME. I put it in the control source...

Hi, I'm making a query which is used to generate a report. Anyways, I've ran into a problem. The query is based on some controls in a form, but what I would like to do is that if a control was null then a field in the query should be assumed to be a wildcard for the criteria, otherwise the data...

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

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

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