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!

Register Log in
  • Congratulations SkipVought 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. mattdrinks

    Left Outer Join Criteria on Parent Table

    I have checked this and I have the join FROM table A to table B. I have managed to solve the problem by adding a Formula field with the following formula if {TableA.Field1} >="3000" then "Yes" else "No" and then added the following select criteria using the Select Expert. {@CUSTOM_FIELD} =...
  2. mattdrinks

    Left Outer Join Criteria on Parent Table

    I am using Crystal Reports XI and have two tables joined by a left outer join. Quick sample data: Table A Table B Field1 Field1 Field2 1000 1000 5.00 2000 1000 6.00 3000 1000 4.50 4000 3000 10.50 5000 5000 11.25 I can...
  3. mattdrinks

    Page is fully loaded but IE Progress Bar Never Completes

    I have the following code in the onlick event of a button: //Create a unique family id var strFamilyName = window.document.forms[0].CPMainFamilyName.value; var dteNow = new Date(); var strNumber = new String(dteNow.getTime()); var strFamilyID = new String(strFamilyName.substr(0,5) +...
  4. mattdrinks

    Firefox Get value from another frame.

    Thank you so much. I had tried all different variations for different browsers and managed to get myself into an awful mess. You solution works for all the browsers I need it to. (IE 6.0, Opera, Firefox 1.5, and Netscape) Thanks again Matt
  5. mattdrinks

    Firefox Get value from another frame.

    I have the following (simplified) HTML. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"> <html> <head> <script language="JavaScript" type="text/javascript"> </script> </head> <frameset rows="15%,85%"> <frame name="fraTopNav" src="about:blank"> <frameset cols="17%,83%">...
  6. mattdrinks

    Duplicate Name when connecting to server via 2nd NIC

    We have the following Setup: 2 Windows 2003 Server Domain Controllers Each DC has 2 NIC Cards in. 1st NIC 10.x.x.x 2nd NIC 172.x.x.x If you connect via 1st NIC then all is Ok, if however you change the computer's IP and connect via the 2nd NIC you get a warning and the following in the Event...
  7. mattdrinks

    Update a form from a static method?

    Is this possible... I have an event that is fired by a timer, but I would like that event to update a form as it goes so the user can see what is happening. I have the following code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using...
  8. mattdrinks

    Type Mismatch Error using Like% in Stored Procedure

    Thanks for your help guys, I tried using single quotes instead of double ones and still get the same error. I also removed the Csng() function as you suggested Chip and still get an error. I have solved the problem by running the query as a text command instead of a procudure and and this...
  9. mattdrinks

    Type Mismatch Error using Like% in Stored Procedure

    I have a query in Access: SELECT Lines.Part AS PartNumber, Product.Desc AS Description, Stock.Locn AS Location, CSng([Free]) AS TotalStock, CSng([SCode]) AS OastStock, CSng(CSng(Stock!Free)-CSng(Product!Scode)) AS ShopStock, Sum(CSng([Qty])) AS QtySold FROM (Lines INNER JOIN Product ON...
  10. mattdrinks

    Loop Through Properties of a Custom Class

    Hi Chance, Great minds think alike, this is what i have been working on: Property Get PropertyNames() As String() Dim AllProperties(21) As String AllProperties(1) = "PartNumber" AllProperties(2) = "SupplierCode" AllProperties(3) = "SupplierPart" AllProperties(4) = "NPP" AllProperties(5) =...
  11. mattdrinks

    Loop Through Properties of a Custom Class

    Hi All, I have a Class module in Excel: (Short Version) Dim strPartNumber As String Dim strSupplierCode As String Dim dblNPP As Double '***PART NUMBER*** Property Get PartNumber() As String PartNumber = strPartNumber End Property Property Let PartNumber(Part As String) strPartNumber...
  12. mattdrinks

    How to Capture an Excel Close command

    To get your code to run when the workbook is closed place your code in the Workbook_BeforeClose Event. Something like this should do: Private Sub Workbook_BeforeClose(Cancel As Boolean) If Cells(1,1) =&quot;Hello World&quot; Then Me.Save Else Cancel = True MsgBox &quot;Please Don't...
  13. mattdrinks

    How do I get a set of values and insert them into a VB Form

    John, I am not sure what you mean by The code seems to stop everytime the vb form is openned I am guessing that you have one userform with a Submit button on it, and that the user types the Part Number into a textbox on that form and then clicks the Submit button, which runs the code to load...
  14. mattdrinks

    How do I get a set of values and insert them into a VB Form

    Ok I think I get what you are trying to do now. If you want to write the values back to the cells when they are changed on the text boxes, then try using a Range object instead of a string. eg. Option Explicit 'ranges instead of strings Public rngOptionCode As Range Public rngPartNumber As...
  15. mattdrinks

    How do I get a set of values and insert them into a VB Form

    John You could also try OptionCode.Text = strOptionCode (as in dyarwood's post) Also are all the controls on the form referenced by the code Textboxes?
  16. mattdrinks

    How do I get a set of values and insert them into a VB Form

    I am guessing a bit here, but if this code is trying to read the data from the Row where the part number was found and display it in the controls on the form. Then all you have done is got the assignments round the wrong way. Try: Option Explicit Public strOptionCode As String Public...
  17. mattdrinks

    comparing two excel sheets Can someone see whats wrong with my code?

    Just an idea, but could you import the data into Access, (File | Get External Data | Import) Import each sheet seperatley so you have two tables. And then create an Find Unmatched query, Access even has a wizard to create the query for you! (Click the New button in the queries tab) I had a...
  18. mattdrinks

    Getting Notes From MS Outlook

    Hi PBA Paul, I tried the following code: Sub GetNotesFromOutlook() Dim objContactsFolder As Outlook.MAPIFolder Dim objContacts As Outlook.Items Dim objContact As Object Dim iCount As Integer Dim objProperty As Outlook.ItemProperty Set objContactsFolder =...
  19. mattdrinks

    assign excel range to matrix

    Not that I know of, it's just that Tony is better at this than me. I never realized that you could do it like that! Thanks Matt
  20. mattdrinks

    Getting Notes From MS Outlook

    Hi PBAPaul, I have just found this: Note: When programmatically referring to the Message field, is is referred to as the Body property. &quot;is is&quot; > &quot;it is&quot; (Their mistake not mine!) Half way down this article...

Part and Inventory Search

Back
Top