This is a bit strange but works fine with access tables but NOT with ODBC. When I create a query using a hard coded value for selection (i.e. = "486-66") my...

Anyone know of a program that can search your database and find queries, etc. that are no longer used? Or does Access have a tool that does this and I'm just...

Is there a way to use a single column in a multi-column combo box as a parameter for a query? I've tried using the control.column(0) and am not having any...

Hello All Does DateDiff always have to return an integer? I would like it to return the actual difference, in minutes, to say 3 decimal places. I realise I...

I have 4 field columns PAID,COMMITTED, OBLIGATED AND A NEW FIELD LABELED ECD TOTAL: after the label ECD Total I have the following formula ECD Total:IIF...

I am running a query that groups an indicator code. I would like to label the code. Here are the results of the query: Code Sum 1 3500.00 2 ...

Hey guys Is there anyway from over a network that an excel file or database can somehow send a communication or some sort of response to force another Excel...

Guys I made a mistake in my other email this is the issue. The PAID field has a P or it's blank there are no zero's (0). I have 4 fields OBLIGATED COMMITTED ...

I have created a DB for tracking a company's trademark applications. Trademarks are assigned to classes ranging from 1-45. Unfortunately a trademark can be...

Don't know if this is possible @ all, as from searching the newsgroups I can't find a particular article that is requesting this. I have two tables as per...

Field 3 contains numerous records as follows: 03-81669-ml 02-21567-rjl 00-58902-kl and so forth. I need to remove the second dash and letters after the dash...

I have a database I am working on. So far, I have used the table analyzer and split the original table into 3 tables. The majority of the fields in the tables...

I am using DMax to show the last "SOCStart" for all customers. This function makes the query run very slow. Is there another way to do this that might run...

Hi folks, I have a question how to obtain an update lock when talking to a MS Access ODBC data source. The DSN is roted to an otherwise unused .mdb file...

Hello, I have a query that when a partial company name is entered, it is supposed to return all representatives of all companies that have that...

Hi all, I am trying to create a query that sums up all used operating systems used in my department. But I want to have them shown just once. i.e. I dont want...

i am not sure if this is the proper Group but i will post it here, i want to calculate from a table the geomean of some values, the table has a primary key id,...

Why does this happen?

I would like to take a known list of street addresses and compair them to the addresses of people in the current database. I have a table of "known...

I have a table, that I want to change its name to be more descriptive to better distinguish between it and a similar table. The problem is I have many quires...