I have a "customerEntry" form where I have a drop down list to choose either
Residential or Comercial.  This entry determines which report to print. I
have 2 reports "CProposal" and "RProposal"  that are formatted differently.  
I currently use two different comands buttons to ...

his is not really an Access question but I can't find any Windows newsgroups
in MSDN. Its related to Access in that I need to read in a table of file
paths and load them to another Access table. The problem is I need to get the
results of a Windows 2000 file search ("Name" and ...

I have a Query that I want to run.  I want it to show Dates older than
20 Days from Today.  The field that has the dates in it is SalesDate.
I tried putting this is the criretia section of the Query but this did
not work.

I have been told I need to use the file scripting object...
What I need to do is to read a table containing a list of file paths to
other Access databases.
Then for each, I need to access and save in a table all of the details you

Can someone point me in the direction of a web site or news group that might
contain usefull information for someone who has several Access97 projects
that are growing beyong their capacity and need to be converted to SQL or
some version of Access beyond 97 that might improve the ...

My computer suddenly shows a blue screen. I can read this error on the
screen and some advices like: check vor viruses, remove newly hard drives
and controllers, run CHKDSK /F.
I restart the computer, it boots and after that it shows the same blue

Hello, I have read via the "ten commandments" of database building that I
should not use look-up fields at the table level.  Before I learned of this a
number of months ago, I had completed a good part of a project I am working
on.

my computer only has regular internet explorer. and i need 5.0 to get a
toolbar i need

Anyone have a recommendation on good books that teach
about doing queries in Access?
Is seems there are about 10,000 books about Access, many of which
are fairly expensive.  Most have a chapter or two on queries and many

I have a database with 370,000 records in the current
table. I have a form based on the table. On the form I
have a combo box with a drop-down list. When I type in the
last name in the combo box, the drop-down list should show

I need to save the PIVOT CHART view of a query to be emailed or inserted in
presentations but when I try to save it I only get the datasheet, not the
chart.

I am new to the Access communty, sorry.  I am trying to rebuild or just
repair a database for my unit.  But the problem that im getting is that all
of a sudden some of the records that I hold in this database is becoming
corrupt.  I dont understand why and it wont let me edit, ...

is there some type of product like sourcesafe for MSAccess

My database has reached the size limitations but when I go to compact it
gives me a message saying "Invalid Arguements". What is going on and how do I
fix it. Thanks.

How can I combine fields in a report?
For example, if a date has been entered in three separate fields for Year,
Month and Day, and I want to print it in a report in the form of YYYY-MM-DD,
how do I create the combined field?