Search Result

I have a datasheet with alternate row shading and conditional formatting. Unfortunately when the conditional formatting returns true, I lose the alternate row shading for that control.

Has anyone else run into this problem? Does anyone know a fix?

I'm wanting to give my users some options in a datasheet view
* drag the columns around
* set the widths
* show or hide columns, etc.

If they do this, the changes don't 'stick' because they're using an .mde and
the next time they open the system it reverts back to the layout saved when
I created the .mde

I'm trying to add a combo button to select and view the different layouts in my...

Help !! My code below generates error 425 'object required'. (I'm using Access 2003)
I have a table opened as a datasheet, but the column widths need adjusting programatically to fit. I have seen posts about doing this on datasheets on forms or subforms - but can I do it this way on a table opened as a datasheet? The application is being distributed as an .mde file to general users with only custom menus showing. I can't therefore use any...

Hi

In VBA I populate an unbound subform (datasheet view) via a recordset that can be changed using filters selected by the user. The only problem I am having is that due to the unbound nature of the subform the sorting function activated by the column header click only works once, the second time the user tries a sort an error occurs ("Data provider could not be initialized").

Is there any way I could handle...

Hi - I've got an interesting one here:
I've got an mdb file that some users run in Access 2003 and some in 2007.
I have a Localize function that is called on the open of each form to set the captions and formatting to match the user's locale. One thing that I commonly do is set the Format property of text boxes that display date/time values to match the user's date/time preferences (i.e. m/d/yy or d/m/yy). It is not always an option...