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 derfloh 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: BAWC01
  • Content: Threads
  • Order by date
  1. BAWC01

    Excel, Checking the Status

    Hi does anybody know how to do the following please or give me an idea on how to start. I have a an Excel sheet with 3 columns. Date Current Status Days Left What I want to do is when a user enters a date the current status will go to e.g Build and the days left will go to 14...
  2. BAWC01

    Crosstab Query

    Hi I have a crosstab query; TRANSFORM Count(Export_1.IATA) AS CountOfIATA SELECT Export_1.Flight, Export_1.Dest, Count(Export_1.IATA) AS [Total Of IATA] FROM Export_1 GROUP BY Export_1.Flight, Export_1.Dest PIVOT Export_1.[0-45]; What I want to do is multiply the balues in the colums by 2...
  3. BAWC01

    Es47 Cluster Tru64 5.1b

    Hi I have a 3 Node Cluster consisting of 2 ES47 machine running Tru64 5.1b. I have having continual problems with CPU0 in one machine I have had HP out twice and they have replaced the bays 3 times and it runs for so long then I get another problem the a CPU. Could it be anything else other...
  4. BAWC01

    Looking Back at Previous Record

    Hi I have a simple form, which just adds to a table with the following data. Date New Previous 01/05/06 30 20 What I want to do is the following: When the user enters a new entry the PREVIOUS field is automatically populated with whatever was entered last. So...
  5. BAWC01

    A Single Row

    Hi I have multiple row containing various data in one table 0125534229 15/04/2006 10:19:13 0 ATR Line 5 No BSM 0125534229 15/04/2006 10:19:33 MC10 MC10 MCS 0125534229 15/04/2006 10:19:36 US MC10 MC10 BSM 0125534229 15/04/2006 11:53:24 US MC11 MC11...
  6. BAWC01

    Fastest Way to Oracle

    Hi I have an Oracle table containing some 180 millions records, I want to use Access (if a good idea) what is the fastest way to to connect and retrieve records. Thanks Phil
  7. BAWC01

    Selecting a record in a recordset

    Hi I have a recordset Private Sub ULDID_Click() Dim dbsCurrent As Database 'Dim rstHUTF As DAO.Recordset === Globally Set GULD_ID = Mid(cmbULD_ID.Value, 4, 5) GULD_Carrier = Mid(Me.cmbULD_ID.Value, 9, 2) GULD_Full_ID = cmbULD_ID.Value Set dbsCurrent = CurrentDb Set rstHUTF =...
  8. BAWC01

    Setting a Report's Record Set

    Hi I have a form and a Subform I succesfully get the records I need to appear in the subform. I would like then to pass these records and the recordset into a report to print. How do I do that ? Thanks Phil
  9. BAWC01

    Setting a subform's Recordset

    Hi I have a form and a subform. I search using a combo to select the records I want and create a recordset Set rstHUTF = dbsCurrent.OpenRecordset( _ "SELECT STAMP, OPCOO, AREA, FLOW, USTATE, UCAT, WEIGHT, SHC, ULDID, INFLTID, OUTFLTID, DEST " _ & "FROM HIS_HUTF " _...
  10. BAWC01

    A Simple Query Filter !!!

    Hi I have the following data in a date field 11/05/2003 01:00:00 11/05/2003 02:00:00 11/05/2003 03:00:00 11/05/2003 04:00:00 11/05/2003 05:00:00 11/05/2003 06:00:00 11/05/2003 07:00:00 11/05/2003 08:00:00 11/05/2003 09:00:00 11/05/2003 10:00:00 11/05/2003 11:00:00 11/05/2003 12:00:00...
  11. BAWC01

    Reading the Next Line - Problem with Spaces

    Hi I have the following text 16.11.05 00:48:12 SMP _CASE: received fcode: 3409 16.11.05 00:48:12 SMP _AWBGRP_INS: '125-54725322' 4 'D' 'BA 215 16NOV05' 0 'PMC 76364BA' 16.11.05 00:48:12 SMP _CASE: Answer send with state: 0 16.11.05 00:48:13 SMP _CASE: received fcode: 3416 16.11.05...
  12. BAWC01

    Slowing Down of Everything

    Hi I'm running a Tru64 Cluster on ES45 with 4 GB Ram and San arrays over fibre interchannel. Im running Oracle 9i I have an Oracle database which reads in text files into a database. The problem is that when Oracle archives the redo logs EVERYTHING slows down and I mean everything. I have 3...
  13. BAWC01

    Stripping Characters

    Hi I have somne text 15.01.06 07:49:39 102374 jobs_worker: loc_para[6].loc_port 20200 15.01.06 07:49:39 102374 jobs_worker: loc_para[6].connectname smp/smp@ba_asmpma 15.01.06 07:49:39 102374 jobs_worker: loc_para[6].thread_no 6 The problem I have is the following changes is length...
  14. BAWC01

    Excel Columns

    Hi I'm trying for format an Excel sheet to make it look tider and much more like a word document table. But it has calculations in a table. Can you in Excel divide columns I need to format the layout with different Column widths and merged columns ? thanks Phil
  15. BAWC01

    subtracting dates in WORD

    Hi Can WORD subtract two dates both from a table and dispay the difference as an intege in another cell ? Thanks Phil
  16. BAWC01

    Word Sibtracting Dates - Possible ?

    Is it possible for Word to Subtract two dates and leave an integer If so could you post me an example Please Phil
  17. BAWC01

    Can Word Subtract 2 dates and leave an Integer

    Is it possible for Word to Subtract two dates and leave an integer Phil
  18. BAWC01

    InfoPath subtracting two dates

    Hi Does anybody know if it is possible to subtract two dates which have been selected from date pickboxes and leave an integer in a field Thanks
  19. BAWC01

    Problem with the Format Function

    Hi I am trying to format a date, using a wrapper function Public Function SetInvDate() As Date SetInvDate = format(GlobalInvoiceDate, "dd-mm-yy") End Function But I have noticed that the format stays in lower case and in black, rather than like Format in uppercase. What is going on Phil
  20. BAWC01

    Export Function Date Format

    Hi I'm exporting a query to a file using DoCmd.TransferText acExportDelim, "Export_AP INV DISTR", "AP INV DISTR", GlobalOUTPUTLoc & "\" & "AP INV DISTR.csv", True This works fine expect when I look at the file Supplier Description Inv Date Inv Number Net 100171 travel 08/12/2005...

Part and Inventory Search

Back
Top