Find Jobs
Hire Freelancers

Access VBA - Event

$10-30 USD

In Progress
Posted almost 5 years ago

$10-30 USD

Paid on delivery
I have an Access DB. 2 tables, one form. As I cycle through records on the form I need the system to check a matching ID field between the tables and copy some information from one table to another. tbl_EMPS tbl_WORKING frm_WORKING When cycling through records in frm_WORKING (I need you to create the "Current Action" vba script) IF [tbl_EMPS].[CODE] is not null WHERE [tbl_EMPS].[Active]=True THEN Copy/Paste the [tbl_EMPS].[CODE] into [tbl_WORKING].[CODE] WHERE [tbl_EMPS].[IDField] = [tbl_WORKING].[IDField] Else 'do nothing So when a record loads, go see if the matching IDField is ACTIVE in tbl_EMPS, if so copy the CODE from that same active line into the CODE field of the form.
Project ID: 19283047

About the project

7 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
7 freelancers are bidding on average $29 USD for this job
User Avatar
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
$30 USD in 1 day
4.9 (251 reviews)
7.1
7.1
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 which use VBA for coding. Until now I work with Access coding and gained excellent experience. I can complete your task with your high satisfaction. Ready to start. Hope to hear from you back soon. Regards, Alta
$30 USD in 1 day
4.9 (9 reviews)
4.5
4.5
User Avatar
Nice work, Consider it done , finding matching records between 2 tables You can get all matching record between the 2 tables on one screen at once too USD 30 , 1 day CHEERS!
$30 USD in 1 day
5.0 (2 reviews)
1.8
1.8

About the client

Flag of UNITED STATES
Hutchinson, United States
5.0
75
Payment method verified
Member since Apr 5, 2005

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.