im having trouble understanding how to perform sql statements in
workign past papers.
can anyone help me with tackling these questions
all female students who do not live within 10km of Bristol university

I have a field in a subform called Status. When I select statusId 3 I want to
automatically have Access enter todays date in the Due Date field. I am
trying the below code but do not understand what the error message is telling
me to do.

docmd.runcomand acCmdSaveRecord and acCmdDeleteRecord are producing error
code 2046 and I cannot determine why.  I have tried saving the record with:
If me.dirty then
 me.dirty = false

I created a switchboard form and another form both of which have command
buttons to run a query and opening in form view. The query comes from 2
different tables. When I run the query from the query design view window,
everything is fine and I get the results in datasheet view. ...

I am having some trouble opening multiple instances of forms.  I use the
following code to open a form.  I am using the NewTaskForm (which is taken
directly from the Access Developers Handbook 97), to create new instances
of forms.  I use the same form in different ways (add, veiw, ...

Currently, I have a main switchboard which contains buttons corresponding to
the different departments of the company I work at - ie. Production, QA,
Engineering.  When the buttons are pushed, the activities those departments
can perform open on a new "tier" or switchboard.  Some ...

I have a combo box on a form which finds records that are stored in a table.  
The look up value used by the combo box is a number stored as a DOUBLE in the
table.  The number can be between 6 and 10 numeric characters in length.  The
table contains about 75K records.

I need the code or any help to be able to get a combobox to run a query
based apon the value selected within the combobox, i also dont know how to
make the query variable and linked to the combobox so that i dont have to
produce loads of queries.

I have a main form that has a field called "InternalDeliverable".  I have a
subform that has two fields called Directory and FileName.  I have created a
new form called filelocation.  I want to combine Directory and FileName and
create a hyperlink to that file based on ...

I'm trying to use some code in the after update event on a combo box in a
form.  I'm trying to select "Reason Denied"(from 1 table) in a combo box and
based on that selection have it automatically populate "Statement for
Letter"(from another table.  I'm not very good with code so ...

I have a mdb in which i have made 3 difference menu bar, generally to test I
have set a particular menu bar, which I would like to change based on the
Windows LogOnID.
The three menu bar is as below :

I have a request from the boss to track the users movement on the A2003 app.  
I was thinking of using Allen Browne's audit trail since I've used before and
it works great.  But now, rather then tracking the controls and the info
going in or changing, it is the button activity ...

This should be simple but...
I have a form that is opened by a form by specifying the year = xxxx  (I
also tried year = xxxx or year is null, and various combinations of XOR)
The table data is:

I used  Albert Kallal's Multi Select example to create a continuous form that
uses checkboxes to select specific records in an animal management database.
(I work at a wildcat sanctuary)
So I incorporated Kallal's code into my form, but I am doing the opposite

Hi ALL,
I want to get data directly from the source which is running on pervasive
odbc client interface to feed into my db. I want to ensure that the file will
be a read only file. Do you know how I can do this? Basically i don't want