Search results for query: *

Using Crystal as included in VS2003, I want to make a simple graph showing the number of people participating in different groups. I made a dataset with one table, columns: date, number, groupname. I inserted a Chart, and using the Chart-expert on the Data-tab selected 'on change of': date...

Hi there, Anybody knows how to create a table with an identy-column using jet-sql? In t-sql it would be: CREATE TABLE test(field1 INT IDENTITY, ...) I googled up: CREATE TABLE test(field1 INT IDENTITY (1, 1), ...) but it doesn't work...

I've filled a listbox with data, using: this.listBox1.Items.Add("ONE"); etc. With some user-input I want to update the text for the selected item. this.listBox1.Items[listBox1.SelectedIndex] = this.textBox1.Text; works OK, but it raises the event listBox1_SelectedIndexChange twice. I use that...

Call me naive, but I wanted to build my own Watch-window for VB6. So I thought to make an Add-in, also in VB6. However: I can't even figure out where to add an entry in the pop-up menu you get when right-clicking on a variable when in debug-mode. Furthermore, I wouldn't know how to get a...

In the app I'm working on, MTS starts a transaction, then lots of objects do lots of things, and finally the transaction is committed. There is a great risk of running into deadlocks that way, but at the moment an even worse problem is: users have to wait until locks set by other user(s) are...

I want to make a simple csv-file, and open it in Excel. What I do is: string URL = strPath + strFile + ".csv"; FileStream FS = File.Open(URL, FileMode.Create); Encoding ENC; ENC = new UnicodeEncoding(); StreamWriter SW = new StreamWriter(FS,ENC); ... SW.WriteLine ("value1,value2") Problem...

I wrote a piece of code in VB that replaces certain characters in a Word document with a paragraph-ending. With objWord.Documents(strMergeNaam) With .Content.Find ... .Execute "[bnrnl]", True, False, False, False, , , , , "^p", wdReplaceAll ... As you see, I use "^p" for...

I'm trying to export a report to Excel, using this code: ExportOptions exportOpts = oRpt.ExportOptions; exportOpts.ExportFormatType = ExportFormatType.Excel ; exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; exportOpts.DestinationOptions = new DiskFileDestinationOptions(); //...

Sorry if this is a dumb question, bit I'm new to Crystal and I need to produce some working reports on short notice... If I use 'PageNumber' in a formula, I always get it like: '7.00' I tried functions like Round() and ToString(), but I seem to be missing something.

Hi, I'm writing a very simple testpage, where I want to show different output from an appl. Not knowing much (hardly anything) about javascript, it wasn't difficult to come up with: [code] function testrun(){ testApp.DoSomething(); Result.innerHTML=testApp.output...

Our application displays data in groups of 15. That way, the user can view 15 customers sorted by name, click a 'next' button, and get the next 15. As there is lots of data involved, it is no option to buffer all data of all customers. So, I've been looking for the most efficient way to get rows...

I' openened a serverside recordset, sql: "SELECT id FROM firsttable WHERE fk IN(SELECT pk FROM secondtable WHERE somefield=?)". CacheSize of the recordset is 20, recordcount of the complete firsttable is some ten-thousands. I get the first 20 records pretty fast, for any value of '?'...

I read a lot of warnings to check the properties 'Unattended Execution' and 'Retain in Memory' when compiling a dll to be used with MTS. What I didn't read: are there situations where it is advisable to leave them unchecked? Anybody knows more, or knows where to find more info?

I want to do a mailmerge (document type = form letter) on a document that is a form: it contains form fields and is 'protected for forms'. This operation is to be carried out by VB code, addressing Word from outside. This way, I want the user of my application to be able to create a document...

In a (rather complex) T-SQL statement I used the expression: WHERE .... AND fieldx = 1 .... fieldx has datatype 'bit'. The query performed very poor, and removing this specific constraint speeded things up more then 10 times. Because I needed the constraint anyways, I made a wild experiment: I...

Treeview has a property checkboxes. If I enable checkboxes they show up on every level, so every time I expand a node: there they are. Would it be possible to have checkboxes only in the items on, say, the second level?

I included the Word.Application object in a VB-class module: Private WithEvents objw As Word.Application This way, my program can start Word, merge data from my application with a Word document, etc. Very nice. However, I need to do some cleaning up after the user quits Word. Therefore, I want...