I've got a continuous list subform.
One of the rows is identified by !IsBuyDependent=True.
I want this row, but none of the others tb non-editable.
My best shot so far is:

How do I get Access to calculate an rate ...
tonnage/(date and time finished-date and time started)
in either the data table or form?

My friend sent me a file containing a fairly large data base of our club
members -name, address, email - all of that stuff. How can I open it in
Access and or Excel. It represents alot of work and I would hate to have it
go to nought.

I have two approaches to a problem I'd like to ask about.  I have a
DoCmd.RunSQL statement that inserts a new record into a database that
contains about two dozen fields.  The SQL is run when a user presses
the 'Add' button on a form.  Everytime the button is pushed, the

I work on a database from home and at times the agents leave the database
open at the end of the day.  Of course when this happens I cannot do any
modification or
repairs because of this.

I am trying to create a database that will be able to track inventory of
products that are used to make up different items. Basically we are building
items from a series of individual products. Not all the finished items will
be made up of the same components, but some will use ...

I have two forms which are View and Edit. The first form displays all
records in a table and second uses to edit record which includes Add, Save
and Delete buttons. If user does not find the record on the View form, he has
to add the new record on the Edit form. Now, switch forms ...

Five of us use my .mdb at the office and as it is still relatively new I
regularly need to do fixes and upgrades remotely from home in the evening
when nobody is using it. I work on anything and everything i.e. tables,
queries, forms, reports, both the fundamental design and ...

I'm would like to have a column in a list box that shows the row number.  For
example, the first item in the list would have a "1" in the column, the
second item would have a "2" in the column.  Hopefully these numbers could be
dynamic so if an item is added, removed or moved in ...

I have a query with a field from an option group.  1=Internal, 2=Client.
Now in my query how do I have it return the text Internal and Client instead
of 1 and 2.  The field name is RequestedBy.
I think this should be fairly easy, but I have never used it before.

I have a Access Report that shows like this.
Date            Amount            Cost
1/2/2008        23                $1.25
1/4/2008        18                $1.10

I have a form with two list boxes, and add/remove buttons.  The user moves
Account Numbers from the first box [Accounts] to the second [Current
Accounts].
Once users have selected the accounts they want in a report, I need those

Hi, I can no longer right click on a control and bring up its properties. I
have to be in design mode and select the field then click the properties
button in the tool bar?
Any idea how to get the right mouse click to bring the properties up?

I'm having issues with a DLookUp function.  Its set up, or so I think, to
pull a company name from a combo box and then display their WSI number.  The
combo box also executes 2 quries in seperate subforms On Change and On Got
Focus.  When the DLookUp is set as below, I get a ...