Search results for query: *

I am in the process of testing our Access 2007 databases for compatiblity with Access 2010. So far - all seems to be working well. All users are using Access 2007 until testing is complete EXCEPT for 1 user who is using 2010 (yes - there is always one!) FYI....I have a SQL backend - using...

I have a user that forgets and uses the ctrl minus sign (-) on an Access 2007 form which deletes a record - which he doesn't want to do. He uses this in Excel 2007 and it zooms out. Is there any way I can deactivate the Ctrl minus sign in Access?

I made a change to a database I inherited and I'm having a problem getting it to work. I thought it was simple? Listed below is the originial code and it works without issue. All I need to do is add a location field (Loc_cls) to the selection. It does not work. Does any one see anything...

I inherited a database originally created using Office 97, then migrated to Office 2003 then Office 2007. All has been working well in the database so I now want to put a SQL backend using the Access frontend. I have run into an issue and can’t figure out what the problem is. I get the error...

Can someone please give me some suggestions for filling a record with data from a previous record? EX: Field1: 1234 Field2: Test 2 Field3: Test 2 aa Field4: Test 2 bb This would be my first record and any other new records would have fields 1 and 2 automatically filled with data from the first...

I have used an autofill module that works great in Access 97 and 2003. I cannot get it to work in 2007. Here's the module code: Function AutoFillNewRecord(F As Form) Dim RS As DAO.Recordset, C As Control Dim FillFields As String, FillAllFields As Integer On Error Resume Next '...

I have an issue with an old database I inherited. I have updated to Access 2007 front-end and moved the back-end to SQL. The field in question is called “Number” with field type of Int. This field is populated from the form based on the following calc...

I have an issue with an old database I inherited. I have updated to Access 2007 front-end and moved the back-end to SQL. The field in question is called “Number” with field type of Int. This field is populated from the form based on the following calc...

I have a field(nvarchar(50) in a SQL table that I want to use in an Access 2007 linked table as a "dropdown" field. I link the table to the Access database but - because it is linked - I cannot use the Lookup wizard as datatype to define the field. How do I define a dropdown list in Access...

I have a field(nvarchar(50) in a SQL table that I want to use in an Access 2007 linked table as a "dropdown" field. I link the table to the Access database but - because it is linked - I cannot use the Lookup wizard as datatype to define the field. How do I define a dropdown list in Access...

I have a SQL table that has an idential duplicate record and I am unable to delete one of them. I get the following error message: "The row value(s) updated or deleted wither do not make the row unique or they alter multiple rows". Any idea why I can't delete one (or both) of these records?

I have an Access 2007 database that has a front and back end (both Access). In the last couple of weeks, something strange has started happening to the front end. The size is increasing rapidly….from 15672 kb at 7:34 to 31416 at 10:30. The backend seems OK….86276 kb at 7:34 and 87268 at...