borderAndreaVB free resources for Visual Basic developersborder

AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2011 Andrea Tincani

AndreaVB Home | News Home | Forum Home | Downloads | Register | Search | PM | Profile

Previous Topic (J2EE Server)Next Topic (Altsoft MergeSplitPDF release is available) New Topic Post Reply
AndreaVB OnLine : Articles and tutorials : New Form Layout Widow
Poster Resource
bolendercm
Level: Scholar


Registered: 25-10-2005
Posts: 45
icon New Form Layout Widow

I have numerous programs in Access VBA 2003.  They converted to 2007 with very few problems.  However, I am about to begin another project using Access VBA 2007.  When I begin to make a new form in the "design view" the new form anchors itself to the top left and when I go to the "layout" view it fills the entire screen which I do not want.  Question!!! What do I do to (1) have the freedom to move the design view window around and (2) have the layout view or open view sized on the screen I choose?

____________________________
C.......................

24-02-2010 at 09:21 PM
View Profile Send Email to User Show All Posts | Add Comment
GeoffS
Level: VB Lord


Registered: 29-09-2004
Posts: 607
icon Re: New Form Layout Widow

Click on the "Office Button" in the top-left, when the menu opens click on the "Access Options" button in the bottom right corner. Select "Current Database" in menu on left pane, then under "Document Window Options" select "Overlapping Windows"
If, like me, you have been using Access for some time, you may be a little disappointed with the new Access. Personally I feel it has been "dumbed down" and is now aimed at company employees with a bit of IT savvy who, recognising that not all problems at work can be resolved with a spreadsheet, now want to create databases to organise their work. One of the biggest backwards step is the removal of the adp Project, the ability to create a front-end application in Access and make a direct connection to a SQL Server database (getting to tables AND Stored Procedures) without having to resort to linking entire tables with a DSN. If you have always done a lot of coding in VBA for your applications I would suggest you look at moving away from Access to using SQLServer Express, and VB.NET Express. Both of these are FREE from Microsoft, and the resulting application will be much better, particularly when data resides on a "Server" computer and the application runs on a Client PC, and it will be much more scaleable so additional Clients using the Application will not adversly affect the performance. The only downside to this is losing Access Reports, which I have always felt were incredibly easy and powerful, but SQLServer Reporting Services (included in the Advanced free version of SQLExpress) is very good, and the reports are constructed in a fairly similar way, so it does not take too long to learn.
Whichever route you take with your new project bolendercm - Good Luck!

____________________________
multi-tasking - the ability to hang more than one app. at the same time.

26-02-2010 at 10:02 AM
View Profile Send Email to User Show All Posts | Add Comment
AndreaVB OnLine : Articles and tutorials : New Form Layout Widow
Previous Topic (J2EE Server)Next Topic (Altsoft MergeSplitPDF release is available)New Topic Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2011 Andrea Tincaniborder