How can I setup a SQL Report I've built using Report Builder 3.0 to automatically scroll down the matrix and then move to the beginning once it reaches the bottom. Should I create a style sheet? If so, please explain how to do this.
I have two tables, with sample data as below. I need to be able to find the stock value from Table1 for each item. But I need to find it for the supplier of the most recent receipt. I've highlighted the records from Table2 with the most recent dates, and shown the desired results I need at...
Unfortunately I have a poorly designed table that I need to query. The sample data and desired query result are listed below.
I need to write a query that will result in the first column name that's found where the value is less than 20,000 (for example) for that item. If it's not possible to...
I have four textboxes on a single form. How can I search the values in these textboxes to determine which contain equal values to the other?
So textbox1 can equal textbox3 and textbox4, but not textbox2. Or textbox1 can equal textbox2 and textbox3 can equal textbox4, but textbox1 not equal...
I am by no means a Cisco expert, so I apologize for my limited knowledge on this ahead of time. We currently have three Cisco 2950 switches. These are currently connected via the fast-ethernet ports.
However, we also have a 3750 switch, SFP SX transceivers, and 1000BASE-SX SFP modules (for...
I have been struggling with an issue for months now. I have an HP 1/8 Autoloader with an Ultrium232 drive. I am constantly getting A0 and A1 errors on the loader and my jobs in Backup Exec just hang until power is cycled on the autoloader. I occassionally get good backups, and after a day or...
We recently moved to a more secure WLAN using WPA encryption. Now at various times throughout the day all the clients connected to the AP are disconnected. The errors in the event log of the AP are, "Received TKIP Michael MIC failure report from the station <####.####.####> on the packet...
I setup Reporting Services a few months back, and evidently must have configured it to run under my domain account, because since I updated my domain password I am unable to execute any of my reports or access the Report Manager. I received the below error message when attemmpting these things...
Is there any way to restrict users access to all but one page of a domain...
Example:
http://www.microsoft.com/en/us/default.aspx - OK to access
http://www.microsoft.com/presspass/press/2008/aug08/08-04CashbackDealDaysMA.mspx - NOT OK to access
Thanks.
I'm trying to create a simple application to read data from the comm port. I can read data fine with Hyperterminal, although it shows as "169800991" in Hyperterminal (notice the strange beginning and ending characters). However, when I created a simple console application in vb.net I'm not...
Is there a way to assign the name property of a timer in vb.net to a variable?
I have quite a few timers on my form and need a way to assign the name of each timer to a variable.
Dim timername as String
timername = timer1.???
This query takes a long time to run and actually ends up causing another application that is accessing SQL at the same time to halt. I thought the "WITH (NOLOCK)" clause should have taken care of that problem but it hasn't. Can anyone offer any suggestions to improving this query?
IF...
I have been struggling with this issue for a while with no resolution. There seems to be a common issue among many of our Excel files that are generated from an outside source. When these files are closed this message appears...
"Cannot find ...\Application...
We are using a VPN connection that is extremely slow (5 minutes or so) when doing tasks inside of Windows, such as printing and SQL database queries. However, our RF handheld units running a telnet connection to the same server on the other end has a much faster response time; 5 seconds or...
Can anyone help me out with loading a 2nd form in a Windows application when a node from a treeview is selected? I need to be able to load this 2nd form but also assign the value of the node selected to a variable. The other piece of this is I have a variable number of treeviews on this 1st...
I have a form with a variable number of treeview's, each with a variable number of nodes. I have loaded this information from a database which works fine. However, I cannot figure out how to retrieve the tag of whichever node is selected when I press a button to move to another form. Can...
We are using Sharepoint Services with Windows 2003. I was going through the online demo on microsoft.com and saw a Web Part called "Issues" that seemed like it could be beneficial to us. However, that is not listed as an available web part that I could add. I have Tasks and everything else...
I only need to select the oldest of the 2 records in bold, based on the date. The dates and cells change so I can't "hardcode" those fields in the query. I need to come up with some group by clause I think and select the oldest one based on that date.
Cell Shift Date...
I noticed a problem with the WMI tool when it's resolving names on our network. So I started out with troubleshooting via ping. To keep it simple, for some reason when I try and ping a computer by its name... "ping computerA", I get a reply back even though that computer is not connected to...
I need some help. I just extended a server to begin using MS Sharepoint, but when I did so, so of the pages I've built no longer work. I think it's got something to do with security but I'm not positive. Here is the stack trace error I'm getting.
[SecurityException: Request for the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.