Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. B Shirk

    Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce

    I appreciate your comments. Let me explain this application from the start. I have a desktop icon that launches a batch file which opens Access and an Access macro that displays a "beginning date" and "ending date" form with a prompt. This is a one click operation. The user enters the...
  2. B Shirk

    Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce

    /The steps you listed: 1) run all three queries via an Access macro 2) open the Excel template 3) press macro buttons to import the query into the template 4) save your workbook are exactly what I want to accomplish and the way it is working now. But, after step 3, I want to prevent the...
  3. B Shirk

    Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce

    I do run all the queries via an Access macro. After they have finished, I open the Excel template that has the macro buttons that are used to import the query into the template. The user has to choose which one to import; never all three. Once the import is complete, the user can review the...
  4. B Shirk

    Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce

    One more issue with this application. The excel template has three macro buttons on it. Each one loads a different block of data from a MSACCESS query. When I load one of them, I want to hide the buttons so none of them can be clicked a second time. Here is the tail end of my code where I do...
  5. B Shirk

    Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce

    I tried this but it did not work. The saved file is MyTemplate.xltx. I entered some data and hit save; and it saved.
  6. B Shirk

    Disabling the Save button in the "File"drop down. Also when attempting to close file. Exce

    I have developed a data application in Access and, using a Macro in Excel, import the selected table into Excel. The Excel sheet has formulas and text that need to stay there every time it is used. The idea is for the user to import the data and save it to a new, dated file. I cannot have...
  7. B Shirk

    Closing MS Access

    Andy, Thank you. The DoCmd.Quit worked
  8. B Shirk

    Closing MS Access

    Thanks for the quick input. As I said before, I'm not real familiar with VB. Where would I add either of these to the code I posted?
  9. B Shirk

    Closing MS Access

    thread181-510401 I have searched high and low for a solution to this. I have a macro in Access that will open Excel and a specific excel file. Works OK (See code below) ==================================================== Function OpenExcelFromAccess() Dim MyXL As Object Set MyXL =...

Part and Inventory Search

Back
Top