Search results

  1. K

    Using VBA to control other applications

    I have a module controlling an application called Business Objects. Basically a report is run on Business Objects then saved as a PDF file or printed. This works perfectly, however Access remained 'Greyed out' after the application has been terminated. This usually only means clicking on a form...
  2. K

    calling procedures

    Is it possible to call a procedure from a module dependent on a value in a combo box. e.g. There are three clients (TOM, DICK and HARRY). Each has a different procedure that can be run only for them. There is a combo box CmbSupplier which will have the client selected. Based on this selection...
  3. K

    Solution: Spellcheck a single text box

    I have been trawling this site for a solution to the problem of spellchecker checking all records and fields without success. I have however used a bit of code to resolve the issue (For me anyway): Mytextbox.SetFocus SendKeys "{f2}^+{home}{f7}" This may or may not be significant, however...
  4. K

    Import several tabs on spreadsheet

    I am supplied with a spreadsheet with 40+ tabs. At different times I want to a import different tabs based on a marker in against the tab name in a table. Previously I have written a line of code for each tab as all records were required at once.I now need to import selected groups at different...
Back
Top Bottom