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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mattdrinks

  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?
See more

Part and Inventory Search

Back
Top