Recent content by croydon

  1. C

    Subform highlighting/selection problem

    I have been able to replicate the user's problem. This only happens if the form is called from a combobox on the customised ribbon. If it is run from a button on the ribbon it works perfectly. When the combobox selection is made it goes into a subroutine containing a select case and when it...
  2. C

    Subform highlighting/selection problem

    arnelgp, just tried that but unfortunately the same issue. The fact that it works differently for me and other users makes me think it must be a setting somewhere
  3. C

    Subform highlighting/selection problem

    I have a form with an embedded subform with continuous forms view. The idea being that the user clicks on a row and the details are displayed in a separate form for editing. This works successfully for me, but not for some other users. The form is not linked to the subform by master/child, but...
  4. C

    Question User cannot start Access database

    An update on this: We had the user's profile checked and it was the same as her colleague's. We have a workaround now (but I'm not sure why it works). We created a shortcut to the database on the user's laptop. We found that if she starts Access from Start Programs then selects the shortcut from...
  5. C

    Question User cannot start Access database

    The database is not split and there are three other users that can be on at the same time and none are exclusive.
  6. C

    Question User cannot start Access database

    I have an Access 2013 user who cannot use a particular Access database whilst her colleagues are using it. She gets no error message, Access just starts (she sees the 'Access' splash screen) then ends. If she goes into the database as the first user, it's fine. Her colleagues can also enter it...
  7. C

    Custom Ribbon question

    Actually I have a tab control that displays four forms, each may need to be filtered for searching. I can put the Filter in the Quick Access Toolbar but putting it in the ribbon would be tidier.
  8. C

    Custom Ribbon question

    Is it possible to use functions in the normal Access 2007 (Fluent?) Ribbon in a Custom Ribbon? I would like to use the Filter button in a Custom Ribbon. I can create a button with a Filter image but I don't know what the callback should be. Any suggestions would be appreciated.
  9. C

    Database growing disproportionally

    No, the back-end contains only tables now. I have found out something that may be significant. There is one process where a user opens a spreadsheet and selects the first four columns from row 2 to the last row, then pastes them to the end of a datasheet (on the "*" row). Any duplicates appear...
  10. C

    Database growing disproportionally

    Thanks for the reply. As I understand it, there are some additions and deletions each day but I don't understand why it increases to such a size. Could it be that the database itself (not the tables) is somehow corrupted and is not being rectified by the compact and repair? Before the database...
  11. C

    Database growing disproportionally

    I have just taken on support of a split Access 2003 database. An immediate problem with it is that the back-end grows disproportionally. There are 14 tables with about 37000 rows in total. The columns are numbers or text, there are no memo fields or stored images. There are no temporary tables...
  12. C

    Ribbon Combo Box

    Nidge, Unfortunately, 'Size' cannot be applied to a ComboBox.
  13. C

    Lines of code - in another database

    Is it possible to open another Access database and count the lines of code? I have been asked to get a count of all lines of code for all Access databases on a particular server. I would guess this ought to be possible using VBA and storing the results in a table. I have found a code sample...
  14. C

    Ribbon Combo Box

    I think I now understand what is going on. The combo boxes were defined with their individual items in the ribbon record. They did not refresh. As a test, I tried storing the items for one combo in a table and populating the combo using the getItemCount, getItemLabel and getItemImage...
  15. C

    Ribbon Combo Box

    Nigel, thanks for the offer. Before I do that, could you tell me what callbacks you have on your combo boxes? In my case, the 'onChange' event runs a function to determine the macro to run or form to open. This works correctly, but as I say, leaves the selection name in the combo text and the...
Back
Top Bottom