http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/a
donetprogmsdn.asp
The Design of ADO
To better understand the model and design of ADO.NET, it is helpful to
review some of the core aspects of ADO.

I am at best a part time developer of Access databases. I use Access
2.0, as this is all my employer has on its computers. Even so, to use
this ancient version requires a fairly convoluted installation
procedure on each PC on which it is used. I am self-taught from the

I am attempting to learn to use pivot tables.
I have noticed that if I have used the Lookup Wizard when creating my
tables so allow the user to select from a list of choices when entering
data, this causes a problem with the pivot tables.

Good evening,
One more and I'm done - I promise.  I have 3 variables - (hours,
minutes, and am or pm - 1 and 2, respectively).  Is there some way that
I can combine these 3 into a single variable that displays the time in

Is it possible to change the record source query of a report at runtime via
code so the report can work with different data source queries?
Thanks
Regards

I've copied a form that has a number of subforms each contained in a page
within a tab control.
The name of the forms are different but i'm reusing the code.  I have to
make sure that I adjust all references to make this work.

I would like to 'grab' certain directory trees and then store them in a
table.
At the moment, I writing my own VBA to do this but I cannot help
thinking that there must already be something (i.e. plug-ins or snippet

Before going further, I should mention that I have found a
workaround for this problem. However, I thought it was
sufficiently interesting to try to find out what is causing it.
I have a form which launches when the application is started.

If I choose a command button on a form in design view,
open the properties box and click the Picture property
and its wiz button, I'm presented with a lengthy list of
pictures. Everything from Add Table, Address Book,

I want to fill in data in the fields and the first caracter is now
automatic capitalized, however, I do not want this as abbiviations must
be fully in capitals. How to get it?
Bart

I have two linked tables. One with several million records that include
"price paid". The second with price increments like "Between 1 and
100,000" and "Between 100001 and 200000" etc. Is there some way to link
them so that I can sum and count by increment?

Hello NG
I want to select data from another DB, and use this data in currentDB.
I have this SQL in a VBA procedure:
Sql = "SELECT * FROM Firma [MS Access;Database=" & strPath & strFileName &

I have two tables in a 1:M relationship- the parent has 5 fields in the
primary key and the child 6 (these are actually pretty far downstream in
a complicated ER model, but the problem is between these two).  I set up
the relationship with no problem- referential integrity and ...

This is something I've not bothered to learn about but I see it in Append
queries everywhere e.g
TID: [forms]![frm_Input]![id]
What precisely does this refer to?

I would like to setup MS Access to use with my maintenance business and
am trying to figure out the best way to do it.
I have a customer list that stays pretty consistent.  Each month I send
out an invoice to each customer for the previous months work which might