I have a field which identifies from a drop down list 4 different types of
transactions - cash expenditure/ cheque expenditure/ transfer etc
What would like to happen is that on choosing one of these entries the
subform changes to a specific subform for each type of entry.

I have a subform, which is linked to a query, which shows all records frm a
master table and the Quantity field from a transaction table.  Only the
Quantity field on the subform has its data Enabled, but any existing records
in the query do not appear on the subform.  If I open ...

Professionals: On my form I have set the property of the navigation buttons
to "no" and have designed my own buttons to go to the first, next, previous,
and last records. The problem with this is it also eliminates the record
numbers (page x of y). My form is set to single page ...

I have my combobox...CBOStrNum and multiple text boxes looking up the
appropriate data in a table based on the combobox
Combo box is unbound, Bound Column is set to 1
My first textbox in the control source is: =CBOStrNum.Column(1) which

anyone know how to disconnect a datasheet form from a table, i use wizard to
create a datasheet form but i need it blank just like a spreadsheet, wizard
keep forcing me to connect my form to the table, thanks in advanced

I am trying to make this 'error' message go away and display my own
MsgBox. I have set some of the fields in one of my tables to Required.
And when I am actually interacting in the form and i dont fill that
required field it popsup this 'error' message saying  "The field 'xxx'

Is it at all possible to apply a Zoom feature to a Memo field that exists in
a form that is in datasheet view?  Maybe users could double click on that
field which would open up another window?
Or...Is there a way to place a command buttton in datasheet view which could

I am producing a stock inventory and have a command button called Add To
Inventory. When i click on this it brings up the relevant records but starts
at record number 1. How do i set up this command button to open at the add
new record stage rather than having to click the ...

I created a macro that stores a calculated value from a field in my form
(FieldA) to another field that will be stored in a table(FieldB).  (I know
that you normally shouldn't store calculated values but in this case it was
necessary.)

Having trouble referring to more than one column.  The first statement below
works, the 2nd gives "error" as a result.  Any help would be appreciated.
If Me.InsFactor.Column(2) = 1 Then Me.InsRate = Me.cboTerm.Column(4)
If Me.InsFactor.Column(2) = 2 Then Me.InsRate = Me.cboTerm ...

I have a simple recordset:
Dim Town as New ADODB.connection
Dim Base as New ADODB.recordset
...

Hi I have a form called frmRelations" I need to add some relations to my
database. At my Switchboard I have a item which calls DoCmd.OpenForm
"frmRelations", acNormal, , , acFormAdd
I've this same form (differnent Access databases)connected to 2 different

In Access 2003, I am seeing something I have never seen before.
In a new form, at the left margin, opposite from the vertical scroll bar, is
a vertical bar the height of the page with an arrow at the top pointing to
the right.  It looks like a tall, narrow button, but I don't know ...

Is there code to determine the path of the database?
I compile to MDE which calls for ODBC connections, but I want to switch this
to a 'file dsn' so that each instance of the MDE can have it's own
conenctions to databases.

I would like to use a calendar in access showing some events that are in a
table by date.
Ex : In my table I have a DATE field and an EVENT field. I would like to
open a calendar showing all the events on it from the date value in the