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...
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...