If you use Access Project, you try this out.

CurrentProject.Connection.Execute "EXEC sp_password '" & Me.txtOld & "', '" & Me.txtNew & "'"

You can use IN operator to help. You might check this sp out by testing in Northwind database.

Create Procedure spGetEmployee

@EmployeeIDs varchar(500)

AS

declare @sql varchar(1000)

select @sql...

You can save the current record to force it to get the auto id.

Just use the code below and see if it works the way you want.

DoCmd.RunCommand acCmdSaveRecord

If you use Access Project, you shouldn't have the problem at all.

Anyhow, what field1 in the Create View statement stands for? Or it's a typo?

CREATE VIEW dbo.vwMyView

AS

SELECT field1, name,...

Thank you both again.

Here's what I used before posting the question here.

select (

select count(*)from products

as temp

where convert(int,(right(temp.product_id,6)))<

convert(int,(right(products.product_id,6)))

)+1 as no, product_id

from products

I was looking for something else...

Thank you, Steve.

So life is not that e-z with SQL Server, huh?

Edited by - kaeg on 08/24/2003 11:35:06 PM

You have to supply the dayx (I guess it's Integer) to the code and make the sql 1 as a parametered sql like this

sql1 = "PARAMETERS dayx Short; "...