Hi I am making the switch from Access to SQL server and I can not make one
of my queries work.  Can you give me some idea on how to do this?
I need to have a countdown from today's date to a future date.  I am using
the DateDiff but I am getting a negative number when I need a ...

Please help me URGENT
How do i make an tableField with a
Auto-Incr, the same like in an access DB where it's
called AutoNumber

any help anyone can give me would be greatly appreciated.  i feel like
i've tried EVERYTHING..here's the situation:
access2k(sp3) -> sqlserver2000(sp?); a project management database:
affected tables:

I have a situation in which I need to have a combo box in a main form in
which the bound column is an Integer value, send the selected value as a
parameter called '@SchoolNum' to a SQL Server 2000 Stored Procedure called
'InstrumentStudentAssign3_sp'. This procedure is the record ...

I'm trying (and failing) to use parameters passed into stored
procedures within an IF statement in an ADP application fronting
SQL Server. Boiled down to the essence, the stored procedure code
looks like this:

For some reason my ADP project will no longer connect to
SQL server. The BIG problem is it will not open up the
Data Link Properties dialog box where I can change or
edit the connection. All I get is the MS error report and

Got this ADP works fine with AC2000.
I am watching the Profiler and AC2002 is sending all these command for
simple execute.
The profiler show this for AC2K

I have a ADP file which connect to SQL7 and it is working
fine. Today I convert it to a ADE file and it works fine
on the original machine. When I copy to another machine I
receive the following error:

Hello, everyone.
Within the past few days there was a post about using a
stored procedure with a parameter as thr recordsource for
a listbox. An answer was supplied by SFAxess. I have

Microsoft Partner
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting

I have form with an On Current event with the following code:
Private Sub Form_Current
    DateVal = "" & Me!LotterySubmissionDate
    If DateVal = "01-Jan-1900" Then

I'm using a basic find command in conjunction with a combo
box on a form to enable users to jump to a specific record
quickly. The SQL Server table contains less than 1000
records and is indexed (primary key) on the field I'm

Sorry for the major crosspost--but in my defense I *did* try to pick
relevant groups!
Recently I have started having a problem in an Access 2000 ADP with SQL
server backend.  I've done a lot of work trying to figure this out, and here

I am trying to convert a query that did not get converted with the Upsizing
Wizard.
The query needs to return a record only if the primary key is not in another
related table.  So basically I am trying to show all of the orders that are

Has anybody an idea how I could execute VBA procedures or functions from an
access 2000 ade form?
I would like to generate a hidden administrative form with a text field to
put in vba procedure calls and execute them from an ade without having