The SaveFileDialog that opens up while clicking the export button of the CrystalReportViewer by default filters the predefined file types. Is it possible to custom define which files to be filtered?
View 5 RepliesThe CrystalReportViewer allows me to export my report to an Excel file, but it always saves the report as sheet "Sheet 1" in a new file. Is there a way to get the CrystalReportViewer to save the report to an existing Excel file and specify what to name the sheet in saves the report to?
View 1 RepliesThe CrystalReportViewer allows me to export my report to an Excel file, but it always saves the report as sheet "Sheet 1" in a new file.
Is there a way to get the CrystalReportViewer to save the report to an existing Excel file and specify what to name the sheet in saves the report to?
I have a 'DataGrid' usercontrol on my simple little form and I press a button that opens a text file and populates the DataGrid like so,
A B C
1 2 3
3 4 4
3 1 3
Where A, B, and C are my column headers.
I also have a 'ListBox' on the form. What I would like to do is, allow the user to select one, two, or three rows (or all) in the datagrid, and press a button that will move the data from selected rows into my listbox (each row its own string in the list box).
I can populate the datagrib easy enough, but don't know how to access the cell data individually?
I need your valuable advise reg. Export options in CrystalReportViewer in VB.NET 2008 In our application, I am using Crystal Reports 2008 and VB.NET 2008. Task : I need to provide all the Export options (Export Type as well as Export Destination).
Suppose if I click Export button on CrystalReportViewer, it shows save-as dialog window. There we have only format types but there is no type of destination like Application or DISK or Exchange Folder or MAPI).
In the crystal report, if you select File---Export----Export Report, then we can get Export Window (It has both Format as well as Destination). Like I need the same export window whenever i click Export button on CrsytalReportViewer.
Is it possible to make the tab (a text 'Main Report' appears in it) invisible that appears in a CrystalReportViewer just below the Toolbar? I know it shows which section of the report is opened currently but in certain scenario I need it not to be visible.
View 3 RepliesI'm designing a form wherein a datagrid is being filtered from numerous controls.
The issue im having is each filter overrides the previous one. Just wondering the best way to approach this problem.
Heres a snippet of my
Private Sub MakeIDComboBox_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MakeIDComboBox.SelectedIndexChanged
Sheet1BindingSource.Filter = "Make like '" & MakeIDComboBox.SelectedItem & "'"
End Sub
[Code]......
i googled many and many keywords and sentences but , i cant found a code that opens the default web browser and gets it a address ( address is : text1.text )
View 3 RepliesWhen the user clicks the Exit button it closes the forms and if there was an open file it asks the user is they would like to save. But after the application closes there is still memory being held in Processes by the application. However, when pressing the [X] in the top of the form the application closes again but in this instance it is not held in Processes. How do I write the close for Exit to take into account how the [X] works and close the application cleanly?
Friend Sub CloseAllForms()
CloseHelpForm(True)
CloseDiagForm()[code].....
Here's what I'm attempting: The user browses for and opens a dbf file. The user is presented with a checkedlistbox which shows the column headers. The user then selects the columns they wish to run a report on. ex. total # of cells not empty, longest cell length, etc.
I'm to the point of populating the checkedlistbox with all of the columns shown but I'm unsure if the users selections are actually linked to my data and if they are how I go about isolating said selections for the reports. I have a feeling that my approach to populating the checkedlistbox is not the proper way for what I'm trying to accomplish.
Here is the code
Public Sub btnGetFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetFile.Click
Dim fileLookUp As New OpenFileDialog
[CODE]......................
How does one get the context menu to appear when right clicking a "custom" windows title bar? I want the default context menu (the one that appears when clicking a forms caption bar) to show when clicking a control on a form... generally i want to make my own title bar (caption bar) for a form...the code that fails is "formTitleContext"also any suggestions to writing more concise code for this task will be greatly
View 4 Repliesok i have a dataset with two columns one column is "NAME" the other colulmn is called "URL". The entries in the URL column are displayed as linklabels. So how do i clear the table and save the table: I tried this
[Code]...
it works. it clears the table of all rows but when i close and re-open the program the data shows in the table again (i.e. it isnt cleared so how do you fix this.Also how do i put code into the click event for each linklable in the URL columns?
I believe there wont be any diff if user clicks the button on the form and the click event is fired OR if we call the button click event / function in the code. Because in one my project, this does make diff. If I click the button on the form, the App works great but same button if I click it thru the form code, the whole process crashes. This happens in Vista / VB.net.
View 12 RepliesAfter inserting an user control and double clicking on it, a stub with the default event should appear.
If I don't define what the default event is and I don't assign any attributes to any events or properties, it works, and it generates the stub for the UserControl.Load event (the default default event).
But if I set some attributes for the properties and events and/or I define the default event, the stub generated is corrupted. Here is an example of what I should get:
Private Sub FaceSelector_OnSelect(SelectedObjects As System.Collections.ObjectModel.Collection(Of Object)) Handles FaceSelector.OnSelect
End Sub
And this is what I actually get: Private Sub SketchSelector_OnSelect( SelectedObjects As System.Collections.ObjectModel.Collection`1)
End Sub
Private Sub FaceSelector_OnSelect( SelectedObjects As System.Collections.ObjectModel.Collection`1)
End Sub
In this case I had 5 user controls, I double clicked on one of them, and I got 2 corrupted stubs.
Sometimes the corrupted stubs are generated when I change some properties of other controls in the form, or the form itself. For example I resize the form, the error window doesn't show any errors, hit F5 to compile and run, and get a syntax error.
I tried to track the problem down by removing each event/property attribute/xml description, one by one, many times I thought I found the culprit, but after 10 minutes the problem popped up again.
Trying to export fields to excel. Have set the references to Excel 12, But, the i, j loop cuts short the number of fields to export to 10 when there are about 16 to export.
[Code]...
is it possible to make a button that when it is pressed it opens up a window i am using vb 2008
View 10 RepliesI have a few questions. first, how do i make it so that when you open your program you can not open ctrl+alt+del = task manager? second how do i make it so that a button opens a .bat file? third Is it possible to a button open multiple Internet Explorer Windows? When i try to do this it only opens a bunch of tabs? and lastly how do I make it so that when it installs on a computer it installs straight to the start-up folder without the user knowing it, or how do you make it so it opens automatically on start-up?
View 1 Repliesi have two asp:buttons.. say button1 and button2, what i would like to do is fire button2's click event when I click button1.. is there a way to trigger click event on an asp:button through code behind? please help, newbie here.
View 1 RepliesI wan't to make a button in my program that opens it when the computer starts up but how would I do that? I am using Visual Basic 2008 Express Edition.
View 4 RepliesI am creating a document control system for standard operating procedures (SOP) in MS Access 2007. I have just started an online VBA class and have moderate MS Access 2007 experience. This thread is very detailed and lengthy.I have the tables set up and forms created for CREATE, SUPPLEMENT etc. I need to create a user interface so that when they open the database it pulls up a form that has buttons for "Start New SOP Process" and "Modify Existing SOP Process". Every step of writing an SOP is dated so that management can have outputs for target measures (to see why it takes so LONG to write an SOP from start to finish). After the user selects "Start New SOP Process" or "Modify Existing SOP Process" I am trying to have a Combobox appear with a drop down box of change types: CREATE, SUPPLEMENT, and REVISE.
Primary Key Explanation:Each document has a 3-part number comprising a 3-part PK. 1.001v1.0. Where 1 is (1-6) identifying what type of SOP: Document Type,.001 is the Document Series (a sequential number for each type of equipment--the 2nd SOP written for a document type 1 would be 1.002v1.0) and v1.0 is the version.
For example, lets say Document Type 2 indicates field equipment. The very first SOP written for a piece of field equipment would be 2.001v1.0. If a supplement is made to the SOP for that same piece of field equipment, then it becomes 2.001v1.1, if a revision is made to that same piece of equipment it becomes 2.002v1.0. If we buy a new piece of field equipment it would be assigned SOP document number 2.003v1.0.
After a document is changed (any part of the 3-part number is changed) the previous record is put into an archive table so that the technicians/general public have access only to the most recent version of each SOP. I am going to store them on Sharepoint with an Archive Folder and an Active Publications Folder and a link to the document is provided in the database. However, while a document is being modified (going through the SOP process of reviews and drafts) the users are going to need access to the previous version until the most recent version is approved (maybe I could have the document be archived upon completion of the Document Link control).
For each Combobox option I need a different "On Click" command to open the associated forms for each "Change Type". I have the necessary forms already grouped (using subforms and tabs) for each change type: CREATE SOP (has all of the forms needed when creating an sop), SUPPLEMENT SOP (has all forms needed when supplementing an sop), REVISE SOP (all forms for revising). I am trying to use If Then statements for this...
The modify part is the simplest. I think the Combobox for the "Modify Existing SOP Process" should consist of "Change Type" (CREATE, SUPPLEMENT, REVISE), "Document Type", "Document Series", and "Document Version". I want the "Change Type" to open up the correct group of forms with "Document Type", "Document Series", and "Document Version" finding the existing record that needs to be modified (i.e. so that the user can add dates for completed activities as the SOP process progresses: draft revisions, reviews).
The "Start New Process" is even more complicated. Each change type does more unique event procedures than just opening the forms (which I can't even figure out to begin with!!). The Combobox would still be "Change Type" (CREATE, SUPPLEMENT, REVISE), "Document Type", "Document Series", and "Document Version". However the following is what I am trying to do for each "Change Type":
When "Create" is chosen from the Combobox it will find the next record in the document series by the user selecting the correct "Document Type". I would like to add a formula so that it adds .001 to the previous record (giving the next sequential number), and force v1.0 to be entered and not able to be modified, since a newly created document can only be version v1.0. Then it would open the "CREATE SOP" form (all forms associated with "Create" compiled on one form by tabs and subforms--I already have this complete for each "Change Type") and require the user to fill out all document information controls (title, description, etc) before closing.
When "Supplement" is chosen from the Combobox it will find the most recent record by the user's input of Document Type and Document Series. I would like to add a formula so that it adds .1 to the previous Document Version. Then it would open the "SUPPLEMENT SOP" form. It would be useful if the fields for the document information controls (title, description, etc) were appended to this form but it is not necessary.When "Revise" is chosen from the Combobox it will find the most recent record by the user's input of "Document Type" and "Document Series". I would like to add a formula so that it adds 1 to the previous Document Version and forces the decimal value to be 0 (revise and create change types have to end in a "0"). Then it would open the "REVISE SOP" form. It would be useful if the fields for the document information controls (title, description, etc) were appended to this form but it is not necessary.Additional buttons I would like to have on the Main Menu Form--opened when the database is opened (includes "Start New SOP Process" and "Modify Existing SOP Process") would be:
"View All Publications" where a user can not edit anything, just gives them access to the current "active" SOP links. It would be a complete list of all of our SOPs. I think I could use a query "Retire" which would put an SOP into the Archive table/folder on Sharepoint. This would be useful in addition to the automated retiring of previous version in case we discontinue use completely of a peice of equipment or administrative procedures (yes we have SOPs for EVERYTHING!!)"Target Outputs" which would be a report showing the timeline of the SOP process so that management can see where we are spending too much time (my vote is for the design of the document control system!!)"Maintenance History" which would show all previous versions for each piece of equipment and administrative procedure."List of Archived SOPs"which would show all of our inactive SOPs, for the Quality Analysis/Quality Control person's benefit.
I have a Search form where the user can click a Button that opens up a rtb with every single word (12,800+) used in the King James Bible. Every word is Capitalized ("Thankful, Grateful", etc), so in my code, the user selects a word, then right-clicks and sends the word to the TextBoxSearch in lowercase. Now, if the RTBDisplay (where all search results go) is empty, then a msgbox pops up asking if the user would like to re-search the same word in Uppercase. If they click OK then the word in the TextBoxSearch (lets says: "thankful") is supposed to become "Thankful". But instead, the TextBoxSearch goes blank. I have tried many variations of code, and here is my latest (doesn't work):
If Me.RichTextBoxSearch.Text = "" Then
MsgBox("Would you like to search the same word but in Uppercase?", CType(1, MsgBoxStyle), "Re-Search?")
If CBool(MsgBoxResult.Ok) Then[code]....
I have a combo box field in my datagrid and when i go to edit the value, when i click on the drop down arrow, it selects the row on the first click and then on the second click it opens the drop down. My question is, is it possible to make it drop down on the first click.
View 3 RepliesI am trying to build a form that has a button on it that will open up a 2nd form that allows me to view and edit the connection string. I believe the connection string is also called app.config, and can see that in the Solution Explorer for the project.All I have managed to do is drag a button onto my main form and relabel it. I have no idea how to create code to access the connection string.
View 2 RepliesMDIform contains Form1. Form1's MDIParent is set to MDIform Form1 has a button on click that opens Form2 as a show dialog. I need this Action.Form2 has another button that opens Form3.Is there anyway that I can make Form3's mdiparent the original MDIform by passing Form1.mdiparent value to form2 (without actually setting that value) that then passes it to form3?
[Code]...
How can i call another button by just clicking on one button?
View 6 RepliesI'm using Visual Basic Express 2008 (VB.NEt). I've created a project which
connects to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app.
I need to add a button which exports the database to a fixed length text file. Does anyone know the code I would use to do this?
I am working on a very simple application in Visual Basic 2008 Express.
The program has a Listview where I display the "DisplayName" field, the user clicks on a name and this should fill 3 text boxes. The code is:
strSQL = "SELECT FName, LName, DisplayName FROM tStaff WHERE DisplayName=@DisplayName;"
Dim conn As New OleDbConnection(strConnString)
[Code]....
This produces the error "Parameter @DisplayName" has no defaul value"
The value of the variable "strDisplayName" is correctly captured.
I need my program to connect to a database within my application i.e.What I have:
m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = C:Documents and SettingsmeroneyfMy DocumentsVisual Studio 2008ProjectsAsset Manager 2008inDebugDatabaseAssetManager.mdb"
What I need is: m_cnADONetConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source = DatabaseAssetManager.mdb"
I have used:System.Windows.Forms.Application.StartupPath & "ImagesSystemDefaultImage.bmp"
for loading of images within the default directory. but this returns the app path but also includes "System.Windows.Forms.Application.StartupPath" in the string?
What is the best way to set the default value for 'bit' or boolean data types in SQL express? I am using the data base explorer in VB Express 2008 and the only way I seem to be able to do it is by using ((0)) for false and ((1)) for true.
View 1 RepliesI have a database app where on a button click, I export the current record to crystal report which in turns converts it to a PDF file. Upon application startup, I export one record into PDF just fine but when I move ahead to the next record and I click the export button, the new PDF file that was exported is now blank. If I restart the app, I can then export the one record again but any subsequent record will export to PDF as a blank PDF file.
To sum up:I can export one record once using the below code snippet but when I try it for a second time on another record, I get a blank PDF file (only the crystal report formatting is in the PDF).
[Code]...