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 User Groups

Access 2010 User Groups Icon
I have recently started to build a new database using Access 2010 and have now found that the UserGroups have been taken away, and I was wondering if there is a way to set permissions from a table to allow certain users access to certain parts of the database, mostly all form access and then run reports.

Does anyone have an ideas and possible sample they might share to get me going.
 

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.
 

Object spacing tools broken in Access 2010

Object spacing tools broken in Access 2010 Icon
I have recently installed and started using access 2010. So far I like it a great deal better than 2007, however I encountered a pretty nasty problem. When designing my forms, I rely heavily on the Size/Space tools to organize and align my objects. The spacing tools however seem to be broken, particularly the Horizontal once. In access 2007, I could select a number of controls, hit Equal Horizontal, and have the horizontal distance between the objects the same. Then I would use Increase/Decrease Horizontal to further tweak it. In Access 2010, none of this seems to work. Can anybody using Access 2010 confirm that this is indeed a bug, and if so what are some potential workarounds
 

Saving Access 2010 database to Access 2007

Saving Access 2010 database to Access 2007 Icon
I started database in Access 2007, then I upgrade my Office to 2010. Now my upgraded database doesn't work in Access 2007. And what is worse, there is no option in 2k10 to save "in Access 2k7 mode"
 

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.
 

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.
 

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 2007 reading Access 2010 DB

Access 2007 reading Access 2010 DB Icon
I started working on a database with Access 2007. My office 2007 got corrupted and my IT department installed office 2010 on my computer. I continued to work on the database in 2010. When I went to use someone else computer whom has 2007 I a database engine error message that " a minimum required version to read the data is 14.0.0000.0000