No, I don't know of any. There is no such feature as parameterized queries in Access, which prompt you at runtime for a value of a parameter.

However, you can...

That 'quick reply' feature is really neat and handy.

Actually, this new window is not that bad at all. But what annoys me, is that when you post a reply,...

Changing your varchar decalration to nvarchar should do it

In EM, right-click on the db in question, select All tasks, Generate SQL script, select 'Show all', check 'All Stored Procedures. Then choose the other option you'd like, and there...

Can you post what you've got so far?

Don't know if this also applies to ADP, but in 'normal' Access DBs' there is a db setting, you'll find in Extras ?!? ->Options on a tab, I guess it's...

To answer your question, would this help?

declare @search nvarchar(50)

declare @stmt nvarchar(4000)

set @search = '53129,53128,53127'

set @stmt = 'select * from mails_header where id in ('+@search+')'

exec sp_executesql @stmt

To be honest, I don't know. Best bet I can give you is to look after the user contributed notes in http://www.php.net/manual/en/function.mssql-connect.php 

I once tried to connect to SQL Server...

Does this help?

http://www.php.net/manual/en/ref.mssql.php

Send me a private message with your email address. There are two mails from January. I'll forwards them to you.

David, didn't you receive one sent by Andy on Sunday, 01/25?

I don't know of a way to get this value before inserting without querying the system tables.

However, wouldn't SCOPE_IDENTITY() also do the job?

Maybe this would help

http://www.abaris.se/abaperls/

IIRC, if you are familiar with C or C++ you should be able to do something like

<pseudocode mode on>

common_code.h:

CREATE PROCEDURE get_tbl

SELECT * FROM...

Thomas,

see I'm in a position I doubt anyone else here on the forum is. I don't do programming for a living anymore This...

When you search the site, you'll find several scripts on that topic. My opinion is to do that at your client. With ASP this should be an easy exercise.