Search results

Good Day All; I have recently upgraded our outlook package from 2010 to 2013; and Access from 2003 to 2010; I have a macro that would e mail out from a form on my Access database, unfortunately now I get error 2293 with the following message: Microsoft Access can't send this e mail message...

cj_london/plog I managed to identify a corrupt record in the tbl_details_cars, I have removed the record and everything is fine now. :D Although; I had to copy the table and structure in order to remove the record, and then delete the original. Thanks for your help. Kind Regards...

Afternoon all; I am running the following union query which has been working until today: SELECT sund_main_ref AS REF,sund_main_folio AS FOLIO, "SUND" AS SUFFIX,sund_main_comment AS COMMENT FROM tbl_sund_main UNION ALL SELECT m_ref,m_folio,"POST" AS SUFFIX,m_declared_contents FROM...

Hi Uncle Gizmo; Thanks for the reply, unfortunately I have tried this code and it doesn't seem to work either? Is there any other way of doing this? Regards Tor Fey

Good Day All; I am looking to hide page tabs on my form for a current user; I have tried the following 'onload' event: If Me.loggedon = jblog Then Me.TabCtl6.Pages(0).Visible = False End If Please not: the field: 'loggedon' is an unbound text field which source is set to...

Hi NauticalGent; I have just discovered this; and now I can confirm everything is working correctly. Thank you so much for all your help :). Kind Regards Tor Fey

Defeat is irrelevant, try, try, try and try again!

All; Attached is the what I am trying to achieve in my query as suggested; unfortunately I cannot get the query to run correctly; any help would be appreciated. Regards Tor Fey

Hi Plog; The data shown; is only a quick dirty test database to try and demonstrate what I need to do; I wasn't aloud to post any data from the actual database this will be run in. Regards Tor Fey

Hi arnelgp; the fields 'totaldays1', 'totaldays2' and 'totaldays3' already add together date fields individually; I then need to add these fields together to get a running total. if the total is then '0' I don't want the records to show on the report. Regards Tor Fey

arnelgp; This isn't going to work; I need to create an expression in my query; that adds together 3 other expressions to give a total and only to display records >0 for that 'totalalldays' column, so for example: 'totalalldays: [totaldays1] + [totaldays2] + [totaldays3]' please not...

This doesn't really work as I have 3 calculated fields that require to be added up and only show records >0, if you have a look at the attached query, how does one go about summing fields in a query? as when I try it nothing is displayed? So I need to sum up the expressions of my query...

Hi NauticalGent; Unfortunately; the calculation field is not in my query; it is an unbound fields that counts days taken between two date fields; this is why I need some kind of 'On Open' event that will hide all the records with a value of Zero in my unbound calculation field. Regards Tor Fey

Good Morning All; I am looking for help with an access 2003 report; what I need to do is to not show an entire record on my report; if the total of my total field is zero. Is there any VBA code I can use to accomplish this? Your help as always is very much appreciated Kind Regards Tor Fey

Hi Minty; Never mind; I have sorted it; I didn't read your part of putting the code at the beginning, everything now works perfectly, so once again thanks so much for your help, very much appreciated :) Kind Regards Tor Fey

Hi Minty; so I have tried this code: Private Sub cmdCalDate_LostFocus() If IsNull(Me.date1) Then Me.date1 = Me.txtdate Exit Sub End If If IsNull(Me.date2) Then Me.date2 = Me.txtdate Exit Sub End If Me.date3 = Me.txtdate End If If Not IsNull(date3) Then...

Hi Minty; The 'Lost Focus' event, works nicely, thanks so much for that, it hadn't occurred to me to put the code there :) Just need to sort out some validation now, for when my 3 date fields boxes are all full so that the user can't enter any further data. going to use a msgbox for...

Hi Minty; I am using access 2003 sp2, and the only way to create a date picker with this version of access, is as I have done. I don't have the option to upgrade access; as my work will not allow it to happen, but we use access for almost everything, this is why I have to do things in a...

Hi Minty; I can't add the after update event to the field that populates txtDate as there is no afterupdate available, please see attached screenshot. Would this then be set as an 'onchange' event? Regards Tor Fey

Hi Minty; Thanks for this, Is this going to be code as an afterupdate event on the filed: txtDate? or if not how do I code it? Regards Tor Fey