Search results

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

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

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

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

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

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