Super User
Super User

Questions tagged [microsoft-access-2010]

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

Microsoft Access 2010 (also known as "Microsoft Office Access 2010") is the version of the Microsoft Access database application that is part of the Microsoft Office 2010 suite of products. Microsoft Access is a Rapid Application Development (RAD) and desktop/workgroup database application.

72 questions
12
votes
7 answers

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 ... How do I go about doing this in Access 2010?
James Mertz
  • 26,529
9
votes
1 answer

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

How do I view system tables for a .MDB in Access 2010?
H.Lam
  • 95
5
votes
4 answers

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. ... and a button labelled «Enable Content». Here's a…
Álvaro González
  • 1,573
5
votes
5 answers

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 update/synchronize to a central Database with the…
James Mertz
  • 26,529
4
votes
3 answers

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 truncated when in preview or rendering a PDF of…
sasfrog
  • 101
4
votes
3 answers

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) to change the default font that is used for…
RLH
  • 4,665
4
votes
2 answers

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 other tables in a dropdown box. For…
James Mertz
  • 26,529
3
votes
1 answer

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 20130825 -54.82018 -68.33854 20130827 …
Alex Tereshenkov
  • 237
2
votes
0 answers

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 Access?
Amie
  • 21
2
votes
1 answer

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 can have the same name), and each row also has…
user3651997
  • 33
2
votes
2 answers

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? I'm imagining something similar to the Protect…
Jon
  • 217
2
votes
0 answers

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([£ Price]>[$ Price],EuroConvert([£…
Mark Said Camilleri
  • 383
2
votes
1 answer

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 -> Open with Access). In each of LinkedTable1…
JW.
  • 557
2
votes
1 answer

"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 the file MSCAL.OCX version 7.0." Searching for this…
Aniko
  • 123
2
votes
1 answer

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 or enabled and I only have to use vba to say…
Dan
  • 21
1
2 3 4 5