Details: I want to take the switchboard CmdArg F_MyForm,YM.  I can parse into
two strings; sFormName = "F_MyForm", sAction="YM" as reportCode
I want to open the value of sFormName and pass in YM somehow.
My code in F_MyForm determines the report name from the YM from the

I kept on receiving type conversion error while trying to programatically
import a csv file into an access table.  I've read a lot of the posts saying
that it is caused by the mixed data type stored in the column and the
solution is to insert an additional row at the top of the file ...

When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
end of statement error with "NDItemNumber" highlighted.  I know it has
something to do with the 2 but I can't figure hout how to get around it.
Sorry if this is a duplicated post but I don't think I posted ...

Is it possible to difine which fields to attach on a Oracle ODBC linked
table?  The table has 300+ fields but I only need data from about 20 of them.
I can't see the complete filed list since Access will stop at 256 fields.  I
was wondering if it's possible to create a tabledef ...

i have a table with fields = item code (id) and photo path (2 fields).
i have another table with item code (id) and many other fields.
i have created a query that combines these two tables and is based on
multiple criteria selection from a main form. the query is working fine.

I have an Orders table and an OrderDetails table. I want to select certain
orders, change a field or two, and make a copy of these records (along with a
copy of their detail records unchanged). I know how to OpenRecordset and loop
on the records selected and to get the fields ...

Hi - I have 2 sub reports included in one main report. Two sub reports run on
different queries.
In the Print Preview of the main report, it is fine. But when i try to print
on a printer, it prints a blank page.

I am new to coding and have had some success but am baffled by this.
I have a form that I wish to ensure that the end date is the same as or
after the start date.  I have attached the following code but it fails at the
point where I am trying to clear out the end date field of the ...

It is my understanding that you can't change the background color of a
command  button in Access 2003.  Therefore, I've used a label and coded the
MouseDown and MouseUp events to have it behave like a command button.  Is
there some way I can assign a "hot key" to this label?

Hello -
I have 2 linked tables - Table "A" is a product , and table "B" generates a
serial number (AutoNumber field) for each individual existence of that
product.

My update function does not always  work properly, especially when one of the
fields is 0 or blank.How could i improve my function so that when addding wih
0 not to give 0 ?
My function is the following:

My update function does not always  work properly, especially when one of the
fields is 0 or blank.How could i improve my function so that when addding wih
0 not to give 0 ?
My function is the following:

i'm having trouble deleting excel worksheets from access.  I've tried all
four methods below but none of them seem to work.
Set xlApp = CreateObject("excel.application")
Set xlWkBk = xlApp.workbooks.Open(CurrentProject.Path & "\" & strFilename)

I am trying to do something that I'm not sure is possible, but was
hoping someone could show me a way.  I have a database on a shared
drive that multiple users access concurrently.  The database is not
split.  I am trying to allow a "one click" generation of various form

I have an MS Access 2003 app that has a linked Excel file.  There is a
process that copies the Excel file from the user’s pc to the network, then
refreshes the link.  If this process is run, then a user makes a change in
the file and runs the copy/refresh process again, the ...