Search results

  1. S

    need help to invoke windows explorer in background from excel using VBA

    Thanks, it worked. I directly used the address in file copy statement instead of that notation. Regards, SK
  2. S

    need help to invoke windows explorer in background from excel using VBA

    Hi, In our project we generally store critical documents to a client location. For this we map one of our drives to this location which would something like \\2.24.23.2\client\abc. I am creating a macro using VBA which earlier used to internally change the drive using cd K:\docs and then i...
  3. S

    Using IIF With an aggregate function

    using iif with an aggregate function Hi, Thank You for your replies. I had tried with count. this works fine but there is one problem with using count Eg: if my table has the following values: Name Age Place Dept aaaa 23 Mumbai Accounting ccc 50 Delhi Finance fff 20 Delhi Accounting hhh 10...
  4. S

    Using IIF With an aggregate function

    Hi, Can anyone please help me out with the IIF concept of MS-ACCESS. I have a table with the following data: Name Age Place Dept AAA 13 Mumbai Accounting BBB 12 Pune Banking CCC 15 Delhi...
Back
Top Bottom