Thanks Jeff and Sushila for your help.  It has pointed me in the direction I need.  I was able to get the skeleton of what I need from your pointers. 

Many...

Problem solved - amazed with 93 views no replies received.

The solution is that when a port is opened and closed quickly it remains out of use for 240 seconds. Also...

Error Message:

Run-Time Error '-2147467259 (80004005)'

[Microsoft][ODBC SQL Serverver Driver][TCP/IP Sockets]

SQL Server does not exist or Access Denied.

This occus after it has entered just short of 4000 entries.  It only happens

on...

Cleech,

When you change the filtered Combo you are undermining the very filter is operates on.

Can I suggest:

Change to ordinary form with subform display. In the main form create your combo...

Michael,

@contractid = me![contractid]

Richard

Michael,

The conversion process from MDB to SQL may have created a different field type. Check that it is a numeric field. Also - in case there are nulls use the...

Thanks - but I managed to solve it - learnt alot along the way - so a worthwhile exercise.

Richie

James,

If he tried from Access then he probably hasn't setup the DSN in ODBC.

Control Panel, Admin, ODBC.

Create the same DSN name as you have saved in yours and it should...

James,

I keep a generic Pass Tru Query called QExec.

form the following code you will see how it works:

mSQL = "EXEC SP_ADDCUST "

mSQL = mSQL & "'" & MCUSTCODE & "'"

mSQL...

Change the line of code as follows:

db.Execute "INSERT INTO Subjects (Subject) Values ('" & Newdata & "')"

ie   (  '  "  &  newdata &  "   '  )  "

Richard

On the toolbar in design view , there is a properties button.  It allows you to specify the ODBC connection string.

One further point is that it asks - Return Records...

To execute the SP create a Query in Access as a Pass Through Query. Then

Exec sp_ConsolidatedTC

will execute the query. It would help to know the purpose of the SP.

MKeast,

Thanks for the above info. I tried your steps but to no avail yet.  I will retry again later. 

Many Thanks

Richard

Where can I set the  SET DATEFORMAT DMY so that it applies to DTS operation

Use inline subqueries

SELECT Student.STUDENTID, (select count(classid) from attendance where studentid=student.studentid) AS Classes,

(select count(classid) from attendance where studentid=student.studentid and attended="Present") AS Present,

(select count(classid) from attendance where studentid=student.studentid and attended="Absent")...