Questions tagged [ms-access]

Microsoft Access is a relational database management system that is part of the Microsoft Office suite.

Filter by
Sorted by
Tagged with
1
vote
1answer
20 views

Combine Multiple Rows Results From Left Join in a unique cell

¡Hi guys!, I don't have any idea how to create a new column that contains all information of results from a Left Join if exists the value Example Table 1 -------------------------------------- | ...
1
vote
1answer
74 views

Query - Match Name to Multiple Unique Types

I'm trying to create an Access 2013 database query to display all insurance policy holders that have more than one type of insurance. I am not interested in policy holders that have only one type of ...
0
votes
2answers
24 views

Microsoft Access Listbox Query

I have 2 tables in Microsoft Access. Table 1: ID Val1 Val2 Val3 1 a b c 2 e f g 3 h i j Table 2: ID Val Chosen 1 a 2 ...
-1
votes
0answers
9 views

Having issue with an application that generate report in background insteed on front [closed]

i have an application builded with Microsoft Access that generate reports. Each time when the application is running, a mdb file is created (see the picture below). the report is showing in background ...
0
votes
1answer
57 views

Backend on server keeps getting into an inconsistent state

I built an Access database. It was originally meant to be for 6 people but I see that it's up to about 20, so that could be the problem. Anyway, the backend gets into an inconsistent state a couple of ...
0
votes
0answers
7 views

MS ACCESS : On a subject form, how can I highlight a required control IF AND ONLY IF the user misses it (an error is thrown) [migrated]

I have built a subject form and would like to find a way to highlight a textbox control that is required (it is paired to a required field) IF AND ONLY IF the user fails to enter it. I know that there ...
0
votes
3answers
3k views

Querying a many to many relationship in access

I have just created a many to many relationship in MS Access with three tables as shown below AE Career Fair - Struc contains a list of companies where the company name is distinct. Office Locations ...
2
votes
2answers
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, ...
1
vote
1answer
123 views

MS Access : Navigation pane is suppressed

I received a MS Access form client. It is in access 2007 format. Initially Navigation Pane was not available. Only form was visible. Then I choose options->Current database->checked Display Navigation ...
0
votes
1answer
88 views

Tables not showing up when linking SQL Server to Access using ODBC connection

I am learning to link the back end of a database in SQL Server express 2016 to the front end in Access 2016. The tables were originally in Access and then I exported them to SQL Server. Now I am ...
0
votes
1answer
163 views

Setting up relationships properly with the Access UI

I am making the database design of my website in Microsoft Access 2013 because it has a nice user interface and I believe it will help me understand everything a whole lot better with the UI. I have ...
0
votes
0answers
44 views

How to create a linked table to an SQL global temporary table

In my Access database VBA code, I would like to create a linked table to a global temporary table in SQL Server. I can't seem to get it to work. This is what I have tried: Dim adors as new ADODB....
1
vote
1answer
118 views

Join two tables and create a new one in SQL [closed]

I am new to SQL and trying to apply a concept of Joins in MS-access. I have two tables Table 1 and Table 2: I want a query which will create a Table 3: Ideally i want all the data from both tables ...
0
votes
1answer
34 views

Cannot login to a MS Access database

Below is some VBA code to authorize users to login into an MS Access database. I am trying to fix this code and I don’t understand what is the issue in this code snippet. Private Sub cmdLogin_Click() ...
0
votes
1answer
76 views

Access 2013: Merging the same table-field with different data

I have six tables with identical fields. the group was tasked to input the data with the same fields and I need to merge all into one dataset--- table and form.
3
votes
1answer
275 views

How to Prevent Timeslot Overlap

SQL newbie here. I currently have a 2-table database-"Customers" and "Bookings". This question concerns the "Booking" table, which has 3 attributes this question is about: BookDate BookStart BookEnd ...
0
votes
2answers
48 views

Guidance on strategy for serving files remotely using SQL Server

Thanks for the help. "I" am the IT department for a small business and my ignorance may keep me from asking the right questions so please bear with me. Currently, we are using MS Access ...
1
vote
1answer
64 views

Database software solution [closed]

Our company has user data (name, email, phone number, systems of access, AD username) in a large Excel workbook. The Excel workbook is becoming very slow because of the 1000s of entries in it, and we'...
1
vote
1answer
852 views

Combining GROUP BY and JOIN

This seems like a really simple request, but I can't find the answer. I'll admit that I only have a very limited understanding of JOINs, so it could just be that I just don't fully understand the ...
0
votes
1answer
59 views

Can't open Microsoft Access Database inside a Microsoft SQL Server Filetable Folder

We recently started to migrate the Data on our Fileserver to SQL Server (Version 14) Filetables and I encountered a problem with MS Access Databases (.accdb, Access 2007). When the .accdb file is ...
2
votes
1answer
209 views

Relationship between two multi-valued child tables

Scenario In my system, there are a number of different TradeBaskets. Each TradeBasket contains a number of different Securities. The Securities have a Type, Value, Sector etc... and new Securities ...
1
vote
1answer
86 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 ...
0
votes
1answer
90 views

JOIN type for MS-Access report query

I have 7 tables, 6 of which are in a one-to-one relationship with a table named SLD joined with SLD_ID. SLD has 17 records and I need them all displayed regardless of matches in other tables. Which ...
-1
votes
2answers
25 views

How to show records for a particular month [closed]

Show the Sales, Profit and ShipDate fields (only) of any records from the month of January (any year) where Region and Province are both Ontario.
0
votes
2answers
258 views

Access Web App query 3 Tables with aggregatios - Need a workaround

