Find Jobs
Hire Freelancers

Access VBA Code

$30-250 USD

In Progress
Posted over 9 years ago

$30-250 USD

Paid on delivery
Hello, I would need do update a table record in a table, based on a state indicator. New records are added with state = I (Insert). A previous record is cancelled by providing a new record with state = C (cancelled) and the same trade identifier as the record being cancelled. Where a record has beenprovided with BO_State cancelled, no further records with the same trade identifier will be provided. A previous record is amended using the reversal/amend approach. First, the previous record is reversed with state = R (reversal), and then a new (amended) record is written with state = A (amend). I only want to see current record. On top of this I would need to have a table that provides information contained in 2 rows on a single row based on the records have a same Order ID
Project ID: 6764620

About the project

10 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Please share the access file..... we can get started... please reply, thank you !
$35 USD in 1 day
5.0 (7 reviews)
3.4
3.4
10 freelancers are bidding on average $141 USD for this job
User Avatar
Hi, Let me introduce myself as an expert in MS Access programming. I have worked extensively on MS Access 97,2000, 2003, 2007,2010 projects both big and small using MS Access as a front end as well as back end. I have worked on Forms, Queries, Modules, Reports, Sub Reports, Macros, Switch Board Manager, Linked Table Manager etc. With the kind of experience I am having I can assure you of quality work first time and on time On this highly competitive site I fully understand how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$150 USD in 5 days
4.9 (54 reviews)
5.5
5.5
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$231 USD in 3 days
4.9 (23 reviews)
5.0
5.0
User Avatar
Good Day, I would like to express my interest in your project. I am a holder of a BSc. (Hons) Computing degree from the University of Greenwich (UK) and have over 8 years professional work experience in the IT industry, holding various technical and administrative/supervisory positions. I have an excellent grasp of MS Access, MS Excel, Visual Basic for Applications, database design/development, SQL, MySQL, data import and export to MS Excel, txt, pdf, emailing reports as attachments, etc. I would be very glad to develop your Microsoft Access Database. Please find below some MS Access applications that I have worked on: ( A ) MARKETING CONTACTS DATABASE: Complex database for keeping track of clients who are targeted for various marketing campaigns. Utilises complex SQL queries to filter clients based on various criteria. Includes bulk importing and exporting of data to CSV/Excel. ( B ) PROJECT MANAGEMENT DATABASE: For management of Project and related data, report generation and emailing of reports as pdf attachments, etc. ( C ) MEMBERSHIP MANAGEMENT SYSTEM: For management of Membership and related data, barcode printing on member ID cards, barcode event registration, etc. I would like to assure you that I am committed to providing you with a solution that meets and where possible exceeds your requirements. (Excellent reviews and work samples are available on my profile page.) Please feel free to contact me in case of any queries. Thank you. Sincerely, Jeane
$150 USD in 7 days
5.0 (5 reviews)
4.9
4.9
User Avatar
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft database (Access ,Sql Server) development and administration on several projects . My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with SQL Server and access databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Access development and Visual Basic to develop all types of requirements related (Forms ,Queries ,Reports ,Database conception and enhancements) ,and given my experience, i am persuaded to give you High quality of work delivery withing budget and time Best regards,
$144 USD in 3 days
5.0 (8 reviews)
4.8
4.8
User Avatar
Hi, I am interested in this project. I am an experienced IT professional with hands on experience of MS-Access database applications using VBA. I can do the job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks, Regards, Jawad
$66 USD in 3 days
4.9 (19 reviews)
4.4
4.4
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I believe I can deliver in 2-3 days. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$190 USD in 8 days
4.6 (11 reviews)
4.3
4.3
User Avatar
Hi, I have gone through your descriptions, I am 7+ years experienced Visual Basic,VB.NET,ASP.NET,MS Access,MySQL,SQL,MSSQL Server(2005 to On wards) developer at CMMI-5 level company.I can do your job easily before your deadline . I can give you the proper steps which will be followed by the Software development stage. Let me know when can we discuss more about the project. I am very much Interested to do your work,Please revert me if you have any concern.
$160 USD in 5 days
4.6 (4 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
genevA, Switzerland
5.0
15
Payment method verified
Member since Nov 3, 2014

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.