Search results for query: *

Thanks Justin! Looks like Shift+F10 is a right click in Windows. Still find it silly that this is lacking in the menu, but this will work. Thanks again.

I'm assuming there's no way to get these shortcuts to show up in the menu since noone has yet posted it. I don't understand why Microsoft would take away the ability to perform operations via keyboard adn the menu, and force us to use the mouse to accomplish these tasks. If the answer just...

Mrdenny, thanks for your help. This works when I'm using a standard keyboard, but there's no right click button on my laptop. Any other ideas?

Simple question. In Microsoft SQL Server Management Studio Express SQL Server 2005, I haven't figured out how to use the menus to open and modify objects. In Enterprise Manager I could give focus to a table and use ALT - A - O - A to open all rows in that table. In 2005, I have to use a right...

ca8msm; I don't want the user to have to modify this file in any way before they upload it. (They download this file from another app and then import it into ours.) Any thoughts on how to do this without having to edit the Excel file? Thanks.

Skip; earlier rows do contain text in the cells in question, but the rows with the cells that aren't coming back are only numbers.

I'm using System.Data.Odbc to open an Excel file (excelConn = New OdbcConnection("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & sFileName & ";DefaultDir=" & sDirectory & ";")) and am having no trouble opening the file, and reading each row via an OdbcDataReader, but for some...

While I wish there was a better way than having to check each row on RowDataBound, it will suffice. However, is there a more efficient way to check the cell that I want than referencing it by index. For instance, is there a "FindCellByName"? I hate to use index numbers to cells, because then...

As I mentioned, it not as simple as changing a query because I'm using a datalayer of which the property for "LastLogin" is a date. Thus, in VB, A Date must be a date. Not an empty string, and not null ("Nothing"). I do appreciate your time and thoughts though. One thing I thought about was...

OK, I've got a Gridview that contains Users and their info; FirstName, LastName, .... It also contains "Last Login", a date. When "Last Login" is null, "1/1/0001 12:00:00 AM" is showing up. I understand that this is happening because a VB date can never really be "Nothing", but is instead set...

Thanks guys. I appreciate the help.

Is there a way to say "IF A1 is Bold THEN 'It's Bold' ELSE 'It's Not Bold'". Obviously the Excel Formula would look something like =IF(A1.font = "BOLD", "It's Bold", "It's Not Bold")It's the ".font = "BOLD" part that I'm not sure how to do. Thanks a lot.

I'm actually updating a table with 65 fields (columns), 63 of which have defaults which I want to be used if the user doesn't enter anything. It seems to me that the following is a bit cumbersome.UPDATE myTable SET field1 = ISNULL(@var1, ( SELECT COLUMN_DEFAULT FROM...

I've got a form where Users enter data that has default values (which I've put as Defaults in the database). Say Field1 has a default of 'The Three Amigos'. When User1 comes to a page to change Field1 he sees the default. He can change it to 'Corky Romano'. Later, if he comes back and...

I don't actually want to leave it unchanged, I want it to set to the default value for the field.

I'm passing myVariable into a stored procedure. Inside my stored procedure I want to store myVariable into MyTable.myField. MyTable.myField has a default value. If myVariable is null, I want to use myField's DEFAULT value. The following code doesn't work UPDATE MyTable SET myField =...

Point taken. Thanks, George.

COL_LENGTH seems to do what I need. I'm a .NET developer and my main interest is dynamically setting the max length of textboxes. Clients will say "Yes, the textbox for the Description of how they removed their underwear without taking off their pants should only need to be 200 characters"...

I have a table "MyTable", with 1 field "MyField" of type VARCHAR(27). Say I've forgotten the length of MyField and I want to use T-SQL to get it. I want "SELECT XXXX FROM MyTable" to return one record with one field, 27. What does "XXXX" need to be? Thanks, and have a great day.

ca8msm, I CAN target the relevant rows. I'm not sure why I thought I needed a div tag either. :-) What I'm doing now is assigning each tablerow an id and using document.getElementById('tableRowID').style.display = "[block/none]"; It works just fine. Thanks for your time and help.