Search results

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

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 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...

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...

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...

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 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...

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 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...

Hi I have a problem creating a sort on a report containing students test results. I would like to sort on the students overall percentage correct but cannot find a way to do it. The student sub totals are a calculated field and Access does not seem to allow sorting on an expression. I looked at...

Hi I have a form that is used to determine whether students have taken a particular test. The same form is used for all tests and uses a query to create the list of students still to take the test. Everything works fine until there are no student names left and then selecting the combo box...

Hi I have a report that contains six fields, with the first being the question number, the next four containing data and the final field containing a number between 1 and 4, this being the criteria to hide one of the four data fields. The report is for administering a test where there are...