Topics Search

Access 2010 Getting Started in Access

Access 2010 Getting Started in Access
Views: 34
In this lesson, you will familiarize yourself with the Access environment, including the Ribbon, the Backstage view, the Navigation Pane, the Document Tabs bar, and the Record Navigation bar. You will also learn how to navigate with a navigation form, if your database includes one.
Sponsored Links:

Similar posts...

 

Access 2010 adp bugs

Access 2010 adp bugs Icon
I had a working adp that started life in Access 2003, was successfully upgraded to Access 2007, and has now been "upgraded" to Access 2010. A number of issues have arisen, all of which seem like Access 2010 bugs to me.

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.
 

Access 2010 auto insert from field above issue

Access 2010 auto insert from field above issue Icon
I have just upgraded to office 2010 and I have noticed that in my Access Database, that it no longer auto inserts the next value in sequence in a column of records -

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.
 

Access 2007 or 2010 Trial Download.

Access 2007 or 2010 Trial Download. Icon
Have tried to find a 2007 or 2010 Microsoft Access download trial edition, but no luck, I have two computers, one with IE and the other has WIN 7 64 Bit. I went to Microsoft links and tried one to get Access 2007, but it sent me to a 2010 Office download link.

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.
 

Installing Access 2003 with Office 2010 already installed

Installing Access 2003 with Office 2010 already installed Icon
I have all of Office 2010 installed and everything works. But now I need to run an old Access 2003 application that chokes with Access 2010 in place. Can I install my older version of Access (I have Office 2003 on disk but not on my computer) without uninstalling Access 2010 or Office 2010. I want to have both versions of Access on my machine.
 

Not able to build an ADP in MS Access 2010

Not able to build an ADP in MS Access 2010 Icon
I have a ADP project in MS Access 2003,I have migrated this application to MS Access 2010. After doing few code changes it is working fine in MS Access 2010, but we are facing issue in building the MS Access 2010 ADP.

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".
 

Access 2010 Startup Form - hide ribbon

Access 2010 Startup Form - hide ribbon Icon
In the process of converting Access 2000 to Access 2010. The following did work in Access 2010.
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 2010
Access Options - Current Database - Display Form
In the Display Form's Load Event
 

Access 2010 - runtime error 3170 Could not find installable ISAM

Access 2010 - runtime error 3170 Could not find installable ISAM Icon
I am running Office 2010 under Windows XP SP3 and I am getting the above error while exporting data from Access to Excel via a VBA routine. It worked fine in Access 2000 but since upgradingto Access 2010, I have started to get the erro "Could not find installable ISAM".

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.
 

Access 2010 to Access 2003

Access 2010 to Access 2003 Icon
I have been reading for what seems like forever but haven't seen the exact words I need to in order to make a decision. I am trying to decide between Office 2007 and Office 2010. I am wondering if Access 2010 can open, use, and save Access 2003 *.mdb file format.

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.

Migration considerations
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?
 

quick access toolbar for Access 2007/2010 runtime

quick access toolbar for Access 2007/2010 runtime Icon
I'm deploying an Access 2003/2007 project to a mixed environment of users -- some have Access 2003 full version, some Access 2007, some Access 2010, some Access 2010 runtime. I there a way to have one project that will display a Quick Access toolbar that has a couple of basic items on it? E.g. a button for Form View, one for Datasheet View, one for Print.

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.
 

create a calendar from scratch using vba in access 2010?

create a calendar from scratch using vba in access 2010? Icon
I would like to create a similar scheduling system using access vba based on the link below. Is it possible to create such a system on ms access 2010. I know this can be achieved on access 2007, but I'm not sure that if I created it in access 2007 and then migrated it into access 2010 it will appear.

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]