I'm using ACC2000 and SQL Server 2000.
The main form uses three subforms. .
In the open event of the main form I set the current connection.
  CurrentProject.OpenConnection ConnectionString

I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what a spreadsheet might show, the
column names will actually be dynamic, based on data from a SQL ...

The following procedure returns the data I want but I need to show just the
latest instance of each s.CurrencyCode in order to populate a combobox,  any
help greatly appreciated!
Alter PROCEDURE dbo.sp_ROECurrent3 @LessDate datetime

I need to create a SQL statement that will return rows
from one table that were supposed to be appended to
another.  In other words:
Show me all rows in table A where the (ID, Code and Date)

We're using Access and FrontPage 2003 and want to post a database on the Web
which we've never done before. I've been told that MS improved Acess for Web
database development in the 2003 version. (Apparently Access releases the
connection quicker than it used to making it more ...

I am using an .adp file which is connected to the SQL
Server.  I have created a query stored procedure.  I now
am trying to search through one field, called NOTES, for
whatever the user inputs.  In the criteria cell for the

I'm having trouble in SQL Server with an ADP in
concatenating fields where a value may be null. For
example, creating a single name field from separate last
name, first name, middle initial fields, where the middle

I get VB error 3709  - The connection cannot be used to perform this
operation. It is either closed or invalid in this context. Stopping at the
Set rs = CMD.Execute line when running the code below:
All I want to happen is for the ShipmentID field in the sp_ShipmentCurrent

I am guessing this has been covered here before, but can't seem to find a
definitive solution in my dejanews searches.
I have an Access ADP app that uses the "DoCmd Openform" construct that
passes a "where clause" to the form being opened.  This gets passed, of

I have built an MSDE adp project that I want to create an
MSI installation package for.
I know how to discover the machine name using VBA, but
don't know how to set the server name property in an un-

I have an sp that inserts a record from one table to another based on a
parameter that works fine. How can I use a field on an MSAccess form to be
the parameter?  I can get the sp to run from the form but only to prompt me
with the parameter required I want this to be the current ...

I've got an adp  database that I created from Access.  Some tables I created
with the Access UI, and some with a SQL script executed via JDBC.
Some of the tables created via JDBC are read only in access, but some are
read-write.  ie I can or cannot add/edit records in these tables.

I made an insert using a Stored Procedure (MS SQL 2000).
How can I store the ID of the last inserted record into a session var ?
I have code to do this with a regular "Insert" page (Using Dreamweaver), but
didnt work for the SP.

I'm using an Access 2000 (9.0.6926 SP-3) ADP as a front-end to a SQL Server
2000 (8.00.760 SP-3) database.  SQL Server is running on a dedicated server.
There is a certain query, based on a view, that completes in about two
seconds via Query Analyzer.  (It's a straightforward SELECT ...

Hello, how can i set server filter on loading form? I use
Me.ServerFilter = "Bylos_nr = '&[Forms]![teise]![Bylos_nr]&'"
Me.Refresh
But recyve error : invalid sql statement