Recent content by amarkmac

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

Thanks, Nigel. You can definatley develop ADPs with 2007 and they've added a lot of neat new features around it. A user on another forum replied with a good lead ( http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1720391 ) that I'm pursuing now, so hold off on digging out the Word...

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

I'm running into exactly the same problem, but it didn't start until I upgraded from 2003 to 2007. After some experimentation, I discovered that it doesn't matter whether I'm working with an mdb or an accdb file, but whether they are located on a network share or my local drive. I'm guessing...

Great! Thanks, Paul

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

Never mind...... The table in question did not have a primary key specified, and without it the ADP/SQL server apparently can't figure out how to lock the records for write access. Thanks anyway. Mark

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