Greetings folks.  I have the following code behind the on open event of
several forms.
   Dim cn As ADODB.Connection
   Dim rsLOGIN_ID As Recordset

I have a form with buttons on it that I would like to open a stored procedure
with, easy enough, however I want to pass a parameter to the stored
procedure.  The parameter is a value from a text box on the form.  How/can
this be done?

We have an MS Access 2003 application (ADP). There is a view in SQL
Server 2000 database that takes quite some time to run (2-3 minutes or
so). When our application opens this view using DoCmd.OpenView
function, everything is fine. However, when user starts playing with

Moving an .adp back and forth between my customer's server  and my dev.
server, I currently load the .adp in the new location - and wait for two
timeouts to occur before I can enter the adp and change the File->Connection
settings.

Having some troulbe with a basic action. Maintenance form open with AssetID
passed in via OpenArgs. Now I want to display the specific Asset record...
Using this code it works... but I'm puzzled by the error.
----------------------

Greetings folks.  I am having a hard time understanding where I go to access
the AccessObjectProperties collection.  I am using Access 2003 .ADP with SQL
Server 2000.  I have found some stuff that seems relavent in the VB editor,
and have looked it up in VB help.  Specifically what ...

I am so thoroughly ocnfused with this whole process, hopefully someone can
help me get this right.
I have a stored procedure that has one parameter, @BeginDate, am trying to
run a report in an Access 2003 ADP.  The user is required to input the

This issue has been reproduced on three different machines running xp pro
xp2 with three different sqlexpress 2005 servers.
The is an mdf db that was upsized from msaccess2000 .mdb to sql 7.0 mdf and
ldf

I have an Access ADP project that is connected to a SQL DB in the back end.
I have quite a few cleints using the application(100+ to assorted DBs), but
every so often I have one client that the application locks up on to the
point of having to use Task Manager to close the ...

Can Access 2007 work with SQL Server 2005 Compect Edition as the local data
data store?
I'm planning an Access 2007 Runtime FrontEnd with SQL Server 2005 BackEnd
that I need to distribute to outside salespeople, who will be occasionally

I'm fairly new to .adp's and have a stored procedure in which I have an
alias which performs a simple division calculation.
However, if the result is between 0 and 1 (i.e the two fields in the
calculation contain 500 & 700, so 500÷700 =0.71) my stored procedure

I have a function to change the forms labels backcolor.  
The function works fine for all forms except for sub forms.
When the subform is ran by itself the label colors change correctly.  
As soon as I run the main form with the subforms on it, the main form

Have not used Access in some time but here goes:
Existing .mdb file with forms and reports etc. uses the native SQL Server
ODBC driver through linked tables.
Can I use an OLE DB connection by pointing to a .UDL file I have setup?

I'm a newbie in Access. I would like to use Access 2007 to connect to a sql
server 2005 database to view and update data in the sql tables. I'm
currently using OBDC to link my "*.accdb" project  to the Sql Server 2005
database. The problem is that I have (of course) foreign keys ...

I have an ADP and a sql server 2005 express backend.  I have a form
that is based on a ado recordset.  I want to open a report based on
the same recordset.  The form's recordset is based on a stored
procedure with multiple required input, optional input and output