Search results for query: *

Thank you, that worked for the field size. Can anyone answer how to set the default value for an Access field using VB?

Visual Basic 6 application with an Access 2000 dbs. I need to write code to add two new fields to an existing table in the Access dbs using Visual Basic 6. This code will be sent to all existing customers to run. I started with code like this: Dim conModify As ADODB.Connection Set conModify...

In VB6 I would like my application title to have a few characters in italics and superscript. Can this be done or am I limited to straight text?

I have a VB6 application that contains a few CR9 reports. RDC is used to execute and view the reports from within my application. I need one of the new features (exporting to editable rtf) that version XI offers. I would like to upgrade to XI but Business Objects support said that XI was not...

Thank you for the detailed reply. You explained it very well. My problem with exporting to text is that some of the data is chopped off. For example: .rpt looks like this in design Wage, bonus, tip {totalwages} {yWages] CR preview looks like this Wage, bonus, tip...

I get the same results when exporting to RTF. Earlier today I installed service pack 4 for CR9 after reading another post that was similar. Unfortunately, neither one fixed my problem. I do not have any borders or lines in my reports. When I referred to "boxes or frames" around the text I...

I'm using CR9, VB6 and Access. When I export a CR9 report to Word the Word document defaults to View-->Print Layout. If I change to View-->Normal, most of the text is all left justified and a mess. If I leave it as Print Layout all of the text has "boxes or frames" around each. I need to...

Thanks for the answer. Here is my situation and why my customers will want to export the report to Excel. The customer has entered data into a VB application. As part of the application I want to provide the user with a standard report based on that data. However, the customer will want to run...

I'm using version CR9 with Access 2000 and VB6. I need to export a report that contains formulas to excel and have the formulas show up in excel. The excel document also needs to be formatted so I'm using the option of MS Excel 97-2000 instead of data only. For example: The report contains the...

Here is a stripped down version of the code I came up with to accomplish switching data in two Access dbs fields. This works but I'm wondering why should I use a command object.execute vs. a recordset.Open? Sub ModifyTable(strDBPath As String) Dim conModify As New ADODB.Connection Dim...

I have a visual basic 6 application that saved data in the wrong Access fields. Ex. Table: Expenses form field "personal" saved in Expenses.Business form field "business" saved in Expenses.Personal I need to create an executable to send to customers to correct this problem. I read that...