Selasa, 26 Agustus 2014

RE: [MS_AccessPros] widths and heights

 

Hi Crystal

 

I posted the code again – did you see it?   Even if my messages are going to spam, I don't understand why you and Stuart can't see them through the web interface.  It was message #8 in this thread.

 

I sent a test email directly to Stuart today and haven't had a reply, so it seems I am really in the dog box!  :-(

 

Cheers, G.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 26 August 2014 19:58
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights

 

 

... and other messages that went to spam?

 

thx ~ Crystal

 

On Tuesday, August 26, 2014 1:56 AM, Crystal <strive4peace2008@yahoo.com> wrote:

 

My spam box gets too many messages each day to go though them ... 

 

Jeff, perhaps you can post Graham's code since you have it?

 

thanks

 

Warm Regards,
Crystal

Remote Programming & Training -- connect to me, let's build it together

Through sharing, we will all get better
~  have an awesome day ~

 

On Monday, August 25, 2014 7:08 PM, "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Graham, I never saw the code either ... I'd like to though!

 

Warm Regards,
Crystal

Remote Programming & Training -- connect to me, let's build it together

Through sharing, we will all get better
~  have an awesome day ~

 

On Monday, August 25, 2014 4:07 PM, "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Jeff

It must be because of that particularly obscene phrase, "Private Declare Function"  :-)

Cheers,

Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 26 August 2014 09:24
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights

 

 

I didn't originally but I do have 3 from you and 1 from Stuart in my Spam folder.  They include the code you mentioned.  Not sure why they went to spam since the rest of the email from you two has been in my inbox.

 

Cheers,

 

Jeff

 

From: "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, August 25, 2014 2:16 PM
Subject: RE: [MS_AccessPros] widths and heights

 

 

I'm getting a bit paranoid now :-)

Did anyone else see the code I posted on this thread?

Did you look at the forum online, Stuart, or only in your email?  If you receive messages by email, have you checked your spam folder?

Cheers,

Graham

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 26 August 2014 07:47
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights

 

 

You're apparently right.  I'd love to see it.....

 

Stuart

 

On Saturday, August 23, 2014 8:09 PM, "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Crystal

 

I don't think Stuart is seeing any of my posts.  The only ones he replies to are ones that you have quoted :-/

 

I wonder if his email has blacklisted me as a spammer or something :-(

 

Anyway, could you please repost my message from a few days ago with the API code?  I spent a couple of hours on it so it would be a shame to see it wasted :-)

 

Cheers,

G

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, 24 August 2014 07:58
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights

 

 

Hi Stuart,

Allen Browne has a great reference page with code for reading and setting database properties.

http://www.allenbrowne.com/ser-69.html

 

 

 

 

 

 

How to ensure Access 2007 users cannot modify the database schema (field structure), forms and reports in databases created in previous versions.

Preview by Yahoo

 

 

hope this helps ~


Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

 

On Friday, August 22, 2014 7:49 PM, "Stuart Schulman stoughy@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

I am now hopelessly confused.  I don't see any code in any of the messages previously posted.

 

Stuart

 

On Friday, August 22, 2014 6:52 PM, "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Stuart,

 

the Database Analyzer for Microsoft Access picks up some of the properties -- you can run it and then check the a_DBs table, which has some of the CurrentDb and file properties.  Bill Mosca contributed code to this too.  The Design view of the a_DBs table tells the property name.  A lot of the information has been discovered by enumerating through properties.

 

Analyzer for Microsoft Access on CodePlex (open source)
http://analyzer.codeplex.com/

 

 

image

 

 

 

 

 

The Analyzer for Microsoft Access documents and analyzes what is in your Access databases. It is useful for anyone using or building Microsoft Access databases.

Preview by Yahoo

 

 

Warm Regards,
Crystal

Remote Programming & Training -- connect to me, let's build it together

Through sharing, we will all get better
~  have an awesome day ~

 

On Friday, August 22, 2014 3:40 PM, "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Stuart

Did you not see the code I posted for you?  It's message #8 in this thread.
https://groups.yahoo.com/neo/groups/MS_Access_Professionals/conversations/topics/108692

All the best,
Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, 23 August 2014 08:49
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights

 

 

Crystal, this works really well!   Only problem is, I am in a multi-user environment, and each user may have his/her own preference for where the form will be.

 

I also wonder if you could tell me where I could get documentation on currentDB properties.  Access help doesn't seem to know about them.

 

Thanks, Stuart

 

On Friday, August 22, 2014 3:35 PM, "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Stuart,

 

Graham had the same problems with the code to check Nav Pane stuff ... maybe the property names changed ... or maybe the property values are read when Access opens and they don't change.

 

Window location:

