I'm trying to track deleted records.
On the main form the data is entered on, I added a command button, to delete
the record.  The code to that command button copies the data to a table.
To get a new ID for each deleted record and start the copy over to the table

I have a form that contains one combo box and 25 text boxes.
1.  The combo box autopopulates the boxes.
2.  One particular text box is called Area, which pertains to a particular
department.

I have a form that runs an append query on close. However I need to have
Date( ) automatically entered as the parameter on the query. Could someone
show me how to add that to the following statement?
Currently it looks like this-

1. I want to change the alpha value of fore color of a button at run
time to fade it.
2. I have a button and some text is assigned to it`s Text property.
3. I want to fade the color of this text OnMouseMove event.

I was wondering if it is possible set an object to a variable within a
For.. Next... Loop.  For example:
(This doesn't work but is essentially what I want to do)
i = 0

I have created a form which requests information from the user which is
entered into a text box.  I cannot apply an input mask because the string
entered can vary considerably however I would like to check that the
characters entered do not include ' , ; @ etc. before the record ...

I have a combo box with a list of three options - BUS, GEN, POL and SOC. I
am unable to get the code right for setting the forecolor property of the
combo box when the selected option is not GEN.
Please review the code below and advice.

I'm using a form using a list box to select name and 2 text boxes to
select a date range.  Once the information is selected, it produces a
report listing the completed projects.  I have a project type header
that counts the number of projects in each project type.  Project type

I have a range of double values that I need to compare and assign a label
depending on that value. For example, if the value falls in the range of 4.7
To 5.0, I will assign an "A" into a textbox or a label box. I use the Case
Select but it does not work. My questions are:

We are looking to automate a task within our batch-process based MRP system.
The MRP system has a very strict requirement on how we must form this data
in order for it to accept it. The MRP system has 7 exported Access 2000
tables where the data we need to compile is stored.

Is there a way to have my "stand-alone-like" .mde file available in the
standard task bar, like all the other windows?  (Instead of having it
minimize to a little itty bitty bar just above the start button.)
thanks,

TableA contains a field type "yes/no" , moving to tableB I have a form
"Form1" which has a field PartNumber from TableA, I need to query TableA via
PartNumber and then test the field type "yes/no" whether null or (yes/no)
I was trying IIf IsNull and Dlookup Functions stringing ...

I have created a form that is based on a query the criteria for the form is
the user ID and the the user services that are set as yes. This is fine in
the query all records display correctly but in the form only one record
displays even with continuous forms set. Is it possible ...

I have a number field on a form that I would like to count up to 20
from one for each entry.  This is probalby something easy, but is
avoiding me at the moment.  The catch is that I would like a command
button to reset it even if it hasn't reached 20 yet.  Also, when it

Access 2003.  I use a drop down combobox to select the value for a record in
a continuous form.  I would like to be able to make multiple selections from
the drop down list (or something similar) and have it then generate multiple
records.  For instance, say the list has A,B,C,D ...