Search results for query: *

SHelton, Thank you for your response. The problem is that I am having a problem at design time when adding the stored procedure to a tableadapter in Visual Studio 2005

I am trying to add a query to a tableadapter in visual studio 2005. It is a long running query that cannot really be tuned further. When I add it to the table adapter the parameters show up listed but the results fields do not. No error message yet. Then when it goes on to generate the...

In VS 2005, I have a tableadapter that has an update command set to a stored procedure with parameters. I changed it to a different stored procedure. The parameters are shown as parameters in the properties section, but I cannot use them when I run the update command. Error message:Overload...

I'm using a third party TreeView control (from a company called "Visual ASP"). When the user clicks on a child node, it does what seems to be a postback: you hear the little "click" and the URL (in the address bar of the browser) changes. But the Page_Load eventhandler doesn't fire - i.e...

I saw stevedeb's post and remembered that I forgot to give tskelton a star :). When I added the 'stop processing more rules' everything worked fine. I still don't understand why because I didn't have any other rules. Someone in my office who had the same problem also added 'stop processing...

SteveDeb: Any luck in solving this problem? tSkelton: Thanks for replying. Here it is: Apply this rule after the message arrives with [tech_notes] in the subject move it to the tech_notes Inbox folder except if the subject or body contains deb Thanks very much! Deb

When I set up a rule to move mail from my Inbox to another folder, nothing happens as the mail arrives. If I go to Tools | Rules Wizard | Run Now - and manually run the rule on all emails currently in the Inbox, it moves the messages. How can I get Outlook to "stay alert" and follow my...

Our accounting ERP mandates the use of the stored procedure.

I have a stored procedure "glbl1_sp" that returns a table (or is it called a recordset - it's done with a select statement) with a bunch of columns - let's call them columns "a" through "q". I need only columns "a" and "b" dumped into a temp table. I cannot access that stored procedure...

I had originally tried to do this within sqlserver but it didn't work but I think that this was due to some connectivity issues. I think that it's OK now. Thanks a lot!

Works. Thank you.

I have the following code: Do Until [ ... ] repName = wrksheet.Cells(currentInputRow, "A") 'does user want to process commissions for this user? If mainForm.repsNames_frame.allOrSome_frame.someReps_rb.Value = True Then 'if this button is checked, user only...

Yes

I am trying to put the results from a query on one database server into a table on a different server. I have put the results of the query into a dataset. Is there a simple way to "export" the contents of the entire query into a SQL table in the second database without using a dataset as a...

Thanks from me, too and here's another star. -Deb

cLFlaVA, I got it to work with this: Sub allChecked(tf As Boolean) Dim ctl As Control Dim ckbox As CheckBox For Each ctl In repsNames_frame.Controls If Left(ctl.Name, 3) = "rep" And Right(ctl.Name, 3) = "_cb" Then ctl.Value = tf End If Next End Sub...

Clflava, thank you very much - that sounds like a great way of doing it... but it's not working. When I do Sub allChecked(tf As Boolean) Dim counter As Integer Application.ScreenUpdating = False For counter = 1 To 44 Step 1 Sheet1.OLEObjects("rep" & counter &...

I have 44 checkboxes on a VBA Excel form that I dragged there from the Toolbox. I named them all rep1_cb, rep2_cb, rep3_cb, ... rep44_cb. I want to add a button to the forum to un/check all checkboxes within this "group". Is there some way to store them all within an array - or create some...

Thanks, it works now! :-)

I have been struggling for days to get a service pack to install on SQL Server 2000. In order to positively assure that I didn't have bits and pieces of various old/mismatched patches hanging around, I took the radical step of reformatting the C-drive of the server and reinstalling the OS. I...