Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-16-2019, 06:17 AM   #1
Alhakeem1977
Newly Registered User
 
Join Date: Jun 2017
Posts: 108
Thanks: 34
Thanked 0 Times in 0 Posts
Alhakeem1977 is on a distinguished road
How to set a Unique number for Barcode values in MS Access

What is the best approach to set a Unique number for Barcode values?

To be used reference our customers files may one customer has many files depends on account type.

The minimum value would be the best.

I heard about algirthum is it ok to use?

Thanks in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk

Alhakeem1977 is offline   Reply With Quote
Old 05-16-2019, 06:46 AM   #2
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 13,526
Thanks: 73
Thanked 1,473 Times in 1,362 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: How to set a Unique number for Barcode values in MS Access

I am not sure what you are asking because I can think of several possible interpretations of your question. If you want a unique number for a customer, you might wish to see if there is a customer number used as a Prime Key (PK) in your list of customers. Per Access rules, a PK is necessarily unique for any single table. The PK, if assigned as an autonumber field, starts from 1 and can be defined to auto-increment when you add a new customer, so that is about as "minimum" as it gets. It would be suitable as a way to reference customer files, I suppose.

You mentioned some algorithm and asked whether it was OK to use but did not name the algorithm so I can't address that part of the question. I also don't know where barcode values fit in for your question.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 05-16-2019, 08:44 AM   #3
Alhakeem1977
Newly Registered User
 
Join Date: Jun 2017
Posts: 108
Thanks: 34
Thanked 0 Times in 0 Posts
Alhakeem1977 is on a distinguished road
Re: How to set a Unique number for Barcode values in MS Access

Quote:
Originally Posted by The_Doc_Man View Post
I am not sure what you are asking because I can think of several possible interpretations of your question. If you want a unique number for a customer, you might wish to see if there is a customer number used as a Prime Key (PK) in your list of customers. Per Access rules, a PK is necessarily unique for any single table. The PK, if assigned as an autonumber field, starts from 1 and can be defined to auto-increment when you add a new customer, so that is about as "minimum" as it gets. It would be suitable as a way to reference customer files, I suppose.

You mentioned some algorithm and asked whether it was OK to use but did not name the algorithm so I can't address that part of the question. I also don't know where barcode values fit in for your question.
First of all thanks for your prompt response, I meant by Barcode value is that, to get a unique reference from a built in function or some how to reference my Barcode, unfrtuantly if I use the PK then there will be a missing numbers because of reverting in data entry process. Any further clarification can be provided.

Sent from my HUAWEI NXT-L29 using Tapatalk

Alhakeem1977 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
get a number of unique values without separating values that belong to the same block lala Modules & VBA 12 12-22-2014 09:09 AM
Creating an unique ordered number field with auto shifting values. TaSMaNiaC General 4 06-02-2013 12:44 PM
Create a Number for Unique Values t_bard Queries 27 11-14-2011 07:19 PM
how to display barcode of a unique number using vba aman Modules & VBA 9 12-03-2009 04:11 AM
number of unique values in list sloth Queries 1 08-23-2002 12:12 PM




All times are GMT -8. The time now is 12:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World