Recent content by croydon

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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

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