save where you want the window to be and how big you want it to be in the form DESIGN VIEW.  Set form property 'Close Button' to No.  Put a close button on your form that closes withOUTsaving.  Make sure you always save your changes in Design view before testing.

 

DoCmd.Close acform, me.name, acSaveNo 'closes the form code that code is behind without saving changes (data of course is saved).

 

> "by the width of the navigation pane"

 

yes, this is how Access works -- you are only setting where you want a window to be in the area to the right of the nav pane

 

Warm Regards,
Crystal

Remote Programming & Training -- connect to me, let's build it together

 

Visual Basic for Applications language reference for Office 2013
http://msdn.microsoft.com/en-us/library/office/gg264383%28v=office.15%29.aspx

 

 

 

 

 

 

Last modified: November 20, 2012 Applies to: Office 2013 | VBA Welcome to the Visual Basic for Applications (VBA) language reference for Office 2013.

Preview by Yahoo

 


Through sharing, we will all get better
~  have an awesome day ~

 

 

On Friday, August 22, 2014 9:12 AM, "Stuart Schulman stoughy@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Crystal, let me be more specific.  The routine you suggest for navpane width returns a number, but the results are puzzling.  The number, assuming it is supposed to be Twips, is much too small.   If I choose a navpane about 2 inches wide, it returns a number of about 250.  And it doesn't change if you resize the navpane.  You have to exit Access and come back in to see the size recalculated.

 

Perhaps I am on the wrong track.  What I am trying to do is open a moveable window in Access and have the program remember the location of the window so that the next time it is opened it opens in the same place. It seems that storing the location of the window by using the form's WindowLeft and WindowTop properties stores values that exclude the ribbon and the Navigation pane, while reopening the form with the stored values with MoveSize includes them.  So the form always reopens left of where I wanted it by the width of the navigation pane if the navigation pane is visible. Analogous problem for the ribbon.

 

By the way code that was recommended for ribbon height is

 

Application.CommandBars.Item("Ribbon").Height

 

but that doesn't seem to work well either. 

 

stuart

 

 

On Friday, August 22, 2014 9:59 AM, "Stuart Schulman stoughy@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

I think my reply got lost somewhere.  I have tried the NavPane properties, but they don't work for me. No matter what I do to the width of the pane, it always returns the same number, 209.  And it always says the pane is hidden even when it isn't.  Am I doing something wrong?

 

Stuart

 

On Thursday, August 21, 2014 10:12 PM, "Crystal strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Graham,

 

uh, you're welcome? that's too bad ... bug? bad documentation? ~ on a happy note, I added more to the Code Documenter and just uploaded a new version :)  Just ran it on the Analyzer ... now I'm running the web page report to post with the code :) ... well we'll see how fast it loads! (whether it will be one or more pages) I like using the jumps and the Back button and having everything all together but some people have asked for the code to be separated.

 

Warm Regards,
Crystal

 

Remote Programming & Training -- connect to me, let's build it together

 

 

Through sharing, we will all get better
~  have an awesome day ~

 

 

 

 

 

 

Download Crystal's Code Documenter Please send me your comments and ideas! This also documents MDB files. Watch for updates. Access 2007+ version Crystals_CodeDocumenter_120204_2p_BETA_ACCDE_TXT.zip

Preview by Yahoo

 

 

 

On Thursday, August 21, 2014 5:40 PM, "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Hi Crystal

Thank you!  I just learned about some more properties :-)

However … the results stay the same, whether I show/hide the nav pain, or change its width, or show/hide the search bar :-/

-- Graham

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, 22 August 2014 11:29
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] widths and heights

 

 

Sub NavPane()
   With CurrentDb
      Debug.Print "Show Navigation Pane Search Bar = "; .Properties("Show Navigation Pane Search Bar")
      Debug.Print "NavPane Closed: "; .Properties("NavPane Closed")
      Debug.Print "NavPane Width: "; .Properties("NavPane Width")
   End With
End Sub

 

someone else can jump in on the ribbon part of your question ...

 

Warm Regards,
Crystal

Remote Programming & Training -- connect to me, let's build it together

 


Through sharing, we will all get better
~  have an awesome day ~

 

 

 

 

 

 

Download Crystal's Code Documenter Please send me your comments and ideas! This also documents MDB files. Watch for updates. Access 2007+ version Crystals_CodeDocumenter_120204_2p_BETA_ACCDE_TXT.zip

Preview by Yahoo

 

 

 

On Thursday, August 21, 2014 1:11 PM, "Stuart Schulman stoughy@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

 

 

Is there any way (Access 2007) to determine the width of the navigation pane?  Or the height of the ribbon?

 

Thanks, Stuart

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

__._,_.___
Posted by: "Graham Mandeno" <graham@mandeno.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (26)

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)