Find Jobs
Hire Freelancers

Decode a GS1 Code in MS Access 2019 VBA

$30-250 AUD

In Progress
Posted over 4 years ago

$30-250 AUD

Paid on delivery
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.
Project ID: 20758338

About the project

5 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
5 freelancers are bidding on average $156 AUD for this job
User Avatar
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). Regards, Branislav Mihaljev
$180 AUD in 7 days
5.0 (322 reviews)
7.9
7.9
User Avatar
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 codes are already in the database or they are going to be uploaded in an appropriate format (CSV, TXT, Excel, etx.), but it doesn't really matter. I will charge you $150* and can deliver within three days (I don't require any payment in front). I'm among the most experienced and skilled Access, and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 320 projects successfully in six years, and I feel confident in achieving your task as well. I'm online from 8 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$150 AUD in 3 days
4.9 (259 reviews)
7.7
7.7
User Avatar
*** 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 on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$90 AUD in 6 days
4.8 (92 reviews)
7.4
7.4
User Avatar
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 developer for Financial system developed in MS Access. Until now, I work with VBA coding and gained excellent experience and knowledge I can develop your project with your high satisfaction. Hope to hear from you back soon. Regards, Alta
$222 AUD in 7 days
4.9 (21 reviews)
5.2
5.2
User Avatar
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 in 7 days
5.0 (8 reviews)
4.0
4.0

About the client

Flag of AUSTRALIA
Burleigh Heads, Australia
4.9
2
Payment method verified
Member since Dec 7, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.