Hello: in the example below, I want to cycle through my records and 1: pick
up the most recent two records based on date and name id; input a "show" flag
IF it has a "Fail" status in either of the latest two (or in the latest).  
Then I want to query on the "shows" .  Using the ...

I need to synchronize records between two forms. How can I acheive this? Is a
macro the best way?

Good morning,
I feel that I have a 'decent' grasp on my code, but I cannot figure out why
I am being prompted for a parameter for 'htmlfilename' when I am assigning a
value to it from within.  Can someone help, please?  (watch the word wraps)  

I have small program that inport excel datasheets to access table and work
with them.
One of my clients send me .csv files which can't be read by import data from
excel

I'm experimenting with transactions in my db.
What limits are there as to what can be rolled back if
something fails. Several subsequent action queries work I
guess.

I have the following code and I keep getting an error about my WHERE
statement about a missing operator... but I can't seem to see my mistake for
the life of me.  Could someone please point it out to me.
************

How can i have code for more color other then one listed down?
like pink , orange, green?
lngRed = RGB(255, 0, 0)
lngBlack = RGB(0, 0, 0)

I posted this question in Forms Coding but couldn't get it answered. Probably
my fault for not explaining properly. Here is what I am trying to do. With
the results I am going to use the SendObject method to send the result info
to different users. All I want to do is dump text ...

I have a form, with a sub-form. The sub-form is a continuous form.
All fields on the sub-form must be populated. Failure to populate
one or more fields will cause a message to be displayed, focus set to
the first missing field, and edit mode for the row.

I get an "Incorrect use of property" error when I try to modify the
attributes as follows:
rel.Attributes = dbRelationUpdateCascade
What is wrong in my syntax here?

I have (I believe) created a table that includes SSN in typical fff-mm-llll
format.  I've included the hyphens to tell the program which field to search
on when text is entered in a "search" text box.  If I open the table and do a
manual "find" from the menu, using the hyphens in ...

What is wrong with this statement.  I am getting the error message
Run Time Error 3061
Too few Paramenters.  Expected 1.
Dim db As Database, rs As Recordset, strSQL As String

I have various reports that print student lists grouped on various options;
by teacher, by grade, by class.....  The line in detail section lists the
students name and rows of boxes based on the report fields.   The boxes are
printed using the  rpt.Line function.

This is a follow up on a calender question that I posted yesterday under
queries, but I put it into a new thread because I am going a different route
with this (I think).  As a brief description this is what I have set-up.  I
have a table with 5 fields:  StartDate, EndDate, ...

I have a set of Windows folders named by date, yyyymmdd:
20041031
20041105
20041109