I have set up a little database of 1000 or so records. It is just a library
that shows me the book cover each time I click through the records. This
will not be the final version of what I am doing but I would like to try it
this way. I am using Access 2000.

I have a data element in a table named Results.  This is defined as a number
field.  The Values go from 0 to 11.  
The problem is I need to count a certain value but sometimes that value has
not been chosen and that, of course, returns nothing.  I would like it to

I've been told that my new goals for 2008 will be to learn access. Why
my company would want the director of credit and risk management to
learn it is beyond me.  Any suggested reading will be appreciated.
Thank you

I have a command button on my form I use to look at the "Datasheet view"  
after closing the datasheet it doesn't return back to the form it returns me
to the switchboard.
Private Sub Command23_Click()

Is there a way to make a report that prints the values of a form's listbox.
I tried making a report in design view to accomplish this. I inserted a
listbox in the report and made it bound to the form's listbox, but the report
only prints a limited amount of items on the list ...

Sometimes when I try to open special folders my computer sais  unknown
program select program to open with or find it on the web but it never
works.What can I do to stop this?

I am trying to use a contact template but I need to add a field.

I have an XP machine (all updates installed) with both Office 2003 and
Office 2007 installed.  2003 was installed first and has been running
fine for years.  I have two issues
Whenever I start 2003 (after 2007 has been used) and vice versa, I get

Access neophyte. Have access database with following characteristeics
1. Main record (publication)
2. subrecord (source)-multiple for each main record.
required result:

I have a table ("tblProject_DataSet") with 3 columns. I am wondering how to
allow the user to only select one of the three possible datasets.
Column 1: "DataSet" - number - 1, 2, 3
Column 2: "AreaName" - text - Area A, Area B, Area C

I recently created a database that my office uses for tracking projects.  The
problem that I have been having is trying to create a append query that will
allow me to transfer data from the main table and subdatasheet to another
table with a similiar subdatasheet.  The object of ...

I have an issue where I had installed Office 2007 on my new Vista machine
and due to the great new feature (NOT!) of Access 2007 caching linked tables
when the db was opened, I had to "downgrade" to Access 2003.  Every since I
downgraded to Access 2003 one of my databases comes ...

I have a form "New Jobs" with a subform "NewJobsSubform", the container for
the subform is named "NJSubform".
On the form I have 10 controls in total the final two being
"txtDateOrdered" - bound to "DateOrdered", and "txtDateRequired" - bound to

Hi , I am from slovakia and I am new here-I looking for same chat room or
forum in english,cause I want to improve my "write" in english.Can u give me
same www,pls-thanks very much and hapy new year...

I am trying to set up a simple time clock.  I want to have the employee enter
their ID and then click on a button "TimeIn" and have it record the time in
in the table.  I want them to be able to do the same for clocking in and out
for a break and then clocking out for the day ...