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
0 votes
1 answer
30 views

Select employees who have NOT completed all training

I'm not a frequent DBA, but I'm working on something to track training complete for some employees and I'm a bit stuck. I'm using MICROSOFT ACCESS and have 3 tables: Employees Last_Name (...
0 votes
1 answer
42 views

Looking for file-based DB engine alternative to MS Access

My company has been chained to this MS Access '97 .MDB format we've had since the dawn of time. Our schema is hierarchical, with multiple one-to-many relationships. We are at a point where we are ...
  • 3
0 votes
0 answers
23 views

Is this a good database design for storing recipes that contain "sub-recipes"?

To preface, I haven't designed or worked directly on a database in years, and my general SQL knowledge is still fairly limited. I'm designing a recipe database in Access to store interesting recipes I ...
0 votes
0 answers
8 views

Using OR for separate fields in Access' Advanced Filter/Sort

I want to create an advanced filter on an Access table that involves several criteria, including an OR between two fields, e.g. "fld1 > A AND (fld2=B OR fld3=C) AND fld4 <= D". I have ...
  • 101
5 votes
3 answers
1k views

SQL Database vs Multiple Microsoft Access Databases

The company I work for produces a lot of test data in raw text files from lots of different devices. Each device belongs to a 'process' of which there are only a few dozen. Currently we have a program ...
1 vote
0 answers
88 views

MS Access SQL - Left Join (or sub-query?) most recent related record

Hello Database Administrators. Thank you so much for your help with this issue. It blows my mind that something so simple can be so complicated. I have an MS Access database with two tables. The first ...
  • 11
0 votes
0 answers
15 views

MS ACCESS 2k3 Flatten out a number of like records

Sorry never seem to understand how to do this kind of query in SQL Given the following data, I am looking to make one or more Queries compatible with MS ACCESS 2k3 that will provide the following ...
  • 1
1 vote
0 answers
31 views

Best Method for Modeling/Implementing Dependent Primary Child?

I’ve implemented Primary Child functionality using a third table as described by @ypercube here (and other posts). I chose this method because it’s database-agnostic, simple (no triggers or deferred ...
0 votes
0 answers
14 views

Records in table not showing in MS Access

I created database system using VB6 and MS Access database. It has been installed many computers and working fine. But I have a problem. Though can retrieve the data from VB system, when open the ...
0 votes
0 answers
62 views

MS Access and the Dataverse -- lost primary keys and read-only queries

I'm trying to create a database application with tables stored on a Dataverse/Teams backend and an MS Access front-end. I have a simple one-to-many database design, and a form with a query as its ...
  • 3
0 votes
0 answers
4 views

Trying to input table-format data using Access Data Input form

We're trying to format and input some scientific data into an Access database, and unfortunately the source of the data is in Excel files with very inconsistent formatting, so we can't use a blanket ...
0 votes
0 answers
33 views

Can't view/create System DSN in windows 10 using ACEODBC.DLL

I need to create a system dsn to connect to a Microsoft access accdb for my fedex shipping station. I can seemingly create a dsn and everything seems fine but then it doesn't show up in the list. And ...
0 votes
1 answer
127 views

MS Access - How to sum matching criteria from two columns in same table

I have an MS Access database with four columns of interest that I am trying to work with. The rows represent sold jobs, and the columns of interest are "OriginalSaleAmount", "...
0 votes
0 answers
119 views

Filter Combo Box list without filtering Recordset - MS Access

I am trying to create a form where users select related pieces of equipment that are already in the database. Since they are existing I want to use a combobox with populated list of existing entries. ...
0 votes
0 answers
16 views

How to handle user input of priority?

I've been learning MS Access 2016 the hard way (trial/error + search everything), and I've hit something that's got me completely stumped. This one is a bit of a two-fer. I have a database that ...
0 votes
0 answers
16 views

How can I GROUP BY based on time between records, rather than time 'buckets'?

I've been learning MS Access 2016 the hard way (trial/error + search everything), and I've hit something that's got me stumped. TL;DR: How do I re-bundle my dataset of operations into transactions? A ...
0 votes
1 answer
337 views

Combine multiple rows into one single column (MS Access)

I am trying to build a query from a table (Tbl_XYZ) that will give me the information for the primary key all in one row rather then creating dups for that primary key and showing up with multiple ...
  • 1
0 votes
0 answers
13 views

Importing a database with the exact same schema as the destination database

I am working in Access with a fairly simply relational database. I want to import another database of the EXACT same schema, but when I use Access' import tool the software creates extra tables (...
0 votes
1 answer
143 views

SQL in Access to add leading 0 in front of zip codes

for a project I am working with a table of zip-codes that I imported from a *.csv file, exported form Excel. Those zipcodes all have 5 numbers and are formatted as text within my database. Some of ...
  • 1
0 votes
1 answer
42 views

MS Access and multiple users

I'm looking for some help regarding Microsoft Access and database design. I have been developing a database application on Microsoft Access for use in my organisation. I work in a hospital and we have ...
  • 3
0 votes
1 answer
22 views

Inputting same data on identical Field Name on different table

currently i am new in ms access, And currently - as a trial and learning step - I created Two tables, and a Single Form that can be used to put a value to both tables, those are: Table 1 - "...
  • 1
0 votes
0 answers
16 views

Creating a new Access Database for Work to do configuration tracking, but need to normalize a huge table they provided me. I am a total noob however

SOME BACKGROUND I've recently graduated from university, where I did an 8 week intro database course back in 2018. I've started working at a company where they've tasked me with developing a tool to ...
  • 1
0 votes
1 answer
101 views

VBA - Hide a Form tab depending on the value of a field

pretty simple question here in scope. Question: Wondering If I would be able to hide the tabs of a form based off the values of a table's fields. I have been reading the 2019 Access Bible and so far ...
0 votes
1 answer
14 views

What kind of object is made when we make CREATE VIEW, and what sort of commands can be ran on it?

I would like to understand the difference between a table and a View in SQL (Ms Access, if it makes any difference). So I know Create View command can be used to "pull" all fields and ...
1 vote
0 answers
98 views

Select value and display in a combobox if the datetimepicker value lies between two extreme dates in a table in database

I am creating an attendance management system in vb.net and using MS access as my database. I created a leave form in which the student on leave has a roll number and his details along with the from ...
  • 11
0 votes
0 answers
35 views

How to insert a TempVar in a form in MS-access using macros?

I have two forms, one that shows information on a person (based on a person table) and one that shows information on a specific order a specific person has made (based on an order table). On the ...
  • 101
0 votes
0 answers
26 views

Can MS Access create a field alias within a table?

I have some third party tools that are written by different developers, but they share a common database and it seems like may not be completely synchronized in their activities. Currently, one tool ...
  • 101
0 votes
0 answers
8 views

Why does Access recalculate a stored query when I copy it? Can I tell it not to?

When I copy and paste a stored query in Access, it's usually because (a) I want to back up the code before making changes, or (b) I want to make a new query by making changes to that one. All I want ...
  • 101
-2 votes
2 answers
48 views

Database schema - Set Limit values in correlation to groups and/or it's members

Provided there are pre-existing tables (diagram attached below). They each have numerous use-case as far as potentially related attributes. Still, I am at a roadblock following best practices with ...
0 votes
1 answer
46 views

Compact Database VBA for an .mdb that utilizes a .mdw security file

The below code works great when you call an unsecured database from another database. But I am trying to compact an .mdb in Office 2013 that has user-level security (.mdw). If I try the below code ...
  • 1
0 votes
0 answers
30 views

SQL Query Statement with Group By

I am trying to analyze how far players of the game progress as a function of age. The age is measured as the number of days since game installation. For active players who played the game at a certain ...
0 votes
0 answers
24 views

How do you modify query to include additional fields in the results?

I have the following MS Access query: SELECT * FROM (SELECT [cnPart],[desc] as DATA,"desc" as CAT from PartData UNION SELECT [cnPart], [qty], "qty" FROM PartData UNION SELECT [...
  • 1
1 vote
1 answer
331 views

Find Max Date from a Distinct Row Then Add Value to a Table Column

Quick disclaimer - I am familiar with Access, but a novice at MySql within Access. I have a table with activity data that I pulled into a query to filter down to only necessary data. The query table ...
1 vote
2 answers
33 views

Return results with several LIKE and NOT LIKE requirements

I am trying to create a query that selects only a set of values, but excludes other ones. The column I am selecting it's called "Participants" and the values therein are not a single text ...
0 votes
1 answer
56 views

How to Stop MS Access From Undesired Cascading Delete? [closed]

When I delete a record from one Microsoft Access table, it deletes the corresponding record in another table. I need to stop that. Table 'items' has ID (the key), item_name, and some other fields. ...
0 votes
1 answer
45 views

Q: Updating multi table linked view with MS Access

I have an MS Access db with a linked table pointing to an MS SQL server database view. We have been using MS Access as a simple front end to change data contents via this view. The view was ...
0 votes
1 answer
236 views

Expressing A Composite Key in a Data Dictionary

I am looking for an example of expressing a "Composite Keys" in a data dictionary. I am using an MSO Access application with a Lecturer Table and Subjects Table where I have taken the ...
  • 1
1 vote
1 answer
47 views

How to design a query to pop up input with two text boxes in MS Access

I ask this question while I could not find any similar question neither on Google nor DBA Stackexchange, this question might be duplicated. I wrote this query in MS access to check for first name and ...
  • 11
0 votes
1 answer
39 views

Consolidate / sort / combine / merge data for dummies

I am looking for a non-scripting solution to combine data from 3 different tables (preferably using spreadsheet software like Microsoft Excel but a database would also work e.g. Microsoft Access). I ...
  • 103
0 votes
0 answers
14 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 ...
1 vote
1 answer
152 views

3 Simple Queries SQL Student Question, Query Errors in Microsoft Access

The First Question is: "List the name of each trip that does not start in New Hampshire (NH)." SELECT TripName FROM Trip WHERE State!='NH'; /* works with State='NH' */ The Second Question ...
0 votes
1 answer
26 views

query for showing columns from various tables, grouping and showing calculated field in each row of the result

I am doing a stock management system. In one table I store items: ITEM<br> id_item<br> item_name<br> ORDER<br> id_order<br> date<br> ORDER_ITEM<br> ...
1 vote
1 answer
21 views

Return only records with a date after the most recent September 1st

I have a table with data with a date column called "dtAssessmentDate" in a table called "tblAssessmentRecords". What I want to achieve is for a select query to return only the ...
1 vote
0 answers
13 views

Autofill spreadsheet data from Excel [closed]

So I've got an Excel template I send to clients and they fill in one cell with a type of resource they need, and I check an Access database for available resources to find what we have and fill out ...
  • 11
1 vote
1 answer
72 views

MS-Access Beginner Replace Textbox Caption With Combo Box Selection on Button Press [closed]

I'm a complete beginner, just trying out/looking into Databases as more of a hobby, and think Microsoft Access would be an easy way to start with the whole front-end forms and back-end combination. I ...
-1 votes
1 answer
32 views

Job Opportunity and difficulty (or not) for me to learn to use msaccess and surveygizmo/alchemer [closed]

First, if my question fits better elsewhere, please advise. My question is: Based on your experience with relational databases like MSaccess and perhaps survey tools like Alchemer (formerly Survey ...
-1 votes
1 answer
405 views

Using an independent textbox to write different values for different rows/registers in a continuous form, repeats the value in every row [closed]

I have a form that is using a continuous form view to show the following: The name of the different products I have. In another column I have the actual quantity of the product.ç This is made using ...
1 vote
2 answers
75 views

Use filters instead of queries in MS Access? [closed]

I realize many things could be done in Access like instead of using queries for filtering things, it is posible to use filters. I'm not sure if the program makes SQL with VBA queries under the hood or ...
0 votes
0 answers
30 views

How do I write my SQL Code in MS Access SQL?

Table Name: Records ID Date Time Status BoxType Material Rack EmployeeNr Transaction 1 25-05-2020 13:11:12 70 36757 4 4 188 2 2 25-05-2020 13:12:40 71 31178 2 5 188 2 3 25-05-2020 13:13:31 71 ...
  • 1
1 vote
0 answers
18 views

Span a record on multiple pages in MS Access [closed]

MS Access has a limitation in its Reports functionality that is max Section height is 22.75 in. (57.79 cm). I want to create a report that will use data from a single record to span on 12 pages in a ...

1
2 3 4 5
14