I have 6 queries in Access that run great. They need to be run in
sequence with the first 5 queries writing to tables and the sixth one
pops up the final results in datasheet view. Now, how can i automate
this process? I started with the simple macro builder and entered all

I have a database that I am converting to a mysql backend so I can
access it across a wan a little better (hopefully).. Im converting my
DLookups to sql statements but I have an issue when they return no
records.  See below for the code.  Also, what are your thoughts of

I have a continuous form bound to an underlying table.
How do I change the value of one field (all rows) to a particular
constant say eg.  1998.
Someone on the Group here mentioned I should not use a the RunSQL

I have a control on a form - Combo0 which lists some companies
for me to select from. I'd like to put a couple of cmd buttons on the
form that allow me to switch between listing ALL companies and
JUST THOSE having related records in tblPreliminaryVINs.

I've created a table in Access and I've made the type field list for
one of my fields. How do I populate that list?
Thanks in advance.

I have a button on my (continuous) form which when pressed performs
the foll 2 actions:
1) it resets the field "Init_Bal" to 0
2) it computes the closing balances & stores them in the field

Dear reader,
As far as I know you can work with Access on tree different ways:
·         Jet-Engine
·         MSDE

Dear reader,
How can I find a record in a sub form, the sub form type is DataSheet and
the record collection in the subform are to many to show them all in the
subform window.

In MS Access how can I skip to the next page on section break if
section can not be printed entirely on the preceding page.  Say if I
had 20 print lines on the page and I have section 1 with 4 records and
section 2 with 5 records ... Section three has 10 records... I want to

How to deal with a VBA-project that is damaged?
Hi everyone.
I am BigOlle from sweden and I have been working with Accees for ten
years

Hello Newsgroup,
I am doing some archive database and therefore got one table indexing
every folder and one table storing which rack belongs to which
department, eg:

On a crosstab query, I often produce reports that show Counts of
values. the problem that I have is that where there are no counts, no
values are returned i.e. there are blank cells.
Is there an easy way in which to automatically replace these null

Anyone help me set these Tools - Options settings in Access 2003 via VBA
code:
1) Use Windows Themed Controls on forms"
It appears that i could use:

I guess I missed the boat on the logic for this one.  Immediately upon
hitting "Import" in an
attempt to import an Excel file containing 7 columns of 'txt' formatted data
into AXP, I got a "Type mismatch" error.  A search of previous posts

I'm generally pretty good at this, but can't seem to come up with the
best way to do this "One Time" task. I have a 2-column table in
Access, sampled below with some sample data shown:
TenantID, OperatingStates