How to Add New Records on the Top of a Continuous Form in Microsoft Access
HTML-код
- Опубликовано: 21 окт 2024
- In this video, I will show you how to add new records at the top of a continuous form instead of at the bottom, which is the default setting.
David from Woodbridge, Virginia (a Gold Member) asks: I have a continuous form which sorts records by date with the most recent entries at the top. I have a button that allows me to add a new record, but it adds it at the bottom. Is there a way to add the new record at the top of the form?
Silver Members and up get access to an Extended Cut of this video. Members will learn a more elegant solution by collecting the data in unbound fields, performing checks on that data, and then adding the record using SQL before requerying the form.
MEMBERS VIDEO:
• New Record on Top EXTE...
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/NewR...
LINKS:
Continuous Forms: 599cd.com/Cont...
Intro VBA: 599cd.com/VBA
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, new record on top of continuous form, New record at top of continuous form, add new record at top of form, Continuous Form New Record at Top, gotorecord, acnewrec, requery, gotorecord, acfirst, gotocontrol, isnull, db.execute
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.