Re: $$Excel-Macros$$ MS Access Group

Respected Anoop Sharma, There are plenty of Access groups.Just google for MS ACCESS groups and u will find a whole lot of them. Regards, VijayKumar On Sat, Aug 10, 2013 at 1:27 PM, Anoop K Sharma wrote: > Join such groups on FB > > On 8/10/13, Kaushal Kumar wrote: > > Hi All, > > > > Is ther

Re: $$Excel-Macros$$ MS Access Group

Join such groups on FB On 8/10/13, Kaushal Kumar wrote: > Hi All, > > Is there any such group for MS Access and SAS as well ? > Rgds, Kaushal > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > ht

Re: $$Excel-Macros$$ MS Access query last modified name

Dear Kaushal, use this. SELECT [name] ,create_date ,modify_date FROM sys.tables Warm Regards, Gawli Anil On Mon, May 13, 2013 at 12:36 PM, Kaushal Kumar wrote: > Dear All, > > I understand its an excel forum. But just wondering if anybody has got any > idea to ide

Re: $$Excel-Macros$$ MS access link

http://www.functionx.com/access/ On Sat, Jul 14, 2012 at 2:11 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > Can any one help me where can I learn online MS Access. > > I don't have any knowledge on MS Access > > -- > Regards > Santosh > santoshkumar.subu...@gmail.

Re: $$Excel-Macros$$ MS Access solution

Hello Rohan, Even though Excel and Access are two products of MS-office, working with them is quite different. While in excel the core term is cell, which when culminated leads to rows, columns, worksheets & workbooks. In excel we work with formulas & functions, with relative or absolute cell add

RE: $$Excel-Macros$$ MS Access solution

Hi Rohan, In Access you should build a query instead of doing a lookup. Your query can refer to various parameters from fields in forms, or the user can be prompted for parameters (Access treats all field names that don't exist in a table as parameters). The other time you might use vlookup in Ex

RE: $$Excel-Macros$$ MS ACCESS MACRO HELP

Hi Ashish, I don't have the answer for you, but perhaps these thoughts will be helpful (especially if dynamically modifying macros is not practicle) -- You can do virtually anything you can do in macros, in VBA. and faster. As I recall, the DoCmd object has methods for most of the macro comma

Re: $$Excel-Macros$$ MS Access Help

I tried to Import the table straight instead of making a link with MS Access. The seems to solve the problem as most of the #N/A and #NUM does not appear. I will try and create the query and the macro in the imported table and see if it produces consistent results. Will get back with the sheet inca

Re: $$Excel-Macros$$ MS Access Help

The column data type is normally allocated automatically depending on the first 8 rows of the data in that column. After you have created a linked table, if the data type in the excel sheet uses data of a different data type, the access table will show erroneous values. Ensure that your formula ret

Re: $$Excel-Macros$$ MS Access

Thanks Venkat On Sun, Jul 17, 2011 at 7:28 PM, Venkatesan c wrote: > Hi Siva, > > You Can Post your MS Access Query's in this group it self... > * > * > *Best Regards,* > *Venkat* > > > On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote: > >> Hi Smarts, >> >> Good day.. >> >> Could you se

Re: $$Excel-Macros$$ MS Access

Hi Siva, You Can Post your MS Access Query's in this group it self... * * *Best Regards,* *Venkat* On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote: > Hi Smarts, > > Good day.. > > Could you send me googlegroup id for MS Access.. > > -- > Thanks > Siva > > -- > > --