Recent content by solnajeff

It is actually for display on a Large TV where the number will take up a significant portion of the screen in order for customers to view it easily. It is a part of a promotional activity that requires number draws. I had previously written everything in Excel which was not a problem, however...

Hi With a normal textbox the text size is limited to a maximum of 127 pt, so to get around that I used an active x control, Microsoft Forms 2 textbox. This allows greater text sizes and works fin apart from the visible border. This is something strange because it does not appear possible to...

Hi I wonder if anyone else has come across this. I have opted to use an active x textbox control to get around the limitation on text size in a normal text box, however I do not wish to have a visible border. Having tried all the options in the property sheet and also using VBA I am left with a...

Hi Thanks for the suggestions, I apologise for the delay in replying buth have been ill and am only just getting back into the swing of things. Regards Jeff

Hi sorry for the delay in replying, I was away for the holiday. I am going through everybodys suggestions and will update as soon as I can. Many thanks for all your suggestions and observations. Regards Jeff

Hi I wonder if anyone can tell me if it is possible to refer to arrays using variables. I have a number of arrays and rather than write out separate code for each I would like to refer to the array using a variable e.g "Array" & var. I have tried all the combinations I can think of but...

Hi Sorry for not explaining as well as I could have. I have prepared a sample to illustrate the problem. with the focus events commented out the combobox works correctly. With the focus events working the combobox locks up and no drop down. Really odd behaviour Regards Jeff

Hi I have a question regarding comboboxes, and also text boxes. I have a form where users can select the report they wish using option buttons, no problem there. The option buttons relating to individual students have code attached to the on focus and lost focus events to hide or show a...

Hi Thanks for the reply. I finally managed to make it work but did need to use an additional query because the result table requires a specific Test ID and Test Number. Once again many thanks Regards Jeff

Hi Thanks for the advice, unfortunately I cannot get it to work. I have made up a sample to illustrate my problem and the query returns the records showing completed tests matching the criteria. However I am trying to find out how to show those trainees who have not yet completed the relevant...

Hi I am trying to create a query that will show only trainees who have not completed a test. The attached relationship produces a query that does the opposite, i.e. only trainees from a particular school who have completed a specified test. I cannot work out how to exclude trainees rather...

Hi Once again thanks for all the advice and the video. Regards Jeff

Hi Sorry I could not post yesterday and thank you to all responders. I am attaching a sample illustrating what I used that generates an error message if there is no data or if an empty box, or boxes, is left in any of the groups (both five and three). Once again many thanks Regards Jeff

Hi I have a form with a large number of text boxes that must be completed. I would like to use a formula if possible to check if any are incomplete rather than loop through using VBA. I feel sure that it should be possible but cannot find any reference on the web. Any advice would be...

Hi Thanks for the advice. Although there are other subforms that have blank textboxes the subform itself contains data so I assume that is why the border still displays. Need to think about that Many thanks Jeff