Access Update Records VBA Coding

Will pay $25 flat fee for below. Must done within 48 hours.

Create code in VBA that I can trigger as an event from a form – eg on click event, or I can run at a set time every day embedded in a module. (See FrmCheckData and have code run onclick event)

My database is broken into a frontend and backend with the backend located in a different folder location.

c:\frontend\training,mdb

With table stored in

C:\backend\[login to view URL]

Task

For each Company field (eg 27751) check if there is another record in the table that matches that company code( 27751) (You will see there are 2 entries for 27751). Note if there may be records that have 3 or more entries

Then

Copy the data from the fields below and paste into the other record if the field is blank – For the following fields only. If some fields contain data then just the fields that are empty. I need it to run for partially completed records. Eg a record may have a DOB but not the other fields completed. Important the code does not overwrite any data.

Microsoft Access Visual Basic

Ταυτότητα Εργασίας: #5726125

Σχετικά με την εργασία