excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Swapnil Palande
> *Sent:* 14 September 2012 11:14
> *To:* excel-...@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Excel to Access Data
>
>
>
> Hi,
>
>
>
> If you want to
l-macros@googlegroups.com] *On Behalf Of *Swapnil Palande
> *Sent:* 14 September 2012 11:14
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Excel to Access Data
>
> ** **
>
> Hi,
>
>
>
> If you want to populate combo boxes
cel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Swapnil Palande
Sent: 14 September 2012 11:14
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Excel to Access Data
Hi,
If you want to populate combo boxes using minimum code then create saperate
f
Hi,
If you want to populate combo boxes using minimum code then create saperate
function to populate combobox and then call that function for each
combobox. Following is the sample code:
1. Create function to populate combobox
Function populateCombo(rst as ADODB.Recordset, cmb as ComboBox)
Hi Swapnil,
I could populate the 2ns combo-box by repeating the code used to populate
ComboBox1. But in this way, if i need to populate other ActiveX Controls,
the code size will become unnecessarily large. Can it be done with few code
lines? I am pasting the code used by me to populate the two
Hi,
You can populate the combo-box with unique items using "Select distinct "
query
Do following steps:
1. Store "Select distinct" query data in Record Set
2. Loop through record set and add values to the Combo Box
Regards,
Swapnil.
On Thu, Sep 13, 2012 at 11:21 AM, wirelesscellularguy <
wire
use odbc connection for export and import data from access to excel
On Fri, Aug 3, 2012 at 6:08 PM, wirelesscellularguy <
wirelesscellular...@gmail.com> wrote:
>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>>
>> Hi All,
>>
>> I am trying to relate Access data