Search results

Can you post an example code of how to use this to obtain a count within a forms code. I dont need to filter the records displayed in the form. The user selects an exemption code from a drop down, and in this case the message displayed to show the number of records is correct, as the same...

I have a form bound to a query. The query contains thee following tables tblRequests Field Name Value Value intrequestID 1 2 Linktable Field Name Value Value Value intRequestID 1 1 2 intExemptionID...

Very true missingling I think I was trying to be too precise. Thank your for your speedy reply You too David Pat

Hi Is it possible to remove the X (Close Button) from a messagebox. I have searched the web, but to No avail this is my code: If Not Me.Dirty Then MsgBox "No Additions or Changes made. Therefore SAVE not appropriate", vbInformation + vbOKOnly, "Add Status" End if Thanks in Advance Pat

THe Error processing works fine on other computers at work. I think the problem must lie with my installation of access. Thanks again to all who have helped in this problem pat

Thank you missingling I was checking the Err flag not the DataErr. Works a treat now Thanks for your speedy response

Hi all I have a numeric field on a form and want to stop the user from entering non numeric data. If the user enters non numeric data the Access error message "the value you entered isn't valid for the field". I want to suppress this error message and replace it with my own. Where do I need...

it seems none of my on error processing is working. the access message showing runtime error is always displayed not the message from the on error routines. Am i missing something here

thanks to all for your help. Have decided to set email to be sent without being displyed first in do sendobject Cant see a way round this problem

i have just realised, on the works computer it is running the Express ClickYES program which stops the macro security message from outlook ( a program is trying to send a message on your behalf) from being displayed, Would this interfere with the Error handling routine.

msgbox in all error handlers still no joy. still displays runtime error 2501, but wont go into the error handling routine.

i will put in the message boxes and see error 3020 is Update or CancelUpdate without AddNew or Edit. Thanks for your Patience (an nhs pun there lol)

Hi Gemma the cheques in the post LOL i added a resume statement, but still no joy, what adjustmenys did you have to make, do i need to change my code. I am still baffled as to why the code runs ok on my home computer, and the send element works fine at work

if you select create foi request from main menu on status tab enter an internal ref code format (999-09) select a received date and a date to be completed by on requestor tab select "daily mail" from organistaion drop down Select White, Paul from Requestor name drop down click Save FOI...

Hi Gemma I can send email, if the user clicks send instead of cancel the email is sent successfully thanks for your suggestion.

moved the code into the save_click event as suggested above , but error preocessing still not being triggered. access displays runtime error 2501 and halts the debug msgbox appears This is back at my works computer, as per original post. Any other suggestions please

just tried the original code (error processing in sub)on my home pc running outlook 2007 and 2051 error processing worked ok, my error message was displayed I will rerun it at work on monday where pc is running outlook 2003 Strange

thanks bob and irish I will move the code and let you know. I am used to putting code in subs for ease of programming. this is a new one on me

exactly,the access runtime error message 2501 is being displayed.

thanks for the replies. gemma: i put the msgbox in to see if the error process was working: Irish: i need to trap the error, because at the moment when the email send is cancelled the run time error message is being displayed and the code is highlighted on the DoCmd.SendObject line in the sub...