Super User Stack Exchange
Super User Stack Exchange

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
11
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,344
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,344
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
  • 373
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

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 views in Access 2010>
Paul Jackson
  • 21
  • 1
1
vote
0 answers

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 looking for a function analogous to the trace…
user2901516
  • 21
1
vote
1 answer

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 within your application. You could Minimize,…
RLH
  • 4,425
1
vote
1 answer

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 select the Club thankyou...Julie T
Julie T
  • 11
1
vote
1 answer

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 purchases per team, 4 tables were created for each team…
Brice
  • 11
1
vote
1 answer

Where can I find some useful current Access Tutorials?

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 to: Basics of access Build and develop…
James Mertz
  • 26,344
1
vote
0 answers

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! Is there a way to get in the background when we…
J1s15n
  • 11
0
votes
0 answers

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, all looks good. Line 1 Line 2 Line 3 Then I…
EngBIRD
  • 148
0
votes
1 answer

Automating the input of query criteria

New user to this site and found an extremely informative answer to a question I had but can't find an answer to this one. Using Access 2010, I have 42 different criteria that I need to run individually using the same query. Rather than have 42…
Steve Wren
  • 1
0
votes
0 answers

Add Microsoft Access to my 2010 package

Let me know if I am sinful for asking this and I will delete it. I would like to add Access to my 2010 Office package (for a few months). Is that possible? How is it possible? The issue is that I am finishing a project that uses Access and I am…
AWE
  • 135
  • 1
  • 2
  • 9
1
2