Access 2010 Getting Started in Access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The Access 2007 version and the Access 2010 version are both connecting to the same SQL Server 2008 database. The issues only exist in Access 2010.
* A form which used Me.OrderBy to sort the recordsource crashed Access 2010 after working fine in Access 2003 and 2007.
* Settings for a form's InputParameters which worked fine in Access 2003 and 2007 now crashed Access 2010.
* Access 2010 incorrectly decided that a foreign key id field in a form "cannot be updated because it is an autonumber". In this particular case, the problem does NOT occur if the record source is "Select P.* From dbo.Payment P", which is the table containing an actorID foreign key.
I am a basic user - no programming involved.
Basically, prior to Access 2010 if I had a entered information via a query, and one of the columns was a blank field. If I started the 1st record with say 101 and then cursored down to the same field in the next record and entered 102, a further scroll down would automatically add 103 and so forth.
Access 2010 does not perform this natively - and I have been using Access since Version 1 and it is the 1st time I have come across this.
I could not locate anything in the (very limited) Access Help and I cannot explain why this has changed.
I just need a 2007 or 2010 edition so I can try it out and then buy it if it suits my needs. executeable file download and a microsoft product key so I can get started.
I am able to import the Forms,Modules and On selecting the run macros to Initialise the Database in MS Access 2010(while building ADP),it is giving runtime error'29060'"file not found".
For the developer - opening up Access with the shift key still hides the ribbon. Added a module and code so the menus open for the developer.
Access Options - Current Database - Display Form
In the Display Form's Load Event
I am using a statement that starts DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3
If I change it to acSpreadsheetTypeExcel5 (or later) then it works fine but 3 or 4 brings up the installable ISAm error.
I have found the following quote and when reading its suggestion it would lead me to believe it would but then there is that little warning that "Because Access 2010 has many similarities with Office Access 2007, such as the same native file format," I'm not totally convinced.
When you plan a migration to Access 2010, changed, and removed for Access 2010. Because Access 2010 has many similarities with Office Access 2007, such as the samenative file format, you can also review and use the existing migration documentation for Office Access 2007 when you migrate to Access 2010.
So my question is can Access 2010 open, use, and save databases in the Office 2003 file format?
This was easy with Access 2003, and I can customize the toolbar for people with full Access 2007 or 2010. But I'm stumped on Access 2010 runtimes.
I looked into custom ribbons, but they seem to only work with Access databases, not projects.
Is this possible to do and transpose it into access 2010? If so, how can thisbe done? Or can it be done programmatically via the date picker?[LINK]