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
Export Table to Text via VBA

The goal of my project is to read in a dbf file, and after some processing, output it as a text file with either comma-delimiting, tab-delimiting, or fixed-width. Given the dbf files can have various field widths and number of fields. What is the best way using VBA to programmatically export the table...

Posted to Access (Forum) by microsoft on 09-13-2009
Wrap Text in a Column Heading in a Pivot Table

I have a Pivot Table where I need to WRAP the text for one of the Column Headings. The full text needs to display and the length will change per Pivot. Anyone any idea please how to do this. The Pivot is eventually imported into a Report.

Posted to Access Forms (Forum) by microsoft on 06-30-2009
Problem: Select data from sql table into a text file

I need to select all data in customer table into text file. This is for Sql 2005. fields in the customer table are name, age, address. Location is c:\ projects\customerdata.txt

Posted to MS SQL Server (Forum) by microsoft on 06-02-2009
Problem: Insert a multi-line text filed in sql table

I have a table called tblCase. I am working on my insert statement. There seems to be a problem and it appears to be with the multi-line text box the users make notes in. Everything else in my statement looks fine. How can I deal with this? The CRs need to stay in there by the way.

Posted to Access (Forum) by microsoft on 05-30-2009
Problem: Write Data From Text Field On Form To Table With Submit Button

I have a feedback form that has a text box (txtFeedback) with a Submit (cmdSubmitFeedback) button. I want to add a record to table tblFeedback when the user clicks the Submit button with the data entered in the text box on the form and message the user that the "Feedback submitted". If the...

Posted to Access (Forum) by microsoft on 05-29-2009
Problem: Export table to the text file using Macro

My table has over 1 million records... want to export the table to text file using a Macro... Please advise how I can do it... New bee, require detailed suggestions... Thanks

Posted to Access Coding/Macros (Forum) by microsoft on 05-27-2009

Page 1 of 1 (7 items)

Changing Individual Lines of Text in a Table Cell

Export Table to Text via VBA

Wrap Text in a Column Heading in a Pivot Table

Problem: Select data from sql table into a text file

Problem: Insert a multi-line text filed in sql table

Problem: Write Data From Text Field On Form To Table With Submit Button

Problem: Export table to the text file using Macro