Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Combobox: Grab (.Value + 1).Column(other than bound column)  using VBA code..

Posted on 2005-03-04
13
Medium Priority
?
261 Views
Last Modified: 2008-03-17
I have a combo box (me.cbo_month) that goes something like this...

200506   December 2004
200507   January 2005
200508   February 2005      <-- current value in me.cbo_month
200509   March 2005
etc.

I would like to grab 'March 2005' using VBA code.  So far I have figured out how to grab 200509 using..
Me.cbo_month.ItemData(Me.cbo_month.listindex + 1)

.. but haven't figured out how to programmatically grab 'March 2005'.

TIA
-Jim
0
Comment
Question by:Jim Horn
  • 7
  • 6
13 Comments
 
LVL 18

Accepted Solution

by:
Data-Man earned 2000 total points
ID: 13460235
Try this

Me.cbo_month.Column(1,Me.cbo_month.listindex + 1)

Mike
0
 
LVL 66

Author Comment

by:Jim Horn
ID: 13460285
You're the (Data-) Man...
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 13460327
:-)  Mike
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 66

Author Comment

by:Jim Horn
ID: 13460350
My msgbox "Lowest Common Denominator Instructions" looks vewwy pretty now..  :)
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 13460380
LOL
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 13460761
Jim,
   Guess what I did....Access FE using a SQL Server 2000 database with ADO over the internet.

   I can pull 1000 records into a subform in 3.5 seconds....time includes (pressing the button, all the processing on SQL Server, displaying the data, and giving control back to the user).  If I pull a single record, it is almost instaneous!!!

   I'm currently buidling an application for a client that can be used by anyone in the world as long as they have an Internet connection.  I have a friend in the UK and he tested it...5.5 seconds...when he was down under it took 8.5 seconds...still not too bad to pull 1000 records half way around the world.

Mike

0
 
LVL 66

Author Comment

by:Jim Horn
ID: 13460775
Over the Internet?  Holy Hanna..  Time to raise your hourly rate.
Straight ADO? (i.e. no XML)
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 13460830
straight ADO...I even bound a form to a recordset (single record) and it's fully updateable...oh so fast.

very cool stuff....all stored procs, and ADO.  I get the power of Access as the frontend and the power of SQL Server and it being not tied to a network.

Mike

0
 
LVL 66

Author Comment

by:Jim Horn
ID: 13460903
With this capability, you should consider doing some web-based speculative applications work.

For example, I had a guy in the VB6 development class I taught a year ago that was convinced that if someone created an inventory application geared towards junkyards (i.e. "Do you have a transmission for a '95 Prelude?  click click click "I have three, come on down") that they could make a bunch of money.   With the speed you're experiencing, you could create this and sell it as an internet-backend, pay per month service.

Contact Management, man you could do a lot...
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 13460941
Sounds great...only one problem....there's this limit of 24 hours in a single day.  Already pushing the envelope in terms of work/sleep/family.

mike
0
 
LVL 66

Author Comment

by:Jim Horn
ID: 13460977
work/family/sleep/hockey/drive kids to-from daycare and classes/pick up the house/etc/etc...
0
 
LVL 18

Expert Comment

by:Data-Man
ID: 13460999
yes, yes and yes...I have 5 kids...twin boys 10 months old, a 26 month old daughter and a 13 and 15 year old from a previous marriage.

Luckily I work from home when I'm not traveling and I had a company buy all my free time from Feb-Jun.

Mike
0
 
LVL 66

Author Comment

by:Jim Horn
ID: 13465950
Mike - You might want to jump in on this question; guy wants to use Access FE over a WAN.

http://www.experts-exchange.com/Databases/MS_Access/Q_21338023.html#13465033
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question