Re: $$Excel-Macros$$ Run-Time Error 3170

of using excel link tables use access tables. And if you want to use excel link table then before running macro link excel table* Regards, Swapnil. On Fri, Sep 14, 2012 at 11:51 AM, wirelesscellularguy wirelessc...@gmail.com javascript: wrote: Hi Swapnil, Many Thanks for replying. I

Re: $$Excel-Macros$$ Run-Time Error 3170

) in local ms access table and it is recommended that instaead of using excel link tables use access tables. And if you want to use excel link table then before running macro link excel table* Regards, Swapnil. On Fri, Sep 14, 2012 at 11:51 AM, wirelesscellularguy wirelessc...@gmail.com

Re: $$Excel-Macros$$ Re: Excel to Access Data

, Swapnil. On Thu, Sep 13, 2012 at 3:52 PM, wirelesscellularguy wirelessc...@gmail.com javascript: wrote: 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

$$Excel-Macros$$ Re: Excel to Access Data

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 am

$$Excel-Macros$$ Re: Excel to Access Data

, 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 fetch the data from the access table or queries. Please

Re: $$Excel-Macros$$ Re: Excel to Access Data

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 wirelessc...@gmail.com javascript: wrote: Thanks Noorain. I couldn't reply in time as I was not keeping well. I

$$Excel-Macros$$ Run-Time Error 3170

Hi All, I am trying to query my Access Database(Database1.accdb) through vba. I am getting run-time error 3170 at the highlighted line. Sub GetData() Dim MyDatabase As DAO.Database Dim MyQueryDef As DAO.QueryDef Dim MyRecordset As DAO.Recordset Dim i As Integer Set MyDatabase =

$$Excel-Macros$$ Re: Excel to Access Data

. The 'Items' re-occur in the database, so i need to populate the combo-box with unique Items only. I suppose I can do this by clicking the property of the Access Query. Please help. Regards, Wireless On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote: Hi All, I am trying

$$Excel-Macros$$ Re: Excel to Access Data

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 fetch

$$Excel-Macros$$ Re: Excel to 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

$$Excel-Macros$$ Excel to Access Data

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 fetch the data from the access table or queries. Please suggest how it can be done.

$$Excel-Macros$$ Insert the complete sentence by typing in the wildcard(*) and first few characters of the sentence

Hi All, I have a predefined sentences to be filled in various cells and under specific conditions. I am checking the entries in column A and based on that I am filling the Column B cells with predefined sentences. As there are many different predefined sentences, I was wondering can it be