sunilvedula
10-21-2009, 03:01 AM
hi all,
i have divided my access file into 2 components. one is the front end and the other is the backend which contains tables only. Now the problem i have is i run a macro which loads the data from an excel sheet into the tables. I cant run the macro on the front end since they are all linked tables. i need to run the macro on the backend file which will load data. How do i activate that macro in the backend file from the front end file. how do i mention it? docmd.run macro "what do i give here"?
i have divided my access file into 2 components. one is the front end and the other is the backend which contains tables only. Now the problem i have is i run a macro which loads the data from an excel sheet into the tables. I cant run the macro on the front end since they are all linked tables. i need to run the macro on the backend file which will load data. How do i activate that macro in the backend file from the front end file. how do i mention it? docmd.run macro "what do i give here"?