Recent content by AlanAnderson

Thank you, That is very kind of you. I think that's a great suggestion.

Hi, I have read it very carefully but that message is the tip of an iceberg. If one tries to save it will not because a "Before Update"prevents it. I have removed every single before update and still get problem. In addition it states that a "Field" must first be saved. There...

Hi Jhb, Thank you very much for trying. Your help is appreciated Regards Alan

Hi, Thanks again for the suggestions. I tried setting I ton After Update instead on On Click but still same error. I've also tried putting in DoCmd.Save in the beginning of the routine as well as before the problem line. Makes no difference Sorry I did not understand your comment: "Ps. Not...

Hi, If I do then I get different error on next line - Requery. Says one can't requery without saving. I've tried commenting out all lines except for the recordset operation and final requery but still get the 2115 error Regards Alan PS I would stress again, this code works if...

Please note that where I have a line like '@@@@@@@ its just a reminder that there is something there I still need to work on. The lines marked '<<<<<<<<< is where the programme stops Regards Alan

Hi, That is a bit of a problem right now because my database currently refers to literally hundreds of images on my PC that are not properly organised ATM. The Code that results in the problem is below. Thanks again, Alan

Hi JHB, Thanks for the reply. What I need to know is WHAT TABLE does it try update? It is an unbound form so I do not understand Regards Alan

Hi All, FIRSTLY I HAVE POSTED THIS PROBLEM ON ANOTHER FORUM I have a routine than has been working perfectly up to now. My save routine was called by clicking a Command Button called cmdAdd. I tried to change this Command Button to a toggle button by deleting it then creating the toggle...

Hi, As suggested in the sticky note above try looking at http://www.databaseanswers.org/data_models/ They have several shipping databases to use, Regards Alan

Hi, In January 2012 you posted a thread Vehicle Management system in which you attached Corolla.zip. I see the thread is now closed but the zipfile is not downloadable. Is it possible for you to either re-post that file or to send it to me at afc@bdsmw.com. Thanks, Alan

Hi All, I know this is an old thread but have you investigated SSE Setup? Its great, easy to use and really cheap. Free for personal use and only $30 for single user. I've downloaded this and it works like a dream - far better than the ones that cost 20 times more, You can find it at...

Hi All, I need some kind of routine (probably a batch file) that can look at a user's PC and find if Access is actually on the machine or not. If yes - no problem my install programme just installs my app. If not then I need to install Access RunTime. Any thoughts as to how I can do this...

Hi Guys, That statement doesn't appear to work. If I place a "watch" on VATMonth it seems that Access can't find it. It says "Expression not defined in context" yet that exact field name does exist in the table. ????? Regards, Alan

Hi, Thank you for that - I will give it a try. But that's only half the problem. What will that statement do if no record is found? In that case, I need to add that record not just edit the existing (found) record. Regards, Alan