I have a report header in a report that prompts for info and omits some
information in the detail section if the data is zero or null.  
While the report header shows up in the design view; it doesn't show in the
print preview mode.  Any suggestions?

Having some problems running a report with a list box selection. Below is
the code I am using.
The code should create a criteria (in the field Seperator) to run a report
based upon a query, however this is not happening. If I enter the criteria

I appear to be having a problem with an append query. I created a select
query, converted the query to a make table query. The query created the
table, NewTable, and inserted the data.
I then modified the query again to an append query. The data in NewTable was

All:
I would like to start by saying that I have reviewed every post I could find
on this site, a half dozen websites devoted to dependent dropdown lists and I
cannot get it to work ... so I am throwing myself on the mercy of the masses

Hi, all.
I have a small group of users for a particular database -- probably about
half a dozen spread around the country.  Instead of trying to get ACCESS to
work over a network, our powers that be decided that the best way for folks

I'm trying to figure out how to do something.  I'm creating a database to
track our counselor's activites with clients (I work for a non-profit
organization).  I'm creating one table with Client information (ID field -
primary key, Name, address, counselor assigned, reason for ...

I have an option group with four option buttons for "Titles," (Mr., Mrs.,
Ms., Dr.,)... I have code in the after update event of the option group to
populate a combo box with the selection from the option group. If I click Mr.
in the option group, Mr. appears in the combo box BUT ...

Why is it that if i try to search for a mumber in a table on Access a box
pops up with "The Pattern String Is Invalid??

I have an option group with four option buttons for "Titles," (Mr., Mrs.,
Ms., Dr.,)... I have code in the after update event of the option group to
populate a combo box with the selection from the option group. If I click Mr.
in the option group, Mr. appears in the combo box BUT ...

DEBIDO A QUE YAHOO A MEJORADO SUS SERVICIOS POR ESO MICROSOFT

I have a text field, why the properties are valid:
Required: No
Allow Zero Length: No
It seems conflict?

I was wondering if there is a way to have a button on my form, that
would wipe out the contents of the record all in one shot?
Something that would wipe out all the data entered manually into the
fields, or "said fields", as well as erasing the data from the

This possibly belongs in the programming area, but is a general question.
Am unclear as to where one locates guide info.  I may be in Access02, 03 or
07....and need to see reference info on say
DoCmd

In table T1, I have fields of which five are recognized as text data type,
which hold a date value.  On form F1, I have text boxes, of which five have a
input mask of short date, which save to the matching fields in T1.  In
testing of my save function, information saves correctly ...

My access book says that I should never include calculated fields in
my tables, so I deleted them.
Now I want to multiply a field by 2% and display the results.  How can
I do this?