I need to implement a dialog that expands to show more options with the
press of a button like the Windows Colour Picker. How can I implement this
in access? The form does not want to reduce width if it has controls in that
area. How do I overcome this?

I have a query in Access 2003 that has the following criteria
SELECT tblOrder.SessionDate, tblMenus.Item_Name, tblOrder.Type,
Format$(tblorder!SessionDate,"Short Time") AS SessionTime,
Sum(tblMenus.Item_Quantity) AS MenuCount INTO tblSessionQuery

I have a tabbed form. Tab 1 has fields that are mandatory. I am trying
to validate that these fields are not null, and cancel  updating if any
of them are. The following code works, except the form closes instead
of setting focus to the null field. What am I doing wrong? Do I need ...

I am working with fairly large databases (> 500 Mb / < 2,000,000 rexcords),
and often need to do action queries on these.
I have the feeling that much of the computing power is going into building a
table of changes so that you can be prompted "Are you sure to change xx

When a user types ' in a Memo control, It throws an error message on a
DoCmd.RunSQL.  What is the escape character for ' which I can insert
before ' so it won't throw an error message?  Any other ideas on
dealing with this?

I need to generate a string of six random characters to act as the first
password. Is there an example of how to do this somewhere?
Thanks
Regards

I have a form with, among others, controls for RoomNo., CheckInDate and
CheckOutDate. I would like to check whether the RoomNo selected is occupied
for the period as stated in CheckInDate and CheckOutDate.
I have used the OpenRecordSet method for the AfterUpdate event in the form, ...

I have created a report, where there is multiple items with different
values in a group that i total up at the end:
App  3
App 3

Hi, all:
i am a new end user of access, now I have many excel files need to
import to One table in access (combine all excel files into one table
in excel). In excel files, some columns will have both # and text in

Dear Access Developers:
I have an interesting problem that I hope someone could suggest how to
solve:
I have the following Report:

I have a combo box with different types of business listed.  If a user
selects "Other" from the combo box list I want to make so that the user
is required to make an entry in a textbox on the form.  Also is there a
way to make just certain textboxes on the form required fields and ...

How do I determine the size of the tables I'm using?  I looked under
properties and it's not there.  The book I just browsed said table is
limited to 1GB.  How do I find out what size my tables are?
TIA

Please help I'd like to know if there is an easy way to setup a command
button to select all the records in a table and then send it to print
instead of opening the table and then choosing file and print. Thanks.

Is it possible, using code, to create a spreadsheet in excel format, with
cells containing constant text and formulae and inserting data from a
recordset in specific cells?
If so, could someone point me to an information page with details on how to