GeoffS Level: VB Lord

 Registered: 29-09-2004 Posts: 607
|
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.
|