I have city state zip in a limited list in a combo box which makes date entry
easier and faster. I have stripped the zip on the form with =Right([zip],5)
Can I use this somehow because for bulk mail in the label wizard I need to
be able to sort by zip code?

is there a method or way to sort on open recordset?
as in Me.Recordset.Sort = "Field"
tia,
mcnewsxp

I have created a form to display my data in a simple name and address table.
I have created buttons to navigate through the records but want to create a
button to print just the current record, ideally with a different layout to
that used on the form.

What format can i use in order to sort one field containing first and last
name by last name only?  In table design view i have tried to put in a format
that would allow me to sort in the report design view, but i keep getting
error messages.

Hello, All!
I want to copy and rename excel sheet from ÁÓÓÅss vba.
I try this but result is error:
Sht.ActiveWorkbook.WorkSheets("Sheet2").Copy

Eu gostava de inserir um campo qualquer e depois automaticamente, o Access
inserir-me os valores que respeitam a esses campos. Tipo: Eu coloco o Código
do Produto Café, e depois o Access tem de me colocar automaticamente, os
campos do Nome do Produto e do Preço Unitário... Já li ...

In a form, when I Insert a new Record I want to update  the REVCD Field
with today's date.
At the same time I want to refresh the RECVDTE with the information.
What is the syntax code for this procedure?

I'm looking at a table window in design view. I have a list of objects
(tables, queries, etc.) along the left margin. The rest of the window is
divided into two halves: a top, showing field names and data types, and a
bottom showing field properties. Can these two haves be ...

Hey guys,
I've created a report based off one of my queries, put in all of my hardwork
into it and sorted "ascending" vs. "descending".  Is there a way to remedy
this without starting all the way over from the beginning?

Why cant I view Access 2003 reports in Vista.  I can view the reports using
XP Pro.
Thanks

Is there anyway I can send a password for an ODBC connection (SQL) database.  
I have information I am taking from a SQL program and want to share with
others.  I don't want to give out the password but want the Access
information to update when the database is opened.  I need to ...

I have created a transactions table in an inventory application. I have also
created a DSum function that shows the quantity in stock on a form, by
calculating the number of incoming transactions minus the number of outgoing
transactions.

Is there any way you can change the way an Input Box is displayed that is
used in an On Click event procedure?
For example: size, position, colour etc>
Thanks for any help

Hello, i would appreciate any help regarding a problems i am having.
I have setup a simple database with working query's. Sadly i think it
would be a much better design
**if i could run my query's & have it ask me what table i would like to

I have a large table with 2 columns (first name and last name) in it and I
would like a drop down of a list of possible first and last names from the
Name table.   I am using the Lookup Wizard for the list of names but if I
have 25 "Joe's" with different last names, is there a ...