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

David McAfee davidmcafee at gmail.com
Tue Nov 9 15:56:51 CST 2010


This is what I do on my main form Open

If (SysCmd(acSysCmdAccessVer) = 12 Or SysCmd(acSysCmdAccessVer) = 14)
Then DoCmd.ShowToolbar "Ribbon", acToolbarNo

and then the opposite when closed.


On Tue, Nov 9, 2010 at 1:00 PM, Mark Simms <marksimms at verizon.net> wrote:
> 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
>>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list