?
Solved

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

Posted on 2005-03-04
13
Medium Priority
?
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

770 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