진행중

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

Results:

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

11 - PROD DATE

21 - SERIAL NUMBER

242 - ADDITIONAL ID

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.

기술: 마이크로소프트 엑세스, 비쥬얼 베이직, 소프트웨어 아키텍처

확대 보기: 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

고용주 소개:
( 1 리뷰 ) Burleigh Heads, Australia

프로젝트 ID: #20758338

수상자:

manujain90

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 더 보기

$190 AUD (3일 이내)
(0건의 리뷰)
0.0

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 8명, 평균 입찰가: $147

branislavm

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) 더 보기

$180 AUD (7일 이내)
(262 리뷰)
7.4
fabest

*** 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 더 보기

$90 AUD (6일 이내)
(91 리뷰)
7.4
paris2785

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 더 보기

$150 AUD (3일 이내)
(184 리뷰)
7.2
Altantsetseg

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 더 보기

$222 AUD (7일 이내)
(20 리뷰)
5.1
alhassanlatif

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일 이내)
(8 리뷰)
3.9
SashaMorozov

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 더 보기

$100 AUD (3일 이내)
(3 리뷰)
1.6
creative3D8293

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 더 보기

$100 AUD (2일 이내)
(2 리뷰)
1.1