[AccessD] RE: AccessD Digest, Vol 7, Issue 2

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
*************************************



More information about the AccessD mailing list