[AccessD] Access 2007 Ribbon Bar and accdb format

Marty
 
check out this guy as well. Hes been doing some great stuff with Ribbons. Been teaching me how they work. He seems to be way ahead of the field and will have a beta customisation tool ready soon. I have been helping him test it.
 
http://pschmid.net/
 
I have to write a chapter on Ribbons and I havnt a clue to be honest. But will get there,
 
Martin
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of MartyConnelly
Sent: Thu 13/07/2006 21:29
To: Access Developers discussion and problem solving
Subject: [AccessD] Access 2007 Ribbon Bar and accdb format



Here is a sample 2007 accdb and method to program with VBA the
ribbon bar via xml inserted in a table. More convoluted
than command bars but at least everything is one place.

http://blogs.msdn.com/access/archive/2006/07/13/664757.aspx

By the way I had trouble converting an accdb back to 2000 format
You try to do a straight conversion and it squawks about
multi valued  fields or something and says can't do it.
I couldn't find the error or what it was complaining about.

Here is a way around it
Not too difficult to convert back from Access 2007
 just create a blank 2003 mdb and right click on the objects
and export them to the new blank mdb.
Selecting the database option.
You also have to recreate the table relationships structure.

To do multiple exports for tables or forms  via vba
use some variation of this

Sub testexport()
Dim cdb As Database 'Database to import
Dim td As TableDef 'Tabledefs in db
Dim strTDef As String 'Name of table or query to import
Set cdb = CurrentDb
'EXPORT tables from specified Access database
'keep opening through security squawk for each table
For Each td In cdb.TableDefs
strTDef = td.Name
Debug.Print strTDef
If Left(strTDef, 4) <> "MSys" Then
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"C:\Access files\2007test\rebuild\crm2000.mdb", _
acTable, strTDef, strTDef, False
End If
Next
End Sub

--
Marty Connelly
Victoria, B.C.
Canada

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>