Recent content by jeffreyccs

  1. J

    Run Sub using keyboard shortcut

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

    Run Sub using keyboard shortcut

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

    Comparing Data in Two Tables

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

    Comparing Data in Two Tables

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

    Text Box with Input Mask Error

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

    Text Box with Input Mask Error

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

    Report Sorting using percentage

    Hi I apologize for the delay in replying. I have put together a small example showing the report and it is the sub totals in red that I am trying to sort on using percentage as the basis. Thanks for your comments Regards Jeff
  8. J

    Report Sorting using percentage

    Hi Thanks for the reply. I am calculating percentages in both group and overall totals using =Format(Sum([Correct])/Sum([Questions]),"0.0%") Regards Jeff
  9. J

    Report Sorting using percentage

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

    Type Mismatch Error with Empty Combo Box

    Hi Thanks for your reply. I realised that the problem was of my own making. I had been converting the database to permit multilingual operation and this required that all references in queries that previously were textual needed to be numerical and I missed one that threw up the error. Many...
  11. J

    Type Mismatch Error with Empty Combo Box

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

    Hide report elements conditionally

    Hi Thanks for the replies which I will try out. In the meantime I have amended my code to provide an alternative. As the test was generated in an array with the final column being the pointer to the field to be hidden, prior to posting the data to the table I moved the 'answer' value to the...
  13. J

    Hide report elements conditionally

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

    Enter any one cell, change the others

    Hi Tom Sorry for the delay in replying. First of all you can delete module 1, this was just for me to use to enable events in case of an interrupted macro and does not have anything to do with the answer, I just forgot to delete it. The If Not Intersect code is to tell Excel to only carry out...
  15. J

    Enter any one cell, change the others

    Hi Tom One way to achieve this is using the Worksheet Change Event which will trigger when a cell is changed. Attached is a sample using your example and this can be easily adapted for other scenarios. Regards Jeff
Top Bottom