Search results for query: *

I replaced a computer at a remote location (Computer R) and I can no longer get replication to work with my local server (computer L), computer R is running windows 7 Professional with Sql Server 2008 R2, the computer it replaced was running Windows Server 2005 and Sql Server 2008 R2...

I have a Vs.Net 2008 application that prints a report, I want to be able to print the last page only. I can print a range using StartPageN and EndPageN, is there a way to set it to only print the last page? I of course could use StartPageN and EndPageN but the lengh of the report varies. Thanks

I have a question about using greater and less than in a case statement. CASE value WHEN > 10 THEN Something WHEN < 10 THEN SomethingElse ... END This doesn't work. The "> <" is not valid syntax, the following statement would work: CASE WHEN value > 10 THEN Something WHEN value < 10...

You can have 3 styles on with a combobox, Simple, DropDown and DropDownList. With a DropDown Style, when you click on the text portion you can select, type, etc into the text box, the dropdown list only appears when you select the down arrow on the right side of the combobox. With a...

I have a databound form, one of the fields is a note field and I have it displayed in a RichTextBox. I want to be able to highlight certain words in the textbox. If I use something like: RTB.Select(5, 5) RTB.selectionBackColor = Color.Yellow everything works as expected, the 6th - llth...

I'm having trouble connecting to a Vpn server, the Vpn connecton connects with no problem, I can ping the server and I can browse the server by it's ip address I can even map to it by it's ip address, but I can't connect to the server by it's name. I am really stumped, I can connect with no...

I have Routing and Remote Access setup on my Windows 2000 Server and all of the sudden I get the error rrasmgmt.msc file is missing when I try and access it. How can I recover this file, I can't find anywhere on the Microsoft website where I can download it ande I don't know how to retreive if...

I hope I can explain this clearly. I have an Payments_Applied table that shows how payments have been applied to invoices. I want to be able to do a query that will select all invoices that have been paid by a particular check number, this may be one invoice or many. This is simple to do and...

I have two tables, Table A and Table B with the same data in them. When new records are added to table B I want to run a query that will add those new records into table A. So basically when records in table B don't exist in table A I want to add them to table A. How do I go about doing this...

Hi, I have a DataGridView and I want to get the data colunmn name for a particular column. What I want is not the DataGridView column name but the coulun name of the bound database. I can do this with a textbox by using tbx.DataBindings.Item(0).BindingMemberInfo.BindingField() I just can't...

Hi, I'm having trouble with an update query, I'm trying to update, an inventory table with records from an invoice table. I have the query below that updates the inventory quantity field and it works fine. The problem I have is when the invoice table has multiple items with the same code number...

I have a windows form with a multiline textbox on it, when the user hits the enter key the focus moves to the next textbox instead of entering a new line. I have set the AcceptsReturn property to True and it doesn't make a difference. How can I get the enter key to insert a new line? I'm...

I want to find out what customers have ordered more than a certain number of a particular item. I can easliy write a select query that will give me the sum of the item sold to customers but I can't figure out how to select the customers that have ordered more than a certain number. for...

I have a table set up with full-text searching, the problem I'm having is when I try to search a string with a minus sign like "A-Z of flowers." If I search for A-Z I come up with an empty set, how do I set it so the "-" is treated as part of the string? SELECT * FROM Inventory.Inventory WHERE...

I have a report that is part of a vb.net 2008 Pro. project that is bound to a datasource that has two columns. One column is a double column the other is a byte column containing an image. When I run the report only the first record shows up as one of one. The datasource has 3 records in it, if...

What's the best way to change the ToolTip Text dynamically, for example If a TextBox.text = "A" I want the tooltip text to be "Apple", if it's "B" the tooltip should be "Banana." The best I'v come up with is setting ToolTip1.SetToolTip(TextBox1, "Text") in the mouseHover event. This works but...

I'm trying to create a narrow windows form but I can't make the width any smaller than 123. Is this a limit? I can't find it documented anywhere. Thanks

I have a DataGridView and I am Validating a column, in this case it's a zipCode column. I have a procedure that verifies the zipCode and adds the 4 digit extension, the problem I am having is changing the value of the zip Code column while it's being validated, If I use...

Every time I shut down my computer it asks me if I want to "install updates and shut down." I know there is a directory that stores the files that are to be installed and all I have to do is delete them and the problem will go away but I can't remember where the directory is. Does any one...

I have a table that has a alphanumeric column, some entries are alphnumeric others are numeric. How can I do a query that only returns the rows with numeric entries? Thanks