I have a continous form with summary information in the footer.  When the
recordset returns I can use the count([FormFieldName]) to get the count of
records returned.  But, it appears that when a filter is applied, the number
does not change because the underlying recordset has not ...

I use CurrentProject.Connection, to send several update querys to SQL.
I try to open a transaction before the updates. Then when I finish, I try to
end the transaction with currentProject.CommitTran.
But in that point, I get an error, saying that there's no transaction

Using sqloledb as a provider for ADO; using exactly 1 connection to a MSDE
Server.
I'm sure many of you could imagine scenarios in which I'm walking through a
recordset, processing each of the records. Also imagine that this particular

   I have a question about the Access Projects and bound forms.  Which type
of Recordset object do they use, ADODB, OR DAO?  I ran into some issues with
an Access front-end application when trying to hand a form an
ADODB.Recordset in code (maybe it can be done, but before the form ...

I need some advice on if I use SQL Server Developer with MS Access 2000 or
2003 as a Backend, and later move to SQL Server Enterprise to connect
Remotly to the Access application, will I run into any problems or will I
need to do any code changes to the Access program.

Access 2003 + MS SQL Server 2000
I'm using a form to manage customers and related contracts; with one to many
relation;
all managed with a form containing a subform:

I trying to upsize a access 2000 database to sqlserver but the conversion
process just stop after it has started. The end report saying all tabels
have been skipped. I'm new to this area, is there something I missing ?
Petter L.

Can I please get some help on the syntax for using
dbQSQLPassThrough in an event procedure where a string is
passed to my SQL server when a button is clicked, hope
that makes sense.

I have two fields city and state the two are combobox , is posible
sincronize these comboboxs ,
example when i choose the city :pasadena (2) afterupdate the select
automatically the state california

I have problem of using transaction on store procedure
When i running SQL store prosedure on access vb i get all there error
messages on access so i can know if the action done or not done.
Now when i started using transactions on the store procedures i don't get

I have about 2 million records.  I orginally set the Record Source of
my main form to the entire table, made a basic search (code below) and
everything worked well, but I quickly realized that it was taking way
too much memory to do.

The scenario is as follows:
1) 3 suppliers provide seperate pricelists that are impoted in the db
2) These pricelists are joined into a single view using a union statements
called tmpSuppliers

How do you write a nested Iif statement in a view or a
stored procedure?
Listed below is what I have in a query in Access, I
realize [Day_CVAD_Date] will become dbo.Day_CVAD_Date and

I change the RecordSource of a form to:
select BC.* from  T_BusinessContact BC  WHERE  (BC.[Mail1]
like '%test@kpmg.com%' OR BC.[Mail2] like '%
test@kpmg.com%')

I have two questions:
Is there anyway to pass parameters from an Access Data
Project directly to a either an SQL Transform Data Task
or an Execute SQL task?