[AccessD] New engagement; trying to avoid the "tip of the iceberg" consulting trap

Yes Susan, it worked fine saved as an MDB from AC2007. They utilized zero
2007 features as far as I can see.

Interestingly, in this project, there is a good reason to use compiler
directives to handle things like turning off the ribbon which only works in
2007. In that regard, I change one line of code, and the code will be
interpreted under 2007.
' place this at the top of a module
#Const VERSION = 2003

#If VERSION = 2007 Then
  ' add code to remove ribbon here
#End If

Problem is: I don't think there's a way in VBA to remove the ribbon, is
there ?
I saw the manual method...ughh...it's a cludge...creating a blank ribbon.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Susan Harkins
> Sent: Tuesday, November 09, 2010 11:59 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] New engagement; trying to avoid the
> "tip of the iceberg" consulting trap
>
> You will lose any accdb functionality, but it's where I would
> start, cause if it works -- YEAH!!!!!!!
>
> Susan H.
>
>
> > Maybe I'm missing something, but there is an option to Save
> As... Save
> > it as a 2003 format.
> >
> > Yes, but it's already in 2007 ACCDB format.
> > Only way to go BACK is export everything, and import in
> 2003, right ?
> >
> > There's no downsize wizard ;)
> >
> >>>
> >> Or just leave it in 2003 format?  I do this for a couple clients.
> >> They don't know the difference - it's transparent.
> >> And I turn off the ribbon so the ribbon doesn't screw up
> my forms by
> >> stealing that real estate.
> >>
> >> Rocky
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>