Рет қаралды 9,899
In this video you will learn how to quickly assign values to records in a continuous form and then automatically move to the next record with the GoToRecord acNext command. Just a tiny bit of VBA is involved. I'll show you step by step.
LEVEL: Developer (A little VBA)
Santiago from Rio de Janeiro, Brazil (a Platinum Member) asks: Every day I get a list of jobs that I have to assign technicians to. There is no rhyme or reason to it, so I can't make an update query to handle the task. There's no real "criteria" for who gets it. I just look at a brief description of what the job entails and I know which tech to assign it to based on their skills, the customer, etc. I have four techs and right now it's a lot of copy and paste. I just go down the list and copy and paste, copy and paste. Can this be simplified at all? Even if I could just have a button for each of my three techs, that would make things so much easier for me. Click a button and it assigns the tech and moves to the next record.
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video. We'll add copy and paste buttons, as well as a button to copy the current value to all of the records, and to all of the records from the current position to the end of the list.
MEMBERS ONLY VIDEO:
• Fast Form Update Quick...
BECOME A MEMBER:
/ @599cd
LINKS:
Relational Database: 599cd.com/Rela...
Relational Combo Box: 599cd.com/Rela...
GoToControl: 599cd.com/GoTo...
GoToRecord: 599cd.com/GoTo...
While Loop: 599cd.com/While
Intro to VBA: 599cd.com/Intr...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/Tech...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
Email Me: amicron@gmail.com
WHAT DOES LEVEL MEAN:
My Access classes are divided into multiple levels. BEGINNER requires little working knowledge of Access. EXPERT assumes you know relationships and how to use functions. ADVANCED users know macros and events. DEVELOPER uses SQL and/or VBA programming.
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, update records, quick update, fast update, GoToRecord, acNext, jobs, technicians, sales reps, copy, paste, gotofirst, while loop
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.