I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we

Hi, I have a tab control on a form with 2 tabs, the first tab I use to
add records into a table.  Why do when I tab from the first to the
second tab do the records get added into the table, is there a way to
stop this? I only want the records to be added into the table when a

I have a perfectly functioning db in 2000-02 and 03. On a calendar
form, that lives inside another form, I have all the day buttons OnClick
event tied to an expression that points to a public function in the
forms code container.

I'm hoping someone can help or at least point me in the right
direction.
I have a SQL backend that is supported by my IT group at a different
site. I have an Access front end with my queries, linked tables, and

I'd like to convert a database from Access 2000 to SQL server. Does anyone
have any advice as to how to get started?

I am using the code example from http://support.microsoft.com/kb/161286/
It will open a file dialog for a user to select or type in a
filename.  It works fine.  However when the user types in the name of
a file that does not exist like "testfile" it will save it as

I am trying to find all records, say, within 100 miles of a zip code. Can
anyone point me in the right direction? I've spent hours looking around on
the web. I've found a lot of distance searches, but nothing that find all
records that meet the criteria.

Happy New Year Everyone,
I have some complex SQL statements that I would like to assign to a couple
different Events.  Any Ideas would be appreciated.
Thanks

The application has 1 main form with 3 tabs on it. The 3rd tab is used to
search and find users records (can have multiple records). To view each
record’s details from the 3rd tab, double click on the record to view and the
values should appear in the correct controls on tab 2. ...

I hope I can explain this correct.
I have a sub form based on an unbound combo box. The cbo box is based on a
query grouped of the subform data. The sub form is linked to a fld named
"Region". If the Region fld is blank and the cboBox is blank I want it to

I have a form with a subform:  parent records in the form, related child
records in the subform.  The user can filter the subform data with the
built-in Access filtering functionality.
I also have a button on the subform that sets a "batch flag" checkbox on the

I have two versions of a picture (.png files), one 'greyed out' and one in
full color. I want to display the greyed out version and then if somone
clicks on it I want it to change to the color version and vise versa.
I'd also like to assign a yes/no or 0/1 value to it so I can ...

Is it possible to filter records from main form by selecting data from
subforms?  Please give me some hint.  Thanks in advance.
Do I have to build a search function or is there a simple way?
Thanks.

We have several processes that we run on a daily or monthly basis that I am
trying to automate.  Each one has a series of delete, append, and/or update
queries, sometimes as many as 15 per process.  I am trying to find out if
there is a way to suppress the query messages but ...

I have a main form and a subform. The main form has  a combo box
control and the subform has a textfield.
What I want to do is when the main form loads it should check the
value of the combo box and if it, lets say "MZ" then the textfield in