I'm building a form with alot of fields,one of my issue that i'm trying
to solve is how can i indicate the window's left view in order to keep
all the time some of the fields on the screen apon scrolling right or
left

I've created an Orders Form similar to that in Northwind, and have been
trying to learn by duplication.  My Problem Is:
I finally managed to get my subform to insert into my Orders form in a
Dataview, however, the field heads show up but I'm not able to enter anything

I am trying to apply the same technique used in the customer contact form in
the Northwind Database for my own. I have done something similar in another
DB using radar buttons and it works fine.
For this one I am using toggle buttons for the letters A-S and "All" (for

I'm using a tabbed control on a form and each tab has a subform. On one of
these the subform will be viewed as a datasheet. There are only 2 fields and
one is a date field. I converted the date field text box into a combo box. I
followed the instructions from fontstuff.com to add ...

I try using IsNull(mycontrol) or Nz(mycotrol) for filling it but not
succeeded.
my code:
Private Sub Form_Current()

Following an example on another post (I believe by Allen), I put a button on
my form which prints out a report of the current record.
frmOrderStatus contains fields from table tFits and also contains 3
subreports:

I have a form that uses a combo box to search on part numbers. There are more
than 85,000 part numbers (records) to search on, and these are alphanumeric
part numbers (data type is “text” in the table design). The combo box will
not list/display all part numbers.

Hello! When a user enteres information on the form and submits it, the
database shows the unique ID number of the (for example) doctors name that
was selected instead of the name itself. Why is this, and is there anyway to
switch this around so when they select the doctor (from a ...

I Have to make a data base that needs a form to generate a number for me when
i click on one number. For example if i make a combo box , then in the form i
click on one of the numbers in that combo box it will automatically generate
the corresponding number into another filed. Is ...

I have Access 2002. I want to insert a picture in a form, but I also have a
label which needs to be on top of the picture.
Is there anyway I can order the picture so that it is underneath the label
... thanks

Is there a way to enable ALL fields in a form only after a combo box
selection?  I am not worried about enabling/diabling controls, only ALL
the fields in a particular form.  (It would be bonus if anyone could
tell me how to get rid of data showing up in disabled fields. I want

I have a form that displays records from a table called tbl_item. I
have added some code, shown below, to the Form_Current procedure to
refresh certain fields on the form based on a value selected from a
combo box. It appears that this code below prevents me from adding a

I have a main form in datasheet view with a subform linked by [sortacct].  Is
it possible that when a record exists in the subform to have the [sortacct]
field on the main form show up in bold or another color possibly.  I have
searched all over the internet and most people just ...

how can i change the colour of the scrollbar properties in an access form.
thanks
jkb

I've used the Forms Wizard to build a form based on a table.  When in design
view, I see all the fields, labels, etc.  When I switch to form view, all I
see is the header or title and a blank body of the form, no fields, labels,
etc.