Search results

Thank you very much for your help. I will have to find out if we have SP3 installed or not here at work. Thanks!

I searched Google and this forum, and maybe I did not know the correct phrase to search against, but I did not find anything on this issue. I have an MS Access 2003 database with a SQL back-end. It works great, quick, multiple users in at the same time with no issues, etc. But a user has...

I have an MS Access 2003 front-end (queries, forms, reports) connected to a SQL server back-end database (SQL Server 2000). When I try to run an append query against any of my SQL tables with a unique identifier, I get the error... "Explicit value must be specified for Identity Column it table...

Is there anyway to resolve the issue? I found a work around for the current form structure, but I wonder if there is a true fix for the error. Thanks!

I did not realize queries were compiled. I have tried your suggestion of copying the SQL into a new query SQL statement, and once again the query recordset is locked. I then played with the SQL statement by taking out some of the fields in the select statement, and still the recordset is...

I have a database in which the tables are located in one MS Access file, and the queries, forms, reports, etc. are all located in a seperate MS Access file (MS Access 2003). The MS Access file that stores the tables, I call the "back end file". I got a call regarding the database, and found...

I need to disable the [Shift] key so that when the users open my MS Access database, they cannot by pass the open form and display the database window. We had code that worked correctly with an MS Access 2000 MDB, and even works with an MS Access 2003 ADP, but the same code is ignored by MS...

I am trying to brainstorm this idea, and I just cannot come up with anything. I have an MS Access database that will now be tracking invoice information. The users were wondering if on the form that displays the invoice information, if they can have quarterly and yearly totals for the invoice...

It has been requested that one of the columns in a Datasheet form be of a different font color. The reason is, if the users double click on this column, it opens an expanded pop-up form with data relating to the data in that specific cell. So the users thought it might be helpful if this one...

This should not be that difficult, but I am not able to get the code to work. I have a continuous form, that is populated by a selection data string (plugs the string into the record source property for the form) once the form opens (depending on the criteria the users choose). Now that the...

I have a SQL Report published to the report server, and set-up to e-mail to select users. The users have requested this report appear in an MS Word format (.doc or .rtf). According to a book I have, this is possible, but on our report server we do not have this option. The options we have...

I did this, then compacted and repaired the database, and [Alt] + [D] is still available.

Thank you all for your help. I believe I have found the source of the error to be not what I thought it was, and this shocking to me. If you are on a sub-form and click [Alt]+[D], it asks you if you want to delete the current record. If you click "Yes", it deletes the main form record. :eek...

When you want to delete a record out of MS Access, you get the default pop-up message confirming you want to delete the record [YES] [NO]. I have a few users who are not paying attention and hitting a combination of keys (I am guessing Alt + D) and getting this message. They then do not look...

I have an MS Access front-end with a SQL back-end database. It works great, I connect the MS Access front-end to the SQL back-end using a File DSN. I have a few users (who are in the database the most) who get ODBC disconnection errors time to time. The cause of the error is not consistent...

I have run into a very strange error, and searched the forum and didn't see anything posted about "appearance, settings". I created an 2003 MS Access database, on a Windows XP machine, that connects to a SQL back-end using a File DSN connection. It works great. Then when I had our testing...

On the database I am working on, it would not be convenient for me to install the mouse scrolling that determines if the mouse should scroll down the form, or to the next record. That is a nice feature, but more than I need. I only need to disable the mouse scroll bar (so the users do not get...

I am running into the same problem. I am guessing you could create your own button on the form, and then call the built in function to spell check, and some how limit to one record. But I am not certain how to do this. Any ideas?

Thank you everyone. The code given to me be pbaldy did work correctly. I made a type (ugh, Fridays) and finally found it after walking away from my machine. Thank you everyone for your help!

Thank you very much for your help. I beleive I have found a fix around the error. If so, I will come back and share. Thank you!