Hello!  Here is my issue:
I have a list of child care providers, their contact information, and stats
in a table called tblproviders.  I have clients request in another table.
I want to match up clients with providers that meet their criteria and to

Hoping somebody can help me here with what is probably a fairly easy
question. I have decided to create a database for a load of stock which
I have to manage in my office as opposed to using a great big unwieldy
spreadsheet. I had hoped that I could use forms to add and remove stock

Dear reader,
Is there somebody who can tell me the VBA code for the following action?
To import data from an Excel sheet by referring to a cell name in the Excel
sheet.

Scenary:
a main form contains two sub-form unbounded.
Sub-form "one" contains a list of products.
Sub-form "two" contains the items of the selected product.

OK, calculating the mean from a set of numbers is easy.
Anyone have formula for calculating the median?
Ok, ok, I didn't do well at maths! :-(

Remember seeing a post a while back from someone who wanted to add to a
table only if the data didn't already exist.
Someone suggested a type of query called an "Up" something or other. Can't
remember - could someone refresh my memory on this please?

I just reinstalled Access 2000 on Windows 2000 after receiving an error on
open (occurred with any database):
[db1.mdb is just an example]
Can't find the file "C:\path\to\db1.mdb" (or one or more of its components).

I am trying to use the DoCmd.TransferText method to export an access table
to
a Tab Delimited Text File.  I have put the code behind the onclick event of
a button

Love this site, have gotten a lot from it.  This is my first time
posting though, so forgive me for any errors.
I have an Access 2000 db where I have a main form of Contractors and on
the main form is a subform of bonds carried by those contractors.  I am

When I open an Access form I can have no recordset specified, then in
the form's OnOpen event I can do something like:
Me.paramaters = "@SomeColumn = 22)"
Me.recordsource = "dbo.sproc123"

I was trying to improve the performance of a database i use for
analysing data from our finance system. I added some index's to some
fields i sort or filter on in the underlying tables. I also made a
couple of other changes to the database (added and deleted queries,

Dim Toevoegvariabele As Integer
Toevoegvariabele = DMax("[Paragraafnr]", "tblParagraaf")
If Me.chkDesignAnders = True Then
   DoCmd.RunSQL "INSERT INTO tblParagraaf (Paragraafnaam,

INSERT INTO ECN_1 (Old_SbPartNo, Old_PartDesc, Old_ManPartNo,
Old_Manuf, Old_Vendor, Old_RefDesi, Old_Qty,
New_SbPartNo, New_PartDesc, New_ManPartNo,New_Manuf, New_Vendor,
New_RefDesi, New_Qty)

To prevent data corruption I have replaced a memo field on my form with
an unbound control on my form that I populate with a function that
fills it from a memo field from my table. When the form is closed,
another function in a query writes it to the memo field. No trouble.

I have a stored procedure as a recordsource for a form, taking a
parameter from another form, it displays records that are already
present without any problems.  I had to add a resync command to allow
edits, but it works ok for now.