I have some code that I got from Microsoft that I can use to send an
automatic email from access - this code is iserted into a module and is
called from a sub.
I would like the module when it is called by the sub, to pick up some of the

How do I convert a number saved as a string to a numeric datatype so I can
perform a calculation?

I've read the documentation for both objects and I think I'm getting hung up
on the phrase "code database".  I 'm not sure what a "code database" is.

I have a question about the best way to sort a collection in VB.  My
actual use is complicated so I've simplified it with the following
fake example:
I have created a class called "Person" in VB in an MS Access program.

(I posted this yesterday but am tryign to make it clearer)
I have an excel list with "name" and "title" and there are many erros
and mis-spellings.  I havbe an acess quesry that has the correct names
and titles and also some mis-spellings and foreign language spellings

I am trying to hide a column in an excel file without having to make it
visible. the code below makes the whole work book hidden, I do not know why.
I, ultimately, need to be able to hide several columns, in any file that I
enter in a text box on a form and save the file.

I need to sort a field  in a query containing values which consist of both a
numeric value, as well as a multiplier (e.g. "k" for 1000, "m" for 1/1000,
etc.). An approach I thought of was to create a second field, which would
call a function to convert the alpha-numeric values of ...

I am using the split function to load an array with substrings from a string.
The array does not have a declared dimension. Can I find out how many
substrings have been loaded?

I need some help importing data from text files into access.  I've got a text
file that is fixed-width text but the text file has multiple "pages" (though
no formal page breaks) of text only distinguished in the text file by a few
lines of header text and a few lines of footer ...

can I use a SQL statement for the domain in dlookup?

Please can anyone help?
I have a table that hold Course Attendees the ACode filed in the table can
be either
A - Attended

I need to set-up a crosstab query that will create a recordset of data I can
manipulate for a report.  The initial data is ran through a parameter and
then I create the crosstab from the data.  When I open the recordset I get
runtime error 3139 for my parameter syntax.  I wrote ...

I have a 9 page tabbed form.  I am using Access 2007 and have tried it as
2007 and even saved it as 2003 Access.  When data is placed in the last field
of a page a new record is opened.  Not what I want.
I have tried multiple codes and always get errors.  I have tried command

I have a subform that displays in datasheet form records related to the
parent record.  I would like to loop through the subform records setting the
lock and background attributes based upon the value of a variable in the
form.current event.  I can do this for one record, but how ...

I have 2 sets of combo boxes on my form where box 2 is set to only show the
values that match with what was picked in box 1.  My problem is the first set
works great but the second set on box 2 will only show the first value no
matter what you pick.  I have looked to see if I can ...