I want to read down through a table and insert a common value in Column
C whenever the values in column A are sequential (1,2,3 etc) and the
values in column B are the same.  See example.  Does anyone have some
sameple code that would get me started?

I have a form, that when I open it, it shows all items that are due for
inspection in the current month and that is overdue. This is shown in
continuous view and it has a column that shows overdue months.
So if it was November it would show all the assets due in November with

I have an Access 2002 program that I install using Wise.  The first
thing my program does when a front end is opened is re-link, then it
checks the version and if needed upgrades the backend.
My problem is that I have a new front end version upgrade that creates

I am trying my first functions in my code.  I have a set of queries
that runs to create temp tables with the right data for some reports.
They can run for a long time, so I want the user to know what is in the
tables (date parameters) before running all the queries.  This way, if

I learned recently that I should never allow end users access to my
tables, that if I want them to see that data in that format I should
show them a datasheet form. I created a form for this purpose. When I
double click on the form in the database window, it comes up in

I have a problem that just showed up and I'm not sure why.
I have a query that is supposed to show all records that have an
Inspection Due Date any time in the past up until the end of the
current month.

I have a continous form that contain 10 fields
I would like to be able to sort 3 fields with a command button
example columnA can be 100 or 200 or 300 (there are many records of the
same value like maybe 200 records have 100 as a value, 85 records have

I have a program working well.
I install it on another computer and i have a problem running the
program and it seems related to the Left function.
Libraries should be the same on both computers.

I am creating a complex database, which contains patient information.
One section of the database involves the tests each patient has
received.  Currently, I am using each test as a field with check boxes.
For each patient, I need to know the total number of tests performed

I have a form which list a Company and its details.
On the form is a 'CompanyType' combo box. I would like to filter the
dataset to show only those records that are of that CompanyType after
the user selects an option from that combo box. What is the best method

I know you can convert a database from Access 2003 to 97 easily but is
there anything that I should avoid doing in Access 2003 that might make
my database incompatible with Access 97?
Many thanks, Dean...

120     MyString = "How many copies of each  letter do you need?"
150     MyVariant = InputBox(MyString, "How Many?", "3")
If MyVariant = "2" Then MsgBox "MyVariant equals the string '2'"
If MyVariant = 2 Then MsgBox "MyVariant also equals the value 2"

I have a data entry form with several fields.  Data is entered over a
period of time before it is exported to a fixed length text file and
then used by a mainframe program.  I need to format one particular
field with trailing 0's.  I have the following code in the 'lostfocus'

I have a form with several combo boxes, continuous form format, with
record source a query off an Item Table.  The fields are Category,
Subcategory, and Color.  I am displaying descriptions, not ID's, so I
have to convert the ID's from various lookup tables.

I did not know pressing F-11 key would open database
window in a runtime installation. I found it out by accident
today. How might I prevent this undesirable event?