Search results

Hi all, In Access 2007, you can now create a form, display it in datasheet view, and specify that the sheet display Totals (Home ribbon, records group). Once turned on, you can select count, sum, average, etc for each column at the bottom of the datasheet. This is a really cool feature...

I'm working with a ADP in 2007 (not an accdb) in which I've defined a new custom ribbon. ADPs do not recognise the USysRibbons table, so it is not available to select through the Access Options screen. I've used the LoadCustomUI method to load the ribbon, and I can then associate it to...

I am quite familiar with how to customize or permanently hide the ribbon in ACCDBs, using the USysRibbon table and XML code. Unfortunatly, I am now working with an Access Project (ADP) frontend interfacing with a SQL server. As you may know, ADPs can not have local tables -- all tables must...

Is there a way to programmatically change setting in the main Options dialog (Tools --> Options...). I specifically need to turn off the checkbox in the Spelling tab titled "Ignore words in UPPERCASE" This is on by default. Thanks!

I recently converted an Access front-end application (that used ODBC to a SQL 2000 database) to an Access Database Project (ADP). I imported all the forms, macros, code modes, etc, including the Switchboard Items table. With minor tweaking to table references here and there (such as in...

I've created an ADP project containingnumerous tables. One (and only one!) table in the set will not open in edit mode while in Access. Here are the particulars: 1) The table was created from scratch in SQL Enterprise Manager, 2) The table is editable in SQL Enterprise Manager, 3) The table...