Suppose that I do not exist. I am a phantom that my prestigious
employer uses to post (sometimes outrageously) without risk to his
reputarion. But in one thread the phantom goes too far and makes posts
which could alienate a portion of the employer's clientele.

Using A2003.  I'm attempting to delete all queries in an mdb.  I was
experimenting with the following coding and discovered that it deletes
exactly half the queries each time it's run.  If I have 100 queries,
then it deletes 50 the first time it's run.  The next time, it deletes

Question
I'd like to know specifically how to select another window outside of
Access
(a web page) and paste cells from my database.

I have a small Task List / Project Management / Time Management app I'm
building for my own use.  Any "Getting Things Done" (GTD) users out
there?
I want a main form that has a large List Box on the right side of the

Example of dataset (only going to include 2 fields)
PolicyNumber                                 AppStatus
--------------------------------------------------------------
Z9999999                                       RECEIVED

I have a problem - some kind of theoretical problem.
What is the right call:
public function function_name (ByVal name1 as string) as string
or

I am working on an audits database.
The main table, Audits, has an AuditID primary key.
Another table, 1:1 relationship, ProgramAudits, has AuditID as a
foreign key.

I am developing a intra-company website. I am working in MS Visual
Studio .NET, and am writing the code in VBScript.
I have an MS Access database with which i want to connect. Once the
connection is established, i want to retreive a particular record and

I have a piece of code which resets all the control on a form  ..but if
I also put an option group on the form and the relevant code in the
routine to reset it I get an error message saying that you cant assign
a value to this object when the code reaches the line for the checkbox.

New article at:
   http://allenbrowne.com/AppRelReport.html
describes how to show information about the fields when you print the
Relationships Report in Access 2000 and later: the field type, size,

I have a form with a subform.  The form has a button which opens a
dialogbox.  I would like the dialog box to call a sub in the subform.
I know how I would do this in C++, but I can't seem to figure it out in
visual basic.

I'm new to this group and quite new to access/vba.
So, shortly after beginning to write a simple application for my wife,
I came across a blocking problem: I need to intercept the sql statement
that stay behind a current, but not yet saved query.

I have an application in service (A97) which is a booking system for a modelling agency.
When they add / edit a job I display a subform which lists all models, filtered according to criteria set by the user,
from which they can select the model(s) they want to add to the job.
The ...

Here's the situation--there is a text field in a form in which students
will key in data.  On the keypress event, I'd like for different sounds
to be played for each character typed, either randomly or in a loop (I
have a number of small, cool, computer-like sounds).  I can get one

I have this code to apply the filter on a form to a report.
In Access97 it worked fine  but when I converted it to Access2000 the
report shows all records in the table. What has happened?
this is the code: