I am creating reports using the following format.
Private Sub Btn_Produce_Report_Byt_Click()
   On Error Resume Next
   Dim dbs As DAO.Database

I am new to access.
I created a report from a table using the wizard.
When I view the report, I only want to see one given record at a time - not
all records.

I have a result that I need to rounded to the nearest 1/2 dollar....any
thoughts

Is there a way to cross calculate a different fields from 3 subrpt in a Main
Report.
Example: rptMainClient:  Contains 3 sub reports.
subrptRufugee

Hi, I have a report in Access 2000. In a Control source of a text box I
have: =Trim(replace(UCase([LIST5]),"PER BOX","")).
Access does not recognize the replace function. Am I missing a reference
here? How do I fix this? LIST5 is my actual field and I want to remove

I have created a database in Access 2007
I am using the runtime for Access 2007 to use my Access 2007 application.
The EXPORT TO WORD function works on the non-runtime version.
When running the database from the runtime version - the following error

I keep track of people's vacation days, my manager wants to see the entire
year on one page, in the form of a calendar, that can be printed out by
individual. She wants it to look like an annual calendar. How would I be able
to format this report?

I have the following equation in the control source of a text box in a
report.  
=IIf(([Suffix]<>[CFR IAD Key Metrics].[Report]![Suffix]),"No Match","Match")
If the response is "No Match" I would like the font to be bold and red.  

I am building a database of the inventory in a store. My database is working
splendidly but then the manager's said to add a thumbnail of all the items to
their corresponding record. I thought that by simply adding an ole object
field would do the trick but apparently when I look ...

I have a report that has a Start date and an End date text box in the header
which have their data coming from a parameter query. I need to display the
full date, ie. August 1, 2007, in each text box. There is also a Date label
on the left side of this line and a to label between ...

I set up a form which has a control to open another form.  The second form
has a control to open a report.  When the report opens, it remains behind
both forms.  Is there a way to open the report in the foreground without
closing either form ?

Hello, I've looked at other questions and answers but have had no luck. In my
query I have "Between [Enter start date] And [Enter end date]" and I would
like my report header to display the entry in the criteria section. I've
inserted an unbound box and had no luck. I had ...

I want to create a running sum in a chart to show the cumulative effect over
time.  
For example
1990  10  10

i would like to display a field in the header, but since it can often have
multiple values i would like to display it across instead of down to save
room.  i figured out a way when printing only 1 report (using a counter and a
crosstab) but it does not work when printing this ...

I have a form where I change the Back color of different fields to Yellow or
Red.  An I was woundering how to get the same field in the report to change
at the same time.  I.e. "Last Name" in the Form highlighted in what ever
color and the "last Name" in the report change ...