When deploying a solution using the Access 2003 runtime engine, do you have
to use the packaging wizard that comes with the Access 2003 Developer
Extentions, or can you use other packaging software such as the Visual
Studio packager?

Dear Gurus,
I had never worked with ADO enviornment in access world.
can any one tell sample codes/ideas how to work with ado on form where
there r buttons like first, last, new, etc..i had done but giving me

I have tab control on one of which pages is subform.
When I change data on one of pages and navigate to another, update in
database is happened.
Is there any way to avoid that?

We have our main database application running on our windows XP machines
and run office on a terminal server.  I need to find a way for a program
on the XP machine to access the terminal server to send a automated
email via outlook using the users account.  Can anyone help me with a

Is it possible to set different colours to each tab in a tabbed subform?

-----------------------------------------------------------------
Sub Sheesh()
Dim myYears                As Double
Dim myRawCumulative        As Double

I am working on an Access application where the author used SQL back
end via linked tables.
I wrote some general functions that would execute pass through queries
and was going to call them for all new DB interaction.

I ran into something really bizzaro today.
A team member had me look into some export code for some data he was
outputting.  The data looks at shipping containers and attempts to look
at how often their being reused.  Details are output according to the

Hopefully I ask this correctly
In Access97 I have a continuous form which is bound via a select
statement in the record source.
Lets say a user starts entering a new record on this continuous form

I have seen some very general suggestions for alternative code to the
WScript.Shell code, but nothing specific.  In the two lines of code
below (I think) the first line creates a text file on the hard drive.
When I get to this line I get runtime error 429 "ActiveX component

I have a table (tbl_Titles) where several records (tbl_Titles.Title)
that start with "The ...". I'd like to convert this to "..., The".
How can this be done with an update query?

Okay, this is probably real simple stuff for you guys. I know its simple, I
used to know some of this stuff when I was learning Visual Basic in school,
but yeah. Only a couple of things.
Firstly, I want to know how to extract an integer from a string. For

I have a user/pc specific problem in access.
This doesn't occur on any other ( windows xp pc) that I have used the
.mbd on.
This involves a query that's using a range of dates as a parm. This

I am trying to send a report by email using DoCmd.SendObject acSendReport.
When I send the report, it sends the report with all the records whereas I
only want the report to show one record.  I have got around this by linking
the form to the query so that the query returns my one ...

I am attempting to use the following code to print a report based on
the current record in the form.  Users bring up the record with a
parameter box and then can make changes to the sub-form on the main
form (main form is locked).  I use this same code for another