access course - combo boxes data access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access course - Combo boxes in Data Access Pages

access course - Combo boxes in Data Access Pages

resolvedResolved · Low Priority · Version Standard

replyReply Wed 13 Jun 2007, 15:48Delegate Ricardo said...

Ricardo has attended:
Access VBA course
Access Advanced course

Combo boxes in Data Access Pages

Hi

Once you have created data access page, is it then possible to have that data access page retrieve and display data records using a combo box as a search box? (I.e. is it possible to duplicate the "retrieve-records-based-on-a-combo-box-functionality" in a form, but in a data access page format?)

Thanks

Ricardo

For upcoming training course dates see: Pricing & availability

replyReply Tue 19 Jun 2007, 11:39Trainer Richard said...

RE: Combo boxes in Data Access Pages

Data access pages are generally very simple in their layout. What I notice about them is that there is no EVENT tab on the properties box, so it is challenging to copy the functionality that you could build into a form using a drop down and command button.

I am not familair with VBA and what it could do in this case.

 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard