A user inputs when cabinets for a specific customer need to be delivered into
a form. All the header information is added. Customer, entry date, phase, etc.
They also select a checkbox at the header level if the job has a special
color.

I am using Access 2002 and I have a command button that will delete data
from a table which will import an Excel file and append the file into the
main table and a message box (macro) will appear stating that "Upload
Completed"  if the user proceed.  Below is my coding:

I'm trying to get a count of items in a combo box with the following code,
but it's giving me a wrong number. The combo only shows 3 items when the
following code gives me 4.
msgbox (Me![cboSerialNumber].ListCount)

How do I enter a record and have some of the information in the form show up
on the next record until I change it.

I'm pretty new to Access but have Excel VBA experience.
I have an Access 2000 application with a number of forms and sub-forms.  At
startup I display a form with a list box listing the forms I may want to
use.  At the moment the form names are hard coded into the list boxe's

I have a subform(continuous) on a main form.  I’m using SQL INSERT INTO table
to save the records from the subform to an event table.  My problem is that
it is only saving one record when it should save and many records as the
continuous form has.

Access 2003/Windows XP
I've got a bound form with a filter (STATUS<>'CLOSED'). The users will be
able to change the value of the STATUS column using a drop-down. Here is the
behavior I want:

I am using a form command button to open a file dialog so the user can
select a file.  From the VBA Access help, I obtained the following code and
pasted it into the Command2 control code as shown below.  Unfortunately, it
does not work.

I have a sub-form(continuous) on my main form.  
The sub-form has information that the User is editing during data entry.
The sub-form is a work area only and not to be saved to the sub-form table.
How do I copy the fields from the sub-form to another table that I am using

I want to concatenate two text fields together. Once is 20 char and the
other is 10. I do not want them "trimmed" - I want to concatenate based on
teh full length of the string...
Example...

I don't know what it is called but I tried to describe it below.
I would like to setup something like pivot tables that is a director listing
and to select folders and then show files with a + or - sign like when
selecting a folder.

In a control, I want to make the format to week number (week of the year),
like =format([dato];"ww"),
but it doesn't work.
regards

I have a form which would normally be in a master-sub relationship if it were
bounded.  This is to enter employee and their associated expenses.  However,
my 'customer/mgr' doesn't like the idea of having to do dropdowns to pick
each type of expenses in the otherwise datasheet ...

I have 2 forms.  On frmTC is a command button to open frmSE (filtered to the
record that frmTC is at) and make frmTC invisible.  (On frmTC are navigation
buttons to scroll through the different records.  When the user sees a record
he would like to edit, he clicks the command ...

i need a code to covert the numbers to words in order to print it in a
report ( to show the amt in both numbers e.g $ 505 and in words e.g. five
hunded and five dollars only. i have one code but for two decimal places only
. i want it for three dicimal places e.g. 126.250 to read ...