I've got to create a dbase using 2000, it will be an inventory of fibre
types.  A list of different fibre types, by manufacturer and several other
characteristics of that fibre.
Can someone let me know if there is a template I can download (and just

I have a select query where I am doing a left-join with two other tables, but
the query output is almost double the number of records in the table I am
querying.
Does anyone know what could be happening?

I have a main form with two sub forms within the Main.  When I press a
button in the main form I would like it to also press a button in the sub
forms.  How to I call the sub form button to execute from within the Main
form?

I have used access for a few years, and have been contemplating looking into
SQL, i see a lot about it on the boards, but don't really know what it is
and how to go about even learning it!
Are there any books you can recommnend? Websites?

a usually perfectly working Access 2003 application copied to a VISTA (Ult)
running notebook bombs at any attempt to open/edit an event procedure... the
screen turns a misty grey and a feeling of utter doom and desperation
permeates the air... followed by some cryptic debugger ...

I have a database of all products in a continuous form, and each time i
select a record, the image of the selected product is shown on the form
header.
For that prupose I placed the following code In the OnCurrent event:

I have found something I find strange in Access 2002. If I use the function
"sum" in a query then Access shows balances in the output (in my sample it
was a balance on the ninth decimal) even if the data Access has made the sum
on is zero!

I have a combobox with 5 columns.  The first field is a company name, the
second the street address, etc.  Some company names have multiple addresses -
when I select the second occurrence of the company name and exit the
combobox, I programmatically fill the address information.  ...

have to type the address in map quest again.
Thanks for anyone who could help me with this problem that I have.

I would like to open Map Quest from my records Form and have the Postal Code
automatically inserted in  Map Quest  so I can then click on street view and
have the map show the location with surrounding streets. Then I could print
off the Map.

Not sure where this goes, can't find a topic to fit.  Anyways, here we go...
I want to change the write-protection of files from read-only to NOT read
only so that I can change the names whatever I want…I'm reorganizing my
files.  However, no matter what I do, I can't get the ...

I have a database with approx. 10,000 records. I am constantly adding and
deleting records. When I am in form view and have a record showing, I can
delete the record by clicking on the delete button on the toolbar. Instead of
deleting the record completely, I would like to append ...

I know this should be easy but for some reason I can't figure this out.
I need 2 buttons on a form that will filter the data.  One button will show
all records that are "active" (or contain a "1" in the active field.
The other button should show all records that have something in ...

Hiya folks!
Heres the problem:
I have three tables.  The first table is related to second table (one-
to-many) and the second table is related to the third table (one-to-

I am an absolute beginner to Access and I am having trouble saving my info
that I have entered via a Form.
I want to construct a very basic DB just to get the basics sorted out and I
built one for entering the cost of items purchased.  There are three basic