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

learn more… | top users | synonyms (1)

2
votes
1answer
971 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
577 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
961 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
106 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
9k 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 ...
3
votes
2answers
10k 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
54k 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
36 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
948 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
3k 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 ...
7
votes
1answer
12k 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
245 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?