|
In my cut and paste frenzy, I forgot to change all kinds of things in the code. I'm going to retry and post my results in a minute or two...
|
|
|
|
|
Okay - success!!
Despite my code posting not making any sense let me assure you that that was just a cut and paste error. However the problem really was that when I called the .Fill method of the DataAdapter I didn't specify which table to use for the field mappings. If you don't, the report comes out blank! Hmmmm, what about when I do the real multi-table query? I'm assuming I have to use the field mapping editor with the DataSet - yes?
Thanks everyone for letting me vent and solve my own problem (I hope)...
|
|
|
|
|
Okay, now that I have mastered my single table report, I thought I would plunge into the multi-table report.
But I do have a couple of questions regarding the DataSet design. Do I just drag the tables onto the designer form and that's it? Do I have to worry about the relationships between the tables? Also, I do not require all the fields from all the tables. Can I eliminate some of the fields so the dataset fields more closely match the query? Does it matter one way or the other?
Thus far I just dragged the tables onto the designer and didn't do anything else and surprise surprise my report runs but it is blank. So, besides the above, is there anything else I need to worry about to get this report to run?
Again, any help is much appreciated
Thanks.
|
|
|
|
|
How do I show and hide controls. In particular I need to show and hide a picturebox, label and command button.
Thanks,
Tim
|
|
|
|
|
Use the visible property
Well.. later
|
|
|
|
|
Found the answer... Need to set the Visible property.
Thanks,
Tim
|
|
|
|
|
I need to write a program that every morning at 5am its start a verification on a table in the SQL Server, is Windows Services a good way or is there another way around ? Thank you very much for your time.
Well.. later
MCP
|
|
|
|
|
Sebastien_Lachance wrote:
I need to write a program that every morning at 5am
You can use Windows' Task Scheduler service to do this (see How To Use the AT Command to Schedule Tasks[^]).
is Windows Services a good way or is there another way around ?
I'd say creating a service is a good idea if you want to run something unattended and without desktop interaction. However keep in mind that if you create a service on your own you'll also be responsible for the scheduler logic. You'll have to decide which solution is most suitable for your requirements.
Best regards
Dennis
|
|
|
|
|
hummm i think right now the best choice i have is to create a small program, and will try to make it run with the Task Scheduler. Thank you
Well.. later
|
|
|
|
|
Hey,
I am using a PDF printer.
I am setting the "HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows" Device key to my PDF printer to set it as the default printer so that it is automatically selected when a application prints.
But some applications succesfully recognise the newly set key as the new default printer and others do not, and only see the previous default printer.
Is there another value that i need to check or set for all applications to use the newly set default printer?
Thanks for your help
Chris
|
|
|
|
|
I'm using code I found on Internet (www.TheScarms.com) to populate/update Excel data from VB.net project. When debugging I'm getting the following error:
An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in PRCoverSheet.exe
Additional information: Invalid index.
The code of the part that gives the error is:
'Open the XLS file and activate the worksheet to populate:
Dim strWorkSheetName As String = "MyData"
Dim sbExcelData As System.Text.StringBuilder
Dim aWorkbook As Excel.Workbook
Dim aWorkSheet As Excel.WorksheetClass
aWorkbook = myExcel.Workbooks.Open(strExcelFile)
aWorkSheet = CType(aWorkbook.Sheets(strWorkSheetName), Excel.Worksheet)
' CType(myExcel, Excel._Application).Quit()
aWorkSheet.Activate()
The debugger highlights the following statement:
aWorkSheet = CType(aWorkbook.Sheets(strWorkSheetName), Excel.Worksheet)
What could it possibly be and how can i fix it?
Thank you all in advance
Alika
|
|
|
|
|
Is it possible to change printer settings through a VB .NET program? Ex Number of copies, duplex, custom paper type, etc
If you have some suggestions or examples that would be great, if not I will have to make do with an answer if it is possible or not.
Thanks
Mark
|
|
|
|
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconPrintSupport.asp
Try this link, it may be not what you wanted but im pretty sure y'oull find a response there.
Well.. later
|
|
|
|
|
Hey,
I was wondering when the 'X' is clicked in the top of the application window to exit the application what is the event that fires? As i need to set values back to defaults etc.
Any help would be appreciated
chris
|
|
|
|
|
the event Closing is fired...
|
|
|
|
|
|
Hello everybody!
I have a trouble with Outlook. The following VB code
set objOLApp = CreateObject("Outlook.Application")
objOLApp.Session.AddStore("c:\temp\test.pst")
perfectly adds new store but how can I get the root folder corresponding to this newly added store? If I were sure that this file is not yet added then I could collect EntryIDs before and after operation and find the difference. But I'm not sure because of statement of work. Is there a way to establis correspondence between root folder and store file name? As far as I know Outlook GUI allows this.
Thanks in advance.
|
|
|
|
|
Can I consume a Webservice coded using ASP.NET & C# in a VisualBasic 6.0
application?
I read it can be done using Soap toolkit..but I a dont want to use it as it will be required to be installed on all the machines using that application.
How to do it without using toolKit.
Thanx
|
|
|
|
|
Save yourself the aggravation of re-writing the SOAP toolkit yourself and just use it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How to ship framework with the package instead of asking for download from web
|
|
|
|
|
You need to download setup.exe bootstrapper form www.msdn.com.microsoft.
|
|
|
|
|
Is it possible to change the color of only certin lines in a text box? I am trying to write a cheap game for my senior project and I thought it would be cool to be able to change color of the text if I was getting hit by something to red, and have me hitting the enemy in white. If anyone has any helpful thoughts please email them to me or post them.
Thanks so much
Tommy
|
|
|
|
|
You know 'txtSample.ForeColor = vbColorRed' can change your text's color, but all lines. It's impossible to change colors of only certain lines in textbox. I have 2 ways to solve this problem (I often do):
1)I think textbox is not for displaying, it's for inputing. So you should use 2 labels: 1 for you and 1 for the enemy. When you are getting hit  , your label red, enemy's label white , contrary...
2)You can use a RichTextBox:
rtbSample.SelText.ForeColor = vbColorRed
but it's not my favourite because the RichTextBox control is very complex .
I post this reply on a computer without Visual Basic installed, so that I can't test the code. If you don't like my answer or don't understand , reply me, I will find another way (I pay attention to this problem too!)
GF bos
|
|
|
|
|
Hi,
I have file as shown in the link:
http://mickey.ccs.uky.edu/doubt/a.doc
I need to parse the file and get the various text information present in it. Also, I need to differentiate whether it came from process or data(see file.)
Any help to achieve this would be highly appreciated.
Are there any ways to access the content of an OLE object ?
Looking forward for replies.
Thanks
Ignatius
|
|
|
|
|
Does anyone know how to format a date to October 02, 2004 when the incoming data is 10/02/2004? (Using Basic Syntax not Crystal Syntax)
The following code works in vb.net but I can't figure out what the correct syntax would be in the formula editor.
Dim dteSDate As Date = csvDataRow.Item("SDATE")
Dim strFormatSDate As String = Format(dteSDate, "MMMM dd, yyyy")")
All help is greatly appreciated!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
