My query in SQL looks like the following: (right now the query makes sure it has a certain qualifier when it pulls data from tblJournal & I would like to add...

Hi to all! Maybe I've found a bug into Access 2000... Can I configure the dbms to delete the null values from a result query without using the WHERE clause?...

I have a database with an employee table. There are duplicate ss#'s in this table I want to create a recorset that shows the duplicate records. In Access...

Hi, I used to use ADO methods to update certain tables. The problem is sometimes, it takes a second or two before the updates get committed to the database....

I have a bunch of Parameter Queries that I have been calling with VBA. But now I am converting my code to use ADO recordsets. How would I change my old code...

I am working on a subform called Cheque, which forms part of a form used to collect payments from clients. the cheque subform is a continuous form as clients...

Below code gives me the error: Item cannot be found in the collection corresponding to the requested name or ordinal. Can anyone tell me why. I get this...

I would like to know, first, if it is at all possible and second, if so, how to: 1. Join SQL Server 2000 table with an Access 2003 mdb (local) table 2. Append...

I have a table, 'Customer', which I want to use VBA/ADO to auto rename all the fields. for example, to rename fields 1 to 'customer name', field to 'customer...

Hi All, I am running Teradata queries from MS Access using a ADODB.Connection. The queries run directly unsing Teradata in about 3 Min. I can't keep the...

I am interested in 'rescuing' a piece of 'Personal Information Manager' software that is due to cease working at the end of this year. It has a popular...

I am trying to change a field name in a query using ado or adox. It seems this is not possible if the query is already in the querydef collection. I have not...

Hi folks My client has a “split� architecture Access database – the back end on a server and the front end on users desktops. All was well until the...

how do i create a crosstab query in an ADP application so that I can create a graph from the data? the query im trying to enter is: TRANSFORM Sum(Clients) AS...

(I hate to cross post but I need to find a solution quickly) As I continue to try to salvage an ADP project in Access 2007 (and the light at the end of the...

There is one query in my access database project depend on Parameter in running from a form For ex. Called Form1 and the Parameter called IdNo When I was...

I have three date fields, EffectiveDate, DisconnectDate, and SuspendDate. I want to create a status field where the result will be Active, Inactive,...

I have tried to get answers before with no help, so now I have two problems. First, I am linking to excel and whatever fields contain blanks, I am getting a...

I need to separate items into sales clusters that are defined by ranking all the items sales and determining which ones compose the top 70% of total sales, the...

I would like to build a slightly more advanced calculated query. The database has a Musicals table, Customer table and Bookings table. If a customer has 3 or...