Search results for query: *

Geoff Thanks for that, how do I then change the status from "Build" to "Implement" as the days go from 14 to 0 Thanks Phil

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

Bingo Simple but Excellent solves my problem Thanks Phil

Can anybody help with this

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

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

Excellent Thank you, has helped and I have solved the problem thanks to your post Phil

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

Thanks I will have a go Cheers Phil

PHV I want to use the first time stamp and then just add items from each row into one. Thanks Phil

Yes I would like to select individual items from each row into 1 row I can then export, so it looks something like. 0125534229 15/04/2006 10:19:13 US MC10 ATR Line 5 No BSM MCS 11:54:19 ATR Line 5 Hope this makes it clearer Thanks Phil

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

Hi Darrylle Sorry I should have been more specific. I have created a front end to retrieve records from an Oracle Table, but there is a Java version on the application that somebody threw together whichis much faster if a lot less informative. That is where my question comes from, is Access...

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

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 =...

Roy Done it, Thank you Phil

Roy I have declared it globally Public rstHUTF As DAO.Recordset Then populate it the following way Private Sub cmbULD_ID_AfterUpdate() 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...

Roy Thanks for that I have done the following Private Sub Report_Open(Cancel As Integer) If ((Not rs.BOF) And (Not rs.EOF)) Then Me.RecordSource = rs.rstHUTF Else Cancel = True End If End Sub but get the following error when I press the print button on the form. Run time error...

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

Figured it out Set Forms!HUFT_ULD_TRACE!HUFT_ULD_Trace_Details.Form.Recordset = rstHUTF