I have an Access 2003 app  (accessing an Access 2002-2003 DB) that runs
every day at a given time on an XP Pro PC. I've used XP's built-in
scheduler to set up the app to run every day at a fixed time (17:30).
The scheduler asks for user and password to run the app under. The app

Is it possible to view access query (design view or sql view) and its
query results in the same window (for example, arrange them side by
side) as other DB software do?
Thanks,

Access 2000 connected to SQL 2000
Is there a way to initiate Sql Replication via code from within Access?
All Replication jobs are setup to run on demand. I would like to be
able to click a command button in Access to start the jobs.

I have a form with two text boxes, text1 and text2.  What I need is a
button that exports each text box to a specific cell in an excel file,
the excel file needs to be refreshed/updated so a calculation will run
and the cell containing the calculation result is passed back to a

"Lyle Fairfield" <lylefairfield@aim.com> wrote >
<SOAD>

From time to time I have posted about the convenience of such hosts.
Typically, they make available an MS-Sql Server database on their
internet-enabled servers (See note below). I (and my clients) have been
using these for a long time, since Access 2000 and ADPs came out which I

Access 2000 attached to SQL
I'm trying to ck for duplicate SSN (text field) and I have this code in
the "before update" event
However I am getting a Data Type Mismatch error on the "Set rst" line.

I have a table that I would like images to be stored to.  I would like
the users to be able to add images and information about the images to
this table through the use of a form.  I want them to simply be able to
click a button, find the image on their computer, and have that ...

I am trying to find valid records in a table
but I must compare a date field to a date stored in the table
I can see where this is wrong (ok I guess its not text)
"[date]= """ & Me.date & """"

when i am joining on a Column of Text Type with one of Memo type
the resulting entry has funny chinese characters!
Has anyone else encountered this before?
Is there a cure??

I'm back.
Do not use queries too often and have trouble formating a field:
misc: if(([data_order]![order_type])='2';"Normal)";
if(([data_order]![order_type])='8';"Extra")

hi I am using MS office Access 2003. ANybody knows how to
convert more than 300-400K rows from text into e.g. number ?
I tried to do so a few times and access told me there aint
enough memory or something. Anybody knows quick fix to that

a student know one ore more programming language
in a mask i select from a list_box one or more language and i send ad
parameter to a query that extract the student that know all this
language.

Let's say I have a table with the following fields.  State, Customer,
and Total Sales.  What I want to do is rank each customer by sales
volume by state.  i.e. highest sales is ranked 1, second highest ranked
2, etc within each state.

I'm largely self-taught (so hardly an expert) in Access 2002. I'm wondering
if it's possible to have a conditional input mask on a field in a form.
My database keeps track of people who register for a conference. They can
pay by credit card (Visa or MasterCard only), check or ...