I have tried the following:tabsmain.SelectedTab = tabNew
and tabsmain.SelectedTab = tabsmain.TabPages.Item("tabnew")
As per articles found through Google.
These don't seem to work though.
I'm tring to create chart from Column B (to be X axis), and column D (Y axis).when I set it as range: .range("B":"D") - it'll take also column C.How can I set range for chart to be column B and D only??
View 1 RepliesI'm looking for a way to use two DateTimePicker controls to select a range of hours and minutes within one day. That is, to basically select a 'starting time' and 'ending time'.
I started with two DateTimePicker controls with the custom format of h:mm tt. I tried adding (on ValueChanged), a check that made the selected 'starting time' will become the 'ending times' minimum and vice versa, the 'ending time' becoming the 'starting times' maximum
However, that approach didn't seem to work -- I was still able to select 11.00 AM on the 'ending time' and 1.00 PM on the 'starting time'. I have a feeling that the current day of the timestamp has something to do with it (e.g. the starting time is of the previous day, and therefore is less).
I thought about changing to a combo box of preset half hour intervals throughout the day; however the minutes need to be more flexible than that...
UPDATE:
Dan's comment below answered this problem... This is the code I ended up with for reference;
Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
[Code]....
I'm looking for a way to use two DateTimePicker controls to select a range of hours and minutes within one day. That is, to basically select a 'starting time' and 'ending time'.I started with two DateTimePicker controls with the custom format of h:mm tt. I tried adding (on ValueChanged), a check that made the selected 'starting time' will become the 'ending times' minimum and vice versa, the 'ending time' becoming the 'starting times' maximum?
However, that approach didn't seem to work -- I was still able to select 11.00 AM on the 'ending time' and 1.00 PM on the 'starting time'. I have a feeling that the current day of the timestamp has something to do with it (e.g. the starting time is of the previous day, and therefore is less).I thought about changing to a combo box of preset half hour intervals throughout the day; however the minutes need to be more flexible than that... This is the code I ended up with for reference;
Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
[code]....
I have the following code to select records from an access table based on a date range. The user is required to select a week ending date (Saturday) from a datetimepicker field.The date field in access is formatted as short.The values in the database range from 12/04/2009 to 2/05/2009. When I select datetimepicker as 2/05/2009 (i.e. 2 May 2008), no rows are returned. Following is the resultant sql statement:
show: Select * FROM Work_Time WHERE WorkerID =1001 AND (WeekDate >=#26/04/2009# AND WeekDate <=#2/05/2009#)
However, if I select datetimepicker as 25/04/2009, the correct numbers of rows are returned. Following is the resultant sql statement:
show: Select * FROM Work_Time WHERE WorkerID =1001 AND (WeekDate >=#19/04/2009# AND WeekDate <=#25/04/2009#)
Private Sub btnGetTSData_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGetTSData.Click
Dim dSelect As Date
dSelect = dtWkEnding.Value
[code]....
I have three pages: default.aspx, Registration.aspx and order.aspx.when sombody choose the items from the ddl default.aspx pages, it goes to registration pages as regristration.aspx?value=hyveeand on that pages there are three tabs: step 1, step 2, step 3 and finish. Those steps are for entering customer informations and finish for validate and submit the registration).
View 2 RepliesOne of the great features of Page Frames in the now discontinued FoxPro language was that you could use a Page Frame (like a TabControl) and hide the tabs. The nice thing about this was that if you wanted (for example) to have simulated "frames" you could use a Page Frame control, hide the tabs, and that gave you endless frame that you could then access programmatically.I need to do something along the same lines. To further illustrate, if you look at any configuration screen in Office 2007, they all have a ListBox on the left, and then clicking on those Listbox selections brings up "frames" on the right with what you want to work with.This is the effect I want to create - but in .NET I cannot see a good control to use.
Panels - these seemed a good idea at first, but even when set to Visible and not Visible these frames hide each other so they dont seem like they will work.
GroupBoxes - Tried these but the same problem as with panels.
TabControl - Tried this, and it works great - but I DONT want the Tabs. Instead I want non-tabbed pages, that would then be like frames.
What is the best control to use? And, can I hide the Tabs somehow in the TabControl?
in my asp code i was using
<%
UserIPAddress = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
If UserIPAddress = "" Then
UserIPAddress = Request.ServerVariables("REMOTE_ADDR")
[code]....
how could i do something like this in asp.net(using vb.net)
I cannot get printdialog1 to print a page range using the dislog. It always prints the entire document, no matter what setting I use in the print dialog. Why?
View 11 RepliesI have aspx gridview with checkbox on evryrow, what is required is whenever we check any of the rows, a query should be launched to change the specific agent -each row consist of agentID, Pass, Status- to Paid Status. using javascriptWhat I need to know is how to loop to get the Checked row and get the ID of the row checked so that I can get THe ID of the Agent in thos row so that I can update its status.using javascriptI found something similar on stackflow:t GridView selected row DataKey in JavascriptBut it is not my case, what is needed is at the check of a checkbox a javascript function should launch through which I could update the selected row in grid view after having the index of this row and this all to avoid refreshing the page.
View 2 RepliesI was wondering if there was a solution to replacing the tab control's tabs with custom tabs made in Photoshop. I know there are plenty of super expensive programs that can do it, but I was wondering if there was a way to do it programmatically. I was thinking that maybe it could linked in some way with a .DLL?
View 1 RepliesMy code is basically a file parser/editor and it handles most files fine as they hold a handful of records concerning family members. However there are a few files that crash when trying to deal with them. Here is the problem.Each family member record creates 3 tabs that hold an average of 3 group boxes each. Each group box holds an average of 3 text boxes.So each member record creates 3x3x3 = 27 text boxes and some files get up to 289 family members which = 7803 text boxes.
The problem is the rare file with 400+ member records = 10,800 text boxes which causes a crash due to using up all the window handles. Each member has a separate tab page (with 3 subpages) but really only a dozen or so member pages are visible in the GUI with scroll arrows to move through them so I was thinking of somehow making the GUI a scrollable window so the tabs get built, displayed and disposed as the user scrolls left and right through the member tabs.
The files are parsed into a 3d list DataList(x,y,z) where x is the page number, y is the group box number and z is the text box number. So all the data is available. The code then traverses MyList and builds GuiList(x,y) where x is the page number and y is the groupbox number with all the textbox.text linked to MyList(x,y,z) locations so all text changes are reflected in the MyList.
I already have a memberCount variable and I am thinking of building, say, the first 30 member tabs with the middle 10 being visible in the GUI. If the selected tab > 20, then dispose of the first 10 tabs and create tabs 30-40.I am thinking I will keep all the member tab pages so I don't have to deal with inserts and indexing problems but just dispose all the group boxes and text boxes for tab pages out of view. I already have a deep clone sub that clones members when the user wants to add a new family member and I am thinking I will have to add something similar when a tabpage is passed in for disposal, it traverses and disposes each text box, then disposes the group box for each group box on the tab page.Additionally, another routine will rebuild the group boxes from the data held in MyList(x,y,z) when a tabpage(x) is passed in.
How do I continue to print a list onto another page once the bottom of the page is reached?
Dim PrintFont As New Font("Arial", 14)
Dim HeadingFont As New Font("Arial", 14, FontStyle.Bold)
Dim LineHeightSingle As Single = PrintFont.GetHeight + 2
[code]....
I have a form with 3 tabs: one tab is for user entry and computations, a second tab shows values that will be used for computations which are read from one database (I call it settings in that the values are constants for calculations but it's not application settings in the way people think of it, to be clear) and the third displays a table from another database. The second tab has a table adapter interface for the dataset that contains values used for calculations that can be changed (to do different scenarios.) Those numbers are read from a single record in a database that has 20 fields and was read once when the data is loaded into the second tab to be displayed.
The problem I am having is that I would like to use the numbers from the second tab (the constants) in computations to be shown on the first tab. I have tried declaring the variables on the second tab as public but they are already "friends" with the form event. However, when I go to use them in calculations, it's like they don't exist.
For example, one calculation I am doing is fuel cost. The user enters miles and this is stored as a variable called mileage. To calculate the result fuelcost, I have to use two other fields that are shown in the second tab: MPG (miles per gallon) and fuelprice (the price of gas). So fuelcost = (mileage/mpg)*fuelprice. These are read from a datatable called testdata which is actually part of the project. I want to be able to use these variables throughout the program but declaring them as public isn't working.
How do I make the variables from one tab usable elsewhere in the program? The other thing I noticed is since the values of the variables are loaded into textboxes and assigned variable names by naming the textboxes, using val([variablename].text) isn't solving the problem either. For example, saying milespergallon = val(mpg.text) is not doing the trick because I am getting a message that 'text' is not an integer when I declare milespergallon.
Update Here the code that is being used:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim mileage = Int32.Parse(Miles.Text)
Dim rate = 0
Dim baserate = 0
[code]....
TabPage2 is where the variables are displayed that I want to use in TabPage1.
Private Sub TabPage2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TabPage2.Click
End Sub
I have a tab control in my Main Form which has 2 tab pages, each of which are a different form. I create them as:
Dim UserManagementForm As New UserManagement()
Dim FileManagementForm As New FileManagement()
Then set them up via:
UserManagementForm.TopLevel = False
UserManagementForm.Parent = TabControl1.TabPages(0)
UserManagementForm.FormBorderStyle = FormBorderStyle.None
UserManagementForm.Dock = DockStyle.Fill
[code]....
I have a PrintForm component on my form and I am trying to send the currently active tab page to the print form and then send it to the appropriate dialog. However, I keep getting the document contains no images. Any ideas how I pass the tab page to the print form component?
I try to select the last row like this:
Dim lastRow As Integer = DGV.RowCount
MsgBox(lastRow)
DGV.Rows(lastRow).Selected = True
The messagebox returns the correct number, but when it comes to select that row it says:Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
But if I assign it a row, example: DGV.Rows(5).Selected = True
I want to select records from a access table using sql in vb.net 2010 based on what a user types....
My statement is: comm = New OleDbCommand("SELECT * FROM Recipes WHERE RecipeName= '" & TB1.Text & "')", con)
this only selects records where the full word is the only word in the record set.
I want to type say "Vodka" in the search box and then it must return all the records where "Vodka" is ANY part of the record name: ie: "vodka" or "Vodka" (any case letter) or "Blue Vodka" etc.
I have a custom (inherited) TabControl which adds Drag/Drop functionality to it, so that one can drag the tabs around, either within the same control (to re-order them) or to and from other TabControls. I've noticed some time ago that my TabControl however was not raising its MouseClick and MouseUp events (or actually: it is not calling its OnMouseClick and OnMouseUp methods, which comes down to the same thing). I've been struggling with this problem for a long while and I finally figured out what is happening. I'm no closer to figuring out what to do about it though... The problem seems related to the drag drop functionality. I have this code in the OnMouseDown method (which is raised as usual):
[Code]...
Is there a way to make a column unselectable? I can make the column read-only but it would be easier if it was unselectable so the user won't be confused trying to enter data into a read only cell. So if I clicked on a cell in that column or moved into that cell in that column it would jump to the next column, or not focus on the cell at all.
View 4 RepliesI am trying to select records from a table using the following command
SQLStr = ("SELECT ItemCode, PriceSold, WhenSold, WhoSold from SoldItems where WhenSold = '" & DateTimePicker1.Value & "'")
I get the error message
[code].....
Using Excel 2007 and VB 2010...I'm trying to have my program select a specific worksheet from a workbook yet my program keeps opening whatever sheet was active at the time of the file being saved last. Here is my code for that
xlWorkbook = xlApp.Workbooks.Open("MyWorkbook.xlsx")
xlWorkSheet = CType(xlWorkbook.Worksheets("My Worksheet"), Excel.Worksheet)
I have two DateTimePickers controls.I am wanting to loop from one date to the other, displaying the date in a msgbox.[code]
View 4 RepliesHere is my
Dim ListViewItemArray(-1) As ListViewItem
ReDim Preserve ListViewItemArray(UBound(ListViewItemArray) + 1)
[code].....
I have an application written in VB.net for batch print jobs. As part of the application, the user selects two printer trays to use to print the batch to (one plain paper the other coloured for coversheets and batch seperators) I had this working until we upgraded our systems from Windows XP with Office 2000 to Windows 7 and Office 2010. Now the selected trays are not being recognised and an error is thrown.
I've looked at similar posts on here and other forums but they seam to concentrate on using some word default trays (wdPrinterDefaultBin etc) however I need to be able to let the user pick whatever tray they wish to use. I don't want to have to go through every printer in the building and map the trays to the word values either as I don't want to rewrite the app everytime we've a new printer.
Here is the code:
sub PopulatePrinterTray (byref Printer as String)
'gets printer trays for selected printer and then populates some comboboxes
Dim pkSource As Printing.PaperSource
Dim printDoc As New Printing.PrintDocument
[code]....
I'm wanting to loop through a range of dates set by date time picker. This is my code and as the SD.Value.Date is 23/05/2010 it shows Sunday for me. However on the Loop it keeps showing Sunday and Never stops.
Dim SD As Date = StartSearchDate.Value.Date
Dim ED As Date = EndSearchDate.Value.Date
Do While SD.Date <= ED.Date
MsgBox(SD.DayOfWeek.ToString)
SD.Date.AddDays(1)
Loop
how do I go about selecting a time of day in a form??
I have tried using a datetimepicker but it just selects a date and it displays the static time (current time).
So i want to create a program (or specifically a part of a program -form?) that will be able to load a xml file.I have managed to save an xml file from a xlsx workbook, i want the program to be able to sort each column either by it's value if is a number or by it's text if it's a text , i would also like to have a range sort so the "program" will only show results from a specific range
View 23 RepliesI am pulling data from a SQL server database into a dataset. The date are a DateTime type:
[Code]...
I can see the data in the field reads: 2011-09-09 15:56:29.667. I have tried to convert this by adding convert(varchar(10),DateFrom,103) which results in 09/09/2011 and then Custom Formated the DateTimePicker but still no success.I think I might be going completely off track here so can someone guide me on where I am going wrong here or the best way of doing this
I'm am trying to determine the total number of fields under a particular heading given that the other Heading's total number of fields are > or < than the heading in question. The query, shown first in the attached code, works well if there is one column in one database table, however it does not work well when there are a number of columns with a different number of fields respectively. The CategoriesID encompasses the entire tables contents.I devised a function to determine the total number of fields within a particular column and then attempted to incorporate this, without success, into the second query, shown in the code.
Private Sub GetRandomHeadingFields()
Dim varNumberHigh As Integer
varNumberHigh = TotalNumberofHeadingFields()
[code]....
Can I select all buttons in my form on mouse hover event in few lines only?I want to add hover sound effect on all buttons when hovered.
View 2 Replies