Microsoft Access 2010 is a Rapid Application Development (RAD) and desktop/workgroup database application.

learn more… | top users | synonyms (1)

0
votes
2answers
10k views

Why won't MS Access 2010 show my list of System DSNs when I attempt to link data tables from SQL Server?

Recently the company that I work for has upgraded my PC from Windows XP to Windows 7. On my new PC they've also update my version of MS Access from 2003 to 2010 and they also gave me a new domain ...
0
votes
4answers
4k views

Is there a batch command to check for Access 2010 Runtime installation?

When using a batch file, is there a command I can use to check if Access 2010 Runtime is currently installed and if is not, then invoke it's installation? This will be used on both Windows 7 and ...
0
votes
2answers
5k views

Microsoft Access 2010 tables not showing the new record row with the asterisk

I have an .accdb on the network. The .accdb has various objects (queries, tables, forms). The problem lies in a form which has the following dependency form <--- table <---- query <---- ...
1
vote
1answer
644 views

UTF/unix time conversion in access

I am fairly good with access/excel/etc. However I am running into a brick wall with a database I query regularly for information. It has date/time fields that are tracked in unix time format (number ...
0
votes
1answer
879 views

Focus the property sheet in Access 2010

Is there any keyboard shortcut in Access 2010 to focus the property sheet? In Access 2000 and 2003, I could press F4 (or Alt-Enter) and then type to change the value or the selected property, or use ...
0
votes
1answer
1k views

Access 2010 forms: direct entry of foreign key into text box

In a form I am creating for an MS Access 2010 database, one of the fields represents a foreign key. I would like this field to be displayed as a text box, rather than as a combo or list box as is ...
1
vote
1answer
19k views

“MSCAL.OCX” error when moving from Access 2007 to 2010: I don't have a calendar

I have a database created in Access 2007. When opening it in Access 2010 I get the following error: "Your Microsoft Office Access database or project contains a missing or broken reference to ...
2
votes
1answer
1k views

Is it possible to create groups of objects in Access 2010 forms?

I have a form with 3 option buttons, and about 50 labels, textboxes, and buttons. Is there a way I can group some of these objects so that way when I select an option, some of the objects get disabled ...
0
votes
0answers
723 views

When using the Access Table Analyzer Wizard, I get the error “Cannot define field more than once”

I'm trying to normalize a very simple dataset: user_id | role_id I have a table with 60,000 records, and all I need to do is turn this into a join, so one table contains users, and another table ...
0
votes
1answer
1k views

How to import row data into Access when Excel does a date conversion?

I have an Excel worksheet that looks like this: MONTH WIDGET QUANTITY COST Jul-09 Widget1 1000 1.00 ... <repeat a few thousand times> ... I would like to ...
2
votes
1answer
124 views

How to toggle between views in Access 2010

I have a form which displays count sheets. One view is with the pre-count qty and the other is without the pre-count qty. This was originally developed in Access 2003. I can not toggle between the two ...
5
votes
4answers
12k views

How do I synchronize multiple Access Databases together?

I'm conducting a study, where we will be collecting data using Access. Since there will be multiple persons conducting these studies using the same structured Access DB we need to figure a way to ...
0
votes
1answer
2k views

MS Access Forms: Store number is table, display text in ComboBox

I'm using Access 2010. In trying to maximize both user friendliness and data efficiency, I'd like to store or reference a record by a reference number and display it in forms by the value in a ...
4
votes
2answers
23k views

How do I pull data from multiple tables into one table in Access?

I have multiple tables that contain tasks according to their category. Each table represents that category. What I need to do is create a 'Master' table that then is able to pull data from ALL the ...
5
votes
2answers
82k views

How do I set the first value of AutoNumber in Access?

I don't need to reset the AutoNumber value like this question, but rather would like to first set the number to: 1001 Which then increments like normal: 1001 1002 1003 ... ...
1
vote
1answer
37 views

Where can I find some useful current Access Tutorials? [closed]

I'm working an a research project and need to learn some of the basic and more intricate how to's of Access 2010. Are there any free online resources that are worthwhile? I'm looking to learn how ...
1
vote
4answers
1k views

MS-Access database-upsizing error

I am working on upsizing an MS-Access database from Access 2010 to MS-SQL 2008 (10.0.1600). When I run the Upsizing Wizard, all the tables get moved over except for one... The table that doesn't get ...
1
vote
1answer
4k views

Using a PivotTable to Count Items in Access

I have a list of text entries and I want to count how often each entry appears in the list. e.g. Berlin Paris London London Paris Paris Paris The result would be Berlin 1 Paris 4 London 2 This ...
8
votes
1answer
15k views

How do I view system tables for a `.MDB` in Access 2010?

How do I view system tables for a .MDB in Access 2010?
1
vote
1answer
1k views

Many to Many Data Entry - Access 2010

I have three tables. Student, Class, and StudentClassMap (many to many) that are laid out like so: Student: SID - PK Student Name Class: CID - PK Class Name StudentClassMap: SID - FK | PK CID - FK |...
0
votes
1answer
406 views

Microsoft Access 2010 set all cells equal to somevalue

I have a table, and I want to set all the cells in the row "State_Abbr" = "MN" How can I do this?