Recent content by scmitc

YIPEE! That was the problem...the control source was blank. I put in ABREV and it ran beautifully!! You folks are GREAT!!! Thanks so much everyone!!:)

I took the advice to create a form that has a simple combo box in it feeding from a Table that I included my state abbreviations. Then I created a test query which references the combo box in the criteria value. But I'm doing something wrong because the result is 0 records. I ran the exact...

But to clarify on the SQL I sent...this is just ONE of many queries in this database that have the "STATE" field that needs to be updated. Each query has different fields - the only constant is the "STATE" field among them. So, currently, I have to go into each of the queries and update the...

Here's the SQL that was requested in one of the replies: SELECT DISTINCT GGDD_PROV_AD.PROV_ADDR_SEQ_NUM AS [Prov Addr Seq Num], GGDD_PROV_AD.FRST_LN_ADDR AS [Frst Ln Addr], GGDD_PROV_AD.ADDR_CMT_LN AS [Addr Cmt Ln], GGDD_PROV_AD.CITY_NM AS [City Nm], GGDD_PROV_AD.STE_CD AS [Ste Cd]...

My company is currently using Access 2002 and they don't have DAO library references set up. They won't let employees access to Library References to add or remove so, unfortunately, that isn't an option. But thank you for the response!:)

I have a number of queries within the same database. Is there anyway to change the criteria in one field on each of the queries all at the same time? Example: I have a state abbreviation in the "STATE" field in 36 queries. I run those to produce reports. Then I need to go in to those same...

Sorry - to clarify...I need to RUN the macro.

I need to pull a macro from a different database. The name of the macro is "Delete"; the path of the database is: D:\Databases\ADDS\Master I've been told I can use the Run App macro and put in code to tap into the macro. I've put in the following code but am getting an error message - can...