I'm relatively new to VB programming & My question was, how do you see the control source or rowsource of a text box so that you can make I display data. I have a case where I am trying to display sub-totals from an exce spreadsheet into a text-box on a User-form. And is it possible to make a selection in one listbox and have corresponding selection highlighted in another listbox?
View 1 Repliesi'm working on a project that is reading text from a file and displaying totals on my form.My issue is that everytime i press my btnCalculate Nothing Happens.Here is the File i am reading from which is in my debug folder.
Otto
Rob
B
Otto
[code].....
Can anyone possibly take a look at my code (below) and tell me what I'm doing wrong? I have been sitting here for hours trying to figure it out. I'm very new at this and I'm thoroughly confused. I am using a book for Visual Studio "Programming in Visual Basic" and I have gone through all of the tutorials and code examples and followed them exactly (at least as far as I can tell). However, whenever I run the program, I am not getting the sum of the quantities I assigned to the constants showing up in"AccessoriesTxtBx" as I'm trying to. It shows up as $0.00 even when I have checked the boxes.[code]
View 4 RepliesI am trying to write a program that will display an excel spreadsheet in Visual Basic. My goal is for the program to display this Work Order Form I have designed in excel and to modify user, date and auto assign a work order number. After that is done I would like to print the excel form. So I guess my questions are:
- How can I display an excel spreadsheet in win forms
- How can I print the spread sheet after it is modified
- Is there a better way I should be doing this
Basically the cells are displayed from Excel to the Visual Basic form, but once I press a button on the form to display the spreadsheet which contains the cell info, the spreadsheet won't display at all. (This I think is because the link has subsequently already called Excel). I've looked at the Task Manager and copies of Excel are already in the process, once these are deleted the spreadsheet can display from being pressed from a button on the form. How can I override this deletion method from the task manager so that the spreadsheet always displays properly from the form.
View 1 RepliesI am wanting to allow a user to enter a number and depending on what number is entered, it will allow that many entries. For example, if 5 is entered, the user has to enter 5 numbers. Those 5 numbers will then be added together.I 6 is entered, 6 total numbers will be added.I was trying to do this with a for next loop but I wasn't getting anywhere.
View 5 RepliesI have a User control having two panels. one at the top border and second at the bottom border of the control.
The panels contain some buttons on the click of which i want to display some forms. But I want thoes forms to act like children of the user control i.e. like MDi Parent - Child (here parent being User control and child being the new forms which would be opening). Unfortunately i've not been able to find any way of do'in so.
I've been working on a class project for quite a while, and I have not been able to figure out this step on my own. What I'm trying to do is connect the totals from three forms to a fourth page where I can then tally to those totals and then add 7% sales tax on the final total on the last page (I don't think I'll have a problem with the final part of add the 7% sales tax, but I'm not completely certain how to go about moving the totals through to that final form. Also, some of my forms use radiobuttons and one uses checkmark controls. I'm going to show some of the code that I have for each page in case this will make a difference. I think I need to do something with a public variable, but I'm not sure how to title that variable, and the public variable should have sub variable sections in each form, or if one specific public variable should be placed at the beginning of each form.I had also considering using a module to connect the totals in the forms together, because someone had suggested this, but I am not familiar at all with this method.
Code form1
Option Explicit On
Option Strict On
Option Infer Off
[code]....
How do I fire an event when changes are made in a datagrid embedded in my form? My datagrid houses line items for different forms (Sales Orders, Purchases Orders, etc.), and when a value is changed (i.e. quantity or price), I want it to re-calculate the datagrid automatically (extended amount) and also re-calculate totals in the form itself without having to hit the Save Button. Right now I have a sub-routine that fires when the button is chosen, but how do I fire this event automatically on datagrid changes?
View 7 RepliesIf my Category and Forum selection is incorrect I am sorry and feel free to move it. I'd like to have the users input in the message box that will show. For example: There is a textbox and the user puts in their name as Bob. Then the message box would be: What my main goal is, is being able to include the users input they type inside the textbox inside the message box.
View 6 RepliesIs it possible to have a Textbox on a form that when the user inputs data, ( during Runtime )that data remains in the Textbox for good and the Textbox then becomes read only ? Is it also possible to make it so that the CD with the programme on, is in the PC when the programme is being used. Perhaps writing the Textbox data back onto the CD ?
View 1 RepliesI'm taking my first (and only) beginning programing class for Visual Basics 2008. I'm working on my final project and have hit a snag. A little background info - I have been able to code everything except for two final steps (but they are my most difficult steps), on these final steps I've gotten two suggestions on other sites, one person helped me with the coding which I used for my form1, but it I still have several errors, and another person suggested that I use a module.
Here is the issue. I have totals on three forms that need to pass through to a final form, and once they are on the final form they need to show up in an itemized list and need to then be totaled again. I actually have a total of 5 forms including my first form aptly named form1, which incidentally is where someone told me I should set up my whole 'connecting the totals' form, and I believe the guy was on the right path with helping me but, I'm still obviously pretty lost on this last segment of coding. Since I had little difficulty with the majority of my project, I didn't think this last bit would be so difficult. I'm going to list my coding for each form below. My project is due Tue morning May 5th Eastern Standard Time, just in case someone starts reading this on or after that date. Just in case it helps explain the issue, I will also post my listing of error codes from my VB project, and they all are centered around my form1 (which is the form that I'm trying to set up the transfer through of the form totals). I also see that I can post attachments so in case it will help I'm going to post my project in the attachment too.
Error Codes:
Error1Event 'Load' cannot be found.
Error2Handles clause requires a WithEvents variable defined in the containing type or one of its base types.
[Code].....
I've worked out how to display charts in VB 2010 Express, but now I'm needing the user to input data into a spreadsheet/table that will be used within the program. I know that table is no longer available and neither is the OWC11 set. Is my remaining option then to use DataGridView? I know it is SQL based and I don't have much experience there yet, but I didn't want to commit to it if there is another method that would work just as well. The values that are put in by the user does not need to be preserved.
View 3 RepliesI make a user control with textbox. When user press enter and textbox doesn't have any text then a search form open. Search a data and select some think and return to main form where my textbox control insert. I write a code below :
If txtIsbn.Text = "" And e.KeyCode = Keys.Enter Then
Frm_Book_Search.FormLoad = True
Frm_Book_Search.ShowDialog(Me)
[CODE]...
But problem is that when Frm_Book_Search close and it must be focus in textbox but it not happend. when user close the frm_Book_Search form then not focus my application another software if open at that time it will be focus that software. if there is not open any software then it is not any problem it will be focus my application in my textbox. how can i write code to focus current form after close frm_Book_Search form.
I have a VB.Net program that reads in a flat file, and then parses line by line, formatting the data into different spreadsheets in an excel workbook (each line can be any 10+ different record types so I parse and put in appropriate excel sheet).
For smaller sized flat files (under 10mb), the parser works great. However, I am trying this on a file that is over 120mb (400k+ lines). While running, I will get an OleDBException saying that the spreadsheet is full. Now I am pretty confident that Excel can handle a much larger data set than a flat file. So I assume this exception is not giving me the true story as to what is really occuring.
I open a connection, and then parse each line in the file, inserting each row into the excel file. I assumed it would be bad performance wise to open/close the connection between each insert. Could this be causing the issue? Any ideas what I need to do to handle such a large file? There are cases where the flat file can be over 500mb.
To actually do the insert into excel, I am just doing the following (I construct an sql query based on the type of row and values parsed):
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExportLocation.Text + "" + importFileName + "-PVF.xls;Extended Properties=""Excel 8.0;HDR=YES"""
[Code]....
I need update the text of a textbox when I do click on a button on a user control.
How I can do that?
I need update the text of a textbox when I do click on a button on a user control.
View 1 RepliesOption Strict Off Option Explicit On
Imports Microsoft.VisualBasic
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.DataSet
[Code]...
I'm trying to add the spreadsheet control to a form in VB but I can't remember what reference or file I need to load to get the object in the toolbox.It has been a while since I used it last and that was in VB 2008.I looked and loaded several microsoft interop files from the .net reference menu but none of the seemed to work.
View 3 Replieshow can I add a spreadsheet into my form
View 3 Repliesembed an excel spreadsheet in my form and maintain its functionality - so i can edit it, formula still works etc etc...
and also if changes are made, save the spreadsheet and so on.
I have an issue that I am trying to work around. I have an aspx page that needs to load up a formated XLS spreadsheet into a DIV tag and then allow the user to input data that will be retrieved later on postback and values store in a MS SQL database.
I created an excel spreadsheet and formatted it with the formulas and colors. I also added a combobox from the control toolbox. I also added a checkbox from the control toolbox to another cell. I then saved the page using File-->Save AS WebPage. I checked the 'Add Interactively' checkbox on the save dialog. I then opened the file in an editor and copied the object tag into my aspx page. Everything was fine except my combobox and checkbox did not appear in the HTML spreadsheet.
I am assuming that I have to EITHER programmatically add the controls prior to render or add the combobox as a XML element to the proper node of the XMLData value parameter attribute.the current XML Block for this node is :
<Row ss:AutoFitHeight="0" ss:Height="18.75">
<Cell ss:StyleID="s23"><Data ss:Type="String">Fund</Data></Cell>
<Cell ss:StyleID="s23"/>
[code]....
The second cell, between FUND and ENG is where I need to add the combobox. also how about binding data to this dropdown control control. This data is coming from SQL DB, and not from a range in the activesheet. Someone told me that I should use Access instead of Excel but I dont think that is right as I need spreadsheet capabilities on the page?
I am converting an Excel spreadsheet with VBA macros to VB. I have been able to export all of the VBA macros (.frm, .cls, .bas), but cannot figure out how to export the controls embedded on an Excel spreadsheet to a VB form (e.g. =EMBED("Forms.CommandButton.1",""). I have buttons, check boxes, list boxes, etc. embedded in an Excel spreadsheet. In the macro editor, I can see the controls in the object browser window. For example:
cmdPrvFirst As CommandButton
Member of VBAProject.Sheet1
Copy/paste does not work. How can I do this? I hate to have to create the VB forms from scratch.
I have a spreadsheet control on a windows form that I would like to populate with data from an existing worksheet (myworkbook.xls, sheet1). The best solution for me would to be to actually open the workbook on my form (not sure that is possible?), the next best solution would be to fill the spreadsheet control.
View 1 RepliesError: ClassFactory cannot supply requested class.I installed 2003 Add-in: Office Web Components, you can download and install OWC11.exe from the following link:aunched a VB formadded the Spreadsheet 11.0 control and got the above error.
View 1 RepliesI Create an application that when a user enters a positive integer value in a input box(the default number is 10) when the OK button is clicked, the application should display a message box with the sum of all the integers form 1 through the value entered by the user. If the user enters a negative value, the application should display an error message. I believe I have to use a loop condition but I have no idea what to do.
EX: User enters 10 in the input box once OK button is pressed a message box pops up and says "The sum of the numbers 1 through 10 is 55". Use the following test data to determine if the application is calculating properly
VALUE SUM
5 15
10 55
20 210
100 5050
I'm building an online shop, but have run into a problem.When the user click that they want to add a product to their basket, i add the product ID to an array that is held on the session.This all works great and i display how many items they have selected etc..The problem comes when i get to the checkout page.Whats the best way of displaying the items that the user has selected?
should i use a datagridview? if so, how do i pass the array into the SQL in order to get all the data rows that i need?
should i use a repeater? this gives me the same problem as above though.I just cant seem to work out how to get the values fro the array and then run the sql for each ID to get the information to show on the screen.I could loop through the array using each ID as a parameter in the SQL but then where do i put the data? in a dataset? a datatable?
I currently have a website and upon registration to the website i generate each member a unique GUID. Upon the user logging in to the website i check the credentials and store the guid in session if successful, in order to show the user there profile / how many post have been made etc i run my queries to the database passing the users session GUID to fetch data related to them.
View 2 RepliesI'm trying to include a user control in an aspx page, it works fine, but my control does position itself where I want it and always appears at the very top of the page. Could it have something to do with the masterpage? I've tried registering the user control in the master page, but I don't know how to reference it in the content page.[code]
View 1 RepliesI've got a label, I want it to display a case of "VocCmb" combo box..[code]If the case is "none", i want the label to display 0, if "sorcerer" then label displays 1 and so on, how to do that?
View 3 Replies