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 strongm 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. d1novak

    Unknown Operator

    Can anyone tell me what the => and <= are preforming here? ---------------------------------------------------------- case "Maximum List Price": decimal maxListPrice = Convert.ToDecimal(this.stateField); this.productView.Filter = (o) => { var product = o as Product; return product.ListPrice...
  2. d1novak

    Import SQL data into list

    Greetings, I have created external content types and external lists to provide live view of external SQL data. however I have not found a way to import the data so the lists could be internal and persistant. I know I can export sql to excel and import but this needs to be seemless or atleast...
  3. d1novak

    Delete multiple records based on data from another table

    I have 2 tables tblCOMPANY and tblCOMPANY_ACCESS. TBL_COMPANY has COMPANYID and Sales_Division. tblCOMPANY_ACCESS has COMPANYID and USERID. I need to Delete all records in tblCOMPANY_ACCESS where tblCOMPANY.SALES_DIVISION='Enterprise' and TBL_COMPANY_ACL.USERID='1234' I tried the following but...
  4. d1novak

    Filter tablix by Login information

    I am using Reporting services on SQL 2008. I have a view listing login names and Department among other info. I have a report with a tablix that lists all the data from the view. when employees login they should only see other employees from the same department. how and where should the...
  5. d1novak

    button to delete Junkmail using VBA

    I have created a button in outlook 2003 utililizing the following VBA code: Public Sub EmptyJunkEmailFolder() Dim NS As Outlook.NameSpace Set NS = Application.GetNamespace("MAPI") Dim olitem As Object Dim fldJunk As Outlook.MAPIFolder Dim gone As Date gone = Date...
  6. d1novak

    Displaying values in xml file asp.net

    Thank you all for your help. I figured it out, I was missing a " near the end. Dim rows as DataRow() = table.Select( "Day1 = '& DropDownList1.Text & "'")
  7. d1novak

    Displaying values in xml file asp.net

    It threw an error "SelectedText is not a member of the DropDownList
  8. d1novak

    Displaying values in xml file asp.net

    Here is the whole page: I am trying to use DataRow the error is: Compiler Error Message: BC30311: Value of type 'System.Data.DataRow' cannot be converted to 'String' <%@ Import Namespace="System.Data" %><script runat="server"> sub Page_Load if Not Page.IsPostBack then dim myclasses=New...
  9. d1novak

    Displaying values in xml file asp.net

    I added this to the script area. sub displayGrid(s as Object,e As EventArgs) Dim myDataSet1 = New DataSet myDataSet1.ReadXml(Server.MapPath("classes.xml")) Dim table as DataTable = myDataset1.Tables(0) Dim rows as DataRow() = table.Select( "Day1 = & DropDownList1.text'")...
  10. d1novak

    Displaying values in xml file asp.net

    Hi all, I have an xml file that displays class dates (Day 1 and Day2). I have sucessfully populated the dropdownlist1 with the Day1 Data. I want to add onselectedchanged to the dropdownlist1 to run another sub procedure that will return the value of day2 for the selected record. Then bind it to...
  11. d1novak

    Reset Running Total in Access query

    I am using a query to Calculate the RunningSum of Hours for a Time Clock. As you can see the below formula works and even recognizes when day number is lower than previous record (Indicates New Week)and results in [TotalHours]. However I need the RunningSum to reset to [TotalHours] rather than...
  12. d1novak

    Append text to Beginning of File

    I have a VBScript that writes error info to a text file. it works but appends to the bottom of the file. set log = fso.OpenTextFile("C:\cleanMB\CleanMBLog.txt", ForAppending, true) log.WriteblankLines(2) log.WriteLine("Success! "&NOw) How can I append this to the top of the file?
  13. d1novak

    Clean Badmail folder exchange 2000 Server 2003 vbscript

    I have a script that stops the smtp service for 10 secs moves the BadMail folder to c:\Program files\crap\"hour_old". restarts the service and on a certain hour at night deletes and recreates the c:\program files\crap folder. the entire script works except deleting the crap folder. no matter...
  14. d1novak

    Open folder with vb

    I have a script that is attached to an access button that backs up the database to c:\database backup. on the tail of the script I would like windows to open that folder for the user to view all the files. Is this possible? or is browseforfolder all there is? Thanks
  15. d1novak

    Access Developer Application VBA Error

    I have a form in Access XP that on one tab has a picture. the source of that picture is refreshed by clicking a button. Which uses the onclick procedure: Private Sub LoadInvoice_CB_Click() If Me![CompanyName] <> &quot;&quot; Then Me!Invoice.Picture = &quot;c:\ADT\Invoices\&quot; &...
  16. d1novak

    InsertObject in access form

    Im trying to write a macro that will automatically insertobject, &quot;create from file&quot;, &quot;link&quot; where the file name is equal to value stored in companyname field. Access has insert object but all that does is open the box. My users are not checking the link box. is there any way...
  17. d1novak

    Change Password in OWA

    I have a exchange 2000 server sp3 on win2000 server sp4. users cant change password on thru owa. When atempting to change the password the popup window displays &quot;Page not found&quot; ssl is enabled. Any help is greatly appreciated Dan
  18. d1novak

    Ghost problems with IBM xSeries

    I have a different situation. We use ghost to image an entire classroom from a file on a 10000 rpm 5 disk scsi raid 5 server. oddly up against a single 7200 ide drive server, the 5 disk raid 5 images the room only 3times faster. 90mb/min vs 30mb/min. And each server ghosting only one machine at...
  19. d1novak

    Deleted SAM in Windows XP Pro

    bcastner Worked like a charm. For future reference, it didn't work till I copied them to the c:\windows\SYSTEM32\config folder. Thanks a billion! d1novak

Part and Inventory Search

Back
Top