Search results for query: *

I recently converted a Microsoft Access97 application to Microsoft Access 2000 with a SQL Server backend. There were Previous and Next buttons, but when I want to go to different records, I get a "Can't go to specified record" error. In testing this worked BEFORE I moved the...

I am using an Access 2000 front end with a SQL Server backend. I just converted the backend data from Access to SQL server two weeks ago. Things seemed to be working fine, then we discovered that we needed to add an index to a patient record field--that wasn't the primary key-- so that the...

Thanks for the help--In my code the "(" was there. I discovered the problem-- you have to use semicolon ";" instead of comma "," when calling functions in Turkey. Ugh!

I'm working remotely on an Access 2000 database application in a foreign country (Turkey). The backend is SQL Server. Any new function I call from a query or form or report, no longer works. I keep getting the error "The expression you entered contains invalid syntax. You may have...

Thank you so much. That did the trick!

I'm using Microsoft Access 2002 with a SQL Server backend for an application. I have a table that has a primary key with an identity that is automatically generated. And then I have a column in that table that is a text field that I do not want the users to be able to duplicate. Is there...

I just recently converted an Access 97 application to Access 2000 with a SQL server backend database. Here’s the issue: The users are getting the following error: “Write Conflict—The record has been changed by another user since you started editing it. If you save the record, you will...

I'm getting an errror: Run-time error: 2114: Microsoft Access doesn't support the format of the file Path to File so it can't load the picture. Through code I can open a jpg file stored in a Pictures folder on the server. I copied this code and added a Formulas folder on the server. I...

I have a user that wants to export an Access report to an Excel spreadsheet. Everything exports, except data in the Report Footer area. Only the first field of data in the Report Footer area exports. The other Report Footer fields are calculations --Dlookups and summary calculations based...