Search results for query: *

I have a spreadsheet that I e-mail daily to internal staff. It has a lot of conditional formatting which change the cell background colors. All the colors and formatting have e-mailed fine. This month, I started a new spreadsheet. All coloring looks fine in the workbook, but e-mailing the...

I am by no means an expert DBA. We have a table with 6 million records. It has 4 indexes. One is a clustered primary key (consisting of 3 columns) and the other 3 are non-clustered on one column each. If I reindex the table, the fragmentation goes down to near zero on all 4 indexes...

We have a large number of Windows NT servers. Each server is a separate LAN. If I connect a workstation's CAT5 directly to Server A, it will show up on that server's network quickly. If I do the same with Server B, it takes up to 2 minutes and sometimes will time out. I connected the...

Hello, This may sound a bit strange, but I am trying to reverse the video of everything on the monitor. Or at least reverse the video of my application. I had hoped there would be a display setting or monitor setting where I could just reverse the video. Setting color properties in code is...

In Visual Basic .NET is it necessary to pay attention to the layout of member variables? I know in C++ the order in which you declare your variable can have an affect on the amount of RAM used. This is because of byte alignment and padding. Example: Dim b As Byte '1 byte Dim i As Int32 '4...

In a socket class I have a method which essentially does this: Declares a new socket Does a BeginConnect to connect to server (waits for connection) Sends data to the server (waits for send to complete) Receives a response from the server (waits for response to complete) Shuts down the socket...

I seem to be having trouble programmatically changing the SelectedIndex of a listbox after a Drag/Drop has completed. I have a source listbox and a target listbox. I click the left mouse button over an item in the source, hold the button down, then drag to the target and release. The code to...

I need to move data from one table to another. The two tables have identical structures. Obviously I can use: INSERT INTO Table 2 SELECT * FROM Table 1 However one column needs to change. Is there a way to plug in this new value during the INSERT INTO statement or am I stuck having to update...

I am currently reading information from a binary file. Whenever I do a ReadChars on the binary reader, I do not get a closing quote. For example (br is the instantiated BinaryReader): Dim tData1 As Int32 = br.ReadInt32 'Works Dim tData2 As String = br.ReadChars(15) 'Get 15 characters tData1...

I have a BinaryReader that I am parsing data with. There are two elements included in the data that are 6 bytes of ASCII (null-terminated). Within the code I have: For i = 0 to 10 Dim tNum as integer = br.ReadInt32 Dim tConn as byte = br.ReadByte Dim tLo as string = br.ReadChars(6)...

I have two tables. I want to write a SQL statement which combines info from both. I'm having trouble. Table 1 fields: 1. ID 2. Name 3. Stat_1 4. TimeStamp Table 2 fields: 1. ID 2. Stat_2 3. Stat_3 4. TimeStamp Table 1 will have one record per ID per TimeStamp. Table 2 may have multiple...

I can't seem to figure out why this is happening... We have a program which displays a lot of data from a database. This program provides near real-time display of information. It reads from the database every 10 seconds and refreshes the screen. It also has various reports. If the program...

I can map a drive on a remote computer, but I cannot ping that remote computer. Pings just time out. I have 2 computers mapping this remote drive. One can ping fine and the other cannot. The TCP/IP properties appear identical. Can somebody offer advice why this is happening?

I would like to draw some lines using the Graphics class. That's the easy part. Is there a way to apply a blur to these lines? Something like a gaussian blur. The objective here is to make the lines appear "glowing" or fuzzy. I'm thinking I may have to draw a lighter shade of the same color...

When I use Server Explorer, I can right click "Servers" and get a context menu with "Add server...". I can then type in an IP address, username, and password. Then the server appears. This isn't really a share. It lets you view performance counters, SQL servers and such. I know adding a...

I have a remote SQL server on the LAN that I would like to connect to. The SQL server itself is password protected. This is no problem for an ADO.NET connection string. However, the server itself (the box) requires a Windows user name and password. I would like to pass this information so I...

One of our computers runs an application which shows current productivity and condition of the facility. The application has very large numbers so the staff can do other work and still view it from a distance. The problem is after about 15 minutes of idle (no keystrokes or mouse moves from a...

I have an application that uses an invisible instance of Excel. I would like Excel to close even if the application crashes. This is mainly for debugging since crashes leaves Excel processes running which have to be manually stopped in Task Manager. I had seen the OnHandleDestroyed event is...

I'm curious about the timer control. If I have 3 timer controls, will they all fire asynchronously and perform work on separate threads, or do they fire one after the other using the same thread?

I've got a serial port connection between a PC and an OpenVMS system. The serial port from the PC goes into a DEC-Server. Data comes across as straight ASCII. I want to send ASCII text across the serial port and receive the ASCII responses. I am using CreateFile to open the port which works...