Search results

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

    Ribbon Combo Box

    Not really. I come back to the problem occasionally to try resolve it. By using InvalidateControl and setting the getText callback to "", I can blank the selection made in the combo. However, the index is still set (the previous selection is still highlighted) which stops that item being...
  17. C

    Ribbon Combo Box

    Thanks for the suggestion, but there doesn't seem to be a way of doing this.
  18. C

    Ribbon Combo Box

    I have a ribbon containing a combo box. When a selection is made, the callback runs the function correctly. However, the selected item remains selected in the combo. This means that it cannot be selected (clicked) again, unless another item is selected first. Is there a way to clear the...
  19. C

    Access 2007 will not launch

    I am having a problem with Access 2007. It will not launch when run it from the Start Programs menu. I get the error 'Access failed to start correctly last time. Starting Access in safe mode will help you correct or isolate a start up problem in order to successfully start the program. Do you...
  20. C

    Customized Toolbars

    I have created a toolbar using the Customize function. This is a toolbar with five options. Each of these options is a group that has a number of further options (i.e. opens various forms and reports). Depending on the user access level, I would like to disable some options from within VBA. I...
Back
Top Bottom