Questions tagged [ms-access-2010]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
13 views

how to Manipulate duplicated records using access

Using Microsoft Access, I have a number of records that have duplicated field-1. I need to form a query such that the duplicate records get unique ; BUT the next filed-2 data must be seen in columns ...
user avatar
0 votes
1 answer
1k 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. ...
user avatar
  • 1
0 votes
0 answers
32 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 ...
user avatar
0 votes
0 answers
27 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 ...
user avatar
1 vote
2 answers
621 views

Are there alternatives to Microsoft Access? [closed]

In my office, we often use MS Access for many applications (eg creating reports, data analysis and data processing) because it is convenient to use (easy data import, fast query building, easy ...
user avatar
  • 19
1 vote
0 answers
33 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 ...
user avatar
  • 11
0 votes
0 answers
287 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; ...
user avatar
1 vote
1 answer
87 views

MS Access 2000 Application - SQL Server [closed]

I have an old MS Access 2000 application which connects to a SQL Server 2000 database. I need to migrate this database and application to a new server with SQL Server 2012. The Access application is ...
user avatar
1 vote
1 answer
999 views

SQL MS ACCESS: Split row into multiple based on column value

I have table (SQL MS ACCESS) COUNTRY NO_OF_PAGES FRANCE 2 UK 4 GERMANY 1 I want output COUNTRY NO_OF_PAGES FRANCE 1 FRANCE 2 UK 1 UK 2 UK 3 UK 4 ...
user avatar
0 votes
1 answer
340 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 ...
user avatar
0 votes
1 answer
23 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 ...
user avatar
  • 1
0 votes
1 answer
111 views

Ms-access defining additional Index Fields

I am developing an access database that eventually will grow in size. For that reason scalability has to be taken in account. My background: no official studies about databases. I have read Access ...
user avatar
0 votes
1 answer
913 views

Connect excel to ms-access front end database

I have an access database split. It is part of an app working along with an excel add-in. Question: Within excel, should I address all query updates directly to the back-end version (in the shared ...
user avatar
1 vote
1 answer
618 views

MS Access copy/paste of table fails with message about clipboard size [closed]

I have an mdb file that has some large tables in it (greater than 65000 rows). I used to not have any problems duplicated the table by copying and pasting but just recently I started getting a message ...
user avatar
  • 11
0 votes
0 answers
25 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 ...
user avatar
  • 101
1 vote
2 answers
3k views

Exclude table's data from another table

Is it possible to create a query and ask the following? I have two tables (each one has one column with data) and I want to obtain as a result all data from the first table MINUS the data from the ...
user avatar
0 votes
1 answer
33 views

Query: Most recent record for unique combination of two fields in MS Access 2010

I'm trying to run a query on some traffic volume data but I'm having some trouble. I would like to pull out the most recent data for each section of road, but this is proving more complicated than ...
user avatar
  • 103
0 votes
2 answers
32 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 ...
user avatar
0 votes
1 answer
34 views

Developing Access DB to SQL? [closed]

I built a database several years ago in Access to track over 4K pieces of equipment in and out of a shop, where it was going, current status, etc. It's dying. I would like to upgrade it, but unsure if ...
user avatar
  • 1
0 votes
3 answers
4k views

Access: How to Combine Data from Two Rows in a Query

I have a base dataset formatted like the one below. Sex1 | Sex2 | Number| F | | 5 | M | | 8 | M | F | 5 | F | F | 3 | ...
user avatar
-1 votes
1 answer
353 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 ...
user avatar
3 votes
3 answers
10k views

Access 2010-2016 Compatibility Error

I was just updated to Access 2016, while my users are still at Access 2010. I opened our database in MS Access 2016 once, didn't make any changes, and closed it out, and now all the users are having ...
user avatar
  • 31
1 vote
0 answers
35 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 ...
user avatar
0 votes
3 answers
1k views

Restrict Front Ended User access to Form entry only

I have a front end database that I want to restrict user access to only enter data into a form. I do not want them to be able to scroll through other entries via the form. How can I restrict this in ...
user avatar
  • 1
1 vote
1 answer
100 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 ...
user avatar
2 votes
1 answer
64 views

MAX and MIN for each car model

I have a problem with a query. I have a db with car and their spec, every model has a different car related to that model with its price. I want to create a query that gives me the min and max price ...
user avatar
1 vote
0 answers
41 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 ...
user avatar
  • 11
0 votes
1 answer
50 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 ...
user avatar
4 votes
1 answer
54 views

if 0 show " ", if <500 show "B", if >500 show "R"

I'm working on a query in Access 2010 and need help. If the value is =0 I want it to show as blank, if the value is <500 I want it to show as "B", if the value is >500 I want it to show as "R"
user avatar
  • 43
1 vote
1 answer
2k views

ADO connection suddenly starts failing Intermittently

I have an Access 2010 front end connecting to a SQL Server 2014 back end. I've got SSMS 2014 installed on my machine, and everything was working fine. (Running Win7 64-bit with 64-bit Office.) Long ...
user avatar
  • 199
1 vote
1 answer
50 views

MS Access 2010 adds unwanted wildcard at end of select clause

MS Access 2010 has a vey weird behaviour for me. Whenever I create a new Query, it silently adds a wildcard (i.e. ', *') to the end of the SELECT clause. The wildcard is visible only in the SQL and ...
user avatar
  • 13
1 vote
0 answers
691 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 ...
user avatar
  • 113
2 votes
1 answer
464 views

Should I maintain relationships diagrams in the back-end and the front-end?

I’m developing an Access 2010 database application. It is split into a back-end, holding all the tables, and a front-end, holding all the queries, forms, etc. I find the Relationships tool helps ...
user avatar
  • 311
2 votes
1 answer
59 views

Distinguishing Records with Related Fields

I'm a newer user (obviously) and would greatly appreciate question writing suggestions as well as answer suggestions: I have a lot of interrelated tables which largely depend on my Products table, ...
user avatar
  • 253
1 vote
1 answer
2k views

Automatic creation of unique Alphanumeric ID?

All the accounts in my database have a unique ID, that begins with the letter "G" (always), and has a 3 digit number following (e.g. "G026", "G123","G005","G999", etc.) When a user is inputting new-...
user avatar
  • 13
5 votes
3 answers
683 views

Microsoft Access Export to Excel

I have an Excel spreadsheet that is filled with a ton of data which is organized by column (a column for names, a column for occupation etc.). I have recently moved all of this data into Microsoft ...
user avatar
  • 51
1 vote
2 answers
2k views

Query of multi-valued field [closed]

I have 2 tables: Contacts Helpers The Helper field (which is linked to the Helper table) in Contacts is a multi-valued field so more than one helper can be selected and displayed in a report. Each ...
user avatar
2 votes
0 answers
683 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 ...
user avatar
0 votes
1 answer
387 views

Access 2010 ODBC Connection to SQL Server 2005

I'm trying to code an ODBC connection to SQL Server in Access 2010 and hoping someone can help me, as I've lost the plot. This is my code, it simply accesses one SQL Server database/table and insert ...
user avatar
  • 1
0 votes
1 answer
2k views

How to prevent #Error values derived from Nulls in an outer join

Suppose I have two tables to outer join Tab1: ID Nam 1 Joe 2 Moe 3 Flo Tab2: ID Val y w 1 stuff 66 33 2 duff 67 44 and one of the resulting columns is derived -- i.e., it's ...
user avatar
  • 311
0 votes
1 answer
1k views

How to subtract records from a table based on their existence in another

I have an Access 2010 table Assignment key Empl Number key Year Number key Week Number key Proj Number It assigns employees to zero or more projects for given work weeks, thus, all four ...
user avatar
  • 311
0 votes
2 answers
119 views

Microsoft Access Security

So I get how to connect Access to SQL Server, and I understand that the tables have to be linked, but my problem is security. If I link the tables from SQL Server into Access, then anyone who comes ...
user avatar
0 votes
1 answer
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 ...
user avatar
  • 1
0 votes
1 answer
388 views

How to save the design of an Access database -- not the content -- as text?

How can I save the entire design or specifications of an Access 2007 database -- not the data content -- as text? I have fallen foul of the "Enter Parameter Value" bug whereby a query pop-up shows an ...
user avatar
  • 311
0 votes
1 answer
228 views

Convert an interaction matrix into a ternary relation

I have what I'm calling a sparse "interaction matrix" of data in MS Excel that I wish to convert into a "ternary relation" (table) in Access. The spreadsheet data are in this pattern: Name Act-1 ...
user avatar
  • 311
2 votes
2 answers
1k 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, ...
user avatar
1 vote
1 answer
11k views

Access 2010 After Insert data macro to update another table

I have an Access DB with 3 tables. Table 1 Appointments Fields with Data that is not used anywhere else, but some of the information is inserted into 3 with a after insert Script. Table 2 Usage Data ...
user avatar
1 vote
1 answer
333 views

"No Current Record" when using COUNT() in Access 2010?

Okay, so, I'm trying to get a count of how many customers each service provider has billed for over the last year or two. Our database's data is slightly imperfect, so I'm trying to kludge together a ...
user avatar
0 votes
1 answer
94 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 ...
user avatar
0 votes
1 answer
192 views

Update query for Minimum absolute difference in Access [SQL]

I have 3 tables in an Access db. Table_1 and Table_2 are where the source data comes from and I am filling Table_3. Table_1 has the following fields: Acct_Name Amt Table_2 has the following fields:...
user avatar