titorober23
asked on
how to generate unique labels
Hi
I designed a database in access and have some items for sale, to register those in my new system i would like to generate labels with unique codes, so i can later scan them and enter in the system.
Any idea how to generate those labels, which have to be unique, i mean everytime that i need more labels it has to generate different ones.
thanks
I designed a database in access and have some items for sale, to register those in my new system i would like to generate labels with unique codes, so i can later scan them and enter in the system.
Any idea how to generate those labels, which have to be unique, i mean everytime that i need more labels it has to generate different ones.
thanks
ASKER
hi
it's confuse
how do i implement this idea
it's confuse
how do i implement this idea
Ok, easier solution.
You have a table in your database that holds rows of data of each item.
The table (Items) table, should have columns
Description
Price
Entered date.
You can add a column to this table say ID and set the property of the column to be Autonumber.
This will automatically create a unique number for each row in the table and new rows that are added.
Rog
You have a table in your database that holds rows of data of each item.
The table (Items) table, should have columns
Description
Price
Entered date.
You can add a column to this table say ID and set the property of the column to be Autonumber.
This will automatically create a unique number for each row in the table and new rows that are added.
Rog
titorober23,
You already have the same question open here:
https://www.experts-exchange.com/questions/23780010/I-WOULD-LIKE-TO-GENERATE-UNIQUE-NUMBERS-IN-A-REPORT.html
Please do not post duplicate questions.
If you are not getting responses, please click the request Attention button in your original question.
and explain the situation.
Creating a duplicate question simply confuses things here and experts do not know which question you will eventually delete when you get your final answer.
Situations like this are what the "request attention" button is designed to deal with.
So, now, *please* click the request Attention button in your original question, and ask for help in resolving this issue.
;-)
Thanks.
JeffCoachman
You already have the same question open here:
https://www.experts-exchange.com/questions/23780010/I-WOULD-LIKE-TO-GENERATE-UNIQUE-NUMBERS-IN-A-REPORT.html
Please do not post duplicate questions.
If you are not getting responses, please click the request Attention button in your original question.
and explain the situation.
Creating a duplicate question simply confuses things here and experts do not know which question you will eventually delete when you get your final answer.
Situations like this are what the "request attention" button is designed to deal with.
So, now, *please* click the request Attention button in your original question, and ask for help in resolving this issue.
;-)
Thanks.
JeffCoachman
ASKER
Hi
I understand adding a new field o that table, but the numbers of records won't grow as fast as the numbers of labels that i want to generate.
i need an example how to generate unique numbers, everytime that i request them.
I understand adding a new field o that table, but the numbers of records won't grow as fast as the numbers of labels that i want to generate.
i need an example how to generate unique numbers, everytime that i request them.
You must be printing more labels than items?
You could create a label table. Have a row for each label you print. In this table have a column that is set to Autonumber. WHen you print a label, you can then add a row. Using the Autonumber field as the label.
Rog
You could create a label table. Have a row for each label you print. In this table have a column that is set to Autonumber. WHen you print a label, you can then add a row. Using the Autonumber field as the label.
Rog
ASKER
I have the same idea, but how do i append n rows to a table everytime that i request n labels
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This table would then house the last label (Number) that was used.
Each time you create a label, you increment this number by one and so on.
The table would always hold the last number used.
Rog