Search results

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

Hi In Excel it is very straightforward to execute a sub from a shortcut but in Access as far as I can see it is only possible to run a macro from a shortcut and from a macro only possible to execute a function rather than a sub. As using a button is not practical I would like to find out if...

Thanks I'll have a go and see how I get on Regards Jeff

As part of learning how to use Access better during shielding, I am rewriting some of my Excel solutions in Access and have come across something that was fairly straightforward in Excel that I cannot work out in Access. I have two tables that I wish to compare Table A has five numeric fields...

Hi Everyone Thanks for your time, I have just gone through everything and found out that I made a typo in the fairly lengthy textbox name and that caused it to create an error when referring to what was an incorrect name. I am sorry to have wasted your time and apologize Thanks again Jeff

Hi I have a form that requires users to enter a starting time for an event in a textbox which is written to a table using code attached to a command button. The textbox has an input mask for hours and minutes and after the write has been completed I want to clear the value from the text box...