I want to create a query that would find and delete duplicates only if two fields have matching data. Not meaning those two fields match exactly, like field A and field B both have "unprocessed" but ...

I'm using Access 2010 with Excel 2010 and I'd like to perform a query using ADO Command. See below what I did in Excel VBA:
Public Sub test()
On Error GoTo TrataErro
Dim cnn As ADODB.Connection
Dim ...

hello guys i have table1 that contain ID and Names columns i don't know how to arrange the name based on alphabetic order the name columns consist of minimum 3 names example: jhon adam smith i want to ...

I am using MS Access (2002-2003 file format) and in the file I have a form.
When I click on the form, I get a table with records.
I would like to edit those records, and want that edited records are ...

A legacy database has an association class represented as several fields. Even if the association class doesn't get normalized, I need to standardize the values to remove minor spelling variations.
...

I have a query that returns a dataset with UserID, CourseID, Course Completion date, Course Registration Date and Status (successful, not attempted, not finished).
However people are allowed to do a ...

I have a recordset that is missing one field for each record and would like to add some data from a form by looking up certain criteria. I used a select query to get data onto the form in the first ...

I have a query in an Access Db that counts the number of observations that meet a certain criteria as defined by two comboboxes. The query works fine, and I can get the result of the query to display ...

I am designing an Access database and I would like to set up a user history tracking system. The issue us that I am a beginner as far as Access VBA is concerned and that I learn on my own thanks to ...

I have inherited an access db that has an odbc connection to another server. The db only works when logged on as the user who left and I need to make it work for anyone. There is no User, System or ...

Target: I have created an split form of a query. I would like to display this in dialog box border style.
Problem: I am not able to resize the dialog box manually. If I select border style as dialog ...

I have an MS Access DB where the Saved Imports inside the External Data has Import Jobs which are actually importing certain data from various locations to SOME tables. I am unable to find out which ...

I would like to disable the bypass key of my database on the open form event during the autoexec so that the user is not able to view the underlying tables of my form. I have found the following code ...

I have built a system in VB.NET where all the sql is automatically generated and executed with CommandType.Text (default). In addition I have created a stored procedure in my access database I wish to ...

In MS Access, I have a form directly from a table and a subform connected to a query. The reason the subform is connected to the query is because I only want the user to add data for the current month ...

So I was given a access 2010 application. I'm trying to deploy it and it was developed in access 2010 sp2. The end users do not have access on their laptops so I installed access runtime 2010. I'm now ...

Ok, so I'm going through and teaching myself Access 2010 and VBA using nothing but the power of Google and the MSDN Dev Center Library. My "learner project", if you will, is an Employee Database to ...

I'm looking how to run a local query with date filters on a saved pass-through queries in Access. I'm trying to leverage the pass through query as basically a View in my Access database... the local ...

I am converting from access 2003 to 2010 and I am having a problem. When I select an item in combobox cmbCV it makes a subform visible and runs this requery for the "Lot" combobox:
SELECT DISTINCTROW ...