Recent content by jeffreyccs

Thanks for your input Regards

Thanks for your feedback I have populated the array by looping through a recordset. Regards Jeff

Hi I would like to populate an arrray using the GetRows method, however I would like to use Base 1 and using GetRows defaults to Base 0 even hough Option Base 1 is set. Is this possible or should I use a different method to populate the array. Any advice would be appreciated Regards Jeff

Thank you for your input Regards Jeff

Hi AS the text in the VBE looked a bit washed out I decided to try and change the foreground and background colours and also increase the default text size. To my surprise after selecting a black background and white foreground, any symbols and numbers changed correctly but alpha text remains...

Hi Thanks for the feedback, much appreciated. Regards Jeff

Hi I have a table that contains the directory information for a number of images and is used to link to the images, this can easily be updated locally using find and replace. When passing the file to another user I would like to be able to automate the process in VBA, I can easily create the...

Many thanks for your input Regards Jeff

Hi I have a query regarding the above, I have tried using the keypress event to restrict entry to numeric values only and that functions correctly. The issue that I have is that there are a number of textboxes and like most people I will use the enter or tab keys to move between them...

I just realised thsat I can place the code in the on load event and it works fine. Regards Jeff

Hi I would like to know if the on Format event or an equivalent can be applied to the report view as I do not want to print anything and all the formatting applies to printing, or at least it appears that way. I want to give users the opportunity to view an abbreviated version of reports by...

Thanks for the example I had used different events got/lost focus for the option button which seemed to be okay apart from causing the strange problem. It just goes to show that you can never be quite sure. Once again thanks to you all Regards Jeff

Hi Sorry for the delay in replying. I am attaching a small sample illustrating the problem Thank you for your assistance Regards Jeff

Hi I have a form used for selecting reports via option buttons and one option is to select individual students from a dropdown list. I had intended that the combobox and label would be hidden until selecting the relevant option button. On selection the combobox becomes visible but the dropdown...

Hi Thanks for all the replies Unfortunately I was unwell and could not reply earlier. I will work through everything and let you know how I get on. Many thanks Regards Jeff