I'm designing an Access 2016 Web App for inventoring our computers. The problem I have is with a query where I want to get the CPUCore-amount and RAM-Amount for each PC. The computer-value in RAM ...
1
vote
1answer
39 views

SQL Trigger that creates new table when a new record is added to current table

It's been quite a few years since I have done DB work. I am working through mysql workbench (using MS Access as a frontend). I have a base table that I am multilinking (basically a name index type ...
0
votes
1answer
14 views

how to convert query related to calculate work hours in MySQL to MS Access [closed]

I want to calculate work hours in each day using MS Access.I have query for same thing in MySQL but this thing is not working in MS Access using pdo php. query in MySql SELECT MachineNo, ...
0
votes
1answer
566 views

Access Macro: ApplyFilter w/values from 2 combo boxes

I'm getting started with databases in Access for a work project (technically a work-learn for my non-CompSci degree). I have experience using multiple filters on multiple columns through Access/Excel, ...
0
votes
0answers
16 views

Need to aggregate data from multiple tables with multiple same foreign keys Access

I need to add coHours and BaseBidHours and then compare to SumofActHours all per CodeID per jobID. See image below. I only loaded everything in to one query to visualize all the tables. Any thoughts ...
0
votes
1answer
563 views

MS Access - Creating a report based on a pass-through query that requires a parameter

I am attempting to make a report in Access that uses parameters as well as a pass-through query. I'm open to using a temporary table but the guides I can find using temporary tables all use an ...
0
votes
0answers
14 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 ...
1
vote
1answer
1k views

SQL Server Trigger does not update all table records

This is my first question so please go easy on me. We are using Access 2013 as a front-end and SQL Server 2012 with MS SQL Server Management Studio 11.0.2100.60 backend with ODBC connections. I am ...
0
votes
2answers
87 views

Split a string into multiple rows and get the count for each of them

I have a table "Production Database" in Server. I am using MS Access as a front end interface. I have some forms there. I want to create a query which will split records in "Reviewer" column and give ...
1
vote
1answer
28 views

How to move geographical data from MS Access to SQL Server

For 20 years I've been working with MS Access, with much VBA involved. I have a lot of geographical data in Access and I'm preparing to move to SQL Server because it supports geographical data types, ...
0
votes
0answers
15 views

Access Database for Capacity Management

I am designing database using Microsoft Access for capacity management. I have different types of equipment and need to track the power usage by every month. For instance, I have HVAC system and ...
2
votes
1answer
19k views

Records in table not showing on form Access 2007

Excuse my ignorance in asking this question - I am a database novice and need help! I will explain as best I can. In the table on my DB I have 235 records. I have created a form which references ...
0
votes
1answer
29 views

Small site / online database [closed]

I have to develop a small website and I wanted to understand which language to use. The main purpose of this site is to access various tables, for example customer table, orders, warehouse, etc. by ...
0
votes
0answers
22 views

Get contents of LDB file

I have a dektop app which is generating content in a table format and displays 10 rows at a time, which I can export to a csv file or copy/paste. The table has 10,000s of rows so I am trying to find ...
0
votes
1answer
35 views

How to convert columns into rows in MS Access [closed]

Please help me to understand, how to convert columns to rows in MS Access. I have the below table, I would like to convert as the below result table. NoOf_A NoOf_B NoOf_C NoOf_D 200 300 400 ...
1
vote
0answers
18 views

Rolling multiple rows into single row

I need help getting multiple rows of data to all pull into one row based on a primary key. I have four teachers rating a student's academic and behavior performance through the year. At the end of the ...
0
votes
1answer
11 views

How to create columns with Count and percentage using MS Access Query

I have a data table below, I would like to create a query to produce a result table like below, with count and percentage, using MS Access Query. I am unable to create this. Name Alex Alex Bob Bob ...
0
votes
0answers
14 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 ...
1
vote
1answer
940 views

Convert MS access to MySQL DB using php

We are creating a system that has a button for converting MS Access DB to MySQL. Is there a way to convert MS Access DB to MySQL using PHP? I would really appreciate any inputs on this one. Thank ...
0
votes
0answers
29 views

how Access can communicate to SQL without using ODBC?

Access will be the front end but I don't want to use ODBC on everyone's PC. Do you have any suggestions on how Access can communicate to SQL without using ODBC?
0
votes
2answers
24 views

MS Access with MySQL [closed]

My current team of 20 people use an Access database front end on their desktop. The backend of the access database is on a network drive. I have been asked to create a Access database front end with ...
0
votes
0answers
4 views

Return only unique values when concatenating fields in MS Access Report

How can I show only unique values when concatenating 2 field in an access report? The code would need to be case insensitive. Let's say that if the values are the same, the first value will be kept. ...
0
votes
1answer
18 views

Concatenate in MS Access - how to omit space and comma if first value is missing?

I am concatenating 2 values in a MS Access Report: "Method" and "Experiment" and they are to be separated by a comma (,). I have figured out how to concatenate succesfully when the second value is ...
1
vote
1answer
14 views

MS Access linked table displays short text instead of Decimal data type

I have linked tables in MS Access databases (various versions, 2007-2019) which are connected to SQL server 2017 via Sql server 2017 drivers (eg, msodbcsql_17.2.0.1_x64). Fields that are of data type ...
0
votes
0answers
46 views

MSSQL Express: linked server from Access database on network path

I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10. I have trouble to set the appropriate network UNC path and other settings for the linked server. My ...
0
votes
0answers
11 views

MS Access - used locally, want to move to use remotely

In my company we have an (old) MS Access software. (Used mainly to manage customers & invoices). In the software it's possible to choose the data file to work against (.mdb file). The goal is to ...

1
2 3 4 5
13