access vba
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Access VBA combobox add first item to .RowSourceType = "Table/Qu

Access VBA combobox add first item to .RowSourceType = "Table/Qu

resolvedResolved · Low Priority · Version 2010

Wed 4 Apr 2012, 11:27 Edited on Thu 5 Apr 2012, 11:40 replyReply Delegate Phillip said...

Phillip has attended:
Access Introduction course
Access Intermediate course
Access VBA course
Access Advanced course

Access VBA combobox add first item to .RowSourceType = "Table/Qu

Hi

How can I append an item to a combo box driven by a SQL query?

I have a combo box of .RowSourceType = "Table/Query" but want to add something like a "Please select" as the first item; how can I do that?

Thanks

Phil

For upcoming training course dates see: Pricing & availability

Thu 12 Apr 2012, 13:10 replyReply Trainer Anthony said...

RE: Access VBA combobox add first item to .RowSourceType = "Tabl

Hi Phillip, thanks for your query. Have a look at the links below for a solution to this:

http://www.vbaexpress.com/forum/archive/index.php/t-24947.html

http://www.functionx.com/vbaccess/controls/combobox.htm

Hope this helps,

Anthony

Thu 19 Apr 2012: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft access courses in london and other Microsoft training courses.

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips



MS Project training
Course rating:
4.8 stars - based on 5149 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Facebook · Twitter · Google+ · LinkedIn · Pinterest