I still think saving it in the actual Access format would be cooler. And
there is no shame in having an external library, you know!
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>
wrote in message news:%dHTb.86074$IF6.2187474@ursa-nb00s0.nbnet.nb.ca...[color=blue]
> Steve I had a chance tonight to publish a more complete Relationship
> WIndow Layout tool. I was able to do add the functionality to copy the
> Relationship Window Layout from an external MDB as I finally took the
> time to decode the Layout BLOB. It was pretty straightforward. The BLOB
> structure is documented below.
>
http://www.lebans.com/saverelationshipview.htm
>
> NEW - Feb 04/2004
>
http://www.lebans.com/DownloadFiles/...-RelationshipW
> indowLayoutver6.zip is an MDB containing functions to:
>
> 1) To allow the saving of the layout of the Relationship window to a
> table.
> 2) To allow the restoration of the layout of the Relationship Window
> from a table.
> 3) To allow the saving/restoration of multiple Relationship Window
> views.
> 4) To allow the importing of the layout of the Relationship Window from
> an external MDB.
>
>
> Private Type RECTL
> Left As Long
> Top As Long
> Right As Long
> Bottom As Long
> End Type
>
>
> ' First 68 Bytes are the Header
> ' This is followed by (NumWindows + 1) * 284 bytes per record
> ' Last padding record seems to be padding
> Private Type RelBlob
> Sig As Long
> AAAs(1 To AAAlength) As Byte
> RelWinX1 As Long
> RelWinY1 As Long
> RelWinX2 As Long
> RelWinY2 As Long
> Blank As Long
> FFFs(1 To FFFlength) As Byte
> ClientRectX As Long
> ClientRectY As Long
> Pad(1 To Padding) As Byte
> NumWindows As Long
> End Type
>
> Private Type RelWindow
> RelWinX1 As Long
> RelWinY1 As Long
> RelWinX2 As Long
> RelWinY2 As Long
> Junk As Long
> WinName As String * NameLengthMax
> Junk1 As Long
> WinNameMaster As String * NameLengthMax
> Junk2 As Long
> End Type
> --
>
> HTH
> Stephen Lebans
>
http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "Steve Jorgensen" <nospam@nospam.nospam> wrote in message
> news:lddb10l7e5g7kim71mt82lrllftsmeo3db@4ax.com...[color=green]
> > On Mon, 26 Jan 2004 15:42:47 -0800, "Michael \(michka\) Kaplan [MS]"
> > <michkap@online.microsoft.com> wrote:
> >[color=darkred]
> > >"Stephen Lebans"[/color][/color]
> <ForEmailGotoMy.WebSite.-WWWdotlebansdotcom@linvalid.com>[color=green][color=darkred]
> > >wrote in message[/color][/color]
> news:AAWQb.73411$IF6.1865635@ursa-nb00s0.nbnet.nb.ca...[color=green][color=darkred]
> > >> Just as an add-in to this thread there is a utility on my site that
> > >> allows you to save/restore multiple views of the Relationship[/color][/color]
> window.[color=green][color=darkred]
> > >>
http://www.lebans.com/saverelationshipview.htm
> > >> NEW - Jan 21/2004 A2KSave-RestoreRelationshipWindow.zip is an MDB
> > >> containing functions to Save and Restore the Relationships View[/color][/color]
> Window.[color=green][color=darkred]
> > >> Allows an unlimited number of different Relationship Window Views[/color][/color]
> to be[color=green][color=darkred]
> > >> saved.
> > >>
> > >> Here is the Access97 version:A97Save-RestoreRelationshipWindow.zip
> > >>
> > >
> > >Very clever! Though you could have saved a bunch of time using the[/color][/color]
> built in[color=green][color=darkred]
> > >Access methods for storing different views by using the SysRel[/color][/color]
> utility I[color=green][color=darkred]
> > >wrote. :-)[/color]
> >
> > Perhaps, I'm not understanding correctly, but I thought the SysRel[/color]
> utility[color=green]
> > saved an internal Blob that represents the relationships. Is there[/color]
> any way to[color=green]
> > know it's safe to restore those after changes have been made to the[/color]
> tables and[color=green]
> > relationships since the time the Blob was saved? That had been my[/color]
> concern.
>[/color]
