Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SaturnSeven

    Get Selected Value Of A Control By Reference

    Hi I'm trying to get the selected value of a dropdownlist by using a reference to the control i.e. a variable will determine what dropdownlist to use for the selected value Here my working so far i = right(ctlChoice.ID,1) strControlName = "SizeTo" & i DDL = CType(FindControl(strControlName)...
  2. SaturnSeven

    Move Email from One Account To Another

    I am trying to move emails from the Send Items folder of one account to a specific folder in another account. I can loop through the emails I am trying to move OK, I can move them to a folder in the same account, but I can not figure out how to them to a different account. How can this be...
  3. SaturnSeven

    Output Stored Procedure Results To a Text File

    I only use this forum when I am really stuck, I've already been through help files/google etc , but to no avail. I know you are "not here to write code for me" I never asked for any code, I did only ask for help / guidence. I would much rather be pointed to a help file or similar example, or...
  4. SaturnSeven

    Output Stored Procedure Results To a Text File

    Done that, now I get error on: File.Create(filePath, writer.ToString()); (File & writer) Error message: The best overloaded method match for 'System.IO.File.Create(string, int)' Argument '2': cannot convert from 'string' to 'int'
  5. SaturnSeven

    Output Stored Procedure Results To a Text File

    Thanks for function, "TextWriter" is throwing error: The type or namespace name 'TextWriter' could not be found (are you missing a using directive or an assembly reference?) Any ideas Many thanks
  6. SaturnSeven

    Output Stored Procedure Results To a Text File

    From a aspx page, how can I call a sql stored procedure with a input parameter and have it's results outputted to a text file (specific file and location) I have managed to populate a Gridview with the stored procedure results, so I happy the SR is OK. It's just the output to a text file I...
  7. SaturnSeven

    Get Drop Down List Selected Value

    I have managed to loop through all Drop Down Lists on my aspx page, but I need to get the Selected Value of each by using the control reference in the loop. For Each cntrl As Control In Form.Controls If TypeOf cntrl Is DropDownList Then lblResults.Text &= cntrl.ClientID & " " & "<br />"...
  8. SaturnSeven

    Best practise for multiple inputs for SQL criteria

    I'm just starting out with ASP.net I managed to get a single text box, a SQLDataSource and Gridview working together i.e. enter a value and the Gridview reflects the input and the SQL <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$...
  9. SaturnSeven

    Simple Function - New User

    I'm a new user to SQL I need a function that simply returns a sigle letter status depending the value passed to function. I have writen the fuction below, but I get this message:- Msg 102, Level 15, State 1, Procedure fn_ABCD, Line 12 Incorrect syntax near '@fn_ABCD'. Can anyone help/point me...
  10. SaturnSeven

    Raid 5 Option Not Available - Server 2003

    Motherboard is a Foxconn RC4107MA HDD's are SATA2 in a 3 bay hot swap backplane I am trying to use Windows server 2003 R2 software for RAID
  11. SaturnSeven

    Raid 5 Option Not Available - Server 2003

    Tony I have 3 HDD. The server isn't branded. It's home made.
  12. SaturnSeven

    Raid 5 Option Not Available - Server 2003

    I am trying to set up Raid 5 on my MS Server 2003 R2. All 3 Disks have been split 20GB and 130Gb All 3 Disks are been converted to Dynamic Disk 0 and 1 are mirrored and have OS installed (in the 20Gb partition) My plan is to set up the 3 lots of spare 130Gb in Raid 5. But I can not get the...
  13. SaturnSeven

    Excel Worksheet Permission - Sort/Pivot Table

    I have a worksheet that has the Sort function disallowed and this works fine. The problem is that it has also disallowed the Pivot Table function. But I have allowed this in the permission. Any ideas anyone Any help will be greatly appreciated.
  14. SaturnSeven

    Opening a Form In a For Next Loop

    I am trying to do the following For i = 1 to 3 Open form "frm" field "fld".value = Array(i) Wait for user to make other selection on form "frm" When user hits OK, write data to table. Close Form "frm" Next i It's the wait for the users input thats stumping me, I'm OK on the rest. Any help...
  15. SaturnSeven

    Word - Font Changes affects other text

    I've inherited a word doc which when a select some text and apply bold, it applies bold to none selected text. How can I stop this from happening?
  16. SaturnSeven

    Count Distinct

    It should shown up as more than one ItemNo
  17. SaturnSeven

    Count Distinct

    I have 2 tables, Orders & Order Details both related by OrderNo field. Order Table OrderNo,CustNo,Date,Seller S001,100,1/8/06,JT S002,101,10/8/06,LT S003,100,5/8/06,JT Order Details Table OrderNo,Pos,ItemNo,Status S001,1,ABC,Complete S001,2,DEF,OS S002,1,ABC,OS S002,2,DEF,OS S003,1,ABC,OS I am...
  18. SaturnSeven

    Multi Line Text Box

    Not quite Steve3110, the form is used to select various criteria and when the user clicks the 'Go'button an SQL statement is created from the criteria on the form and executed in a DoCmdRunSQL line.
  19. SaturnSeven

    Multi Line Text Box

    I would like to use a multi line text box on a Access form. I.e. using Ctrl+Enter to write on the next line of the text box. How can I split the text box values to loose the square characture for the Ctrl+Enter in to say an array.
  20. SaturnSeven

    Many Users Same Email Account

    I would like to have the same PC running Win XP with Outlook 2003 to use the same outlook account and settings for whoever log's on to that same PC. i.e. Not just the same .pst file but the same configuration settings. When a new users logs on Outlook asks to configure account. Is there a way...

Part and Inventory Search

Back
Top