DataBase - Setup Display properties in Windows XP

Asked By Jose Carlos
24-May-07 07:41 AM
In windows XP, how can I setup display properties, tab appearance and
windows and buttons change from windows classic style to Windows Xp style
over vba?



Thanks



JCP
XP
(1)
Microsoft Access
(1)
MVP
(1)
GetSystemMetrics
(1)
MCP
(1)
MSFTNGP
(1)
Y_FULL_SCREEN
(1)
X_FULL_SCREEN
(1)
  Arvin Meyer [MVP] replied...
25-May-07 11:19 PM
Those properties are on the Appearance tab of Display Properties in the
Control Panel. They are accessible via the Windows api, but the best website
has been sold. I suggest you try to find another website, or get Dan
Appleman's book on the Windows API:

http://www.amazon.com/Applemans-Visual-Basic-Programmers-Guide/dp/0672315904/ref=sr_1_1/102-2086513-7244956?ie=UTF8&s=books&qid=1180149381&sr=8-1

or:

http://tinyurl.com/24knc5
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
  Jose Carlos replied...
26-May-07 07:34 AM
Thanks for your help
I tried to open the hyper link but it goes to amazon book and I can not see
the code.
have chance to show me the code'

Thanks
  Arvin Meyer [MVP] replied...
30-May-07 09:28 AM
I can't find my copy of the book, but I couldn't post code from it anyway.
It is copyrighted. You might find something at his website:

http://www.desaware.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
  Stephen Lebans replied...
30-May-07 09:07 PM
Hi Arvin,
which VB website was sold?

A favourite VB API book of mine is available free online here:
http://vb.mvps.org/hardcore/


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
  Douglas J. Steele replied...
30-May-07 09:28 PM
He might be talking about www.allapi.net

According to http://www.mentalis.org/allapi.qpx, "The domain name of this
site has been sold in February 2007, and since then doesn't point to the
original contents anymore". However, the material's still available at
http://allapi.mentalis.org/

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
  Stephen Lebans replied...
30-May-07 11:00 PM
Thanks Doug.

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
  Arvin Meyer [MVP] replied...
31-May-07 10:35 AM
http://www.allapi.net/

Which IMO, was the best api website.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
  Arvin Meyer [MVP] replied...
31-May-07 10:38 AM
I was.


That's great. Thanks,
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
  Jose Carlos replied...
01-Jun-07 09:37 AM
I din't find code where i can change the properties.

Somebody else can indicate?
thanks
  Arvin Meyer [MVP] replied...
01-Jun-07 10:54 AM
The only code I have is for the screen resolution:

Option Compare Database
Option Explicit

Declare Function GetSystemMetrics Lib "User32" (ByVal nIndex As Long) As
Long

Public Sub GetScreenRez()

Const X_FULL_SCREEN = 16
Const Y_FULL_SCREEN = 17

Dim lngX As Long
Dim lngY As Long

lngX = GetSystemMetrics(X_FULL_SCREEN)
lngY = GetSystemMetrics(Y_FULL_SCREEN)

Debug.Print "Screen Resolution = " & lngX & " x " & lngY

End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
  Jose Carlos replied...
01-Jun-07 02:26 PM
Thanks Arvin,
For resolution I also have.
Create New Account
help
Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for and small businesses. I do not know if I could sell clients on hosted Sharepoint / Access. I have been able to sell clients on hosted Exchange, and it is been very W. Fenton http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1
Access 2010 for software development DataBase Hi, What do I need to use Access 2010 (or perhaps 2007) to port our 2003 application and create an executable (MDE in Access 2003)? Are there any issues with 2010? -paulw Access Discussions SQL Server (1) SharePoint (1) Albert D. Kallal (1) Office 2007 (1) Office 2003 1) Access 2007 (1) Access 2010 (1) Access 2003 (1) You can use Access 2010 to develop your MDB until it is ready to release, but you will then
Access 2010 with Sharepoint 2010 DataBase I found this article http: / / sharepointproconnections.com / Articles / tabid / 149 to me was these two points: client." Hopefully this means you can test out the Access 2010 in a browser capabilities. 2.0 AA compliance. Level 1 browsers, which support 100 on other platforms. Level 2 browsers will have some limitations in rendering and behavior." Bob Access Discussions SQL Server (1) MySQL (1) Visual Basic for Applications (1) SharePoint (1) Access 2007 (1) Access 2010 (1) Office 2003 (1) Windows 7 (1) Well, the question is do you really If you are writing your software to mySQL, but that web server is only running Microsoft's SQL server, then again you are out of luck. (you will either have to is quite a few choices, but two common ones are Apache, and another one is Microsoft's Internet services. I could type on for a bit more here, but I think now we build applications to the office standard (that might use outlook, excel, and MS access on the desktop), in the future we build applications that does all the similar functions
seconds to load. There is a possible reason, it reads from a local MDB file (access), and it reads from some 270000 rows (result some 15-20 rows, where the highest are counted 150000, 50000, 40000, 26000, remaining are 100's). This is probably more Access that Visual Studio, though - is there a way to split it up or cancel the code takes less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual Studio (1) SharePoint (1) NHibernate (1) Microsoft SQL Server (1) Hi, Besides that your code is full of SQL injection bugs because help for this task. And an appropriate index might help to avoid the full table access. By the way, grouping by a.event_id in conjunction with count(a.event_id) makes no not, each and every record needs to be loaded and compared. The JET engine behind Access is not suited to handle databases beyond stamp collection size and lacks most features of should restrict your post to the dotnet / csharp newsgroups, so those in comp.databases.ms-access who _do_ know about Jet and Ace will not see and correct your erroneous claims. Larry Linson Microsoft Office Access MVP Co-Author, "Microsoft Access Small Business Solutions", Wiley, 2010 Utter rubbish and
deployment issues of Access XP, Access 2003, and Access 2003 DataBase On my advice, a long time ago, a customer purchased the Access XP developer edition. That special Office XP version of Access was supposed to allow the Access developers to deploy Access XP applications within their organizations