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 Swapnil,
Please go thru the procedureand suggest to modify the code for the 2nd
combo-box
With com
.ActiveConnection = con
.CommandText = "Select DISTINCT [Date] from DR ORDER BY [Date]"
.CommandType = adCmdText
End With
Set rst = New ADODB.Recordset
Hi Swapnil,
I have done that. And I got the unique values in the drop down. But in the
second combo-box, i am trying to retrieve other category with same
procedure. But in vain. Can you please suggest?
On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I
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
Thanks Noorain. I couldn't reply in time as I was not keeping well.
I worked with the procedure suggested by Swapnil and moved ahead. And now I
got an obstruction. In the excel sheet, I am using an combo-box and want to
populate the combo-box with 'Items' category in the Access Database. The
'I
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
Hi Swapnil,
Many thanks. I will practice with the samples shared by you and will
consult you in case I find any issues.
Regards,
Wireless
On Friday, August 3, 2012 6:08:55 PM UTC+5:30, wirelesscellularguy wrote:
>
>
>
> On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote:
>
> Hi All,
>
> I am trying to relate Access data & queries to excel. The excel will be
> the user interface. This excel will contain the various buttons to get
> specific informations and clicking these buttons will fe
12 matches
Mail list logo
