Recent content by PatD

Many thanks for proposed link. This led me to Jan Fransen link http://msdn.microsoft.com/en-us/library/cc136539(office.12).aspx which then explained why the deployment won't work and then went on to explain how to make it work. Thanks again for the help Pat

Hi All, I'm trying to create a Runtime to be installed with the Application. It all works OK but the Application file is not included with the final package (either .accdb or .accdr). I want to place the whole package on a disc. I am using the Wizard to create the runtime package and the Runtime...

Many many thanks for all your effort and time you put into my problem. Everything is working great now. Pat

Compressed Db attached a requested Pat

Nearly there, Have checked tab orders & all OK and then added a line just prior to the End Sub which reads: TxtEnd = TxtRankage + TxtStart (this is not the final calculation coding, but a simple test to check the result) TxtRankage calculates and displays in the Report OK. The Report then...

Thanks for response. I created the code as proposed and the opening line reads: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) The "Me.txtStart.Tag = Me.txtEnd" - Returns: Run-time error '94' Invalid use of Null On the Locals - Cancel reads 0 and FormatCount reads 1. I...

I see sail the blind man!! - TxtEnd is the name of a calculated text box in the Report & has no associated field - All down to the requirement not to store excess data. I was using the Function CalcTxtEnd() to provide the data for each report row. Obviously it can't back calculate to the...

Many thanks for the response but unfortunately the proposed DlookUp didn’t work for me. The main index for the Query is Skipper_ID which I used after using the plain ID didn’t work. I had #Error on each row. I then tried the Function CalcTxtStart() but this didn’t work per Note 3 below. The new...

The attached word document is the Microsoft KB101081 document. My equivalent, held in a Module, is: Function PrevRecVal(Q As Query, KeyName As String, KeyValue, FieldNameToGet As Long) 'KeyName = The Name of the Queries key value 'KeyValue = The current records key value Dim rs As Recordset On...

Microsoft document KB/101081 shows how to do this but I can't get it to work. Neither could another member as discussed on thread 27545 (which is no longer accessible, except by internet search). As my query generated report is fed from three tables I need to use the proposed CODE method...

Hi Simon, Thanks for that, I like the idea of varying points on fleet size. These are Model Racing Yachts to a strict specification and races are not timed. The basic idea is to allow each skipper to see how they improve (or otherwise) over a number of races. Each Skipper is initialised with 90...

Simon, Many, many thanks - I could never have sorted it out myself. Everthing works as planned. On your two questions the 1st/2nd name was me playing and never took it out or cleaned up. The maths are a bit odd as I'm trying to see how Skippers progressively improve - or otherwise Meanwhile...

David, Sorry for delay due unforseen circumstances File attached as requested in Access 2007

Sorry David, you were right – it was a typo (will try and do better in the future!!). The following is the new Query which now works OK when just running the query. It lists each Skipper ID in turn but thereafter not in Date Sequence. SELECT Rating.Skipper_ID, Race_Dates.RaceDate...

Thanks for response David, unfortunately that didn't work for me. I have a Skippers Table and altered the Query to read: SELECT Race_Dates.RaceDate, Race_Dates.NrEntries, Rating.Skipper_ID, Rating.Rank, Skippers.ID FROM Skippers INNER JOIN Rating ON Rating.Skipper_ID = Skippers.ID; Also...