We have a system that each night exports several tables of data to Access 97
format.
We use Access 2000 and 2002 and have several programs built that link to
those exported tables.

Hi, this is the scenario:
I am storing several databases on a server (inventory system).
I have created a Welcome Page where you select which database to view. It
opens up the Data Entry Page.

Using Access 2002 we have a form containing a tab control which has 12
pages.
When the user clicks on a New button for a new record focus is set onto the
1st Page.

This about an existing database to which I was asked to add a form.
I just tried to compile an Access2000 database (on Access2002), and a form I
did not work on, came up with an variable not defined error, on a textbox
that was programmatically set to have its Locked property set ...

I have a database that contains information that I retrieve through links
tables. I would like to be able to scan through and copy this information
to a locale table.
I have a Parent form that views information from the linked tables via a

Hio there,
I have a form with a button on it, which i put on via the wizard - this
opens up a report.
My Report is run from a query, which requires a unique id - i want my button

I have a text box on my form that requires a MSISDN to be entered with a set
prefix (27). What code do i use to make this happen. I also want a message
box to appear in two intances - 1. If the number is entered without the
prefix, 2. if the MSISDN is less than the required ...

I want to disable editing of a field in an updateable form without using the
enabled property. I don't want the field data to appear greyed if I can help
it,
prefer to just cancel the event for updating.

I created a multi-field index (named "Pass2Index") for a dataset. The fields
are all the ones in the ORDER BY below:
recSet.Open "SELECT * from [Quarterly Data - Passed]  WHERE [Year] = " &
yearCounter & " ORDER BY [Procedure Code], [Major Program], " & _

I have created a query that collects and a report that desplays all of the
collected information from the query.  
I would like to be able to view the data pulled from that query using
different fields (these option buttons enable a textbox for which the user

The ShipWeek field is supposed to be the week of... I need to know how
to get the value of the Monday of that week.  The field value is
currently the OrderDate plus 21 days using DateAdd.
ie: OrderDate is 4/20/05, ShipWeek should be 5/9/05 (Monday) not

I have a form that has a subform. They are joined by the OrderID. I am
trying to access the itemized records that are in the subfrom by
cloning the subform records.
I am getting errors on the method below.

Given a directory path string, such as "D:\documents\file1.txt", how do I
extract the filename part?

When I select an option from a menu that runs a query I first want a custom
form to popup and promp the user for criteria.  I've designed a form but cant
seem to attach it to the query not getting much luck with the access help
either.

How to highlight an entire row of records and hold this format while user
navigates to correct record, (6 fields) so an append query (via a control)
can then be run to append the selected row to another table.
I have a product search form with: