hello i have been trying to export a query to an excel file. this query will run once and the data that it selects i want it to export to excel. then the...

That did it. Thanks a lot. John -----Original Message----- If you mean you want to take FieldA, FieldB, and FieldC and put them all into Field A of the...

Hi, I'm having problem of sorting a string this is the way access will sort 1.2.3.1 1.2.3.11 1.2.3.2 1.2.3.3 1.2.3.4

Hi Allen, I appreciate your help. Thank you so much for helping me resolve this problem. Petra

I currently have Office XP SP3 installed. When I run the following code to cancel a record I get the error that follows. DoCmd.Hourglass...

My setup: tblComposition PartName Chemical ChemAmtRatio (has a composite primary key formed by PartName, and Chemical) sample data: PKR1234 Al 40 PKR1234 Si 60

I built a query that was working fine at first, but then it started giving the error message ". . . expression is too complex to be evaluated . . ....

Greetings, I have a general question to the database community: Where can I find a utility other software device that allows me to create queries to a...

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...

Where has the PRINT button gone that helped us print a message. Its nowhere to be found since the site was 'enhanced' - now whenever I print the right edge is...

I'm trying to separate addresses of the form "201-33445B Main St" into Apt="201", BuildingNumber="33445", BuildingNumberSuffix="B", and StreetName="Main St". I...

is it possible to have a select query with a dynamic field name alias? basically i'm opening a query in datasheet view to edit some values but want the column...

ok... I have a table with 2 feilds in it... The first feild is a 4 digit number... The Second feild is a city... I made a look up with the look up...

Hi, how do you set the criteria in an Access 2000 Project example Criteria will be Forms!Form1!txtCustID. When I tried this it is returning an error. Please...

I would like to use a query to generate a list box that pops up when entering data into a table. I would like the query to run with a selection criterion that...

I am trying to calculate fields from different queries. The problem I am running into is some of the queries have no records, giving me a blank field when...

On my website (see sig below) is a small sample database called "TopQuery.mdb" which deals with duplicates in Top queries. -- --Roger...

I have downloaded microsoft office 2003 for my college classes. Whenever I try to do queries, it says a need a SQL server. I have tried to download one, but it...