I'm new to Access.  But I've been ooping for about twelve or thirteen
years in another language.
I've got a form with two instances of the same sub-form.  It works
quite well, or at least it will, when I find out how the source form

I've written quite a few user-defined functions in vba in MS Access I was
just wondering:  Is there any way to write a user-defined aggregate
function, like Access's Count, Min and Max functions that you use in your
queries?

I am using a combo box to search and return a specific recordset.
The function works fine when I just designed it using the wizard. I
type the first few letters of a client's name, and the autofill fills
in the rest and I can enter to see the given recordset.

I have the following data to query.  I do not how to get the output
(below) in a single query statement in Access '02.  No problem in
using separately 3 queries.  Can anyone help here?
 Thanks in advance.

What should be a very simple function is going terribly wrong, and I
don't know why. StartTime and EndTime are table values (formatted like
"01:00A" or "02:00P"); DaypartStart and DaypartEnd are string values I
specify when calling the function (initially tried passing time values

I use hyperlinks in a subform datasheet to display locally saved documents
that are associated with individual database entries.  A customer entry may
have a list of invoices in pdf format, for example:
invoice23.pdf

I have a database with a Master table and a Budget table.
The Master table has all the data including these 4 fields (Enccredit,
Encdebit, Credit and Debit) and related to the Budget table.
The Budget table has the 3 fields namely:

The person responsible for installing software at work believes in
installing the bare minimum., which does not include the option to
split a data base into a front and back end.
So, rather than "beg" will any CD work to install more features. Or,

Does anyone know if it is possible with Access 2000 to
create relationships between tables using code?
Thanks
G.Gerard

I need to scan a couple of hundred databases in several directories to
locate all code that uses a particular function, but cannot figure out
how to read the Form or Module text itself.
I am able to locate, then connect to the databases, and have figured

"[database name] has detected corruption in this file.  To try to repair the
corruption, first make a backup copy of the file.  Then, on the Tools menu,
point to Database Utilities and click Compact and Repair database.  If you
are currently trying to repair this corruption then you ...

Alright this is a new one to me.  I have linked a table using ODBC to
our AS400.  When I either open it directly or query it I get the
incorrect values for several fields.  For example the query on the
linked table returns these 5 records...

I need to establish user-level security for an application that will be
deployed at unrelated client sites.  Is it recommended (best/easiest) to
create the workgroup file, add the users, set the permissions etc. on the
developer machine then install on the client network (with ...

i hope this information will be useful for all who want to extend
possibilies of user's interface:
New freeware and shareware components are presented on:
www.vmgroupsoft.com

Let me start this out by saying that I don't know much about sql
statements.  I hae a microsoft access database which has a default
value for CustomerNumber.  This default value is a 4 digit random
number.  The way i have it set up currently is