I use this update query populate the [FactorRating] column in a table;
however, i'd like to use a VBA Case statement to set the full range (high,
mod high, mod low, and low) programmatically rather than chaning the values
in the WHERE clause each time.

I set my windows schedule task to open the
autoexecu Make table query(autoexecuRunQuery) and it did
not work????
I have XP, explain how to use the windows scheduler??

Howdy All
   I'm writing some VBA code to update a table from a flatfile that was downloaded off the net.  Any record in the flatfile may have a primary key that already exists in the table, in which case I think I need to use an SQL "UPDATE" statement to modify the table.  ...

I have a Query that has selection criteria (Example: Day=5)
Now I want to write a Macro that opens the query in design
view and changes the criteria to a value specified by the
Macro (Example: Change Day=5 to Day=17 or 19 or 31), then

I have two make table queries that I'm trying to
autoexecu by macro on a daily basis.
As instructed I have
Set Warning - False

Hello,  Is there a macro that I can link to a control that
will change the font color of a cell on a form?  Thank you.
Kent

Is there a way to run a macro that will go to a make table
query and at a certain time each morning it will run the
refreshed data from an ODBC linked table. Because of
processing each day the linked tables information changes

How do I get a macro to filter a macro and then run another query on the results from the first?  Please help!!!

I'm new to Access but have used Excel Macros extensively.
If I create a macro in Access and then go into VBE that
macro is not there. Similarly if I create a macro in VBE
and then try and connect it to a button on a form it

I am trying to create a macro which will automatically
create an index based upon a field I choose.  How do I go
about this or is it even possible without resorting to VB
which is beyond my understanding at this point.

I have a form with many tabs.  I have fields that get
inventors' names from the inventor tables in a drop down
list.  I have a created button to enter a new name
(because it is not on the list yet), which works just

I am wondering if there is a way to test to see when a form closes
I want to run a macro only when the other form close
please help me

Have a macro named mcrClose.
Within is a macro named mcrCloseoptions.
mcrCloseOptions has conditions relating to option group selection and is run
on a button click:

I need help creating a report whch includes a Conditional
Macro (no VBA).
I have a query, qryA whose records contain the
fields  "StreetName" amd "AssocMemb".  "AssocMemb" is a

Please Help!!!!
How can I use Setvalue to set the value of the ID (autonumber) of a main form to ID control (number) on 3 Subform whose visible properties are set to NO. The subforms will be visible based upon a selection in a combo box on the main form. Your prompt response is ...