I have a text box on a form so user can write a password
I also have a button
here what I want
If the user put "123" and click the button, form "Employees" open

I'd like to save the 2000 db file format to a 2003 format to prevent having
to answer the security warning blocked expression etc questions when I
intially open the file.

    Tran date    Total Tran        Tran ID            Merch Name        Bank Name    Term ID   
    0710    22        247            EBS Center        El Nilein Indstrial Development Bank G    12345678   
    0711    63        262            EBS Center        El Nilein Indstrial Development Bank G    12345678   
    0714    5        538            Bank El Mozaree POS        El Nilein Indstrial ...

I was wondering if anyone knows how to use API call with access.  I would
like to be able to store who updated tables last with a their ID and a time
stamp.  Was wondering if anyone could help.
Thanks a lot,

Ok, So i'm not one who is prone to 'hissy fits' but I am at the point of
moving to Linux and Star Office just to stop M$ from fixing something that
aint broke.
So the problem, I used to be able to search the body of an email by just

I have a new Vista laptop and installed the Office 2003 Pro on the system.  I
am trying to create a database in Access and when I try to create a report
for the information I get a failure message.  If I don't use the wizard it
won't do anything.

when inserting new costumer in a data entry form, I want to check if
he already exist, and if so I need to fill the in the entry form as a
new record with all data in table related to that costumer.
Thanks in advance

I currently have a form that contains a combo box.  I use this combo box to
select certain criteria for a subform.  In the subform I have another combo
box, which I would like to be requeried based on the selection in the combo
box on the main form.  I have tried using the ...

hi all!  i made a table 'Routine Scheduling for maintenance', in which i have
following field
1) Routine card no (text)
2) Equipment name (text)

Does anyone have experience with an ActiveX Control to view PDF's on a form?  
Or can anyone make a suggestion as to how I might go about doing this?
Thanks in advance.
Bonnie

I have an Acc2003 security enabled database containing the names of
students who log in to book facilities. They are all members of a Group
called "Students" giving them certain restricted permissions.
Occasionally it is necessary to suspend a student from booking

I have several queries which are identical in structure and use the same
field names except for one field that uses an expression (the expression is
what makes the queries different).
How would I create another query that combines these queries back together

I am an novice in Access and would like to find out how i can solve this
issue of mine.
I have 2 fields, [CASH TAKEN] and [AMOUNT RECEIVED]
In [CASH TAKEN], there are 2 values,   YES,NO

tblRouter:routerName
tblUtilization:routerName, weekending date, utilization%
What I want to do is output to Excel the  fields:  routerName & the last 6
weeks utilization figures in columns.

tblRouter:routerName
tblUtilizationHistory:routerName, weekending date, utilization%
The match key is the routerName
What I want to do is create a flatfile output of the fields: routerName &