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

learn more… | top users | synonyms (1)

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?
5
votes
2answers
80k 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 ... ...
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 ...
4
votes
2answers
22k 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 ...
3
votes
1answer
3k views

How to avoid rounding numbers in MS Access 2007-2013?

I have an MS Access 2007-2013 database (.accdb format) which I open in MS Access 2013. It has just one table with several columns Lat Long PositionDate -54.82045 -68.33834 ...
3
votes
2answers
666 views

Truncation of Calibri rich text in preview/PDF mode on a report

I am experiencing truncation of text in rich text boxes in preview/PDF mode on a report. There is enough space for the text box to grow on the page, and the text appears in full in layout mode, but is ...
2
votes
1answer
1k views

When importing an Access table into Excel, a look-up column is showing all values as numbers

I have a basic Access to Excel question that has me frustrated. I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers ...
2
votes
3answers
13k views

How can I change the default datasheet font in MS Access 2010?

I've never liked the default font that is used as for datasheet views in MS Access. Recently, I've upgraded from 2003 to 2010, and for the life of me I can not find out how (via Google or otherwise) ...
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 ...
2
votes
0answers
55 views

How to paste multiple entries to a query?

How to do you paste multiple entries to a query in design view? I can only paste one value at a time, and I need to add multiple values. Is there a way of doing an Advanced Filter in Microsoft ...
2
votes
0answers
88 views

Error when validating formula

