Search results

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

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

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

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

Every time I open a particular report a blank page is sent to the printer. The 'On Open' property is blank and the report width does not exceed the available page width. I am not giving any explicit 'print' instructions, and the underlying query does not have any print actions. I'd like to stop...

Has anyone succeeded in using Allen Browne's audit trail method described at http://www.wa.apana.org.au/~abrowne/AppAudit.html I find that changes are not being recorded - both the temporary and permanent audit tables remain empty when changes are made. I've check my implementation and all...