Is there a way to "read" (put into a string variable) the name or
caption of open windows within an open Access database?  I know that I
could use  IsLoaded and go through all the forms, queries etc to see
whqt's open, but is there a quicker way?  in excel, word etc. they have

Is there a way to trap an internet 404 msg (page not found) in access?

Thanks for giving me this opportunity to seek for a help.
I have a table in my access project called users that contains UserID,
username, and TypeID. I create an unbound form with three test field
(txtUsername, txtPassward and txtTypeid) and two control OK and Cancel

I have a two-dimensional array that I redim in my code:
   ReDim arRecs(FCnt, 8)
This gives me 8 data elements for every Farm (FCnt).  There are many
different types of data in this array; I'm having trouble with the string

I am trying to build a query that will return the usernames that are not in a
specific list.   The list is not coming from the same database so I need a
way to compare something like a comma delimited list to a query.
Is there a way to do this sql side?

How can I send a report from Access 2002 to a fax recipient? (using VBA)

is it possible to open and read txt files in vba? the files im reading arent
to be used as imports for tables, they just contain text that i need to
search.
thanks for any help

I have a table of customers who may have purchased numerous types of
products. Finding out who purchased what is easy. However, what I need
to determine is which customer has purchased ONLY one or two
particular products and NOTHING else.

I have the OFFICE11 object library checked in the references but still am not
able to use  common dialog box objects.  
Below are all the references my applicatio is using:
VBA: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL

I have been having a problem with MS Access over the last several days.  One
of the associated dll files is not working properly.  An error is encountered
with existing code.  To correct the error I reselect the reference(dll) for
Microsoft DAO 3.51 Object library and the ...

 I am creating a database analyzer that creates specific documentation on
the contents of a database for a report I created.  I have all the required
information for tables/queries/reports/forms/modules but now i need to
extract all pertinent information from macros.  Can this ...

I'm making a small database for an investment company. What they would like
is that at the end of the month, they press a button and a statement would be
emailed to each investor in their database.
I understand this would need to be done through outlook. What I am looking

I've asked this in a previous thread but wanted to open it up to the whole
community.
I have a procedure that calls several other procedures. Each of the called
prcedure contain the following:

Anybody have a quick solution to locate a folder (not a file) with only part
of the folder name? Actual folder name could be "2206516_BlahBlahBLah"
however the "BlahBlahBlah" portion is an unknown...
__________________________________________________________________

I need help to shorten the worktime here.
I have a form that has a subform in it.
The main form contains the shipment-ID
In the subform there are several ordernumbers that comes in the shipment.