Search results for query: *

Hi All, I am currently using a Windows 2003 server to send out reports and perform other tasks. These are primarily VBscript programs which I am executing using wscript and are all setup as scheduled tasks. These have been working away fine for years. However, as Windows Server 2003 is now end...

Hi All, i have to admit that it is a long time since I have been on Tek-tips - used to be a regular user but just getting back into development now after an absence and I am having a problem. I have severl VBScript programs that I am using to update Excel files regularly. Some of these Excel...

Hi All, I am having a performance issue on my IIS server (IIS 6 on Windows Server 2003). I am running two ASP applications - each with their own application pool. Both sites are Intranet based applications and are in heavy demand. I need to be able to introduce some form of load balancing as...

Hi All, I have a simple script which uses an inputbox to prompt the user for a lot number. The inputbox is populated using a barcode scanner when they scan a barcode on their documentation. What I want to do is prevent them from changing that scanned value or manually entering one. Can you...

I am having an issue on a few pages. I have an intranet site where I only want to allow pages to load if the person accessing the site is on the internal network. So I am using the REMOTE_ADDR servervariables value to get the IP. The problem is that if I access the site from an external...

I have a checkbox as a control in a datarepeater object. I have an event handler function which handles the checkchanged event for this checkbox and sets the visibility of other fields based on it. However, the problem I am having is that the event handler function is getting fired when I set...

I have a dataset which contains 17 fields - 6 strings, 1 boolean and the rest double. 4 of the 6 string fields store data in relation to "Visual Inspection". If any of these 4 fields contain data, filling the dataset throws a NullReferenceException error. However, when they are all blank the...

I have set up a dataset in Visual Studio with one parameter in the Select statement. My dataset stores a list of parts which match the lot number passed into the parameter. The where clause in my dataset is as follows: where [Lot Number] IN (?) The reason I have the "in" statement is that I...

I have a form which has a label and a progress bar. When the user clicks on a button to retrieve data from an external source, I want to display this form. When the main form returns a value I want to hide the form. In theory this should be very simple, but I am having issues getting the...

In the Load function of a form, I create a populate a dataset with data using the following command: Me.Lot_DataTableAdapter.Fill(Me.DESDataSet.Lot_Data, SelectLotForm.lotnumber) I was just wondering what best practice is when closing the form, Should I dispose of the dataset, dataadapter...

I have a DataSet in my application which has all of a sudden started giving errors. I can preview the dataset at design time but when I run the application it gives me an error at the following line: Me.Lot_DataTableAdapter.Fill(Me.DesDataset.Lot_Data, SelectLotForm.lotnumber) I get the...

I am trying to resolve an issue with a combobox datasource. I have managed to set the source for the combobox to a data source that I have added to the project and it is displaying the full list of options in the combobox. However, I have another dataset and I want to use the value in one of...

Sorry for the questions but I am new to Vb.Net and having some issues. I have a windows form which has a tablepanellayout control which I add at runtime. Depending on the source data I am also populating up to 60 rows of that table with controls - 16 controls on each line to be exact. That adds...

When a user clicks the X button to close the form or clicks an exit button I have on a menu, the dispose event handler is fired. At this stage, I would like to be able to loop through the controls in my tablelayoutpanel and perform some DB updates. However, it fails saying that it can't find...

I have a windows form that has a table panel layout with a dynamic number of rows all of which contain controls. I create the tablepanellayout and controls on form load. It flashes as this is happening but that it no my primary concern. Every time a control is actioned at runtime the whole...

Hi Guys, I am currently running SQl Server 2000 and have just purchased SQL Server 2008 R2. Don't know much about SQL Server and wondering what the best options are to upgrade to a different server. I have installed 2008 R2 on my DB server and want to move the SQL 2000 DB's from a different...

Hi Guys, I have an issue with Exchange System Manager. Let me paint the picture first. I have an Exchange Server which is also my active Directory and DNS server. It runs fine (touch wood) and have no issues with it. However, my Blackberry server died a death last week and I am in the process...

Hi Folks, A couple of users, myself included, are experiencing an issue with Outlook Meetings. If I try and reschedule a meeting it tells me that the meeting is being modified by another issue and can't be moved and it creates a copy of the meeting instead. This appears to be intermittent. Has...

Apologies for what will probably be an easy question. I have a DSN setup to access a SQL Server DB on a remote machine and use that in a VBScript that I run from my machine. This script also runs from another IT machine. However, when I try to replicate it on another machine it won't access the...

I have an ASP page which opens an Excel file in the background. I want to read information from a number of cells and display them as headings in my ASP page. However, in the Excel document there are a number of merged cells which are merged across columns and rows. So I basically want to be...