The command works but im getting an incorect time It returns 15/9/2009 12:00:00 the date is fine (was ok when this thread was written)but the time is always the same 12:00:00 Is something wrong with the server or am i entering not the right command?
View 1 Replies
I got a SQL statement where am selecting from an access database in vb but I get this error; "syntax error in query expression select sum(brought_qtty)" when I run my program. I imagine am doing the right thing but seems am not. How can I adjust this select? The code is below:
"select distinct(brought_price) as [Price], select sum(brought_qtty) as [Ordinary] from brought_coffee where " & _"coffee_grade=O, select sum(brought_qtty) as [Premium] from brought_coffee where" & _"coffee_grade=P, sum(brought_qtty) as [Total Qtty]" & _", sum(brought_paid) as [paid], " & _"sum(brought_bal) as [Balance]" & _"from brought_coffee, farmer where brought_date=#" & dtc.Text.Trim & "# and farmer_centre='" & cc.Text.Trim & _"' and farmer.farmer_num=brought_coffee.farmer_num"
If a form is being displayed on the secondary monitor, is there a way to make sure that a MessageBox generated by that form will display back on the primary monitor? The form is being displayed over a projection system and some messages do not need to be seen by the audience, just the computer operator.
View 1 RepliesI have been writing visual basic and vb .net applications for years and have come across this problem with the timer component under Windows 7 32bit on dual core Intel processors. This problem only occurs with Windows 7 running on a dual core processor, single core and under the virtual pc on any processor works.
I have attached a test program to show this problem. The program uses 2 timers to count down to 0. It does not matter what type of timer component I use system.timer.timer or system.windows.forms.timer. I read the system.timer.timer may fix this problem so I changed the program to use it but it did the exact same thing. Left it in anyway.
The program: Timer1 is set to a number of ms for a given amount of time say 150000 for 150 seconds and started. The timer will expire correctly. At the same time a second timer Timer2 is set to 1000 ms for a count down display to 0. Timer2 fires and the count is updated. This happens and everything looks fine. When Timer1 fires I disable timer2 so it will stop counting down. Timer2's countdown is at 2 instead of 0. It is firing slow. If I increase the value of timer1 to say 500 seconds timer2 is behind by 6 seconds. These amounts are the same for the 2 very different computers I ran this on but both are dual processor systems running Windows 7. The exact code works correctly on Windows Xp on the same processors and works under Windows 7 on a Pentium 4 system.
[Code]...
I just got this really cool 9" monitor (USB attached) which I will be using for dialogs in my vb application. Can someone tell me why this code displays on both machines? if I change screen=AllScreens(1) to (2) the form is only shown on the primary but I want to show it on the very cool USB screen.
[Code]....
My app displays a list of records in a DataGridView on the main form. I've developed code for cut/copy/paste for the selected records and have put the code behind Cut/Copy/Paste menu items under a classic 'Edit' menu design, with the standard shortcut keys(Ctrl + X, Ctrl + C, Ctrl + V).
The trouble is, I also want the shortcut keys to work on selected text when I'm editing inside text fields on a record in the DataGridView. So I need the shortcut behaviour to change depending on whether I'm editing a record or selecting record(s).
I have a form1 and many other sub forms in my software.I want all those forms to work on a 2nd monitor (if the user does have a 2nd monitor)while working on my 1st monitor as well.But i don't have 2 monitors in my system hence i cant test this feature out.But dual monitor integration is a very important part of my software.
View 1 RepliesIs there a simple way to differentiate single display vs. dual display clone? I am asking about dual clone, not extended desktop. .Net Screen class treats dual clone as single display. I could not find useful WMI method also.
View 6 RepliesIs this possible in VB 2005? Mirroring or extending over a second display?
View 2 RepliesI am working on a custom bulletin board system for my company. The idea is to have a program running that displays a full screen bulletin board on many monitors around our facility. I wrote a VB client that pulls from a server and displays a single board perfectly - I am wondering how to expand this.
View 10 RepliesI need a 2-listbox mover/selection type control such as the example here: [URL] For over a week now I've searched countless forums and done myriads of googles. All I've been able to find is C++ or ASP based stuff. I really would like this to be VB.net, but at this point, I'd even settle for C#.
I've taken a shot at developing it myself, but am too new to the .Net world to really get anywhere with it other than being completely overwhelmed and frustrated. I've even looked at some 3rd party custom control webistes, and am even willing to spend a few bucks for this thing, if I could find one that suits my needs.
[Code]...
I've got a dual monitor setup, my main monitor is a Dell 20" 1680x1050 res, secondary is a Dell 17" 1280x1024.I've just updated my gfx driver (nvidia driver version 190.62).I'm using code like that shown below to get the screens and I always assumed that AllScreens(0) would be the primary screen and AllScreens(1) would be the secondary but this appears to be reversed since I updated my driver.
[code]...
Is my coding in error or is Windows reporting the screen information wrongly ? How can I be sure to set AllScreen(0) as the users primary screen and AllScreens(1) as their secondary ?
i am looking for a way to make a clone of 2 webbrowsers when i make a click in the first webbrowser it shows the same in the second webbrowser
detailed:i am making a program with a touchscreen and a hdtelevision setup as extended monitor at the touchscreen you can control what is happening on the tv now i want to control a webbrowser but the problem is i want a internetbrowser on the touchscreen where i can make changes and clicks on the websites
and then i want also to view the internetbrowser on the tv to see the website this is meaning i want a clone from the internetwebbrowser from the one on the touchscreen to a clone on the hdtelevision some sort of linked copy/clone of the webbrowsers
i've managed to have the form in fullscreen.. How can it fullscreen if the computer has dual monitors?
.MaximizeBox = False
.MinimizeBox = False
.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None
.WindowState = System.Windows.Forms.FormWindowState.Maximized
how do I prevent my users for more than one simultaneous login per account. I am using Vb.Net SQL.
View 2 RepliesAfter I upgraded from Windows Xp to Windows 7 on any dual core cpu machine my programs that use a simple timer function run incorrectly. The program works with the exact same hardware under Windows Xp and Windows Server 2003. I am using Visual Studio 2005 to write .NET Visual Basic programs that use 2 timers to count down. The first timer, timer1, is set to a value say 150000 ms (150 seconds). The second timer, timer2, is set to 1000ms (1 second). Both timers are enabled one right after the other from a button click event and begin. The timer2 routine running every second updates a label counting down the seconds. When timer1 fires it disables itself and exits. Timer2 also checks to see if timer1 is still running if it is not it will stop. Under Windows Xp and Windows Server 2003 the resulting count in the label is 0 when timer2 detects timer1 has finished. Under Windows 7 when timer1 stops timer2 is not at 0 it is 3 for 150 seconds and gets larger the more timer1 is increased. It appears to me timer2 is not being fired every 1000ms as it was under Windows Xp.
I have included the Visual Basic code below. If you want to test it just run Visual Studio and create a new project. Put the buttons, numericupdown, and labels in your form and past my code into the correct buttons. I have used these type of timer events for years without any problems unit Windows 7. Windows 7 on a single core Pentium 4 with hyperthreading turned on works fine. Windows 7 on a dual core E6500 fails, Windows Server 2003 works.
Public Class Form1
Dim I As Integer
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[CODE]...
I try to create a dual video player with VB 2010.
With that I have 2 forms, 1 main form (with all the controls and it should contain a preview screen of what is being displayed on the second form.
And a second form (with a windows media player component).
Now the main form should have (as told) a preview screen of what is shown on the second screen, I want to know if it is possible to have is as the windows 7 taskbar thumbnail (when preview the mediaplayer).
Select Case currentNodeName
Case "string1","string2","string3","stringEtc"
Case Else
[Code]....
The above is a code snippet... of course I've already made my declarations earlier in the code. My issue is I get the error " 'Select Case' must end with a matching 'End Select'." It looks to me like VB is not liking my If statement with the "Next For" in the middle. I'm sure this is a basic syntax issue.
Private Sub ComboBox6_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox6.SelectedIndexChanged
con = New SqlConnection("Data Source=DEW-D63D9D2D032SQLEXPRESS;Initial
[code].....
Basically, I have the following sql select statement in vb.net.[code]...
From the above statement, I would like retrieve several data and the count of Traceid from trn_Invt_Details where the traceid in trn_Invt_Details match with traceid in trn_Invt. By the way, it will also based on the criteria where the field of ErrorType in Trn_Invt_Details is Null or contain empty string. Then it will retrieve out the count of traceid.Finally, all the results will save to dataset in vb.net
[code]...
im getting an error with my SELECT statement. Cant see whats wrong, but i must be missing something?
I have a small vba in xls 2003:
[Code]...
why I am getting the error pictured below. In this case, the variable DT has the value "REAL"
View 2 Repliesit seems when the treeview loads I get an error [code]I cannot get the error in debug mode.
View 4 RepliesFor some sort of reason, which I can't seem to spot, this fails and I get a #Name? error. When I tried to do this, I use pretty much the same code in another place in my form; the only difference is the "cbo" and the names of my txt and alike.
[code]...
Can anyone spot my error? What I wish the code would do is when I Select something in my cboVarenummer, the TextBox txtVarenavn changes its text to what the sql statement returns.
Using vb2005 and .Net 2.0. I've been trying for some time to get my query to work. I've posted my issue on several forums but no one been able to asssist me. From code behing I need to query Active Directory and have following issues:
1. I need to select only where "title" is empty and
2. I need to do a LIKE on sAMAccountName
[Code]...
CODE:
And the following sub routine is load in the Listbox_selectedindexchanged event
CODE:
And listitem class
CODE:
And subsequently I want to Design the select query by adding the three column i.e. First Name, Middle Name and Last Name in the Listbox and by selecting the list item that will show in text box.
I am trying to select a row in a datatable using the datatable.select method as described in the help files. There are several examples and here is a typical one: Private Sub GetRowsByFilter() Dim t As DataTable t = DataSet1.Tables("Orders") ' Presuming the DataTable has a column named Date. Dim strExpr As String strExpr = "Date > '1/1/00'" Dim foundRows() As DataRow ' Use the Select method to find all rows matching the filter.foundRows = t.Select(strExpr) Dim i As Integer ' Print column 0 of each returned row. For i = 0 to foundRows.GetUpperBound(0) Console.WriteLine(foundRows(i)(0)) Next i End Sub The intellisense comes up with an error on the 'select' line: "value of type '1-dimensional array of system.data.datarow' cannot be converted to 'system.data.datarow'
View 5 RepliesI have a combobox the has12345in it, Does a function, Then changes to the next one
View 17 RepliesDetails: I want to compare these above two table1 and 2 . The unmatched records should be save in a new table .
objectives
1 Should take input the table and fields we want to match each other.
2 Then after searching or reading the record from table and selected fields save the unmatch records in a new table
