I am trying to find out how I can restrict users to only being able to
read/edit records which they have entered.
Apparently I need to "limit the recordset for the form to those where the
User ID is equal to the current user". Can anyone tell me exactly how to do

I have a database of names and addresses and I only want the Title field to
appear on the data input form if there is a value in the Lastname field for
that record. I have been trying out a few variations based on:
Private Sub Form_AfterUpdate()

As our Ministry database gets bigger I need to find a way to story
variables or parameters so that rather than change 15 forms and
reports I could change one variiable possibly stored in a table and
change the whole database at once by changing that value... for

Help please
I am trying to put together an if statement to run a
proper case module and also to to transfer
the contents of a field to another subject to the field

I don't know SQL and I have searched high and low through Help, but
can't figure this out...
I have a table that uses a Notes subform in which the users hav
entered many notes, each with the date the note was entered.  I want t

I need advice on working with Access 2000.
I've got a database of  house repair records stating the cost of each
repair.  Am going nuts trying to figure how to add all the records of this
one cost-field to got a total sum of repairs.  Can anyone help?

Hi, I am setting up a database of exam questions in
Access 2000.  The exams cover different topics and come
from a number of different contributors.  I have set up
the following tables:  

Is it possible to have the dialogue box that pops up to
get a parameter, formatted as a combo box that users can
select a value from.
I have a button on a form which opens a preview of a

I have access 2000 and am able to open dbase files but cant save them as
Access tables. Can anyone help? thank you

The following code returns multiple records to the
recordset. How do I update each record in the recordset
with the value of lngNext?
Set MyDb = CurrentDb

I currently have a database on Excel, the problem is that
it is a spreadsheet on a network and that not more than
one user can access it at a time. They end up in a read
write file. If I purchase access will I be able to have

I have a table for all of the Events I have to work and what equipment
I need at them. I then have a subevent table if there are multiple
shows at the same location during the same trip.   I am then running a
report to determine all of the events that need a specific piece of

Using WindowsXP, can I uninstall Access 2003, then install Access97 without problems?  Thanks.

I have what I hope is a pretty simple problem. I am
building a simple database for a social services agency
and it consists of two tables. TblCustomer has basic
demographic information about our customers and

I have the following piece of code trying to pass 3
parameters to a query but get the error message 'Object
Variable or With Block variable not set' on the set qdf.
Any ideas on what the problem is?