Search results

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

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

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.

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

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

I am working on an Access 2003 application where the data has been upsized to SQL Server 2005. I need to make a change to a form's processing when a new record is added. This requires inserting a record in a second table using the same key. The key for the original table is identity...