Recent content by imfarhan

Hi All, I've a two tables (new) and (Old) and like to compare the values the sql and output shown below select 'TableA' , costcentre, count(costcentre) as Total Count, sum(values) as TotalAmt from TableA group by costcentre UNION ALL select 'TableB' , costcentre, count(costcentre) as...

Hi John Many thanks for your help , I ve tried your code and its work pefectly well on my testing db. I will make it alive in my live sysem Thanks again for your time and help Regards Farhan

Thanks its worked perfectly fine , when I copied into current db(Where function is) but I would like to paste into defferent db DoCmd.TransferDatabase acImport, "Microsoft Access", "N:\InfoCom\Farhan\Test_DB\Test1.mdb", acTable, "emp", "emp", False DoCmd.TransferDatabase acImport, "Microsoft...

Thanks , but how can I write the Target database, as this VBA code , I'm writing on control datbase where I don't want to keep any table. I think in your syntax you're copying into the current db but could we define the target databse which differnt than I'm writing this code I hope it make...

Hi All, I have a control datbase , and I would like to copy/paste the table using the VBA code. Meaniang copy the X table from "CoreDB"(SourceDB) into "TargetDB". I'm trying to used the following VBA code but getting some errors Option Compare Database Option Explicit Sub CopyTbl() Dim...