I want a listbox with column sort buttons at the top and adjustable
column widths.  You see them in all kinds of applications, like Windows
Explore's file list.  I could build one for myself using labels with button
down and button up events and a bunch of code to round it ...

How do I set my  subform to add mode when it is opend up? It is based
directly on a table.
Thanks, Kyle.

When a new Form is created in Access 2007, the "Moveable Property" is set to
"No" and cannot be changed to "Yes".
What am I missing and what can be done?
Thanks,

Hi, i hope someone can help me, i would like to hide various fields under
different conditions.
i have combed other posts about the subject and they have help me greatly, i
am about 75% there.

I run A2K and created a s'board using the 'wizard'. The 3rd option label from
the top of the s'board is hooked up to a 'macro1' which proceeds to run some
queries that update a couple of tables in the app. I've got a msbox at the
top of the macro that tells the user they are ...

I have a combo box where the user will select an employee from a Employee
table listing the employees with a lookup filed for the supervisors. The
supervisors' names are in a separate table, called Supervisors. What I am
trying to figure out is how, after a user selects the ...

Is there a way to auto-populate a form using data indexed to a primary key in
a table?  That is, when I enter the primary key value in a form, I want the
remaing fields to automatically pull data from a table with that primary key
and populate the remaining fields.

Hello!  I am looking for an email routine using Microsoft Access where
there is an option to include associated PDF or Word documents from
the working (Windows) directory.  So any PDF file or DOCs put in the
external directory are automatically attached to the email.  The user

Keep in mind that I have most of the fields. the only thing I don't have
which should be include in the statement are the dates. I have the RACC
field, serving size, sodium, cholesterol etc... I just don't know how to do
this IIf statement

I've had forms with subforms before, and when I created them through
the Form Wizard, the subform always showed up as whatever I picked. If
I picked datasheet, it stayed a datasheet. If I picked columnar/
tabular (I forget which), the subform stayed in that format.

Is there a way to open a form with no control in focus? I have a form that is
information only (for reading) and would prefer the first control not be
highlighted.
Thanks,

How do I create a tabbed form, where the tab names and number of tabs will
change based on the outcome of a "group-by" query? (or the unique values in
one field of a table). Or am I asking too much from a tabbed form?

I have a database where I need the output from one list box (listbox1) to
determine the values displayed in a second list box (listbox2).  listbox1
contains the fields MailCodeID and MailCode.  Each MailCode is associated
with one or more FloorCodes, and listbox2 contains the ...

I have at table of Students with the following fields:
StuID (key)
FirstName
LastName

I'm trying to fix the sort ID. When I get to about the 7th or 8th the one
that shoould be 0 jumps to something like 30. Other than creating a new form
and cutting and pasting into that form then copying them back one-by-one
what can be done. aS I'm going around in circles getting ...