Search results

Hi, We have been having intermittent problems with an MS Access 2000 front-end application linked to a SQL Server 2000 database recently. From the switchboard a user was sometimes getting "There was an error executing the previous command". When she shut the application and opened it again it...

MS Access Database Issues Hi, We have been having problems with MS Access for a few weeks now (MS Access front end to a SQL Server 2000 database). We have a shared .mde file which is in a network folder and used by 14 users. All users use MS Access 2000. Recently users have intermittently been...

Hi, We have an MS Access 2000 Database front-end to a SQL Server 2000 database. The database was initially developed in MS Access and then upsized to SQL Server 2000. I am just wondering .... When I do a query in the MS Access front-end, does the application return all of the data back to the...

Hi, I have a query which returns 1 value (The description associated with the maximum ID in the table). I have a Text box on a form and I would like the default value of the text box to be the the value from the above query. I have tried to build an expression using the expression builder by...

Hi, I am absolutely puzzeled with a problem we are having with an Ms Access 2000 application, which is the front end to a SQL Server database. We have a database which was working fine for over 6 months. And now all of sudden users are intermittently getting the error messages: "Error...

Hi, I created a database in Microsoft Access and then upsized it to SQL Server afterwards. I now need to add a new column to a table in the database. So I added the new column in SQL Server using ALTER TABLE command. This column is a foreign key which has an associated parent key in another...

Hi, We have an MS Access .mde file on a network drive which is shared by 15 users. This Access Application is a front end to a SQL Server database. Lately we have been having intermittent problems where users are getting the message "There was an error executing this command". When they close...

Hi, I have an MS Access application installed on a number of machines and it is running fine on all of them except one. On one of the server when I am submitting a form to search the database I get the error message: "Automation Error. Element not Found." Same version of MS Access on all...

Hi, I have a form with a number of fields and buttons on it. The form is opened in "add new record" mode. I have noticed that when I move from the last field in the tab order to the first field in the tab order it saves an entry in the database. This is causing me problems because when users...

Hi, I have an MS Access database. It contains tables linked to tables on SQL Server. Therefore MS Access is really only acting as a front end to the SQL Server database. I converted the MS Access database to a .mde file. I noticed over the past few days that the .mde file is growing in size...

Hi, I have a form and I set the record souce for this form based on a query built by users (they select different options). I open the form and then assign the form's record source to the SQL query. This works fine 90% of the time, however, sometimes instead of displaying the query results it...

Hi, I have an Access 2000 database with some linked tables. When upsizing the database I selected 'Save password and user ID with attached tables'. Therefore in the Linked Table manager after each table in brackets I have the name of the database to which the tables are linked. I am now...

Hi, I have an Access 2000 database and I have hidden the database window in the startup options. I have also saved the database as a .mde file. However, if a user opens the database while pressing the shift key they can still get access to the queries and tables in the database and can change...

Hi, I setup a generic report just to count the number of table entries by a particular field. E.g. Count of sales by product. I then hoped to open this report using the Docmd.OpentReport and specify further criteria (strCondition) for the report. DoCmd.OpenReport strReportName, acViewPreview...

Hi, I have created a report with about 20 fields. When I run the report and then click on "Analyse it with MS Excel" I get: "Microsoft Access can't retrieve the value of this property....... The property isn't available from the view in which you're running the macro or visual basic code, or...

Hi, I have a form with some bound fields and some unbound fields. If I make any change to the bound fields I can use the "Before update" event to perform some actions when a user tries to move onto a new record. What I now need is if a user doesn't make any change to the bound fields but makes...

Hi, I have a form with a number of drop-down lists on it and each of these lists is bound to a field in a table. When I return the results of a search to this form I want to allow users to be able to cycle through the records and change them if they want. However, the changes should only be...

Hi, I am creating a generic search form [FormSearch], which allows users to select different data options and then display the results of the query in a new form [FormAnswer]. When the search button is clicked on FormSearch I: - construct my SQL Query, which works okay - set the recordsource...

Hi, This is a Query / Forms question... I have 2 tables setup with a 1 to many relationship, simialr to 1 Customer having 1 or more orders. I created a query to prompt for all orders for a particular customer. I then created a form based on this query - i.e. linked the query to a form. Now...