I have a list that contains many options from which a salesperson can select
one or more.  Multiselect is set to Simple.  The problem I have is: If the
first item on the list (Customer declines all options) is selected, any
additional items selected will also be added to the ...

I have a system where a file is imported to a new table and is given an
AutoNumber field so each record has a sequential reference number.
At the end of the import process, I need to 'juggle' the reference number
between records so they are sorted differently on a report.

Hi! I'm simultaneously working in developing 2 different Access 2003
applications with VBA, but changed to a new laptop this week. Unexpectedly I
get run-time error 29068: "Access cannot complete this operation. You must
stop the code and try again" whenever I try to save a form ...

Is there a way to enable the Digital Signature option in an Outlook email
message that is generated from Access VBA?  The user must send a digitally
signed email and currently a message box is used to remind the user to select
this option once the email is displayed for their ...

I have an "order details" table that has a text identifier for the "order
number" (e.g. "abc"). I would like to create a numeric identifier that
uniquely identifies each order (e.g. 1 to 10).
Is there a way to do this via a query?

I am using Access 2002 and whenever I open up an expression builder box (e.g.
in a query to build an expression), the text is all on the same line.  This
makes it very difficult to read as I have to keep scrolling right across the
dialog box.  Is there any way of forcing the ...

        I have a table with a single record that contains the dates and
information for the jobs processed during a quarters processing, I want to
create a form so that users can update the table.
The table "tblQuarterDates" contains the following fields.

I have a project Update form.The record source of the form is a parameter
query.
I made a custom from for parameter.But when i open the form,firstly the
system generated parameter box appear and after giving the value the custom

In Acess 2003, I need to select the first record from a subform to copy the
data in it to another subform with a VBA module (called from a macro outside
both forms and subforms), and then select the next record and do the same,
until the last record. The form/subForm that ...

I am creating a new database and i am trying to export some tables to this
database.I get the error named Could not find installable ISAM.Could yo help
me with my error ?
below are my functions

I am trying to create a command button on a form that will email the address
that I have in one of the fields also on the form.  Is there a VBS code that
will allow me to do this?

Access03/WinXP
(Probems with initial post - my apologies if this is duplicated)
I am using what seems to be a standard process to export a query to Excel.  
The code below is the first part of an IF...THEN where it is true that Excel

Using Office 2003 and Windows XP;
I have a DB in which I need access to the international character sets. It
would be nice if I could popup a dialog containing them and then double click
to pick one and have it insert the character into the current control.

I have a 3 forms, MainForm, SubForm1 and SubForm2. From SubForm2, I would
like to refer to a control on SubForm1 through VBA. I have the following
syntax:
Forms![MainForm]![SubForm1]![ControlName].Value