Can someone please show me how to hide all columns when it is null using VBA
code.  I am using a form in datasheet view.  I am trying to hide all columns
that are null and display all columns that are not null.   I have tried the
following in the Form_Current event and it does ...

I am trying to access set of records in a query sequentially to send
email. I have the following code to access a query.
*****
Sub ReadRecords()

my computer is changing all my 2003 word docs to note pad on its own.

I want to create multiple Mailing lists for different Items that I
send out from my marketing department.  I want to create lists for
four different items which are sent out every month,  some of the
recipients receive more than one of the items and others do not.  I

I have a form and on this form I have a text box called "FE Owner".
This text box does not have a control source to any table.
What I need is the default value of this text box to point to a table called
"tbl_FEOwner" and to a field called "DB Front End Owner"

I have a form that I would like to lookup values in several taxt
boxes.  The values I want displayed are from several different Sum
Queries.
Example: I want to pull Total Working Blance from a query and monthly

First, I would like to say I am using Access 97.  I am using it at work
because for one reason or another they can not upgrade higher than 97 due to
Security flaws, or losing information.  With that said, I will ask my
question.

I've implemented the following procedure using this guide -
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b210297
Now my main thing is to have it to where it'll run after 7:00 pm - Is there
a way to do this?  Should the Database be closed, or opened?  Should I run a

I am using a main form (Level1) that has subform (Level2) which in turn has
another subform (Level3).  Both subforms are being dsiplayed in Datasheet
view such that expanding a row on the Level2 subform Datasheet displays opens
up the Level3 subform to show child reocrds.

I have a table whose fields are named boolType00, boolType01,
boolType02, ..., boolType19.
I need to make a loop and real all of the 20 fields. Something like:
Dim i1 As Integer

In my tables I have a link to an Excel workbook.  What VBA code can I
put in the OnClick event of a button to automatically refresh that
link?

I'm using an After Update event on a form to update one field with the
current date when a checkbox is checked, but the date doesn't display until I
scroll down the form.  Is there some way to get the date to display right
after the box is checked (or at least once the next record ...

I have a form in Continuous Form view where I added two Command buttons
after the last control in the details section, one over the other.
the first one has a "Key" picture on it and when it is clicked, it unlock a
control so I can edit its value, then it's visible property is set ...

I have the following code derived from various examples:
The original error trapping seemed to be faulty and sometimes ended up
in a continuous loop so I removed it while I developed the
application.

I have a single table with a main form and sub form. A combobox on the main
form filters the subform - works fine.
I have added a command button to "Show All" records - in essence, removing
the filter condition.