Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-17-2019, 11:53 AM   #1
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Relationship window behaviour 2010 and newer

Hello to the forum:
Currently using 2010 and have the (apparently) well known issue of the relationship window clipping the top section and so making many tables inaccessible.

Does any user of a more modern version experience this issue ?

If this is stable and reliable in newer versions I will upgrade ....
I have been told (in answer to previous posts) that this is a low priority issue for many but I used to find this relationship window very helpful ..

Pavl is offline   Reply With Quote
Old 06-17-2019, 11:57 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,601
Thanks: 56
Thanked 1,233 Times in 1,214 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Relationship window behaviour 2010 and newer

Hi. I use several versions of Access prior to, later than, and including 2010, but I never experienced the issue you're referring to. If this is a common problem, I guess I'm just lucky and never seen it yet.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-17-2019, 12:26 PM   #3
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,043
Thanks: 10
Thanked 207 Times in 196 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Relationship window behaviour 2010 and newer

never happened to me either. If you're saying there is no scrollbar or moving it isn't exposing the entire view, there is an accepted answer here
https://social.msdn.microsoft.com/Fo...orum=accessdev

it just doesn't say exactly what the rebuild process is

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is offline   Reply With Quote
Old 06-17-2019, 01:02 PM   #4
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,893
Thanks: 114
Thanked 2,979 Times in 2,710 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Relationship window behaviour 2010 and newer

I've also never seen this behaviour.
Can you post a screenshot showing the issue or, better still, post a version of your database with this occurring
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 06-17-2019, 01:05 PM   #5
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Re: Relationship window behaviour 2010 and newer

Thank you "theDBguy" and "Micron".
I have checked(used search) through posts and it seem there are others with this problem and replies from a number of people stating the best method to be "wipe and start again".
Some have suggested/guessed that the window could be corrupted in some way if modifications are made while something else is in design view.
And ... just had a reply from "the other place" from "Daniel Pineault" saying that he has same issues up to 2013 .....
I did try using the Lebans thing (October 2017) but could not get it to work .... even with help from "the other place"
But thanks anyway ... looks like an upgrade is not going to help.
Pavl is offline   Reply With Quote
Old 06-17-2019, 01:14 PM   #6
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,893
Thanks: 114
Thanked 2,979 Times in 2,710 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Relationship window behaviour 2010 and newer

The other place is called UtterAccess.
If you crosspost, it is standard etiquette to say you have done so and provide a link to that thread
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 06-17-2019, 01:22 PM   #7
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Re: Relationship window behaviour 2010 and newer

Thank you "isladogs"
Image attached from yesterdays version.
Did not know about the cross posting reference ...
Current copy has window wiped and about to be rebuilt.

i have just opened the Lebans version for scrolling instead of restoring and will try that ... but might well be beyond my capabilities ...
Will report results.
Paul
Attached Images
File Type: jpg 2010_rels_window.jpg (104.7 KB, 15 views)

Pavl is offline   Reply With Quote
Old 06-17-2019, 01:24 PM   #8
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Re: Relationship window behaviour 2010 and newer

In reply to "Micron" ... that answer (wipe and rebuild) is the one suggested by most and the one I have used ... to date.
Pavl is offline   Reply With Quote
Old 06-17-2019, 01:28 PM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,893
Thanks: 114
Thanked 2,979 Times in 2,710 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Relationship window behaviour 2010 and newer

This is the UA thread - https://www.utteraccess.com/forum/in...ic=2054140&hl=

This is the standard guidance for cross posters https://www.excelguru.ca/content.php?184

Regarding your screenshot, you are using tabbed documents display.
Try changing to overlapping windows & maximise the window. Then drag the topmost tables down and rearrange the other tables positions

Also look at Allen Browne's relationships report: http://allenbrowne.com/AppRelReport.html
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 06-17-2019, 10:37 PM   #10
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Re: Relationship window behaviour 2010 and newer

Thank you "isladogs".
Changed to overlapping but same result.
And have looked at the Allen Browne link and that 'seems' to display additional information based on a correctly functioning relationship display ...
And note that "Stephen Lebans" is mentioned again .... will try both versions of his utilities again ... but I am a part-time amateur ... so will take time.
Pavl is offline   Reply With Quote
Old 06-18-2019, 05:47 AM   #11
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,043
Thanks: 10
Thanked 207 Times in 196 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: Relationship window behaviour 2010 and newer

Did you try clearing the layout? Or is that what the utility does? Or can you post a db copy here?
Micron is offline   Reply With Quote
Old 06-18-2019, 09:29 AM   #12
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Re: Relationship window behaviour 2010 and newer

Micron ....
Have been doing the "wipe/rebuild" method for a couple of years now ... and have got used to ignoring the relationship window.
The window can be cleared in two ways ... one is just use the ribbon command and the whole lot goes ... or the other is to click on any table field that is visible and then hands off the mouse ... using tab you can now sequence (don't know what sort that is) through each table that is invisible and then just delete those.
I keep printed copies now .... so the rebuild is a good time for a layout review !
Anyway ... my time on this is limited so will just crash on for the time being. Thanks for comments.
Over and out.
Paul
Pavl is offline   Reply With Quote
Old 06-19-2019, 11:20 AM   #13
Pavl
Newly Registered User
 
Join Date: Jan 2013
Posts: 56
Thanks: 6
Thanked 0 Times in 0 Posts
Pavl is on a distinguished road
Re: Relationship window behaviour 2010 and newer

Update and progress.

Courtesy of a lot of help from "Daniel Pinnault" on "UtterAccess" and the correct way to use the "Lebans" tools ... Relationship window now accessible via the Lebans "Relationship Views Add Modify" and associated table [tblRelationshipViews].
By saving the 'wrong' relationship layout from the window where I cannot see the top section .... then looking for negative values for X/Y coordinates in [tblRealtionshipViews].
Changing those to reasonable large positive values (by simply looking at the range of values for tables that are actually in view) ...
Then use the Lebans [frmRealtionshipViewsAdd-Modify] to restore the initial saved 'wrong' version (which now uses the positive values from the table.

Thought I would go through all that in print just in case someone else comes across the same problem.

Thanks for help from this forum - over and out.
Paul
Pavl is offline   Reply With Quote
Old 06-19-2019, 11:49 AM   #14
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,147
Thanks: 3
Thanked 467 Times in 460 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: Relationship window behaviour 2010 and newer

Coming late to the party. However, I've also had at times partly obscured tables. My way to fix the problem is to hide, then show the table via the buttons in the ribbon.

Cronk is offline   Reply With Quote
Reply

Tags
relationship window

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange behaviour - hands free switched between vba window and access window lost vba sxschech Modules & VBA 9 08-22-2019 12:47 PM
can't understand access behaviour with relationship creation merlin777 General 34 11-21-2016 03:31 PM
Access 2010 Default Macro Behaviour mafhobb Macros 3 04-18-2011 06:59 PM
Relationship window and relationships Keith Nichols Theory and practice of database design 7 07-18-2006 04:05 AM
relationship window damsel General 10 07-17-2002 03:18 AM




All times are GMT -8. The time now is 07:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World