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 bkrike 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

    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...
  4. 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 />"...
  5. 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="<%$...
  6. 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...
  7. 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...
  8. 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.
  9. 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...
  10. 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?
  11. 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...
  12. 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.
  13. 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...
  14. SaturnSeven

    Same Outlook Setting for Any User

    Is it possible to set up a Win 2000 Pro machine using Outlook 2000 on a network so that any user who logs on to that PC will see and use the same Outlook setting ie the PST file that resides on the network? (Also not using Exchange Server) Any help or guidance will be greastly appreciated.
  15. SaturnSeven

    Running totals within group

    I am struggling with the following query I have a table looking like the following Product Qty Date ABC 10 01-Feb-06 ABC 5 10-Feb-06 ABC 15 20-Feb-06 DEF 2 5-Feb-06 DEF 5 15-Feb-06 DEF 5 20-Feb-06 I am trying to create a query to show Product...
  16. SaturnSeven

    Run Scheduled task Minimized?

    Is there any way or a way around running a scheduled task in a minimized state. I have a task that needs to run every 15 mins and I do not want it to pop up over want I'm working on. Any help will be greatly appreciated.
  17. SaturnSeven

    Database locks after Docmd.SendObject

    The following extract all works fine, with the exception that when a users choose option 3 to send a snapshot report attached to a email but then chooses to close the email without sending it, you can no longer select any other custom menu item. If you try to close the database you recieve...
  18. SaturnSeven

    Auto Delete Completed Outlook Tasks

    I'm trying to write some vba code that on opening Outlook 2003 it automatically deletes completed tasks. Any help will be greatly apprecicated
  19. SaturnSeven

    Stop Excel Closing

    I have a procedure in Access that uses the CreateObject to create a Excel spreadsheet and then some tweaking etc, that works fine. My problem is that as soon as the procedure ends it closes Excel down, when I don't want it to. Is there a way to stop this from happening ? Any help would be...
  20. SaturnSeven

    Convert a Excel Module to Access Module

    I have written a excel module that extracts a query from a database to a excel sheet(via ActiveSheet.QueryTables.Add) then does some calculation, formating, pivot tables etc. I would like to put this onto the database so it can be run by other users. I.e Instead of running a excel procedure...

Part and Inventory Search

Back
Top