Combobox: Grab (.Value + 1).Column(other than bound column) using VBA code..
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.c
.. but haven't figured out how to programmatically grab 'March 2005'.
TIA
-Jim
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.c
.. but haven't figured out how to programmatically grab 'March 2005'.
TIA
-Jim
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
:-) Mike
ASKER
My msgbox "Lowest Common Denominator Instructions" looks vewwy pretty now.. :)
LOL
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
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
ASKER
Over the Internet? Holy Hanna.. Time to raise your hourly rate.
Straight ADO? (i.e. no XML)
Straight ADO? (i.e. no XML)
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
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
ASKER
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...
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...
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
mike
ASKER
work/family/sleep/hockey/d
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
Luckily I work from home when I'm not traveling and I had a company buy all my free time from Feb-Jun.
Mike
ASKER
Mike - You might want to jump in on this question; guy wants to use Access FE over a WAN.
https://www.experts-exchange.com/questions/21338023/Limiting-bandwith-use-when-accessing-SQL-server-over-WAN.html#13465033
https://www.experts-exchange.com/questions/21338023/Limiting-bandwith-use-when-accessing-SQL-server-over-WAN.html#13465033
ASKER