Færdiggjort

Access VBA - Event

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.

Evner: Microsoft Access, Visual Basic, Visual Basic for Apps

Se mere: vba return line logfile, copy paste text vba access, access copy paste vba code, access form load event, ms access [event procedure], access vba run code when form opens, access on current event, access report events, access textbox events, ms access event procedure open form, access vba event when record changes, excel vba show workbook closing current workbook, copy paste report access vba, access vba form text copy paste, access 2003 vba copy paste report, access vba copy paste forms, copy paste vba access 2003, access copy paste vba, access vba event application close, access vba position line

Om arbejdsgiveren:
( 70 bedømmelser ) United States

Projekt ID: #19283047

Tildelt til:

jrsmoots

Hi: I've been developing for MS Access and MS SQL Server for over 20 years. Please see my LinkedIn profile/resume: [login to view URL] I have experience developing complex Electro Flere

$25 USD in 2 dage
(0 bedømmelser)
0.0

8 freelancere byder i gennemsnit $28 på dette job

VladimirLilenko

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 possibl Flere

$30 USD på 1 dag
(139 bedømmelser)
6.4
royalcalif

Let me review the existing database to calculate the appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to Flere

$30 USD på 1 dag
(77 bedømmelser)
6.0
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 Flere

$30 USD på 1 dag
(10 bedømmelser)
4.1
vw1514518vw

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 på 1 dag
(1 bedømmelse)
1.4
arashbahrami1

Hi, I am expert in web application development and also have experience over 10 years in security and quality assurance fields. I think I can do it for you as soon as possible. In order to see my customers projects Flere

$30 USD in 2 dage
(0 bedømmelser)
0.0
$25 USD på 1 dag
(0 bedømmelser)
0.0
alokes

HI, I AM A SOFTWARE PROFESSIONAL DEVELOPING SOFTWARE IN MS ACCESS WITH VBAFOR LAST 20 YEARS. I WOULD LIKE TO DEVELOP THE DATABASE IN MS ACCESSAS PER YOUR REQUIREMENT AND INPUT PROVIDED BY [login to view URL] TASK WILL BE COMPLETED Flere

$25 USD på 1 dag
(0 bedømmelser)
0.0