Recent content by cytomatrix

Thanks namliam. But, it does matter to me especiallly when using autonumber for fields like customer Id or member ID. Is there a way to reset the autonumber?

I have a database in access that allows user to create a record that uses the autonumber to create the primary key. On occassion, the autonumber generates a key, but the user may later choose to undo the insertion of that record. This all works fine except, after the user undo's the insertion of...

Worked.. Thanks alot jgc. It worked. I really appreciate it. :D

Thanks. Actually i am trying to assign the result of that query to a variable. Sql bit is fine. I just want its result to be assigned to a variable. Thanks a lot again in advance.

Hello guys, This is my first post. I am just try to create a car booking database for fun. I wanna assign the result of SQL query to a variable. SQL query is quiet simple. SELECT Customers.[First name] FROM Customers WHERE (((Customers.[Customer ID])=10)); Instead of '10', I wanna assign a...