I have several queries that have worked fine for years yet everyonce in a while they absolutely will not run. They are "make table" Queries and I will get...

I am having a problem with my MS Access 2003. When I try to append a table to another I am not seeing the first table in the list. I have tried to force it...

Didn't see an appropriate group, so I hope these two will do... I'm setting up my table relationships is MS Access 2003. Some tables appear multiple times...

Hi (How) can I set column widths in a query programmatically? TIA

Hello, I heve been beating around the bush with Union Query. I am giving up and need some help here. I have a query that extract lots of data, I need to...

Hi everybody, FormPermit with SubFormAlarms writing in QryAlarms. The form describe the owner of a permit for an alarm. The subform the list of false alarms...

I have an Access 2003 project connected to a 2000 SQL Server. All in-line functions that requires a parameter is not working by any user that got the windows...

Hello, I've found a quite disturbing issue in Access 2003 projects with MSDE2000A. I've find out the shortest way to reproduce it: 1) Create a blank ADP...

Hi, I am using Access 2003, and whenever I design a view and wish to view it, Access will prompt that it must be saved first. Is there a way to view it...

I am aware that Microsoft, in their infinate wisdom, has decided to block the ability to update linked Excel files from within Access 2003. My question is,...

Hello, I have a large Access 2003 database with about 50 000 records upon which I would like to perform mathematical operations (percentages, weighted...

I want to append a new record in one table, if the field in another is equal to one of the values in a third. e.g. COLORLIST table contains "BROWN", "BLUE",...

An append query I have been using monthly since 2002 all of a sudden will start running but hang and never finish. I tried making it a make table query and...

I have done append queries before, though not recently, so I may be doing some very simple error to which I am oblivious. I am using the query window. When...

Hi All I'm unsure which approach I should use when designing a FE/BE. In the Access BE I have 2 tables which are related by primary and foreign key with...

I have a query that results in one row (record) with 14 fields. Those feilds correspond to 14 rows (records) in another query. I need to match up the rows...

Hi everybody, Is it possible to copy a record when a field contains three entries and obtain 3 records, one with each entry. The table is Colors : Id ...

Hi everybody, Is it possible to copy a record when a field contains two entries and obtain 2 records, one with each entrie. The table is Colors : Id ...

Is there a way to format a field in a query to currency and display it like this: -$4,650.00 instead of this: ($4,650.00) ?

I am working on a database started by someone else. It consisted of a table with data already in it. All the data was entered directly to the table. I...