Guys -
I have a textbox that I will store information from a variable.  Th
textbox will store a form of report based on some calculated figure.  
want the following items to be displayed:

I have a table that contains 2 relevant fields:
Grade | Points
 A+  | 4.2
 B   | 3.0

I am trying to Run a setvalue macro based on conditions the condition is if a number field is between certain numbers I am tjinking I am doing it right ex:
Report![Name]![Field] between 1 and 10
However not working

I am having a problem with DLookup.  I have a table with a field calle
COMMENTS.  This field is a text field.  A record might have ht
following information under this field: "Called person on 06/11/2004".
Each record in the table has information under the COMMENTS field an

Hey folks,
Got a file that comes as EITHER a one ling string OR same
long string BUT has a Crlf @ (I think) 80 character wrap
and always I need to parse this file into individual

I have a little problem, how can i change an date f.e. 05/02/2004
that he gives me the last day of that month?
Thx in advanc
-----------------------------------------------

i have an access database on a server which i have very
limited rights to. i need to create a macro/form anything
at all which will generate reminders and send auto emails
each 48 hrs from the time field in the database. i am on

I created a form that automatically insert dates based on the input of another record in Forms.  However this data is not in the Table.  How can I either create a macro to copy this data into the table or How can I get this information into the table from the Form.  These all ...

I have a macro that runs a dozen queries of various types.  It seems that
when the macro is complete, the screen is littered with datasheet views of
any of the queries that were select queries required by various update and
make table queries.  Hope can I prevent these from opening ...

I have a query that has a parameter that is chosen from a listbox on a form.  I need the form to open evertime the query is executed.  How do I make it do that?

I have succesfully created a macro to update a table by importing a
text file using the transfer text macro and the import specification.
When I click on the macro i get a text pop up letting me know it
couldn't append all the records in the text file due to key

Is it possible to get access to automatically run "send
to a compressed folder" in order to zip files together
which have been created?
Thanks

Access 2002: I have a combo box on a form from which to
select data in a table. I want to be able to add an entry
to the table if it's not already in the list. HELP tells
you to run a macro on the "On Not In List" event/property

Ok so i placed this question on a previous post and i
would like to know if a macro could run to be
able to calculate how many hours an employee has left for
vacation.For example, 10 employee with each having 200

I have a macro set up in my database that dumps data to
several Excel spreadsheets at once.  This data dump will
take place weekly, replaceing the existing data in the
existing spreadsheet.  My problem is that I have to click