Show Values Based On A Starttime And Endtime?
Aug 20, 2010here im trying to show values based on a starttime and endtime in another column in the same row
what am i doing wrong in this statement
[Code]...
ADVERTISEMENT
Show Values In Row/column Based On The Selected Time?
Aug 22, 2010im trying to show values in row/column based on the selected time
Public
Sub Btnplanner_Click(ByVal
sender As System.Object,
[code].....
DB/Reporting :: Show Values From Data-set To Text Box Based On Selection From Combobox List
Mar 18, 2008How Do I show the values from the dataset to the text box based on the selection from the combobox list i already populated the combobox my code is. [code]
View 3 RepliesVS 2008 : Timer Code For VB6 To VB2008 - Error1Name 'StartTime' Is Not Declared
Jun 10, 2009This timer code is for VB6 and worked fine, It's to change the timer seconds into minutes, I'm not sure how to make this work for 2008 though.
Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Timer1.Interval = 1000 ' set timer to 1 sec intervals.
Timer1.Enabled = False ' timer is off
End Sub
[code]....
the errors are...
Error1Name 'StartTime' is not declared.
Error2Name 'MinutesToWait' is not declared.
Error3Name 'StartTime' is not declared.
Different Values Based On Alot Of Other Values?
Aug 21, 2009Not sure exactly where to begin with this one. i have a screenshot that would make this easier to ask, but I can't figure out how to post it here.
[Code]...
How can I apply/combine both of these so that it will figure the datediff for each row (on a datagridview), figure the appropiate case and then update each annual leave row in the database?
Take Values From One Table, Based Off The Values In Another?
Apr 9, 2012[code]If I wanted to get Part Name for multiple PartIDs from OrderDetails, how would I go about doing this? Would I use two DataTables? I'm confused as I cannot see an efficient way to do this. The only thing that I can think of is to create a DataTable with SQL:[code]and then maybe use a For loop to take each PartID, create another DataTable to find the PartName for that and then give this to a variable. There could be up to 10 PartIDs to search through and I don't want to have variables such as PartID1 PartID2 etc. [code]
View 2 RepliesC# - Show Text Based On Login?
Sep 8, 2011I have a login page and I am capturing not just user's username and password, I am also capturing whether the user who has visited us has voted or not.I have put all of this into session variables:If the user is successfully logged in, the user is taken to a menu page.So far so good.On the menu page, I have a link that says, Please click here to register.I have been asked to show the link only if the user has not registered.So, my initial approach is to have this bit on the page_load() event of menu page.If session.Item("voted") = "1" Then 'User has voted Show the user the message that says, Thanks for your vote" Else 'otherwise show the user the registration link end if?
View 1 RepliesHow To Show Roles Based Menu
Dec 9, 2009How to show menu according to their roles in vb.net2.0
View 8 RepliesShow And Hide Data Based Off Of A Value In A Column?
Feb 16, 2009I would like to know how I can show and hide data based off of a value in a column.
Example. My table has 3 columns Name, Password, and Tel#
:Pseudo Code
if Name or Column(0).Row(0) = "Shawn" then
. Column(1).Row(0).Forecolor = System.Highlight
. Column(2).Row(0).Forecolor = System.Highlight
[Code].....
I placed my code in the rowprepaint event of the datagridview and on start up I get the results I am looking for. However, if the user selects the row or a cell in the row then the value will display.
I don't want the value to show even if the row is selected.
Calculate A Column Values Based On Other Column Values In Datagridview?
Jun 3, 2011am trying to calculate the values in rows in column 6 based on values of column 5. Bellow is the the code I am using I get a run time error about the string not formatted properly
[Code]...
Get Value Of BLOB Field And Show / Hide A Label Based On It?
Nov 2, 2011I'm calling some data from my Oracle table and I have a field which is called 'image1' which is a BLOB field.
Sometimes an image is input into the field and others it's not. I need a way to read the BLOB field to see if its a blank and then show/hide my label based on its contents.[code]...
Show Menu Items Based On User Rights?
Jan 18, 2010i've created toolstripmenuitems in design time.I named it to mnuUser,mnuKaryawan and form menu based on it too..I create a table that holds the data like this
position menu
admin mnuUser
admin mnuKaryawan
I'm wondering how to achieve suppose the admin logged in,then the menus will be shown?
Crystal Reports - Show / Hide A Sub Report Based On Condition
Jun 2, 2009I've a VB.net 2005 desktop application, and i'm using crystal reports. In one report i've abt 6-7 sub reports. is it possible to show/hide a sub report based on some condition. i'm new to crystal reports , please suggest what is the best possible way to achieve this.
View 1 RepliesShow Genealogy Diagram To User Based On Readily Available Data?
Mar 10, 2012I have a requirement to show genealogy diagram to user based on readily available data. Our existing database is as follows
1- Every person has unique ID
2- Relation field's has id of respective persons based on relationship like Father, Mother, Spouse etc.
Show/draw Path Dynamically Based On Label Coordinates?
Dec 5, 2011does anyone know how to connect points of a label? Let's say I have a label and start the label at point 0,0. Aterwards, the points jumps to 3,6 ... then to 6, 9 dynamically based on incrementing 3. How do I show for example, the path it takes to let users know where they are? for example, 0,0 --> 0,3 --> 3,6 --> 6,9 --> etc. I've tried with drawline but unfortunately, this leaves my lable in a mess.
View 1 RepliesCalculating Elapsed Time Based Upon Two Values
Jun 26, 2005I have one text box that contains a value for the "Start Time" and another text box that contains a value for the "End Time."Both of the values are expressed in a format for military time (i.e. 1200, 1300, 1430, etc.).When the "End Time" text box loses focus, I would like the "Elasped Time" (expressed in minutes) to appear in a third text box.Seems easy enough...right?Well the problem I'm having is since the first two numbers in military time are base 24 and the last two numbers are base 60, a standard calculation subtracting the "End Time" from the "Start Time" does not yield an accurate result.
View 3 RepliesCalculating Subtotals Based On Values In Two Columns
Jun 1, 2010I have a monthly forecast showing expense accounts by cost centre so columns headings look like:
Cost Centre, Account Number, Jan, Feb, Mar etc
Using VBA code to automate the process, I need to calculate the total for each month of each account number where the 2 left characters of the cost centre are the same. I have a formula which will calculate this (for one cost centre grouping/account) which looks like this:
=SUMPRODUCT((LEFT('Sheet2'!A6:A5136,2)="BE")*('Sheet2'!C6:C5136=AccountNumber)*('Sheet2'!D6:D5136))
I am not sure whether there is a more efficient way than using a formula like that (at the moment this would be used for 12 months on about 6 cost centre groupings with about 500 accounts each - though this would vary). Its not massive, but could be slow to calculate. I don't think the subtotals command is powerful enough, and I haven't used arrays for a long time (especially for what would appear to need a dynamic, mulch-dimensional array).
How To Load Grid Based On Values In Xml File
Nov 23, 2010I'm trying to load several grids based on the Type values in my xml file. For example my xml file is in the following format:[code]How do I accomplish this when in the load event of my windows form?
View 2 RepliesHow To Select Multiple Values Based On Parameters
Aug 11, 2011I have a little challenge. I have a report that I declared a parameter called Department that has default values like this: [Code] The problem is that when I test this (with CR10 or on web), and I select multiple values, the thing does not show the values for the multiple values. It only works when I select a single department. What should I do?
View 2 RepliesLINQ-to-XML Selection Based On Node Values?
Mar 8, 2010Given the following XML, I would like to return all eventtitles where the eventtype id = 23. My current query only looks at the first eventtype, so returns the wrong result.
<event>
<eventtitle>Garrison Keillor</eventtitle>
<eventtypes>[code].....
Return Random Values Based On A Range Given?
Mar 22, 2011I am coding a lottery number generator for a homework assignment. My project needs to have functions that return random values based on a range given. The first function I am coding is for a pick 3 lottery game.The function should return three random numbers between 1 and 9. I have coded the function but it only returns one number. When the debugger runs it says my function does not return a value on all codepaths.
[Code]...
Summing Values Based On Type Then On Month?
Feb 11, 2011I have a List<Object> where Object contains Name, Month, Type, Value.
is it possible to sum all the Value based on type, and then based on month?
I am using .NET 3.0 in VB.NET I was doing withe like 4 For loops, but its taking a while to run.
For clarification, I have something like this:
Name | Month | Type | Value
-----------------------------
hello | Jan | A | 1
hello | Jan | A | 2
hello | Jan | B | 2
[Code].....
Show A Dialog (based On Current Code Is Running In A Winform App OR Windows Service)?
Apr 7, 2011I have some shared code I need to use both in a WinForm and a service. How can I test if my code is running in a service, so I can avoid problems with modal dialogs.
View 2 RepliesShow The Objects Based On The Payout And The Prize Money For Paylines In The Slot Game?
Oct 15, 2010I am doing a internet cafe sweepstakes slot game in vb.net. I want to show the objects based on the payout and the prize money for paylines in the slot game. I tried using MT algorithem but it basically random number based. the final output should not be radom.
[code]...
Add Extra Values To A WinForms Combo Box Based On A Hashtable?
Aug 6, 2009I'm trying to add some extra key/value pairs to a combo box using VB.NET. The initial item list is generated from a hashtable, which contains a collection of objects.I've managed to add the extra values to the box using the Add method, however I now run into problems when reading back the selected item from the combo box because some list items are objects, while others are strings.
My best option seems to be to load the initial data as key/value pairs by looping through the hashtable, however this doesn't seem to be working too well either because I'm still getting errors.I'm getting frustrated because it's taking me hours to do something that should take 5 minutes!
C# - Create Controls Dynamically Based On Dropdown Values?
Jun 12, 2012I need to create a sample question types web form in VB.NET which allow user to the following:he user selects the control type from dropdown (TextBox, RadioButton, ListBox etc). Generate controls dynamically based on the control type on the webform.It will always show the TextBox (where user writes the question) and (generated control - TextBox, RadioButton, ListBox etc) and save those values to the database.
View 3 RepliesCompare Field Values Based On The Value In An Array Using Access07?
Aug 11, 2009I have a query I'm using to identify a group of contracts that have expired. The query has a ContractID, Status, Start Date and End Date. For each contract, I need to go to a directory and search for a file to import. That part works just fine, but how can I put a qualifier in to check for contracts that have the same start and end date? Do I need to create a multi-dimensional array for this or can I use the query I have? The part in bold text is where I need to identify identical start/end dates. Comments identify pieces to be developed and message boxes to help me confirm what's happening as I run the code:
Private Sub cmdRefreshList_Click()
DoCmd.SetWarnings False
'Create an array based on the true-up contract IDs.
Dim db As Database, TUrst, PYMTrst As Recordset
Dim TUContracts() As Variant
Dim TUContractID As Variant
[code]....
DataGridView Cell Formatting - Red Columns Based On Values
Jan 12, 2009I want to make a certain column of my datagridview red based on values from 2 other columns. I have a "HI" column, a "LOW" column and a "Result" Column which are all strings. Now I want to make the result column red if it's values is less than the "LOW" columns value or if it's value is greater than the "HI" columns value. I tried the following code but something is wrong because cells that shouldn't be red are red:
Private Sub dgvTests_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgvTests.CellFormatting
If dgvTests.Columns(e.ColumnIndex).Name.Equals("Result") Then
Dim RowValue As DataRow = TestTable.Rows(dgvTests.CurrentRow.Index)
[Code] .....
VS 2008 : Set Colors To The Rows Based On Values In A Cell?
Aug 25, 2009I have a MySQL database which acts as a source for a datagridview, is there anyway I can set colors to the rows based on values in a cell? So that if the value in a row in the field "Priority" is "yes" then the row is red?
View 2 RepliesC# - Make Groups (sections) Based On Column Values In Gridview?
Jul 26, 2010In my grid I have data in two columns same for couple of rows. Then again couple of other rows will same with different data.I want make them into alternative sections with colors In below example(image).
Rows no 1 to 4 has 'High', 'High'. I want make them gray bgcolor for those rows.
Rows no 5 to 8 has 'High','Low'. I want make them white bgcolor for those rows
Rows no 9 to 12 has 'High','Medium'. I want make them again gray bg color for
those rows.