Doyle Hebert
Doyle.Hebert at PREMERA.com
Tue Sep 2 16:52:16 CDT 2003
-----Original Message----- From: accessd-request at databaseadvisors.com [mailto:accessd-request at databaseadvisors.com] Sent: Tuesday, September 02, 2003 10:00 AM To: accessd at databaseadvisors.com Subject: AccessD Digest, Vol 7, Issue 2 Send AccessD mailing list submissions to accessd at databaseadvisors.com To subscribe or unsubscribe via the World Wide Web, visit http://databaseadvisors.com/mailman/listinfo/accessd or, via email, send a message with subject or body 'help' to accessd-request at databaseadvisors.com You can reach the person managing the list at accessd-owner at databaseadvisors.com When replying, please edit your Subject line so it is more specific than "Re: Contents of AccessD digest..." Today's Topics: 1. Re: OT: My Retirement (Darren DICK) 2. Sending emails from within ACC02 (David Fenton) 3. Sending emails from within ACC02 - Answer (David Fenton) 4. Re: Sidebar navigation (Kath Pelletti) 5. Cool little app (John Colby) 6. RE: [dba-VB] [AccessD] Cool little app (John Colby) 7. Re: Sending emails from within ACC02 - Answer (MartyConnelly) 8. Pictures from the last DBA conference (Jim Lawrence (AccessD)) 9. RE: PDF through code - Follow up to Arthur's and Charlotte's pastpostings (Arthur Fuller) 10. RE: OT: DUAL BOOT XP PRO AND WIN2K SERVER (Arthur Fuller) 11. RE: Pictures from the last DBA conference (John Colby) 12. Re: Pictures from the last DBA conference (Lembit Soobik) 13. Crystal Reports Password (Paula Wright) 14. RE: Creating PDFs (Charlotte Foust) 15. RE: SHIFT + F9 (Charlotte Foust) 16. AW: [AccessD] Sidebar navigation (Garraway, Alun) 17. relationship documenter (John Colby) ---------------------------------------------------------------------- Message: 1 Date: Tue, 2 Sep 2003 09:31:32 +1000 From: "Darren DICK" <d.dick at uws.edu.au> Subject: Re: [AccessD] OT: My Retirement To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <013101c370e1$2dbd0260$3c619a89 at DDICK> Content-Type: text/plain; charset="iso-8859-1" NO ARCHIVE Congratulations Charles. What an awesome felling. My very best wishes to you and your family for excellent health and an abundance of good times. You'll be missed for your humour and skills from the greatest of lurkers - BTW feel free to lurk Darren ------------------------------ Message: 2 Date: Tue, 2 Sep 2003 09:43:54 +1000 From: "David Fenton" <dfe at nudgeeinternational.com> Subject: [AccessD] Sending emails from within ACC02 To: <accessd at databaseadvisors.com> Message-ID: <A3218B71657C264E8EAE5A90040B351103CBD6 at phoenix.student.nudgeeinternational. com> Content-Type: text/plain; charset="iso-8859-1" Just wondering why I would use the following code http://p2p.wrox.com/archive/vba_access/2002-04/1.asp ...instead of what I'm using successfully right now (in a loop) DoCmd.SendObject acSendNoObject, "", "", strEmail, , , strSubject, strMsg, False Both seem to do the job, but my way is only one line of code, the other requires an entire module to be set up. Am I missing something? Or has Access improved to the point that the automation code shown on the above website is simple legacy now? However I do need a hand to switch the warning message off. The message says "A program is trying to send email on your behalf... etc etc" The usual DoCmd.Setwarning does not stop it from appearing Cheers David Ô¿Ô¬ Ext 0751 ------------------------------ Message: 3 Date: Tue, 2 Sep 2003 09:48:05 +1000 From: "David Fenton" <dfe at nudgeeinternational.com> Subject: [AccessD] Sending emails from within ACC02 - Answer To: <accessd at databaseadvisors.com> Message-ID: <A3218B71657C264E8EAE5A90040B35111A4005 at phoenix.student.nudgeeinternational. com> Content-Type: text/plain; charset="iso-8859-1" Sorry folks, Just found a site that answers my own question http://www.granite.ab.ca/access/sendobject.htm Cheers, David Brisbane Australia Just wondering why I would use the following code http://p2p.wrox.com/archive/vba_access/2002-04/1.asp ...instead of what I'm using successfully right now (in a loop) DoCmd.SendObject acSendNoObject, "", "", strEmail, , , strSubject, strMsg, False Both seem to do the job, but my way is only one line of code, the other requires an entire module to be set up. Am I missing something? Or has Access improved to the point that the automation code shown on the above website is simple legacy now? However I do need a hand to switch the warning message off. The message says "A program is trying to send email on your behalf... etc etc" The usual DoCmd.Setwarning does not stop it from appearing Cheers David Ô¿Ô¬ Ext 0751 ------------------------------ Message: 4 Date: Tue, 2 Sep 2003 11:16:06 +1000 From: "Kath Pelletti" <sdssoftware at optusnet.com.au> Subject: Re: [AccessD] Sidebar navigation To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <007201c370ef$cf8684a0$6501a8c0 at user> Content-Type: text/plain; charset="iso-8859-1" Hi Joshua - I have done something along those lines - not quite like Outlook, but the idea may be of some help if you have to go that way. I had to create a form which allows users of different departments to see a 'process'. I created a form with a subform - the subform (tall and narrow - about 2.5 cm wide x length of screen ) remained always visible on the left hand side of the screen while the contents on the right changed. Eg. The narrow form on the left displayed the names of the 10 departments in the organisation. By default it displayed 'Sales' and subforms 1 and 2 were loaded and made visible on the right. But users could select 'All' and see the entire process which involved 32 (!) subforms of content on the right. But by selecting their department name on the subform the main form then only displayed the appropriate subforms for their department. It was a bit more complicated than that, but the general idea is that to have a form sitting on the side of a main form the properties you need on the subform are: Popup: Yes Modal: No Border style: None Autoresize: No Autocenter = No The main form has an on open event with the code: DoCmd.OpenForm "Frmnpdpopup", acNormal, , , , acNormal This was a while ago but I remember that to get the subform to sit exactly where you want you need to: - set the border style of the subform to sizable (so that you can resize the form) - open the form in form view, and restore the window so that the form is shown in the same size as it would appear on the subform - Size the form and place it exactly where you want it (remember that it has autoresize=No and Autocenter = no) - Save the form (Just do a Ctrl+S even though you're in form view - it works). Not that the form size / position is locked in, then go back to design view and change the border style back to None. Save / close. To allow the subform to act as a 'toolbar' in my case I did the following: - Place all my 32 subforms onto the main form. - Removed the source object from each, so they are unbound. - Add a list box of options to the subform on the left. - The listbox on the subform has an 'on click' event which makes the appropriate subforms on the right visible / not visible, and loads their source object (if not loaded already - I had a routine which checked that). - If you need to position multiple forms like I did, then you can do that by using their 'top' to put them in the right place. If you can avoid going down this route then I would - incredibly time consuming for me. But if there is a strong requirement from the client then it can work very well. I had to make sure that I would be paid for all the mucking around it took and in the end the result was very slick and the client was extremely happy. I can send you some screen prints if it helps. Good luck - Kath ----- Original Message ----- From: "Joshua B" <lists at jbsolutions.com.au> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, September 01, 2003 12:53 PM Subject: [AccessD] Sidebar navigation > Hi Group, > > A client of mine has requested that instead of having a "switchboard/main menu" type setup for navigation within their app, they would prefer to have a sidebar menu ala Access & Outlook. Has anyone had any luck designing this sort of interface within Access? My initial thoughts are to have a popup form and control it's size to take up a portion of the left hand side of the screen, however this means I would no longer be able to maximise other forms. Any ideas would be greatly appreciated. > > Best regards. > Joshua B > lists at jbsolutions.com.au > www.jbsolutions.com.au > 2003-09-01 > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > ------------------------------ Message: 5 Date: Mon, 1 Sep 2003 21:58:55 -0400 From: "John Colby" <jcolby at colbyconsulting.com> Subject: [AccessD] Cool little app To: "VBA" <dba-vb at databaseadvisors.com>, "AccessD" <AccessD at databaseadvisors.com> Message-ID: <DCEFJAOENMNENLAAOFGPIEGGEOAA.jcolby at colbyconsulting.com> Content-Type: text/plain; charset="iso-8859-1" For anyone interested, an article I stumbled across that demonstrates using .net to lookup ip addresses. http://msdn.microsoft.com/msdnmag/issues/02/04/Virus/default.aspx I cut and pasted the two classes and built a form to use the MyWhois to lookup an ip address. For whatever reason I am only able to lookup IP addresses (passing in a True as the last value), I'll be looking at this more closely later. I'd love to get the lookup working on my web page - anyone who wants to help me in that regard give me a shout offline. With all the discussion on Security going around the group lately those interested parties might want to read this article. It discusses the IIS logs which show hack attempts. John W. Colby www.colbyconsulting.com ------------------------------ Message: 6 Date: Mon, 1 Sep 2003 22:36:09 -0400 From: "John Colby" <jcolby at colbyconsulting.com> Subject: RE: [dba-VB] [AccessD] Cool little app To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>, <dba-vb at databaseadvisors.com> Message-ID: <DCEFJAOENMNENLAAOFGPCEGIEOAA.jcolby at colbyconsulting.com> Content-Type: text/plain; charset="iso-8859-1" Well, I got both the Whois and the IP lookup working. Nice little tool. The article discusses turning it into a dll (for use in a web page) but apparently my vb.net compiler isn't in my path because I get a "not found" when I try to do the compile. sigh John W. Colby www.colbyconsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of John Colby Sent: Monday, September 01, 2003 9:59 PM To: VBA; AccessD Subject: [dba-VB] [AccessD] Cool little app For anyone interested, an article I stumbled across that demonstrates using .net to lookup ip addresses. http://msdn.microsoft.com/msdnmag/issues/02/04/Virus/default.aspx I cut and pasted the two classes and built a form to use the MyWhois to lookup an ip address. For whatever reason I am only able to lookup IP addresses (passing in a True as the last value), I'll be looking at this more closely later. I'd love to get the lookup working on my web page - anyone who wants to help me in that regard give me a shout offline. With all the discussion on Security going around the group lately those interested parties might want to read this article. It discusses the IIS logs which show hack attempts. John W. Colby www.colbyconsulting.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com ------------------------------ Message: 7 Date: Mon, 01 Sep 2003 20:49:08 -0700 From: MartyConnelly <martyconnelly at shaw.ca> Subject: Re: [AccessD] Sending emails from within ACC02 - Answer To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Message-ID: <3F541334.6050707 at shaw.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed To get rid of the security warning message One way is to use the redemption dll http://www.dimastr.com/redemption/ David Fenton wrote: >Sorry folks, >Just found a site that answers my own question >http://www.granite.ab.ca/access/sendobject.htm >Cheers, >David >Brisbane >Australia > > >Just wondering why I would use the following code >http://p2p.wrox.com/archive/vba_access/2002-04/1.asp > >...instead of what I'm using successfully right now (in a loop) >DoCmd.SendObject acSendNoObject, "", "", strEmail, , , strSubject, strMsg, False > >Both seem to do the job, but my way is only one line of code, the other requires an entire module to be set up. > >Am I missing something? Or has Access improved to the point that the automation code shown on the above website is simple legacy now? > >However I do need a hand to switch the warning message off. The message says "A program is trying to send email on your behalf... etc etc" > >The usual DoCmd.Setwarning does not stop it from appearing > >Cheers >David Ô¿Ô¬ >Ext 0751 > > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > > ------------------------------ Message: 8 Date: Mon, 01 Sep 2003 22:50:33 -0700 From: "Jim Lawrence (AccessD)" <accessd at shaw.ca> Subject: [AccessD] Pictures from the last DBA conference To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Message-ID: <NHBBIIELMLKIEHOOHNNFOENFCMAA.accessd at shaw.ca> Content-Type: text/plain; charset=iso-8859-1 Hi All: The pictures from the last DBA conference, in Germany, have just loaded to the DBA web site (www.databaseadvisors.com) ...check it out...it can be accessed through the main page. Jim ------------------------------ Message: 9 Date: Tue, 2 Sep 2003 08:31:41 -0700 From: "Arthur Fuller" <artful at rogers.com> Subject: RE: [AccessD] PDF through code - Follow up to Arthur's and Charlotte's pastpostings To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <HMEMJOMMIJPPGDIHAFABEECMCPAA.artful at rogers.com> Content-Type: text/plain; charset="windows-1252" MessageI can't quite remember, but I think the standard version was about $75 and the Pro version upgrade an additional hundred. I haven't regretted one penny of it. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Skolits Sent: Thursday, August 28, 2003 1:01 PM To: accessd at databaseadvisors.com Subject: [AccessD] PDF through code - Follow up to Arthur's and Charlotte's pastpostings Hey Arthur and Charlotte: Regarding the below postings. What did you pay for you PDF converter? Was it a plug-in or some API calls? Did you buy the developer's kit, and finally how did you handle licensing costs? Thanks John Skolits --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://databaseadvisors.com/pipermail/accessd/attachments/20030902/4ca7482c/ attachment-0001.html ------------------------------ Message: 10 Date: Tue, 2 Sep 2003 08:31:46 -0700 From: "Arthur Fuller" <artful at rogers.com> Subject: RE: [AccessD] OT: DUAL BOOT XP PRO AND WIN2K SERVER To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <HMEMJOMMIJPPGDIHAFABGECMCPAA.artful at rogers.com> Content-Type: text/plain; charset="Windows-1252" You should probably install SQL Server Developer on the XP Pro boot and SQL Enterprise on the 2K Server boot. Get the best of both worlds. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Sunday, August 31, 2003 12:53 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] OT: DUAL BOOT XP PRO AND WIN2K SERVER On 30 Aug 2003 at 23:22, Joe Hecht wrote: > Microsoft tool says my system can do it. > > Can any one tell me how? > > Running XPPro but want to add sql server. > > I have the action pack and therefore have my choice of sql. I think I want > to run sql developer. Right? > Windows XP is an operating system SQL Server 2000 is an application. You don't boot an application , only an OS. Just install SQL Server 2000 on your XP machine. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003 ------------------------------ Message: 11 Date: Tue, 2 Sep 2003 09:26:15 -0400 From: "John Colby" <jcolby at colbyconsulting.com> Subject: RE: [AccessD] Pictures from the last DBA conference To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <DCEFJAOENMNENLAAOFGPCEHFEOAA.jcolby at colbyconsulting.com> Content-Type: text/plain; charset="iso-8859-1" It looks like a very good time was had by all - judging by the "final toast" pictures. ;-) Good job to Lembit in hosting the conference. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Lawrence (AccessD) Sent: Tuesday, September 02, 2003 1:51 AM To: Access Developers discussion and problem solving Subject: [AccessD] Pictures from the last DBA conference Hi All: The pictures from the last DBA conference, in Germany, have just loaded to the DBA web site (www.databaseadvisors.com) ...check it out...it can be accessed through the main page. Jim _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ------------------------------ Message: 12 Date: Tue, 2 Sep 2003 15:57:40 +0200 From: Lembit.Soobik at t-online.de (Lembit Soobik) Subject: Re: [AccessD] Pictures from the last DBA conference To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <01e001c3715b$a57114c0$0200a8c0 at S856> Content-Type: text/plain; charset="iso-8859-1" thank you, John :) Lembit Soobik ----- Original Message ----- From: "John Colby" <jcolby at colbyconsulting.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Tuesday, September 02, 2003 3:26 PM Subject: RE: [AccessD] Pictures from the last DBA conference > It looks like a very good time was had by all - judging by the "final toast" > pictures. ;-) > > Good job to Lembit in hosting the conference. > > John W. Colby > www.colbyconsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Lawrence > (AccessD) > Sent: Tuesday, September 02, 2003 1:51 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] Pictures from the last DBA conference > > > Hi All: > > The pictures from the last DBA conference, in Germany, have just loaded to > the DBA web site (www.databaseadvisors.com) ...check it out...it can be > accessed through the main page. > > Jim > > _______________________________________________ > 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 > ------------------------------ Message: 13 Date: Tue, 2 Sep 2003 10:39:05 -0400 From: "Paula Wright" <paulawright at boddienoell.com> Subject: [AccessD] Crystal Reports Password To: <accessD at databaseadvisors.com> Message-ID: <DB08A21F71F47A4093381FFEABDB46DC74AC1F at exchange2000.boddienoell.com> Content-Type: text/plain; charset="us-ascii" Skipped content of type multipart/alternative-------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/gif Size: 145 bytes Desc: Blank Bkgrd.gif Url : http://databaseadvisors.com/pipermail/accessd/attachments/20030902/8306af56/ attachment-0001.gif ------------------------------ Message: 14 Date: Tue, 2 Sep 2003 09:19:17 -0700 From: "Charlotte Foust" <cfoust at infostatsystems.com> Subject: RE: [AccessD] Creating PDFs To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <E61FC1D4B1918244905B113C680BEA86312297 at infoserver01.infostat.local> Content-Type: text/plain; charset="us-ascii" We pass the desired filename in the OpenArgs of Access 2002 reports. Then we use that filename when we output to PDF format. Charlotte Foust -----Original Message----- From: Selina Iddon [mailto:selina at easydatabases.com.au] Sent: Sunday, August 31, 2003 6:32 PM To: Access Developers discussion and problem solving Subject: [AccessD] Creating PDFs Hi Everyone Has anyone had success with printing to a PDF, assigning it the desired file name? My client is using Adobe, but will change if required. TIA Selina _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ------------------------------ Message: 15 Date: Tue, 2 Sep 2003 09:21:15 -0700 From: "Charlotte Foust" <cfoust at infostatsystems.com> Subject: RE: [AccessD] SHIFT + F9 To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <E61FC1D4B1918244905B113C680BEA86312298 at infoserver01.infostat.local> Content-Type: text/plain; charset="us-ascii" The problem with using the DoMenuItem syntax is that it is difficult, if not impossible, to remember later what exactly it is doing! The RunCommand syntax is at least self-documenting to an extent. Charlotte Foust -----Original Message----- From: Kostas Konstantinidis [mailto:kost36 at otenet.gr] Sent: Saturday, August 30, 2003 4:50 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SHIFT + F9 Hi Gustav, what I want is to refresh an ole object into a form. I tried all the methods I know but none of them seems to be able to update the object. So I put the DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 I don;t know if that is the right method but... it works perfect Thank's for your responce Kostas ----- Original Message ----- From: "Gustav Brock" <gustav at cactus.dk> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Saturday, August 30, 2003 3:30 PM Subject: Re: [AccessD] SHIFT + F9 > Hi Kostas > > How about: > > Me.Requery > > /gustav > > > Could anybody help me in how to set the SHIFT + F9 in code > > _______________________________________________ > 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 ------------------------------ Message: 16 Date: Tue, 2 Sep 2003 18:39:38 +0200 From: "Garraway, Alun" <Alun.Garraway at otto.de> Subject: AW: [AccessD] Sidebar navigation To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Message-ID: <D096EDDAA3939B45BEAF0F506801709A08058A at ntovmail03.ov.otto.de> Content-Type: text/plain; charset="iso-8859-1" hi Joshua, you could try using the following DoCmd.SelectObject acForm, "YOUR_FORM", False DoCmd.MoveSize 0, 0, 11907, 1531 I use this in a couple of apps where I have a "selection" form and all other forms are displayed below this one. the form above is in the top left, 11907 twips wide and 1531 high. I place all the other forms with DoCmd.MoveSize 0, 1531, 11907, 6237 as you can see all other forms start at the top where the "selection" form stops. (1531 twips) HTH alun -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Joshua B Gesendet: Montag, 1. September 2003 04:53 An: Access Developers discussion and problem solving Betreff: [AccessD] Sidebar navigation Hi Group, A client of mine has requested that instead of having a "switchboard/main menu" type setup for navigation within their app, they would prefer to have a sidebar menu ala Access & Outlook. Has anyone had any luck designing this sort of interface within Access? My initial thoughts are to have a popup form and control it's size to take up a portion of the left hand side of the screen, however this means I would no longer be able to maximise other forms. Any ideas would be greatly appreciated. Best regards. Joshua B lists at jbsolutions.com.au www.jbsolutions.com.au 2003-09-01 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ------------------------------ Message: 17 Date: Tue, 2 Sep 2003 12:46:38 -0400 From: "John Colby" <jcolby at colbyconsulting.com> Subject: [AccessD] relationship documenter To: "AccessD" <AccessD at databaseadvisors.com> Message-ID: <DCEFJAOENMNENLAAOFGPAEHKEOAA.jcolby at colbyconsulting.com> Content-Type: text/plain; charset="iso-8859-1" Has anyone ever seen / designed a documenter for relationships where the relationships are NOT specified in the database window? I am going through a fairly complex "relational" database where there were no relationships established, defining the relationships. In order to do that I am looking at all form's combos to determine the column(0) field and the field in the forms query that it is bound to. I also examine the link child / master properties of all subforms on all forms. Using this strategy I determine the fields in all tables that have manual data input methods. As I discover each "relationship" I create a relationship in the relationship window of the FE. This allows me to at least see the structure of the database as envisioned by the original designer. It seems like a process that could be automated but I have never done so. Has anyone else ever seen a tool that does this? John W. Colby www.colbyconsulting.com ------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd End of AccessD Digest, Vol 7, Issue 2 *************************************