Recent content by John S

Thanks - I've a very sketchy grasp of VB in Access - if it came to that I'd be more likely to export the data and try to cobble something together in C. An unsatifsying workaround rather than a neat solution. It's a frustrating problem, as it's easy to represent graphically (like a series of...

I've got a table 'Activity' with around 9000 records built up over the past 18 months. Each record has three fields: ID (autonumber), Start (datetime) and End (datetime). An activity can start and end at any time (denoted Start and End), and be of any duration. Generally there are several...

apologies - they are the same as CALLDAT and CALLTME - the actual table and field names are more complex, but I'd tried to simplify things

I have to build some queries based on a table called ASSIGN which stores dates and times as nine digit string as follows: CALLDAT = 131336708 CALLTME = 269688871 I've been give the following algorithm for converting these to date / time format: Dat = CALLDAT_HDW Tme = CALLTME_HDW YYYY =...

Jonathan - many thanks, it now works OK

I have a form displaying postcodes (amongst other things) from an underlying table MEMBERS. There is also a calculated field in the form which shows the first two letters of the current postcode. A separate query qryFirst2 simply usesthe LEFT function to return the first 2 letters of all the...

Looks to me like you'll need to add a bit of code to handle dates in December - to ensure that the 'year' part of the date increments properly. John

Finally sorted it, by adding the line: Me.Refresh to the OnExit code suggested above - and it works! many thanks to everyone who responded. John

Thanks - still not quite there yet D-Fresh - no, there is nothing in the table for a new record until I enter a value for LastName - which I then want immediately to appear as well in the ChildLastName box on the same form as soon as I tab away from the LastName box. Both values should then get...

Thanks Kevin - I'm afraid that doesn't work either - it does copy the text from LastName into ChildLastName, but only after I move to a different record & then back again. Still hoping for a way of putting a value into LastName, tabbing to the next field (Address1), and immediately seeing the...

Thanks Doug - very nearly there - this puts the value of LastName into ChildLastName, as required, but it only does so when I start a new record. I'd like to be able to get this to happen as soon as LastName has been entered. I've also tried putting the code into 'on lost focus' and 'on exit'...

Probably trivial - but this is getting annoying. I've searched this forum & Access help files, but can't find a solution. I have a form where all the fields refer to a single table Members. One field has control source LastName, and another is ChildLastName. I am trying to do the following...

... or select the field on the form, use Format | Conditional formatting from the main menu bar (Access 2000), and set the conditions as required. Works fine for me, and no coding required. John Bristol UK

RpbertS It is certainly possible - I have it working OK keeping an audit log of a table (Access 2000). It took me a couple of days to get it sorted, but this was entirely due to my typos when substituting my table names for those in the example. I followed the detailed instructions at...

thanks - but it's a networked office printer & works fine (i.e. no extra blank pages) with everything else I send to it. I'm sure it's an Access problem