I am trying to create a field to convert currencies from one of 2 fields, thus I am putting the following code in "Default Value" as I want this field to be open for my manual input too: =iif([£ ...
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 ...
1
vote
4answers
7k views

Active content security warning in all files

Every time I open a *.mdb or *.accdb file I get the yellow Message Bar with a text in Spanish that translates as: Security Warning: Some active content has been disabled. Click for more details. ...
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 ...
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
2answers
602 views

Query for false values in Access not working

I'm trying to create a simple database to keep track of paperwork as it's turned in. In the form and table I've used yes/no check boxes, checking them when a paper is turned in. What I want to do is ...
1
vote
1answer
640 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 ...
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 ...
1
vote
1answer
13 views

Access 2010 - Providing the FE to Users

I have an Access database I split into backend and front end. I want to share the Front End with users; however, I don't want them to have all the queries I use (not useful to them). Can I hide my ...
1
vote
0answers
12 views

How do I bypass the Bypass startup if the person who set it is gone in Microsoft Access Plus 2010?

The database is set to disable the shift key when opening, but the person who set the Bypass startup is no longer employed here. We need to edit tables and a query in the background but can't get in! ...
1
vote
0answers
21 views

Which Databases Link to Particular Table in Database

I'd like to know if there is a way to determine which databases link to a particular table in a database without looking through each database to see if it links to the database of interest. I'm ...
1
vote
1answer
240 views

MSAccess - Updating all fields in form when selecting one field from listbox

I have a form which has the following fields Club Player Handicap Membership Number Score I have set the Club as a list box how do I get the other fields to automatically polulate when I ...
1
vote
1answer
4k views

Is there a way to convert a memo field to a text field in Access 2010 in an expression?

I have two tables (each in an Access DB) -- called LinkedTable1 and LinkedTable2 linked to my working Access database. I got them on my computer after downloading them from a SharePoint site (Actions ...
1
vote
1answer
759 views

Access 2010 Multi Table Report Combining Fields with same info

I am creating a Microsoft Access database for my office and am trying to create a Report to show every purchase for the whole office. My office is split into 4 teams, and, due to the differing ...
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
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
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
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 ...
0
votes
1answer
6k views

Access 2010 Table appears to be locked and can't be modified? How do I unlock it?

I have rather simple Access 2010 database. I needed to add a new field to one of the tables. While in Datasheet View, I Clicked the "Click to Add" column header and defined a new field. I went to ...
0
votes
2answers
4k views

Password Protect Access Database from Edits

I'm familiar with how to encrypt an Access database with a password (requiring a password to view data). Is there a way to allow data viewing w/o a password, but requiring one for editing the database?...
0
votes
1answer
8k views

how do you use RunSavedImportExport from a macro

I have yet to figure out all the 'musts' for getting this gem of a macro step to even show up in my macro step drop down. does anyone know what you have to do?
0
votes
2answers
1k views

MS Access 2010 maximum number of records

I have VBA program written in Access 2010. It creates and populates a table from a text file. Previously, there have been less than 20,000 records total. With the current data set, I get an ...
0
votes
1answer
688 views

Can I change the default Access 2010 view to allow for “Window”ed objects?

Before Access 2007, Microsoft Access was an MDI Container. For those who aren't developers, this means that each time you opened a DB object (i.e. Data Table, Query, Form) it appeared as a window ...
0
votes
3answers
562 views

Access 2013 file to open in Access 2003

I made Access Form which was working fine in Access 2013 and Access 2007 until I add some new features(I don't remember what) to it. After adding them, it keeps giving me error "Unrecognize file ...
0
votes
2answers
404 views

Why is my pivot chart not saving properly in Access 2010?

Working in Access 2010 and am trying to build a pivot chart from a query. My query is looking at an item type (multiple possible) and closure date with the intention of creating a stacked bar chart. ...
0
votes
1answer
1k views

Save multiple Selected Items From List box In Access

I have a simple form in Microsoft Access 2010 in which I have a list box with Multi-Select Enabled. I want to save the selected items in table. How would I go about it in Access 2010?
0
votes
1answer
2k views

Move The New Record Entry Row In Access Table To The Beginning Row

Is it possible to move the "New Record Row" in an Access table to the beginning of the table? For example, say you have 200 items entered into your table, you would have to scroll the whole way down ...
0
votes
2answers
4k 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 <---- ...
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 ...
0
votes
1answer
402 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?
0
votes
0answers
22 views

How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two cross-tab queries and combines them in a slightly different format than the original cross-tabs. I have used ...
0
votes
0answers
30 views

how do i run DoCmd.RunSavedImportExport to a different DB than CurrentDb in access 2010

I am not quite sure how to describe my problem correctly, but i try my best. I have a Formbutton that triggers with VBA some external Batch scripts and then imports the freshly created csv files. ...
0
votes
0answers
20 views

Access 2010: Database cannot be opened because the VBA project cannot be read

I used a simple software made with access on windows 8 s.o. with accde extension After formatted pc and installed windows 7, I can't run software because "Access 2010: Database cannot be opened ...
0
votes
0answers
23 views

Paste Append Sporadically Skips Lines (MS Access 2010)

First off, if this isn't a superuser question, please feel free to let me know and I'll be on my way. (I'm used to Stack Overflow, but I know this question isn't appropriate to that site's bailiwick) ...
0
votes
1answer
47 views

How can I determine which SQL db my Access app is pointing to?

There is no ini file containing any kind of connection string so it must be embedded somewhere, but where can I find this? The linked table manager appears to point to something but doesn't give ...
0
votes
0answers
58 views

The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ? It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10) File Path\file_name.cub is always changed every time database is opened. Now ...
0
votes
0answers
24 views

Query will work in designer but not in code

I have used this type of structure several times with no problem but this time I get a "type incompatibility" error message (error 13). The SQL statement returns results when I run it throught he ...
0
votes
0answers
60 views

Hide column in report based on combo box on form

In Access 2010 I am trying to get a report to show or not show the contents of one column based on the value of a combo box on a form. For example, the column name in the report is "foo" and I only ...
0
votes
0answers
78 views

MS Access Ctrl + Enter for new line results in extra line breaks when exported to a text file

I am preparing a database with many different types of fields. One, a memo field is best organized with line breaks. When I type the lines and use the appropriate Ctrl + Enter to force a line break, ...