in
All Tags » VBA » add (RSS)

Browse by Tags

  • Dynamically add images to an Access form with VBA

    I want to use VBA to dynamically add and display images on a form. I want to read the file system for the image file paths then add images with these paths. Reading the filesystem and fetching the image paths is no problem but I can't figure out how to dynamically add the Image controls. I thought...
    Posted to Access (Forum) by microsoft on 12-31-2009

  • VBA Word 2003 - How do you add and retrieve custom doc properties

    Hello, I have a word template that has a dialog box attached in which the user enters information to generate the document. I would like to take the text field info and attach it to the document properties. Later, I want the user to be able to run a different macro -- which will pull that document property...
    Posted to Microsoft Office (Forum) by microsoft on 08-12-2009

  • VBA:  Add command button programmatically to sheet

    I would like to add a command button to a sheet through my excel macro. I have seen how to add forms programmatically, but controls seem to be different. I really would prefer NOT to add a form with a button in it. Have tried the following In sheet1 declarations: Private WithEvents CommandButton100 As...
    Posted to Excel (Forum) by microsoft on 08-11-2009

  • VBA code to add new record based on previous record

    Using Access 2003 VBA. I need to take a table that has one record in it. It has 10 fields. Each field contains a number. I need VBA to read the numbers in this record and then create x new records by adding 1 to each of the values in the previous record. I'm a litle hazy on Access VBA hence would...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-13-2009

  • How to add a value in a RowSource

    Have 2-Questions: 1. Have a field in a table, with: Display Control = ComboBox RowSourceType = Value List RowSource = Brother;Cousin;Sister How do I add another value/item in RowSource through VBA? 2. The same field is displayed as a combo-box on a form. Similarly, how do I add a value to a RowSource...
    Posted to Access (Forum) by microsoft on 07-10-2009

  • Add appointment to another users' calendar. Via VBA.

    I'm working on a little project at the moment that is going to be rolled out to our Sales Executives over the next couple of weeks. It's going automate their booking of appointments etc onto Outlook and will also provide reminders etc for them. We'll also be using it here to generate letters...
    Posted to Access Coding/Macros (Forum) by microsoft on 06-24-2009

  • VBA - Using DAO to add record(s) to a table

    Greetings... I'm helping a buddy out with some coding for a small app he's building, and could use some help with this part. The code that I started with is pasted below. The idea is to add record(s) to the Inventory table. What he would like is use an Unbound field (txtAddRecord) on a form to...
    Posted to Access (Forum) by microsoft on 06-22-2009

  • Problem: How do I use VBA to add records to a pre-existing table with an autonumber primary key?

    I am creating a form to enter and edit data into a pre-existing table. The table has already been setup and includes an auto-number primary key. How do I write the code to insert a new record with the information on the form? Below is the code I have so far based on previous databases I have worked on...
    Posted to Access (Forum) by microsoft on 06-05-2009

  • Problem: VBA: Adding/Removing reference files upon startup

    Hi experts! I seem to have gotten a problem with regards to reference files. I have an access 2000 program that will get data from an excel file. Only problem is some of my users are using Excel 2000 while the others are using Excel 2002. The reference file is different for both versions (Excel.exe for...
    Posted to Access (Forum) by microsoft on 06-03-2009

  • Problem: VBA-"Recipients.Add" - Seperate people, Same name

    Is it possible to get Recipients.Add to resolve a contact when there are two contacts with the same name. This is going to be used to build a Distribution List on existing entries within your contact list. Duplicating the problem... 3 contacts in your contacts list (All with extra details such as home...
    Posted to Outlook (Forum) by microsoft on 05-28-2009
Page 1 of 1 (10 items)