in
All Tags » VBA » table (RSS)

Browse by Tags

  • Changing Individual Lines of Text in a Table Cell

    I have a Word Table and I am trying to use VBA to change the text properties in a single cell. Specifically, I need to make the first line bold, and all of the following lines (and the total number of lines will vary) italicized. I know how to make these changes to all of the text in a cell. How do I...
    Posted to Miscellaneous (Forum) by microsoft on 05-08-2010

  • Word VBA - Inside a Table: how I can know if a WHOLE cell is selected?

    Hi all, I am using Word 2003 VBA. The current selection (made by the user) is inside a Table. How I can know if a cell (i.e., WHOLE cell, by Table|Cell|Select) has been selected or just all the text inside has been selected ? I need to know this since I want to add a new paragraph at the end of the selection...
    Posted to Miscellaneous (Forum) by microsoft on 05-08-2010

  • Update linked tables in access using vba

    I have a database with about 50 tables linked to a SQL Server catalog. I have a catalog for each month using the following naming convention MTHYYYY. To switch between catalogs I currently update my ODBC connection pointing to a new month then update all linked tables in my Access database using the...
    Posted to Access (Forum) by microsoft on 04-19-2010

  • How do you define an Access AutoNumber Format?

    I am trying to come up with an AutoNumber field for a Control Log. It needs to be formatted YY-001 ("YY" being based on systemdate followed by a dash and three digit autonumber beginning 001 and so on). It also needs to start over with 001 at the beginning of the next year. Any help with this...
    Posted to Access (Forum) by microsoft on 02-21-2010

  • Using A Variable In VBA SELECT Statement

    I have a function that is called from my form. I am hard coding a variable into the function simply for testing will implement after the SELECT statement syntax is correct. I need help with the syntax. I use the following below and I receive error "Too few parameters. Expected 1" The important...
    Posted to Access (Forum) by microsoft on 02-10-2010

  • PickUp PowerPoint Table Cell Formatting

    Can anyone explain why the following VBA code throws an error? I am trying to PickUp the formatting in a PowerPoint table cell. The object model appears to support this, but it just doesn't work. Thanks. Code Snippet: 1: 2: 3: Sub CellPickup() ActiveWindow.Selection.ShapeRange(1).Table.Cell(1, 1...
    Posted to Powerpoint (Forum) by microsoft on 02-08-2010

  • VBA for Updating Table Data

    I'd like to update one table in my database with data from an identically structured table from another database using VBA, but track any changes in the destination database. Anybody have some code I can pilfer? Thanks! mv
    Posted to Access (Forum) by microsoft on 01-18-2010

  • How to createa a checkbox datatype column in a table in VBA code

    I have the following which alters the underlyitng temp table by adding a yes/no column. But how do I tell the table that this new column is a checkbox? The below creates a text box with 0 or 1, but even though the form that uses this field is a checkbox, it does not receive the check mark, it just stays...
    Posted to Other (Forum) by microsoft on 01-07-2010

  • VBA Export Table to CSV file

    Hi I want to make a "export"button on a form to transform a table into a .csv file. Can somebody help me with the right VBA code? I've tried things like: DoCmd.TransferSpreadsheet acExport, "RESULTS", "C:\Temp\Results.csv" Hopefully somebody can help me J
    Posted to Access (Forum) by microsoft on 12-20-2009

  • Example VBA Code to Insert records into table for each day of year

    I need to do some work to an Access Database and I haven't looked at Access for Donkeys Years, so it makes sense to get a head start from an expert! I have a table with two columns, date and units (integer). The table has a Form based on the Datasheet type from the 'Create Form Wizard'. I...
    Posted to Access (Forum) by microsoft on 11-12-2009
Page 1 of 6 (51 items) 1 2 3 4 5 Next > ... Last ยป