I tried to create user security level in access 2003.
for some reason, one of our administrator cannot access
reports in database. Everyone else on the network can
access them.

Hey guys,
Here is a question for anyone who may be able to shed light on this.
Is there a way to count specifically on certain values, but
incorporating a wildcard at the same time? Here is an example:

I have a field:
tblPKCGPhysicalAttributes.Style
Style is a combo box that queries:
tblPKCGStyles.txtCodeID.CorrugatedStyles

I'm making revisions to an access project on a computer
that does not have a printer installed. It seems that a
printer is required to preview or design a report.
Is there a way to make Access work without a printer

If you have a text box in a report, can you use an "if"
statement in "do while" loop to look at the record source
for a certain character and if the character is found
change the format for only that character to BOLD?

Is there any reason why this formula wouldn't work?
=(nz([sumw])+([sumo])+([sumf])+([sumh]))
It works for all values of sumw, sumo, sumf, but not for sumh.  
sumw is the sum of all records in a table where a field = w

Is there a way to set the ,acPreview , to open in "Fit"
mode?

The page breaks or force new page propeties do not work once I view from my
main report, is there a way to get them to work?

How do I write code so that the color of a group is
selected by the items inside that group. Ex: Group name is
Process. This group has 4 items and each item is either
Red, Yellow, or Green.  I need the Group name to change

i am using access 2000......i am trying to make a label
not for mailing but as means of getting information onto
a sheet of paper for a quilt show....problem is that in
the label wizard not all the data fields are listed (a

I have designed a two subreports using crosstab query as
record source. the crosstab query is based on a union
query. Problem is if i open subreports its opening fine.
when i open main report where both or any one of the

anybody tell me
what is non-fixed-column crosstab query?

this might be really easy but i can't figure it out...
i want to produce a sort of summary report from a table, so that if a field
on the table contains information, then in the report a check box relating to
that field will be ticked.  and if there is no information in that field ...

Let me start by saying thanks for all the info I've
gotten from the newsgroups. You all are first rate. This
is actually the first time I've had to post a question,
as I can usually search out the answer.

I just built a report and it access only 44 records. However, it opens and
displays 3,225. This is very strange. I cycled through the first 44 records
and then to my surprise the report came back to the first record again. The
report is cycling through all 44 records.