I'm trying my hardest to learn VBA but have run into a problem which
hopefully someone can guide me with.
Basically what I am trying to achieve is to get the database to check the
users Outlook Inbox every hour for the existence of a mail from a certain

I want a combox to requery each time it is being changed.
What i am trying to do is have the combo box filter to the text being
entered.
The combo1 rowsource is:

I want to link products and contacts, products and axctivities and
activities and contacts. I am using one to many links with full
referential integrity. Each table is linked to a table that defines the
possible relationship between either 2 tables.

How do I delete a hidden file in VBA?  The normal kill function is failing
with hidden files.  Is there a way to 'unhide' them first?
dixie

Been irritating me since day one....but I never bothered to track it down.
Does anybody know how to make MS Access 2003 always drop full menus instead of
making the user click the ">>" every time?

I am a form which has a sub form,
The sub form is linked with primary key of main form as a foriegn key
in sub form, very basic,
In the main form, I have another field which is investor, and in the

I am looking for a control that would look like a timeline (12 hours)
which would allow the user to click at a particular location on the
timeline, then allow characteristics to be associated with that point.
Free or For Profit either one.

I want to scan documents and then store them in an Access database.
What file type would I want to scan the document as?  Would I want to
store the document file in the database or a path to the scanned
document file?

I have a textbox for storing the URL to a web page.  I figured the
person could simply copy the URL from IE and paste it into the text box.
 The client would like to have a more automated process.
We came upon one "glitch".  We pasted the URL into the Access text box

I have the OrderNo set as the following
Right(Format(Date(),"yyyy"),1) & Format(Date(),"mm") &
"-"Format([OrderNo],"000")+1
This works great until

I am looking at installing an Access 2003 application on some machines
that don't have any version of Access previously installed.  After
reading lots of posts on this group and elsewhere I assume that I need
to purchase "Visual Studio Tools For Office 2003" which will give me

I am working with Access 2003. When I click on the drop down list tool.
Access crashes. Get the error message that "the constant you entered is
not valid". No matter what db I work with, no matter if the form is
blank or not. I have searched in vain MS and google. Reinstalled Office

I have a problem of number and text field.
I got the database file(mdb) that contains many combo boxes used and
its list values are created by "value list"
For eg field

i have 2 queries totaldues and totalPayments
totaldues has 2 fileds(custID (Group By)
amountDue(sum of all invoices dues)
and totalPayments consist of CustID(Group By) and  Amount_Paid(sum of

Im trying to write a query which takes part of the string for example:
peter_Poland
michael_Germany
I wish to get output: