I have several instances of one form loaded. They all have an instantiated variable "Name." How do I select one of these forms based on the name variable?
Code:
Public Sub MakeForms()
Dim x as New frmBlack(me)
x.show
End Sub
I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
Using Visual Basic 2008 Express. I need to pass a variable to another form. Or else make the variable visible to both forms.
View 4 RepliesI have a table and I need to select the record based on an Id. I only want to return the record that has the Max(Date) on a date field. How do I do that?
In SQL Server I use this
SELECT * FROM dch
WHERE EffectiveDate = (SELECT MAX(EffectiveDate) FROM dch
WHERE ID = 99) AND ID = 99
How can I do this in Linq. Unfortunately this app is coded in VB.NET as we inherited it that way.
I was trying these
Dim qry = (From dch In db.dch _
Where dch.Dealer.Equals(Dealer) _
Select dch.EffectiveDate).Max()
[Code].....
What I have is 4 datagridviews named dgv1, dgv2 etc.I also have a variable curr_player whose value is between 1 and 4. I would like to be able to enable one of the dgvs based on the value of the curr_player variable. I'm reluctant to to write select case for each time I want to do this so the question is can I enable one of these objects based on that variable?
View 3 RepliesWhat I have is 4 datagridviews named dgv1, dgv2 etc I also have a variable curr_player whose value is between 1 and 4. I would like to be able to enable one of the dgvs based on the value of the curr_player variable. I'm reluctant to to write select case for each time I want to do this so the question is can I enable one of these objects based on that variable? something like Datagridview(curr_player).enable=true
View 1 RepliesI am trying to Select data based on two where, but I am not writing the statement correctly can anyone see where I am going wrong? [code]
View 13 RepliesUsing VB.Net,I have an XmlNode object, xNode.I need to select an attribute of this node if it has a particular value.
e.g. xNode.SelectSingleNode(".[@attr1='1']")
I would expect this statement to return the attribute "attr1", only if it has a value of "1". However, I get an error - Expression must evaluate to a node-set.When I tried this - xNode.SelectSingleNode("@attr1[@attr1='1']")It always returns Nothing, even if the attribute has a value of 1.
I 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 RepliesI have a database table that holds order information and saves the current gold price (world price) automatically at the time of entryif i look back on the table, and the saved gold price has a difference of the current gold price of + 100 i want to show that in a report
View 1 RepliesI'm trying to write a small app which can be used in order to log off Citrix Sessions. Citrix Sessions can be logged off via cmd or a batch file using this method:
[Code]...
So basically what I want to do is to select each listbox item that matches one of the hits from the cmd command. Probably the servername that gives a different result than "No User exists for" How can something like this be achieved?
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file. OrderDetailsID is a foreign key in Requests Table.
I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId. And If there is a row in Requests Table for each OrderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum.
Here is the way I implement that. I am looking to prevent using "For each".
iRefund = (From od1 In dc.OrderDetails _
Where od1.OrderID =1 _
Select od1.UnitCost).Sum
[Code]....
Contact Title has a default value which is Sales Person. Anyhow, when a user click Edit on the chosen ListView record, i need Contact Title to have the right value that corresponds to the chosen record. For example, if user clicks edit, the fields on the left side will be filled with values. In this case, i want Contact Title to view the right value.
View 1 RepliesI'm trying to display a different image based on the day of the week but my code is stuck on Monday. It won't work appropriately.
[Code]...
I want to be able to have a case for each data system data type. Obviousely the code below doesnt work but it should make it easier to understand my question.
[Code]...
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file.OrderDetailsID is a foreign key in Requests Table.I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId.And If there is a row in Requests Table for each rderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum
View 3 RepliesHow do you select records based on the next 10 days from todays date.For eg:Lets say I want to select records based on ReqDt = today + 10Select * from Sample1 where reqdt <= today + 10
View 4 RepliesI need to use a select case statement that evaluates PostDiscountCost based on the value 0 to 999.99, 1000.00 to 1499.99, 1500.00 to 2499.99 and one that doesn't fall within the others. The message box's going to be triggered by the vbYes in the confirm exit message box. Im not asking anyone to do it for me, I just have no idea where to start it, if I need to declare anything else and if I'm on the right track. Code Attached.
View 1 RepliesI have a bound datagridview and I have found this forum that code that I use to select a row based on criteria
[Code]...
The code with selection works fine but it doesn't reset bindingsource (bsrc_SEL) .Current and also doesn't scroll to the first selected item,I know that code coudn't do more but how can I solve that.
Say I've got the following variables:
Public Shared x As String = "100"
Public Shared y As String = "text"
Public Shared z As String = "something"
[Code]....
But this doesn't do what I want, naturally. What I want is that my function giveVar returns the value of the variable that holds giveVar. For example I call giveVar("x") I want my function to return "100".
Of course this can be done by a Select Case but thats not what I like to do. Is it even possible to call a value based on a string?
[edit:]
Namespace i18n
public NotInheritable Class Settings
Public Shared LanguageCode As String
[Code]....
I think this works so far, BUT I get the following error on the CallByName(Me, varName, vbGet) at the Me : "me is only valid within an instance method"
I have a DataGridView with 3 columns (metric_key, metric_name, metric_value).There are for example, 6 ROWS in this table (6 different metrics), added programmatically (DGV is not bound in any way)
Now, when I assign values in my grid I do:
dataGridView1.item("Metric_value",0).value = "value of the metric in row 0, in the column named "metric_Value".
[Code]...
I'm using the following select statement to pull rows of data and display them in a datagrid.[code]This displays sometimes 5,000 different rows of data with one of the columns being time. Their times are something along the lines of 6:08, 6:09, etc. Is there a way I can show only 1 row for all times between 6-6:59?[code]
View 1 RepliesEverything I know about .Net programming tells me that the behavior I see here is completely impossible. Simple code:
Structure WKSTA_USER_INFO_1
Dim wkui1_username As Integer
Dim wkui1_logon_domain As Integer
[Code]....
When I put a break point in here, I see that after RtlMoveMemory, my wk1 contains a pointer to a username, and all the others are 0. This is consistant. Now, if I change Dim test As String = "" to Dim login As String = "" and run it again, wk1 contains pointers to both username and logon_domain.
If I change it to Dim login As String, it contains a pointer to only the username. Depending on what I change that (completely unused) variable name to, I get a different result.
I have always been under the impression that it cannot possibly matter what you choose to name your variable. And that declaring a variable, and then never using it, cannot possible be different from not having a variable there at all.
I've tried this on 2 computers, with consistant results (one on .Net 3.5 and one on 4.0). When I tried converting it to C#, however, I was not able to reproduce it.
I am aware, by the way, that I can just use System.Environment to get what I need about the current user information; this was old VB6 code that was automatically upgraded (and I've edited it a little to make it more trivial).
So I'm trying to write a MasterMind game, but I have a problem I have 40 pictureboxes set up in 10 different rows, and I want to have one code handle all 10 rows, rather than copying and pasting the code and changing the names of the pictureboxes. I've been trying to use a variable to achieve this, but if it's possible, then I don't know the correct way to do it.This is what I have right now:
[Code]...
What i am tring to do is execute certain code based on a variable held in a module someting like compiler directives, here's an example for lack of an explanation.[code]...
View 2 RepliesI wish to display a greeting to the user when they start an application. It's very simple "Good Morning John" or "Good Afternoon John" or "Good Evening John" depending on the time of day. How do create a time variable where it's based on 24 and not 12?
View 3 Repliesthere is a way to turn the following code into a sub so I don't have the same boilerplate show form code in use a thousand times in a program:
Example:
Public InstanceOfFrmGeneric As frmGeneric
If InstanceOfFrmGeneric Is Nothing Then
InstanceOfFrmGeneric = New frmGeneric()
[code]....
I have two module-level variables and Linq query. I want the results of the Let clause to change the global variables - is this possible?
For example:
Dim X As Integer = 0
Dim Y As Integer = 0
[code].....
I am a former IT student and have not used VB in a little while but feel it can come in handy to help me complete some tasks at work.I am trying to write a small program which will open a url + a number for each number entered into the textbox. As an example lets say the website is "www.google.com/id=" and I enter into a textbox 3 values such as "134,325,2112", www.google.com/id=134, www.google.com/id=325 and www.google.com/id=2112 would all open at once.
The purpose of this is at work, we have an employee database and would like to load multiple employees at once (upto 6 at a time) to compare profiles. The issue with doing this manually is we have to fill out the search criteria for each, instead, I would like to load a link with parameters in it already filled out + the employee number we are searching for each number entered into a textbox on a VB form.
I have a VBA form in Microstation I am using to try and help automate a task. The only problem I am having is I am reading a textbox (Filebox.Text) and setting it as the variable (FN). It works, because I used Msg.Box (FN) to test it. However, in two of the lines of code, I am trying to use (FN) to pass the typed in filename to the command to run in Microstation. Unfortunently, it gets passed on as (FN).dgn instead of the actual filenale typed into the textbox. Is there a way I can make the variable actually seen as a variable? Code on Pastebin: url....Also, not sure if this is the right section, 100% new to VBA, coming from a world Bashed together.
View 3 Replies