access course - Combo boxes in Data Access Pages

Resolved · Low Priority · Version Standard

Combo boxes in Data Access Pages

Ricardo has attended:
Access VBA course
Access Advanced course

by - delegate Ricardo [8 posts] (2007 Jun 13 Wed, 15:48) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Combo boxes in Data Access Pages

by - trainer Richard platinum contributer [818 posts] (2007 Jun 19 Tue, 11:39) Reply

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 Database Optimization: First Normal Form
· Why a Microsoft Access Course Could Change the Way You Do Business
· MS Access: Access your Personal Information with Ease
· Learn about Subqueries in Access Courses
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips