Recent content by irfanali

Dear All, I have this list in MS Access of a List of Employees and thier Blood Groups from varied departments across organisation... My Access Table has 3 columns: - Department Name - Employee Nr - Blood Type I have created and uploaded a sample(in xl format) in the the attached...

Thanks a ton...DrSnuggles..got the Logic into Reality Translated !! Cheers !

This is an issue that i was unable to find a resolution to..The Logic seems simple but am unable to translate it into Practicality.. Well the issue is as follows : I have a table called "Order Data" with data containing the following columns - Team Member Name - Order Amount - Order Date -...

I finally got the Code to work.. The reason occured to me when i was having my shower this morning...i was like..i m asking my code in Access to close the Workbook and also, i m asking Excel macro to close the workbook as well...of course there will be a conflict in argument ! Came to office...

I needed a code wherein on a click of a button, access opens a specified excel file, (copies a segement of data from the Excel file and save it at another location as a new file) and then set focus back to Access The line in italics is taken care by Excel macros. I tried the Code above with...