I have two forms in my project.  When the first form is opened you use the
record selectors to choose a record.  You click a command button and another
form is opened that contains several combo boxes.  These combo boxes need to
be populated via a Stored Procedure / User Defined ...

How do I enter more than one input parameter into the form or report?

How do I convert access queries which have form variables
to Sql Server query?
Example:
SELECT Plus.*

re-posting since I wasn't able to find an answer and previous post has some
answers from me with might mislead
pople into think I found the error.  So here it is:
I have a form with a subform.... once the user celect the client, he then

I'm developing a readonly continuos form with
- AC2003
- adp
- ADO

I am new to SQL server and project, very familiar with Access. Why does MS
Project  return message every time i run a stored procedure that basicly
says "the sp was successful but did not return any records."  When in fact
it does return records.  Also why can't i preview the ...

How do I fix this problem
Error when running Stored Procedure:
Syntax error converting the varchar value
'forms!switchboard!list15.Column(0)' to a column of data type int.

Hi
I used to have autonumber in the form which gives the
current record no which i comfortably used to mention in
the the document from where data is extracted for future

I have an ADP project which works fine in A2000 and W2K.
Two users have Win XP Pro and can't execute the stored procedures
because the stored procedures have been renamed e.g. sp_gethours to
sp_gethours;1

I have an MS Access 2000 query that I need to convert into  a SQL Statment
for Access project and SQL Server backend.
One of the queries have an IIF(RecType="A",Name,COntactName).  this is not
working how do I get this to work?

I am in the process of upsizing an access database to an
access front end/sql back end.
I have several "pre" screens where a user can select a
record then it will open a form with the entire record

I'm sure this is a real simple one ,
whats the best trick when your select conditions have a ' in the value
"WHERE (People.FullName   = 'Example  O'Toole' )"   ?
Chris

i have 2 tables: tbl-LAWYERMembership and Case Info.  What
i would like to do is move a Lawyer's name from tbl-
LAWYERMembership (the field name is FULL), where a
checkbox is checked, to a field in Case Info

I have searched and can't find where anyone else has had this problem, so
maybe I'm missing the obvious.  But, any help would be appreciated.
I'm rebuilding an Acc2000 .mdb to an Acc2000 .adp with SQL Server back end.
I have various columns that need to be formatted to show leading ...

I have a form with a subform.... once the user celect the client, he then
goes to the subform and add qty and select a check box to order...
when the user selects the check box the following code is done:
DoCmd.SetWarnings False