Recent content by jking

Guys, I've found the error on my code :) on this part: .Range(X).Value = eTinNo .Range(Y).Value = eBDay .Range(Z).Value = eName .Range(A).Value = eAmount .Range(B).Value = cAmount .Range(C).Value = tAmount should be: .Range(X).Value = rst("eTinNo") .Range(Y).Value = rst("eBDay")...

hi nIGHTmAYOR, i wont be using huge amount of data here, just a few records, 20-30 max.. I know it would be easier to just create a report in ms access for this, but the situation really calls for an excel report.. I made a do while loop to go through my table one record at a time but i cant...

Hi Mike375, Thanks for your reply and the link, i was able to do that with Bob's code, my problem now is copying all records of a table to excel but with selected fields only. :D regards, Jon

hi bob, i think the best way i can explain my situation is by example: on my excel sheet, i have this columns TIN NO. | BDAY | NAME | EMPLOYEE CONT. | EMPLOYER CONT | TOTAL | my table includes all those fields plus a lot more, and contains many records. now, how do i copy all the records on...

Hi bob, i have a follow up question, i've now come to the data on my subform, which includes several records , is there a way i can loop thru each record and transfer the data on my excel sheet? i tried using the recordset approach but i have to control on which fields i would like copied only...

Wow!! just what i needed !!! thank you so much Bob!! :D

addition to my post earlier, what i basically need is a way to control where access put the data on my excel sheet, example i want put field1 to range(A1), field to to Range(B6), field3 to range(d9) and so on.. most of the examples i see on the internet only gives the starting range and copies...

thank you so much guys for your replies, ill look into your suggestions, and hope it can solve my problem. Thanks! Jon

Hi Everyone, Is there a way to manipulate how access writes to excel? i mean if i have different cells for every field i have.. i've been searching the net for help on this but all i can find is where you only specify the starting row and column where the copying will start, and then it will...