I could be wrong, but I thought if I used RAISERROR in stored procedure, it
would return the error message back to the client, in this case MS Access
(2003).
However, altho I see the message displayed when I debug the stored proc, it

The database look lilke as below :
Cards           Vintages     Ports (u=unused)
AUX          0001         01 02 03 04 05 06 07 u u u u
                                11 12 13 14 u u u 18 19

I need to know the VBA code for deleting an Excel workbook.
Problem:  I create a Excel workbook to attacht to an email.  This works
great.  However, when I try to overwrite it with the next workbook it is hit
of miss if it will do it.  So, I want to delete the workbook after I ...

i have a print command on one of my forms. When you click the print button, a
quote is printed. A msgbox appears asking did the quote print. if the user
select yes then certain controls are adjusted. If user clicks no nothing
happens. Here is my code. When the user clicks no i ...

I have two combo boxes in a table.  Method of Payments and Method of
Payments #2.  These combo boxes have the following options "Check", "Wire",
"Adjustment", and "CC."
Example:  1. Method of Payment = Check and Method of Payment #2 = Adjustment.

I'm trying to create a form that will open another, filtered form when you
trigger an event (double click a record).  Something has happened so that I
can't close the form once it is open or switch to form view if I have it in
design view (and vice versa).  I get the following ...

I have a graph based on a table.  The table has parts, count of parts
returned for month, date (in mmmm yyyy format).  If no parts were returned in
a given month, the graph simply skips over it.  That is to say it doesn't
show it as a zero month.  What I want to do is write ...

I know that this issue doesn't belong to this group but i cannot find where
i can put the following question:
I'm trying to create a batch file for renaming files. This new filename
should include the system date.

I have created a report that opens a query to supply totals on the 'On
Format' event of a report footer.
                   Dim Conn As ADODB.Connection
                   Dim rst As ADODB.Recordset

I am getting a compile error (see subject) for the following code:
Set wbk = app.Workbooks.Open(FileName:=strCompleteExcelName)
The "highligted" compile error is ".Workbooks".  I borrowed this code form
another individuals program and it works in her database (and it compiles)

I just received a copy of:
Access 2000 Developer's Black Book, thru an authorized reseller(?) for Barnes &
noble.  (Since it's out of print, it's used.  Good shape, but used.)
The problem is...it came with no CD.

I want to be able to select *all* the items of a listbox.  Is there a way to do
this with a single statement or do I have to loop through it using the ListCount
property?
Thanks,

The splitting function responses I've read explain how to split text if
there is a separator.  I have a phone number field on my form that includes
the 10 digit telephone number.  What I would like to do is take the first
three characters off this line, and place this in a new ...

Hey guys,
here is the deal. I am opening a report from a form (tab control type of
form) that has a combo box with a list of Airport codes (station).
here is the code:

I want to sort the details section of the report (which is a Tabular View).
The sorting to based on a Field/Control. What code should I write to do it.
I posted the same question to report groups, sorry the answer was not useful.
My situation is that I have made a report (Tabular ...