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 TouchToneTommy 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: *

  • Users: mattdrinks
  • Content: Threads
  • Order by date
  1. 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...
  2. 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) +...
  3. 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%">...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. mattdrinks

    One recordset from 3 databases using ADO from Excel

    Hi everyone, I have many different Access databases from which I need to get information onto an Excel sheet. I would like to do this using ADO so users can select options and run the code from a UserForm My problem is creating the SQL string for the ADO command object. So far looking at...
  9. mattdrinks

    Fatal IO Error 104 When installing Redhat 7.1

    This is my first attempt at installing any version of linux so please bear with me. I purchased a boxed set of Redhat Linux 7.1 Professional edition so I had all the manuals to help, but after 3 weeks of trying I have still not successfully installed a copy on to my machine. When I start the...
  10. mattdrinks

    Correlated subquery with COUNT and TOP

    Hi, I have been on this for a few days now and can not seem to get it working correctly. Any help would be great. I have a single table and am trying to write some SQL to produce a summary query. WHAT I HAVE IN THE TABLE Part Group Range No1 No2 No3 BP1440 BPAD ONE 100 78...
  11. mattdrinks

    Access Import Wizard Customization

    I am trying to write a Import Wizard to import Text and Excel files in to Access. I would like to use the ImexGrid that Access's Spreadsheet Import Wizard uses. I have started a new moudle and added a reference to accwiz.dll this shows two objects in the object browser FieldList and...
  12. mattdrinks

    Access Forms Have No Top Property?

    Working in Access 2000 and Excel 2000 I have a button on an access form which runs the following code: Private Sub cmdGetData_Click() Dim xlData As Excel.Application Dim strFileName As String Dim bar As Office.CommandBar Dim intI As Integer Dim lngFormWidth As Long Dim lngFormHeight As Long...

Part and Inventory Search

Back
Top