Decode a GS1 Code in MS Access 2019 VBA

We are trying to decode GS1 codes provided on manufacturers on new equipment. We want to store this information in an ms access 2019 database via VBA.

We need to be able to input a numeric string and have it decoded according to GS1 Standards.

The code is required to be in VBA for MS Access 2019.

input is a single string, output data should be in line with these application identifiers

the data arrives via scanner without brackets surrounding the application identifiers

example: 010012345678901210154565545421991231

we then need to identify the identifiers: (01)00123456789012(10)1545655454(21)991231


01 GTIN 00123456789012

10 BATCH/LOT 1545655454

21 SERIAL 991231

here is a web based example is below, it is capable of identifying the identifiers and seperating the data accordingly.

[login to view URL]

These are the GS1 application identifiers we need to be able to identify, there may be others present in the code but we can disregard them.

01 - GTIN

10 - LOT




422 - ORIGIN

so to confirm, we need to scan a similar code - 010012345678901210154565545421991231, and identify the elements and the appropriate data in VBA, then store/make available the data in individual fields or output variables.

Taidot: Microsoft Access, Visual Basic, tietojärjestelmäarkkitehtuuri

Näytä lisää: csv access database vba code, access 2007 vba code print pdf, progam code access 2007 vba download file ftp, working access recordsets vba code html, access 2007 vba code print report pdf, vba code save access report pdf, access 2007 print report access pdf vba code, backup restore facility code ms access vb net, email vb code ms access examples, form level validation code ms access, ms access vba code copy paste subform form, ms access vba code ftp download, search project code ms access, visual basic code ms access search, freelance ms access excel vba programmer, ms access excel vba, Data collection forms using MS Access and VBA - open to bidding, ms access vba code examples, ms access references vba, ms access print separate pdf vba code

Tietoa työnantajasta:
( 1 arvostelu ) Burleigh Heads, Australia

Projektin tunnus: #20758338

Myönnetty käyttäjälle:


Hi I've read the above description thoroughly and I can help you write a VBA code to decode the String into the GS1 Code. I can do that in MS Access. Given the instrustions you have provided, I will split the string i Lisää

$190 AUD 3 päivässä
(0 Arvostelua)

8 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello! Let me know do you know how to decode GS1 code or at least where I can find how it can be done? I can easily write a VBA code to decode it. I'll try to find it myself how it can be done (what each number means) Lisää

$180 AUD 7 päivässä
(262 arvostelua)

*** I can decode your GS1 code *** Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus Lisää

$90 AUD 6 päivässä
(91 arvostelua)

Hi, there! My name is Paris, and I was glad to see that you're looking for an Access developer. According to your brief, you want to have an Access database to decode GS1 codes. It's not clear in your brief if these co Lisää

$150 AUD 3 päivässä
(184 arvostelua)

Hi. From your project declaration, it's the kind of project that I have been experienced well. I have been experienced in programming including Ms Access since 2000. During 2006-2013, I had been working as a senior dev Lisää

$222 AUD 7 päivässä
(20 arvostelua)

Hi, I am a professional Access developer I am also using MS Acess 2019 I can finish the required work contact me for details

$140 AUD 7 päivässä
(8 arvostelua)

Dear sir. I have just read your requirements carefully. I am very interested in your project. Although I am new in freelancer, I have more than 8 years of experiences in VB & VBA. I'm an expert in Excel, algorithm and Lisää

$100 AUD 3 päivässä
(3 arvostelua)

Hi, there! I have read your description carefully and understood clearly. I have rich experience in VBA programming. I am sure I can help you. Please contact me so we can discuss more details. I hope work with you. Tha Lisää

$100 AUD 2 päivässä
(2 arvostelua)