I have a page that displays questions. The user enters their answer to the
questions and the data is written to the database.
I need to be able to hide certain questions based upon who is answering the
questions.

I am calling a function that calculates the difference in days based on
2 dates entered in a table. I am doing the call from a txtbox in the
form that displays the data. It correctly displays the results in the
textbox, but I want to have it update the [EstDuration] field in the

I have a listbox that is associated with a query. What I want to do is
select the record in the listbox, and transfer the contents of two fields
into two text boxes called txtSerialNumber and txtProductDescription. I am
having a hard time trying to figure out what record I am on ...

I've noticed when I set bookmards in the VB editor that they don't get saved.
Is there a way to save them?

Can anyone help me find out how to use code to find the computer's mac
address?
Thanks,
Beth

I am using Access 2002.  I need to calculate a ratio pertinent to each
record.  What event do I use to do this?  I tried this on the open event of
the form and the ratio field contains the same value for each record...I need
it calculated for each record on the form but am not ...

Due to data issues I don't have the energy to explain I had to create two
unique identifier fields (old data not consistant)....but I'd like to somehow
allow the user to enter search parameters into only one field and actually
search both.

I need to get the value of a text box on a form that is bound to a table. I
need to be able to pass this to another form. I don't know how to do this.

How can I if possible disable the scroll wheel on a mouse to prevent users
scrolling through records.
I have a form which display one preselected record, all records selctors are
disabled but the mouse still scrolls through the records.

i have a form use to edit two table that are linked by a field.
So the form recordsource is a query
Recently i modify the link between the two table
Now the link is made by two fields.

The attached is giving me fits. Is there any way to make this query
updateable and still do the some thing? I need to be able to view [Expr1]
because it validates a field in my table. If I don't show this field then it
works fine.

this code does not fail but the field is not set to false either. what am I
coding incorrectly?
CurrentDb.Execute "UPDATE p_Myfile SET FN#_met = False ", dbFailOnError

OK, since intellisense gives up after hitting "me.pivottable." in a code
window...
Can anybody tell me WHAT Object Type is returned there?
I know it is an (?abstracted/dumbed-down?) interface,

I have a persons table with an "AddressID" field which is a foreign key into
the "address" table.  The default addressid is Null.  When I want to list all
people + their addresses, an outer join works nicely.  However, even though
this outer join is an updateable recordset, I can ...

I thought I had this down but these two buttons do not work on my form.
I want to have a delete button that deletes what the user has entered.  
Ideally I would like it to delete the record and have a message box that says
"you have deleted this record".