How do you transpose a label in a report in access 97? i.e. from horizontal
to vertical. Thanks.

Hi, I'm doing an ADP form with Access 2003.  It appears that the data
is saved automatically to SQL Server 2005, is there a way to remove
some of the icons like the save/disk icon so the user isn't tempted to
click it for no reason?

I have a subform that I use on two separate forms.  There is a field on the
form that shows the total costs for accessories.  Here is the syntax for the
field:
=IIf(IsNull([LocationID]),0,DSum("[Cost]","Accessories","[LocationID]=" &

I would like to make party invitations for a family party cause My daughter
just made Chief in the U>S> Coast Guard.  I would like to have some clip art
for her rank.  

I'm having a little bit of a problem, I have a form for transactions by
customers(frmCustomerTransactions), and a subform
(frmCustomersTransactionsDetail) with each transaction on page on of a tab
control.  On page two I have two more subforms (frmTransactionServices,

Can anyone help me, or know a link, of how I can create a search form
in Access '03.  I want to be able to type in a number (such as an IP)
and have it give me the title (server name).
Any help will be greatly apprecaited.

I know my nifty switchboard has to run inside the Access window.  Is there a
clever way to make the Access window appear to disappear, or almost?  I don't
have the Developers Edition and will never have, but I would like to make my
interface as uncomplicated as possible.

I have designed a form that displays the information from the parent table at
the top and displays the information from the child table in a subform
displayed in datasheet view.  The parent and child table have a one to many
relationship.  The table that the subform is linked to ...

Hi everyone. I have a tapes database to record the companies master tapes. I
have a field in which to add a bar code using a barcode scanner.
I have made an unbound box(txtFind) that I want to use as a record search
box for the user, i.e. to input the barcode via the scanner into ...

I have a Continuous Form where a user can select a "Yes" or "No" toggle
button to show acceptance.  If they select "no," additional text boxes open
for the user to explain why it was not accepted.  I made this a continuous
form because the user can come back at a later date and ...

I tried searching the newsgroups but so far everything I have tried isn't
working for what I want.  I have a form with a subform.  After checking a
box on the subform...
Private Sub chkShipped_Click()

I am designing a form (Access2003) that is opened from another form based on
the selection criteria from a combo box (ex.  Clinical Evaluation, Service
Authorization, etc.)  
Once the user selects the form type from the combo box and clicks the Select

The default shortcut menu for an access form contains the command filter for
along with a text box.  I would like to include this command (and the text
box) on a custom shortcut menu, but am unable to locate the command in the
list.   Thank you

I want to users to update data in the table via form.  Once the deadline for
updates passes I would like to "freeze" the form temporarily so no more
updates will be made. Once new data is available for next month, I need to
"unfreeze" the form so users can enter their updates ...

I have a form that I would like to creat a list box for a group of fields.  
In my main table I have a group of fields that I would like to show up as a
list in a from.  I want to be able to select from that list of fields and
save it to a table.  Here is my example: