Senin, 07 November 2016

Re: [MS_AccessPros] Spacing for Query List

 

Hi John
 
That looks as if it might be where the issue lies - I will look into it and let you know
 
many thanks for that.
 
Another one for you whilst I have you if you don't mind.
 
I have a query which causes the message 'Access is not responding' - it is quite a complex query in that it has about 12 fields which use fairly involved dcounts.
 
Is it possible that a query simply becomes too 'big' to run? 
 
cheers
 
Phil


On Monday, 7 November 2016, 14:56, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Phil-

See if this solves your problem - solution is in Control Panel.



John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Nov 7, 2016, at 3:40 PM, Phil Knowles pdk444444@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Hi John
 
I have tried the 3 options on view by (ie details, icons or list) but on the computer that is double spaced it is set to list (which is the same as the setting on my system)
on mine the list is just as I would want it to be but on the other it is double spaced.
 
anything else to try?
 
Phil


On Monday, 7 November 2016, 14:29, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


Phil-

Right-click the top of the Navigation bar at the top of the list and choose View By.  Choose List to see them single-spaced and Details to see them "double spaced" with additional properties displayed.

John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals 
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
(Paris, France)




On Nov 7, 2016, at 2:49 PM, Phil Knowles pdk444444@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



Probably something really simple.
 
I use a database on 2 different computers and when I run it on my computer the list of queries is single spaced but when I use it on a different computer the list appears to be double spaced and scrolling up and down the list is a pain.
 
It is not just the queries but also the tables, forms, macros etc - they are all double spaced.
 
Both computers are using windows 10 and also office 10.
 
Must be a setting somewhere but I can't find it - any ideas?










__._,_.___

Posted by: Phil Knowles <pdk444444@yahoo.co.uk>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar