in
All Tags » VBA » 2007 (RSS)

Browse by Tags

  • Access 2007 attachments in a form

    I will need my form to display some attachments that I attached to specific items in a table. How would I go about doing this, I would like them displayed as links, and the attachments are doc, xls and pdfs. There will be multiple attachments, I have no idea how to do this.
    Posted to Access (Forum) by microsoft on 05-02-2010

  • Open PDF file and goto a specific page

    Hello From VBA in Excel 2007 I want to open a pdf file in Adobe Reader (outside Excel). That work ok. But when I try to use parameter to specify a page number, zoom etc. it does not do what I expect. From shell the following work successful: AcroRd32.exe /A "page=2,zoom=100" "C:\Tmp\manual...
    Posted to Other (Forum) by microsoft on 03-13-2010

  • Increase Button size on toolbar/ribbon

    I have the following code that adds a group and button under the addin ribbon. I did it this way because I did not want to deal with writing ribbonx code, however, I am left with a tiny non-descript icon. How can I make the icon larger, and label the icon as well as the group. Thanks PS. there isn't...
    Posted to Excel (Forum) by microsoft on 02-26-2010

  • Access 2007: How to check for memory leak?

    I created a sales application in MS Access 2007. The sales order form has the basics in the header (order number, date, order discount, sales tax). The order lines are entered in a subform. Today we are having a high volume of sales due to a sale and I noticed something that has not happened before....
    Posted to Access Coding/Macros (Forum) by microsoft on 02-20-2010

  • Minimized UserForm not appearing in task bar

    Hi all, I'm trying to enable a UserForm to be minimized to the task bar. The code I'm using is attached. I can Minimize and Restore the UserForm OK, however (depending upon the platform) I'm getting some unusual behavior in terms of the Taskbar. On Vista/Office 2007, the UserForm disappears...
    Posted to Excel (Forum) by microsoft on 02-20-2010

  • Export Worksheets with Values and additional Code for Cell Protection

    I have a main workbook that has 30 - 35 worksheets. The initial values are generated based upon a formula within the workbook. In some cases this generates a #VALUE after copying the worksheet to a second one that is sent out to the appropriate department for them to enter their budget numbers. I would...
    Posted to Excel (Forum) by microsoft on 02-14-2010

  • Filter on split form

    I have a split form sourced from a query(qry1). I need to put two combo boxes (cmb1 and cmb2) on the form to filter the data sheet part (field1 and field2). When user chooses the value in either of these combo boxes, the data sheet will filter accordingly. Meanwhile, other combo box, which the user doesn't...
    Posted to Access (Forum) by microsoft on 02-02-2010

  • Retrieve list of all files in folder & subfolders with DateCreate property equal to today

    I have some VBA code that runs every day in Access and creates a few hundred reports. With all the variables it is possible that over 10,000 reports could be run in a day. What I'm trying to find out is how many reports were actually created today. Using the code below, I'm able to list all files...
    Posted to Access (Forum) by microsoft on 01-11-2010

  • Can I copy data from one excel workbook into another without the second workbook visably opening?

    Hi all, I need a macro that will copy all the data from the current sheet of an open excel work book, and then create a new sheet in a closed workbook to paste the data onto. The new sheet ideally needs to be renamed with "todays" date and the paste need to be a paste special, values then formats...
    Posted to Excel (Forum) by microsoft on 01-05-2010

  • Access 2007 VBA Report onFormat ignored on open

    If I create ANY report in ANY database the OnFormat event in ANY section on the report is ignored when I open the report in report view. If I right click and open the report in print preview the onformat is processed. If I then right click again and chose report format the onFromat has also been processed...
    Posted to Access (Forum) by microsoft on 01-04-2010
Page 1 of 9 (84 items) 1 2 3 4 5 Next > ... Last ยป