i have an app that pings all IP's on my network and then adds all alive hosts to a list, then my WMI query runs for all of them ips and gets some information. it all works fine except for when it gets to printers and switches/routers which obviously dont support WMI. Is there some way i can check if a device supports WMI and skip the query if it does not?
View 2 Replies
I am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
I want to retrieve query from MS.Access database criteria is between some date range,but I get the following error when execute my reader:Syntax error in date in query expression 'D_ate BETWEEN # @DateFrom # AND # @DateTo #'.
Dim StrSQL As String
StrSQL = "Select * from Pla_Comp Where D_ate BETWEEN # @DateFrom # AND # @DateTo #"
myCommand = New OleDbCommand(strSQL, conn)
[code]....
Trying to write a Vbscript. Actually, I'm trying to modify an existing script that I found on the internet. I basically need the script to run on workstations, delete printers from our old print server (master), and install the corresponding printer from our new print server (dc01). I should also mention that the printer names have changes slightly. So far, the script does a great job of deleting printers from Master, but none of the corresponding dc01 printers are installed.
Here's the code:
CODE:
Am looking at making a small application that will list printers on two file servers at two separate sites, from this app they can add the printer/s to there local computer.
I have found a small application on the web but there are a few improvements it could do with.
They are; Show all local printers without having to click on a check box. Show sites printers without having to click on a check box. Show comments about the printer�s location other then just the site.
If it is possible I would like to update this one, but if there are any other examples where I could download something similar, or even some help with how to begin to create a new application.
Here are some screen shots, of the application form and the xml which holds the folder structure for the sites.
I am trying to bind an Access database to a MSChart control in VB Net 2008. I have a test database populated with four fields SAMPLE-DateTime, Values-Number, MAX-Number and MIN-Number. I'd like to only display the rows that fall within a specific date range but I'm running into a problem when i try to execute the following command:
cmd = "SELECT SAMPLE,VALUES,MAX,MIN FROM TABLE1 WHERE [CHECK_DATE] BETWEEN 01/01/2009 AND 01/01/2011"
i am trying to find a code that will do a search and find the ip address of any printer on the network with a ip address?
View 1 RepliesTrying to work out if there's a nice way of doing this, preferably in Linq rather than loops, which is what I've done for now.
I want the number of days my Product is active between two dates.
Product has many ProductHistories, ProductHistory has values for DateActive and DateInactive. DateInactive can be null, and often will be, to show that this history is ongoing. Histories won't overlap.
I want to sum the maximum of my startDate or the ProductHistory's DateActive, and subtract that total from the sum of the minimum of endDate or ProductHistory's DateInactive (endDate by default if DateInactive has no value).
Worked example:
Get active number of active days between 2011-01-01 (1st Jan) and 2011-02-01 (1st Feb)
Histories:
Active 2010-12-25 : Inactive 2011-01-05
Active 2011-01-15 : Inactive 2011-01-20
Active 2011-01-25 : Inactive null
[Code]....
I have three tables,
Products(ProductID, ProductName)
Orders(OrderID, OrderDate)
OrderDetails(ProductID, OrderID) Junction table between Products and Orders.
For example, there are Three ProductID in Products table A01, A02, A03
Four OrderID in Orders table
1. 01/01/2009, 2. 03/01/2009, 3. 05/01/2009, 4. 07/01/2009.
OrderDetails data as below:
A01 -- 01/01/2009
A02 -- 01/01/2009
A01 -- 03/01/2009
[Code]....
then I want to display the date that A03 is not ordered from range 02/01/2009 till 08/01/2009 which could have the result like this.
DateMissingOrder for Product A03 in range of date 02/01/2009 to 08/01/2009:
03/01/2009
07/01/2009
How can I do this in LINQ to SQL Visual Basic?
I'm receiving an error when trying to query a range of dates from a MS SQL DB in MVC Entity Framework. Unable to cast the type 'System.Boolean' to type 'System.Data.SqlTypes.SqlBoolean'. LINQ to Entities only supports casting Entity Data Model primitive types. This is our query:
[Code]...
i am trying to find a code that will do a search and find the ip address of any printer on the network with a ip address?
View 5 RepliesI am trying to bind an Access database to a MSChart control in VB Net 2008. I have a test database populated with four fields SAMPLE-DateTime, Values-Number, MAX-Number and MIN-Number. I'd like to only display the rows that fall within a specific date range but I'm running into a problem when i try to execute the following command:
[Code]...
I'm using VS 2008 and .NET 3.5. I'm in one of my programs and when I run the program to test it, I keep getting these errors... 'Exception occurred' And the line is highlighted green and there's a green arrow on the side line (where you can enter breakpoints). When the code stops at these exceptions, I can hit continue and the code still runs just fine even though there were a ton of exceptions. Now, I'm wondering if there is a way that I can skip over these or have them not show up because I know the files that this is happening have not been changed in several weeks and I've tested this program beginning of this week and it was working fine... no exceptions or anything. I'm not sure what would've changed. The only thing I did was install the newest versions of Telerik Rad Controls. That should have nothing to do with the exceptions I'm getting.why i'm getting these now all of a sudden or how I can just skip over these without having to hit continue after each time?
View 5 RepliesIt appears that when IO.Directory.GetFiles tries to read a folder that it doesn't have access to it throws an exception & stops reading. Is there any way to have skip those folders & continue reading the rest of the folders?
View 1 Repliesis there a way through vb visual express 08 to ask a printer if it has toner or paper? im not to sure on how to communicate with printers in this way if it is at all possible.i am writing a program to display the status of the printer and this is key.
View 1 RepliesWhen you go to the Start button and then "Printers and Faxes" and you see a list of the printer objects defined on that PC. In my App VB.Net app I want to be ale to use a drop down box to display this list of printers and allow the user to select one of them.So, Not necessarily a list of printers on the Intranet that the user is connected to, only on their personal PC.
View 1 RepliesHow can i create a program using vb.net to add and remove networked printers?
View 2 Replieshow to set the printers paper orientation using vb dot net
View 17 Replieshow to set the printers paper orientation using vb dot net
View 1 RepliesI am using the following code in the Load method of a VB form to generate random numbers in the range 1 to 8. Without fail after enough loops the range is exceeded and 9 is the random number returned every time. The line using the Rnd function is from: Rnd Function (Visual Basic)
[Code]...
I have been attempting to do this in so many ways. I have tried using rundll32 printui.dll, PrintUIEntry and for some reason it stops working on vista. I have no clue why. It wont even try to work with HP printers using the inf file. What is the best way to add a LPR port printer programmatically? I can create the LPR port with NO issue what so ever.
View 3 RepliesI have a routine, with the printDoc_PrintPage() function where i loop my pages and print them on the default printer.
What i need to do is print page 1 on a special printer and the other pages on the default printer.
How can i control the printers paper source?
Im printing a document but i want the user to only be able to print from the Manual feed tray on a HP 2055dn printer.
i currently have ths code in place but is anyone able to tell me if it would work or not.
i was using a print dialogue box but changed my mind as i just want to print the document as soon as the button is pressed.
' Allow the user to choose the page range he or she would
' like to print.
PrintDialog1.AllowSomePages = True
[Code].....
I have multiple forms and reports with different print area. Some are designed to print to a thermal label printer and others to department shared printers. Currently the user is able to change the printer in print dialog box and print to differernt printers. I want to be able to create a form where the user can assign different printers for different jobs and not have to worry about it.
The problem is, i have never worked with printing function and my collegues arent too smart so I was wondering if someone can throw me ideas on where to start so i can start googling for it.
way to detect Detect physical/Virtual Printers in VB.Net?
View 1 Replieswhy this code doesn't work?
Dim s As String
For Each s In PrintDocument1.PrinterSettings.InstalledPrinters.ToString
MsgBox(s)
Next
I have what is basically a text only printer (a Zebra 105SL) connected to my network at a static IP address. I have downloaded Zebra's Text only driver for it and set up a print queue named "Zebra North Text". I can print to that queue from Notepad just fine.
However, I am trying to print from a VB 2005 (soon to be upgraded to VB 2010 or VB 11) application. All of the standard VB sample printing code assumes I need to render the text in Fonts, etc, which just confuses the Text Driver.[code]...
I need to check all the printers of my faculty by sending a test page to everyone of them. And I want to do that with a little program in VB... All the printers are in the same server. I've found this piece of code : It should get the names and put them in a list box (the following code) and them send the print request
[Code]...
I need to list printers on a remote pc and am gettings errors trying to use wmi code but I am open to another way of doing this,
Private Sub DetectPrntrs()
Dim strComputer As String
Dim colPrinters As String
[code]....
I get the error:'Name' is not a member of 'Char'.
I have this working but only shows printers for the current user I think, I need to see a list of all printers installed on a remote pc for all users.I think I need to use the reg keys but all samples I fnd want only for one user and seem to be vbscript not VB code..[code]
View 2 Replies
