I have a query that ran perfectly fine in access 97 and 2000. It's running fine on my client's system now in 97 and it used to run fine on mine in 2000. I...

Greetings, I have some mediacre fee shcedules that contain "CPT Codes" which contain codes that have several different fee's associated with them....

I am just getting started with Access and have a simple question. I have a basic table with part information in it. I would like to have a small window open...

I am looking for a way to order text numbers - similar to a number list order in Word i.e. - 1,1.1, 1.2, 2, 2.1, 2.2, 3 ... etc. These are item numbers in a...

I have a split database on a network. Everyone is working just fine but one computer which has suddenly slowed down. Everything else on his computer is fine...

Hello, Has anyone experience of this problem? I have a database with three tables - lets call them 'tblA', 'tblB' and 'tblC'. Structurally, they are all the...

Hi all, I'm trying to create a transform query with VB6, ADO 2.8 and Access 2003. I'm basically doing the following: 'Create catalog connection Set...

I've run into a curious behavior with Access 2003. I would like to know if Access 2007 handles things differently. I have to provide a bit of background before...

I'm trying to create queries in Access 2003. Every time I save my code, Access truncates the code and destroys my query (and as a result, when I try to run the...

I have a set of excel export queries I created in an access 2003 DB. Now, some of my users have upgraded to Access 2007 and are running in to a "Parameter"...

I must zero fill a text field in a query but not sure how to go about it. Suggestions anyone? Thanks! -- NC Beach Bum

Hi - I am trying to return non-duplicate fields from 2 tables. tblParts is a Parts list with specific partnumbers and tblGDSOUT is a table created from a txt...

I am new to Access and having a difficult time. I have built some tables and would like to create queries and reports. One of my tables has a key field...

Hi, if you read my first message, you know that I forgot to state the nature of the problem. so, here it is again. When I try to create a query using the...

I have a duplicates query ported over from Access 2000 that is showing an extra record. For testing purposes, I have a table with 2 duplicates and I am...

I have a moderately-sized database with over a couple dozen tables. I use this to track employees (hire, fire, transfer and promotions), maintain specific...

I've been at this way too long! Syntax errors, type conversion errors...help! I've tried ltrim/rtrim left/right...latest follows. fullname field is...

Hello, I have a combobox on a form and currently I manually select the next item for a member as needed. This is fine for 1 or 2 but typically I have to do...

Hi, When I try to start Access' Table "create a database design I get an 'dll' error message, but i can use it; however, when I trying creating a...

I have serveral tables 1: Invoice table Fields, Inv. #, Date Truck,Type,Contract,zone, over-zone, 2. Truck List Table Fields: Truck, Type,...