I am currently formatting receipts. I want to be able to put the dollar
amount in both as numeral and words. Is there anyway to automate this so that
$100 will generate One Hundred in a query or in the report itself? I do not
know how to code but have some experience using Access ...

When I run a report in my 2007 application the navigation pane appears, and
the report is enclosed in a tabbed screen.  The ribbon is then in print
preview mode.  If the end user clicks on the navigation pane close button
manually it does close, but the ribbon then goes to ...

I interviewed with a company that was using an Access Form and for each job
in my history I was entering the info on a new page of the form, also other
information was stored on different pages.
I am at a new job now, building a database that contains the following

I am a complete rookie when it comes to Access but I have managed to create a
database with 2.2 million entries.  I would like to design a form using the
Symbol for the company [enter symbol:], the Date, and the Low Rate Price
[enter low rate:]. The problem I am encountering is ...

I am new to Access database coding. I finished my first database (on Office
2003) and wanted to give it to my company's employees. It is a survey with
one form calling the survey (another form). What I am looking for is to have
the form open without having the all database ...

I am totally lost.  I have a query titled "Service Record Query" with a
calculated field - ServiceTime: DateDiff ("w",[DateIn],[DateOut]).  The
calculations work correctly in the query.  I have a form titled "Employees"
with a subform titled "Service Record".  One of the fields ...

I am attempting to create a form in access 2007. I have a combo box that I
enter data in then when I click refresh it automaticly fills in my list box.
However when I try to print I get a box showing up around my list box. How do
I hide the box around my List information so it ...

A long integer field is bounded by an associated check box.  Let's say
the integer field is named ID and the checkbox is named CB1.
Currently, when CB is checked, the value of -1 is assigned to ID.
I'm trying to use this current (Default?) value of -1 in an equation

I have a form which is divided into sections where each background is a box.
This makes it easier to manage the info for the user.  However there are
some functions I have placed on one of the boxed areas that I don't want all
users to see.  I am looking for a setting that will ...

Does anyone know what is wrong with the following code:
I'm trying to use this to pull an e-mail address from a table based on the
dealer and then e-mail a report to that e-mail using the Win2pdf mail helper
program.  Everything seems to work fine except the DLookup....

I have several databases that were created in Access 2003 and earlier.  
Several have forms where the main form is one record and the subform has
several records.  For instance, the header record would have a trip number,
truck number and driver.  The subform would have all the ...

I have a form which I have locked for edits (in properties) to avoid
accidental changes to data, and have place a command button on it to
allow edits.
There is a subform on this form which previously allowed users to add

How to set fields in a form to be mandatory

My database records details of a site on which affordable housing is built.
It has a table for the site, the affordable bit of that site, the houses and
the funding for these houses. I am working with about 4 or 5 main tables in
all.

I have an ACC2003 db and have notice display issues for users of ACC2007 due
to themes.
I have in my code at start up:
Application.SetOption "Themed Form Controls", False