Immediate Window in MS Access

http://databaselessons.com/blog/using-the-immediate-window/ Use the Immediate Window in MS Access to quickly test the use of a function before using the function in a query or in some VBA code. To load the immediate window, press Ctrl-G on your keyboard.

Examples used in the video are:
? 5*8
? now
? dlookup(“[CourseName]”,”Courses”,”CourseID=2″)
? dlookup(“[StartDate]”,”Courses”,”CourseName=’Basket Weaving 101′”)
? dlookup(“[CourseName]”,”Courses”,”StartDate=#Jan 26, 2015#”)

This is part of my video series for Microsoft Access VBA beginners.

Тэги:

#Microsoft_Access_(Software) #function #vba #immediate_window #tutorial #visual_basic_for_applications

Скачать видео