Search results

Dear Bob Fitz The world really seems to be a better place to live when people like you are around. I was astonished by the prompt response given by you. In the past also I have raised a few questions in this forum & every time a noble soul like you appeared to help. Hats up to people like you &...

Hi I have a database in which I have number of queries/tables. Some of these queries/tables are related to each other & some of them are totally independent of each other. I am able to make individual report for every queries/tables. What I want is to combine the individual report into one...

Thanks David for the prompt reply I am basically using Excel because I have some data in which I need to compare the values involving different rows which is pretty easy in Excel & quite difficult (at least for me) in Access. Of course I am working on that but for the time being I am relying on...

Can someone help me out of this problem. Is there a way to refresh Excel Sheet from within Access. Thanks & Regards

Thanks JANR I got the immediate window. But can you please suggest what should be the code if I am linking Access Data to Excel File as "Table" & not as "Pivot Table", because when I am running the code it is showing the following error:- Run-time error '1004' Unable to get the PivotTables...

Where is this Immediate window. I am also facing a similar problem. I opened the VBA window but was not sure where to paste the code. Please help.

Thanks for your response But I need to move those files to different computers as I have to distribute it to different users & they are not connected to each other through any network. Hope you understand my problem. Any help please Thanks & Regards

Thanks David for replying. Here I am giving the details of my problem. 1. I have an Access file to keep all the data. This is my master file & it contains multiple number of tables & Queries. All the data resides in this file so you can say this is my master file. 2. Now to do some calculation...

Can someone help me on this as I need to move my files to another PC & stuck with this problem. Please help. Thanks & Regards

Sorry if I am asking too much. But my problem was not solved as I was thinking after applying the suggestion. After applying the above procedure I am able to open & close the excel file but the data in the excel sheet is not being refreshed which was my prime & only requirement. I have set in...

Thanks Mr B I applied your suggestion & the problem was solved partly. My Access file in the new location was refreshed but the Excel file is getting data from the Access file in the original location. Whatever changes I made to the Access file in new location is not reflected in the excel...

Thanks Mr. B for your kind help & patience in handling my problem. I made the changes as suggested by you & it worked fine. Thanks a lot Regards

I use the procedure as described by you but the excel file doesn't open. It is showing a message of "Compile error: User-defined type not defined" & showing the code saved in the module with one line highlighted which I have highlighted in Red under quote. Actually I am not at all conversant...

Thanks Mr B for your reply & link provided. But my problem is I am not conversant with VB & thats why opted to do this using a macro. Can you please help me do this using macro? I want to know how the RunApplication command works in macro. Or else can you please explain where to write the code...

I have an Access & Excel linked files. I have my data in Access & do some calculation in excel. The system works fine till I change the location of both the file. Whenever I shift the files to another location or another computer the linking failed. I have tried to change the path from within...

I have an Access & Excel linked files. I want to open the excel file & then close the same using macro. Actually this will refresh the data in excel sheet & return the result to Access. I have tried to use the "RunApplication" command but unable to do it. Can someone explain the procedure to do...

Dear Jdraw Thanks for the help & sorry for the delay. I think I can solve my problem by the hint you have given. I will try the same & get back to you if I face any problem. Anyway lot of thanks to you & all the helpful members of the forum

Please see the file in .mdb format.

Thanks jdraw for the useful link. The content in the link provided is very good & I think this can solve my problem. I tried the solution given there but didn't get the result. Actually I have never written SQL statements & therefore struggling with the syntax error. Also the examples given in...

Thanks rodmc for your suggestion. But will you please elaborate the steps Or else can you please do the same in the attached file & post it here for reference? Your kind help really will be appreciated.