[I have cross-posted this to m.p.a.gettingstarted and m.p.a.queries]
I have an application that I believe is very analogous to the Northwind
example DB (or any sales order db).  The short version of what I am doing
is:

I have an Access 2000 database that contains only tables (no forms, reports,
code, etc.)  When I try to convert it to the prior version, I get "Record
Size too Large."  There is no other information telling me which table, and
even if I knew the table, I wouldn't know what the size ...

I have a number of pictures on cd's but I would like to
have a system where I could go in and look for a picture
from all my cd's. Fox example if I am looking for a
picture of my dod jim, I know that I have about 8 or 9

I have 2  date fields: dateIn & dateOut.
Can some one please show me how to get the total of "Work Days" (not including Sat. nor Sun.) to do so?

I want to step into VBA world to be a little bit more proficient with my Access skills but I do not seem to find a campus class that teaches straight VBA, I know there is many books to teach yourself VBA, SQL etc. but it would still be nice to attend a community college class, ...

I have been assigned a project to create a very large db.
in access. It has 52 columns and is giving me error
messages already that I have exceeded the # of columns
allowed in a table.  I can't find an answer on the number

I am trying to create a Status Database, you know for weekly statuses of  projects, I am trying to create a form that would show current and previous weeks info (status), I have a couple of pulldown menus to show the person and another one for the project (for current week). My ...

How do I ensure that a particular field has [percentage] a formatting rule ?
I can do this in Excel quite easily in 'Format'
Hope you can help
Thank you

I want a Invoice Statement system for Horses that have percentage for each
owner. I can email my excel system billing to change to  Access
Thanks in advance.........Bob Vance
Thanks in advance.........Bob Vance

I'm creating a form, and I would like to have different
command buttons on each tab in a tab control, but when I
try, it puts the button on each individual tab in the tab
control.

I have a form with multiple pages.  One [pgWitness], I have a subform called
[fsubSurveyors].  Within the subform there is a combo box drop down
containing a list of names.  What I want the drop down to do is only show
the names that are related to a  field [Region] on the first ...

When I set up some macros in a spreadsheet I used the options section and set
the right click mouse button to add the macros.  Now I have the macros listed
3 times.   Anytime I open a new spreadsheet the right mouse click displays
the macros 3 times. How do I clear the macros ...

I have developed an Access 2000 db on my Dell 2.5 gh with XP.  This database
works great on computers with XP or Windows 2000.  The database is very
buggy  on some 98 operating systems  (Pentium 2, 350 mhz). even though they
also have access 2000 installed.  I am getting error ...

I am printing a series of 45 sequential reports using a
macro to open and print.  However, some Reports do not
print.  It seems like it is random as to which ones print
and which do not. Any suggestions?

I have a report that is based off a crosstab query. In
the ct query I sum the field "balance" and this field is
printed in the detail section of the report.
I want to limit the records that print on the report to