Questions tagged [ms-access-2010]

The tag has no usage guidance.

23 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
637 views

Select number of records until the sum is less than 'n' - Access SQL

I am working in Microsoft Access. My requirement is: user will give any percentage value and I have to find the number of IDs which form the percentage of the 'Value' column. For eg in the below ...
2
votes
2answers
994 views

Splitting 1 record on one table to become two records on another table

I am REALLY very new to this so please excuse my ignorance, but I could really use some help! I've got two tables: BillsFiled and Authors On BillsFiled, there are the columns: ID, Symbol, Filedate, ...
1
vote
0answers
31 views

UPSIZING ACCESS 2010 to SQL Server 2014

When I run the upsizing module it goes through the motions but the report at the end says "table was skipped or export failed" for each of the tables. I can't find a solution for this. I ...
1
vote
0answers
33 views

How do I hide the “read …save as” notification for an accdr file

When I make the accdb file to an accdr file and open it with Access 2010, the database is created with Access 2010 and OpenGateSoftware’s UI builder. I get a notification bar at the top saying: Read ...
1
vote
1answer
85 views

How to create a form that allows user to enter a variable number of items

I am a total beginner to Microsoft Access 2010. I need a form that allows a user add items from as list to a list. The items can be added until initial list is exhausted. Here's the most basic ...
1
vote
0answers
40 views

Need to update a column in table from Form , if there is no value in the column before ,

I am new comer to Access Database. I have a table named Employees with the columns named: Badge No Name Position Salary Address Status I create a form , in which i am using DLookup for to get the ...
1
vote
0answers
641 views

MS Access 2010 report - SQL pivot query WHERE criteria not working

I have created a report that has a list of actions which are populated from an "Actions" table. (See Below) However, each action will have multiple updates populated from an "Updates" tables and I ...
0
votes
0answers
10 views

How to optimize storage of sales details with multiple products in each sale in Microsoft AccessDb

I have created an accdb with customers and products tables. Now, I want to know how to store the sales order details in the Sales table, WHEN each sale has multiple products, each with different ...
0
votes
0answers
4 views

CopyFromRecordset Not Working

Hi I Inserted A Select MaxID+1 Data and want to retrieve what was that ID I inserted the Following is the codes Im trying to Insert data from Excel to Ms Access and Automatically Retrieve that Data. ...
0
votes
0answers
9 views

Combine information on multiple rows with the same key, into one row with the information in the cells next to it in a query in microsoft access

basically what this guy did here: Combine multiple row's records in one row with MS Access Query? but in such a way where its from: Case Number / Insurance 00001 / BCBS 00001 ...
0
votes
0answers
12 views

Opening a .mdb created by 64-bit ACE with 32-bit client

I'm creating Access .mdb files out of a 64-bit application via ACE. This process works fine. However, the only MS Access client available in the organisation is 32-bit. I've done some basic testing, ...
0
votes
0answers
14 views

MS_Access Employee Productivity database

I have one table all the details available in table1, I am trying to do relationship, however its asking 'No unique index found for the reference file of the primary table" In the Table1 Fields 1....
0
votes
0answers
15 views

I cannot open a local access database if I am not connected to our network

I can open it just fine if I am connected to network, but it will not open offline. I have turned off startup form and there are not autoexec macros. I am using Office 2010 on Windows 7 as a ...
0
votes
0answers
26 views

How to transfer 3.5 million records from one Access 2010 table to another

Because my table has over 3.5 million records I'm having issues with changing the data type in certain fields in the original table (Table A). Since it's so big I can't simply copy and paste the ...
0
votes
0answers
268 views

MS-Access - “Previous Record” Query

I'm working in an access database with the following fields (and others): Asset; Asset_Date; Start_Date; Start_Time; Office_Stop. Asset is a # field, Asset_Date is text; Start_Date is Date/Time; ...
0
votes
1answer
290 views

Access.adp (2010) and SQL Server 2014

We are using Access .adp (Access 2010) frontend in combination with SQL Server 2014 backend. At the moment we have a big performance problem with the SQL function permissions(). We have ca. 400 Users ...
0
votes
1answer
22 views

Counting Rows based on values in other columns

I'm trying to count the rows of an entire table (approx 3000 rows) based on the content of a column. In the column in question, there can be a single text value or a concatenation of text values ...
0
votes
0answers
24 views

Are there negative effects to creating multiple copies of an access database?

I've been working on updating an existing database for a company and for version control have been making multiple copies (so far I'm at 10) and making different kinds of changes to each one. I am ...
0
votes
2answers
28 views

Assistance with part of a join

I'm a college student and the database i'm working with is purely fictional but part of it requires me to make a query that is a join. What I have are 3 tables each with part of the data but also ...
0
votes
1answer
48 views

Beginner Question: Trouble turning a field with comma separated values into a multi-valued field

It's my first time using Access, and I have my first of what I assume will be many questions. Yay! So I imported some data from Excel to a table, including a column with a comma separated tagging ...
0
votes
1answer
89 views

How can I Use Access to combine tables of information

I have two tables in access with a common ID number in both. One table has mail to info and the other table has account information. The account information can have multiple listings per ID. The mail ...
0
votes
1answer
1k views

Firebird linked tables in Access 2010

I have multiple data sources in multiple databases that I have been tasked with correlating for business analytics. I currently have ODBC connections to two (one Pervasive, one Firebird) that I can ...
-1
votes
1answer
299 views

Find Missing Dates in My table

I have a make table that figures daily pride and assigns the current date to each line. I want to be able to run a query to pull all pride numbers from 06/01/2016 to 06/30/2016 and then run a query ...