In reading some of the posts on this group, it appears as though it is
not strait forward at all to filter a form, which has subforms, by
criteria which are either on subforms or span more than one
subform.....

I have a multi-select listbox, that can have duplicate items (i.e
samples numbers that are analyzed in duplicate - the sample IDs are not
the same, but these IDs are hidden from the user).
I want to loop through the items on the listbox, but only use unique

Anybody know why I might be getting error #2109 during the
procedure below? It does not occur on 2 desktops, but did
on a laptop. The error said:
"The following unexpected error occurred in Sub OwnerZip_AfterUpdate,

Hello sirs,
I have an ASP.NET application that I am planning to release under the
GPL license, free and open-source. Am I allowed to use and distribute
JET databases with this application? I am using OleDB to manipulate

I have an Access database that has a few huge tables.  It was taking
about 20 minutes per table to import them from another application.  I
used the upsize wizard to put them in a SQL server database.  I created
a DTS package to import the files and it runs in less than 5 minutes.

Hey. Normally I play with something until I get it, but this form
needs to be finished by tomorrow. Here's what I'm trying to do (form
is in datasheet view):
1) Hide a field and assign it a value from a control file when a

Is it possible to launch a functional Access 2000 db switchboard by clicking
on
a desktop icon? I have searched the Microsoft Knowlege Base but, apparently
I'm not

I have 3 tables: tPart, tMachine and a table linking these 2:
tMachinePart
tPart: ID, ... partcolumns
tMachinePart: machineid, partid

MSAccess linking to Oracle 8 tables with Microsoft ODBC for Oracle
driver
I need to change the email address of all users because our domain has
changed. Is there a way to do this with SQL and not an Edit Replace

In the VBA toolbar under Tools*Macros I see a dozen or so of my subs
listed as macros, which I didn't create as macros but had entered into
standard modules. I copy the code, delete the macro, but as soon as I
paste the code back into the module, the macro reappears. If I change

I have a continuous form which has two combo box contols on in "Lot"
and "Raw".
The Row Source property of "Lot" is a Select statement based on "Raw".
SELECT [COA Data].lot FROM [COA Data] WHERE ((([COA

I've been trying the PDF & Mail Class Library from ACG Soft
in combination with Northwind-2k3 style of db. Can someone help
me with the error which is popping up: (which I cant get solved..)
I'm trying to send a report in PDF-format with a unique QuotationID to

I have a subform in a form in an ADP that I am creating "form-by-form" based
on an equivalent MDB front-end db.
(I'm converting from a front-end/back-end mdb structure to an AccessXP ADP +
SQL2000DE. It's amazing the number of gotchas I'm coming across in the

Is there an SQL command that allows control properties on fields to be
changed?
I'm specifically using RunSQL in a macro to try to do this.
Thanks

I have 2 global constants declared in the same global module:
Global Const MY_VERSION$ = "1.04"
Global Const ProjectName$ = "MyProj"
I have 2 global procedures designed to return the