Search results

Hi Minty; Thanks very much, that has resolved the issue. Much appreciated for your help as always :) Kind Regards Tor Fey

Hi Ridders; When I try this Access 2010 adds them back in? Regards Tor Fey

arnelgp; Ok.. I have added the following criteria only to the RecordCreationDate field in my query: Field: RecordCreationDate Table: TblTFBenMain Sort: Show: Yes Criteria: <DateAdd("d",-25,"Date") This brings up an error: "Data type mismatch in criteria expression", not sure where this is...

arnelgp/Galaxiom; Thanks for a quick reply, is this code to be placed in the criteria field of my query? Kind Regards Tor Fey

Good Afternoon all; Is it possible in a query; to show a list more than 25 days old of the creation date? In my table I have the following: RecordId - Auto Number RecordCreationDate - Short Date with the following default set: =Date()ItemNumber - Number Field ItemDesc - Text Field ActionDate...

Good Afternoon All; I wanted to thank everyone that has helped on this, I have the code working as I expect now. Kind Regards Tor Fey

Good Afternoon all; Sorry for being late getting back to you, I have been on leave. I wanted to thank everyone who has helped on this, it was very much appreciated, I have now identified the field causing the error, it was a bound YES/NO field, which after some consideration doesn't need...

The_Doc_Man ; You are indeed correct, it is error at this point with the following error code: For Each ctl In Screen.ActiveForm.Controls If ctl.Tag = "Audit" Then If Nz(ctl.Value) <> Nz(ctl.OldValue) Then operation is not supported for this type of object 3251 The form I am auditing is...

Good Afternoon All; I have created an audit trail procedure for an access database, for a form based on a query, unfortunately it is giving an error when running, but does record the changes to the audit table, my setup is as follows: I have a table called: tbl_audit which contains the...

Orthodox Dave; Perfect thanks, I have it working now with the following code: ------------------------------------------------------------------------ On Error GoTo Hell Dim NameSpace As Object Dim EmailSend As MailItem Dim EmailApp As Object Dim strUser As String Dim strBody As String...

Good Morning All; I have the following code on a button in my database; which works fine and I'm happy with. -------------------------------------------------------------- On Error GoTo Hell Dim NameSpace As Object Dim EmailSend As MailItem Dim EmailApp As Object Dim strUser As String...

Good Afternoon. I have a table called enquiries, and within this table I have a field called person, date, year & complex (complex field just contains the numbers 1,2,3,4,5,6,7 & 8) What I need to do is count all records in a query; against a person’s name for types 1,2,3,4,5,6,7 & 8, and...

Minty; Thanks for all your help; putting all the calculations in queries works real well, had to build 3 queries to accomplish what was needed, but everything is working as I expect. The 'diff' field is set to <>0 in the query; which is showing me the negative and positive figures I was hoping...

Hi Minty; The field 'duefromfigures' is made up of the following none visible fields on the report with the following criteria: '=Nz([lowA])+Nz([stdA])+Nz([lowB])+Nz([stdB])+Nz([lowC])+Nz([stdC])+Nz([lowD])+Nz([stdD])+Nz([udecs_st])-Nz([odecs_st])' The field 'duty_declared_st' comes from the...

Hi CJ; This isn't working either; the report is still show all the data that contains 0.00? Thanks Tor Fey

Minty; I have 3 fields in my report as follows: duefromfigures duty_declared_st diff the diff field is setup as a currency field as follows: =[duefromfigures]-[duty_declared_st] So what happens is when the figures from 'duty_declared_st' don't match the figures from 'duefromfigures' the...

Hi CJ I have my code, on the 'On Format' of each section, but still it doesn't work, the field is a currency field, my code won't let me put 0.00 or £0.00 All I want to do is prevent; records showing if the 'diff' field is equal to zero. The fields aren't calculated from a query, but...

Hi Minty; My report does not seem to have an 'On Format' event? Please see attached pic. Regards Tor Fey

Good Day all; Is it possible to hide fields on a report if they equal zero? I have a currency field on my report called diff, what I want to do is hide other fields on my report should this field be equal to zero. This is the code I have for the ‘On Load’ event of my report: If Me.diff =...

Hi Minty; Thanks for the reply; our MS Access & Outlook packages are delivered via App_V, so does this make them streamed? Regards Tor Fey