By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,808 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

MSAccess Query Criteria

P: n/a
hi friends

I am facing problems generating a query from access database.
I have a form which fills all the records, validates and then send the
collected info to the db.

Now the problem part, I need to chk or validate the current records by
the ID number which is unique and is not to be duplicated.

So i am trying to generate a query by select statement, no go

then i saw this type of database dsnless connection..
set rs = Server.CreateObject("ADODB.recordset")
rs.open "Customers", conn

' Method 1
rs.addnew "FirstName", "Rich"
' Method 2
rs.AddNew Array("FirstName", "LastName"), Array("Rich","Smith)

' Method 3
myFieldList = Array("FirstName", "LastName")
myValueList = Array("Rich", "Smith")
rs.AddNew myFieldList, myValueList

rs.close
set rs = nothing

conn.close
set conn = nothing
My question ????
can we do it with msaccess database and whether do we need to have some
extra configurations configured at my ISP's end ?

2nd...
how do I validate the current records by the ID number which is unique
and is not to be duplicated.(being taken from the user which filling
the form)

thanks

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.