Search results

Thanks a lot, i appreciate your help.

Thank you very much for the detailed explanation. I am trying to create a database where i want the ID to be a autonumber which i am able to do it but i wanted to add "Test" before the autonumber. Write now the way it is, My number is starting from 4000 and then it been continue like 4001...

Hi, Did you get a chance to look at the SQL statement?

Thank you. Here is SQL Statement INSERT INTO Ticket_Tracker_Table ( ID ) SELECT 4000 AS Expr1; If i put Test before 4000 and run the query. I get the pop up window, it says "Enter Parameter value. When i write Test4000, it says Data type mismatch in the criteria expression.

Thanks. Write now when i click on my Queries. It gives me Field: Exper1:4000. Where do i need to add Test? I have put the Access database in shared folder. How can i make sure users only user forms for interaction? Thanks for your help

Hi, I will like to add "Test"before the Auto number. i have created a query and number is starting from 4000. Can someone please suggest how it can be done? Also Is it possible to restrict a user to delete the rows? can we setup a password so all the users cannot delete? I would appreciate if...