Recent content by Peter Hibbs

Hi Peter, Perhaps the attached demo will give you some ideas. There are three databases which have slightly different facilities, Demo 1 is the earliest and the enclosed User Manual refers to this version. Demos 2 and 3 have additional features which are not mentioned in the User Manual but I...

Hi MajP, Thanks for the additional options on my demo, this was very interesting for me as I have not come across the Paint feature in this context before. As you say, it certainly looks simpler than the Rich Text version so I will test it out when I have a bit more time to see how it works in...

OK, it just sounded like there was a question regarding the Calculated Field issue but maybe I misread the comment. My mistake. Peter.

Hi arnelgp, Yes, it is. Is there a problem with that (I am relatively new here)! Peter.

This demo shows how to create a Continuous type form with a different colour for the background that is linked to a field value. Normally we would use Conditional Formatting to achieve this effect but this demo use Rich Text fields and some simple code to do the same. This has the advantage over...

Hi Colin, Yes I did and thanks for passing it on to the Access team. I am not sure how they deal with this sort of issue, do they just issue an update or do they let you know what they are going to do or do they sit on it for weeks or what? I guess you would know better than anybody what the...

OK, in view of the above discussions it seems that either - the Calculated form is working correctly and Microsoft has not published a definitive list of operators/functions that are valid or invalid or - the Calculated form is NOT working correctly and Microsoft need to fix it. It looks like...

Hi Pat, What exactly do you mean by SQL? Do you mean that Integer Divide and Mod cannot be used in a Query (which they can) or did you mean something else? I am a bit confused. Hi Ken, Yes, I could use a query but using this method was simpler and for my purposes was adequate for the task. If...

Hi Doc_Man, No problem. I guess that if Microsoft are saying that the backslash should work in this situation then perhaps somebody here should flag it up to them to see if they can fix it. I'm not holding my breath though! Peter.

Hi Doc UnitsInStock is in the same table and it is Number type (Integer). The spellings are correct (if I use the / character instead, it works fine). The purpose of the Calculated field is to just create a number between 1 and 8 (approximately) which is then used in a query. I should have...

Hi All, I have a Calculated type field in a table (and I am aware that these are not normally recommended but this is only for a small demo program and this method is the easiest option for my purposes) which fails when I enter the calculation formula. Anyway, I entered the following...

Hi, OK, that's fine. it is your choice of course. And good luck with your project. Peter.

Hi Murray83, Interesting project but I think that the user interface could be improved a bit, it is a bit too 'clunky' for me. See the attached demo which I wrote a few years ago which does something similar to your version. Maybe it will give you some ideas on how to do the chess piece moves...

Hi Colin, OK, thanks, I will do that. One question - is the Report link at the bottom of the text box used to alert the Admin people? There is no pop-up 'Control Tip text' to tell me what it does! Peter.

Hi Colin, Thanks for the greeting and I would be happy to upload the calendar app (once I have worked out how to do it on this site). It needs a bit of tweaking but I will give it a try as soon as I can. And thanks to The DBGuy and NauticalGent as well, much appreciated. Peter.