Search results

  1. I

    How to Query a Pivot in Access with "Top Autoshow" Feature

    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...
  2. I

    Quering and re-Quering aint working !

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

    Quering and re-Quering aint working !

    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 -...
  4. I

    Code to open and close Excel not working

    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...
  5. I

    Code to open and close Excel not working

    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...
Back
Top Bottom