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
0 answers
8 views

Does MS Access 360 suffer from issues with frequent data corruption?

When discussing what database software to use I've been given advice to avoid Microsoft Access 360 due to stability issues. Have others experienced these issues? How bad are these issues compared to ...
user avatar
0 votes
0 answers
14 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. ...
user avatar
0 votes
0 answers
10 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 ...
user avatar
0 votes
0 answers
15 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 ...
user avatar
0 votes
1 answer
20 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 ...
user avatar
  • 1
0 votes
0 answers
11 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 (...
user avatar
0 votes
1 answer
15 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 ...
user avatar
  • 1
0 votes
1 answer
29 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 ...
user avatar
  • 3
0 votes
1 answer
18 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 - "...
user avatar
  • 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 ...
user avatar
  • 1
0 votes
1 answer
28 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 ...
user avatar
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 ...
user avatar
1 vote
0 answers
26 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 ...
user avatar
  • 11
0 votes
0 answers
14 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 ...
user avatar
  • 1
0 votes
0 answers
15 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 ...
user avatar
  • 101
0 votes
0 answers
7 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 ...
user avatar
  • 101
-2 votes
2 answers
41 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 ...
user avatar
0 votes
1 answer
28 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 ...
user avatar
  • 1
0 votes
0 answers
22 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 ...
user avatar
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 [...
user avatar
  • 1
1 vote
1 answer
63 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 ...
user avatar
0 votes
0 answers
76 views

Creating a report with multiple sub-reports, grouped on one field - Microsoft Access 365

I am trying to create an MS Access Report (Microsoft Office 365) with more than 1 subreport, to be grouped under a field called "City". The report is based on a linked table and the sub-...
user avatar
  • 1
1 vote
2 answers
31 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 ...
user avatar
0 votes
1 answer
34 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. ...
user avatar
0 votes
1 answer
35 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 ...
user avatar
0 votes
1 answer
171 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 ...
user avatar
  • 1
1 vote
1 answer
21 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 ...
user avatar
  • 11
0 votes
1 answer
34 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 ...
user avatar
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
1 vote
1 answer
120 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 ...
user avatar
0 votes
1 answer
22 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> ...
user avatar
1 vote
1 answer
17 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 ...
user avatar
1 vote
0 answers
8 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 ...
user avatar
  • 11
1 vote
1 answer
43 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 ...
user avatar
-1 votes
1 answer
28 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 ...
user avatar
-1 votes
1 answer
265 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 ...
user avatar
1 vote
2 answers
48 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 ...
user avatar
0 votes
0 answers
27 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 ...
user avatar
  • 1
1 vote
0 answers
11 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 ...
user avatar
1 vote
1 answer
63 views

What is MS Access ODBC SQL syntax for a table with AutoIncrement and Memo columns?

I am migrating a full framework .NET app to core. It used ADOX to create an MS Access database and tables. It used OLE DB to populate data. In ADOX, the data type was ADOX.DataTypeEnum.adInteger and ...
user avatar
0 votes
1 answer
53 views

Why i can't use table name in subquery?

I have a MS-ACCESS database. When i try to do this query: SELECT * FROM (SELECT * FROM tblClients AS a1 LEFT JOIN (SELECT TOP 1 lVersion, lRequestID AS lVerReqId, lClientId FROM ...
user avatar
  • 11
0 votes
1 answer
24 views

How to select maximum row value using optimal way

I have a large table: +----+-----------+------------+--------+--------+--------+ | Id | lClientId | datAccess | lProp1 | lProp2 | lProp3 | +----+-----------+------------+--------+--------+--------+ | ...
user avatar
  • 11
0 votes
1 answer
973 views

Is it better to have multiple tables with the same primary key or one big data table?

So there is one primary key so far used for IDs of locations. Currently there are multiple tables (sheets) in Excel for the following Events (Location ID, Date, Title, Description) Animals (Location ...
user avatar
-1 votes
1 answer
182 views

How to rewrite IIF and dlookup function from Access in SQL Server as we have recently migrated from access to SQL Server

I need to rewrite the IIF and dlookup part of this query so its can work in SQL Server . I would preferably like the CASE and SELECT statement as SQL Server doesn't have dlookup function so code is ...
user avatar
1 vote
2 answers
282 views

SQL server Login failed for user [duplicate]

My MS Access Application uses SQL Database as backend. The permission to SQL database is granted with Windows Authentication mode to a specific user group. Most of users in the group can get access to ...
user avatar
  • 21
1 vote
1 answer
22 views

Update query using two tables

I want to update the ProductStock field in tblProduct when this query is run. The ProductStock should minus the Quantity field in tblOrderProduct. (ignore the * sign, I just wanted to see if ...
user avatar
  • 13
0 votes
1 answer
93 views

Table Diagram and Access File of Contact Database for Church

I have volunteered to design and develop an MS Access database for contacts at my local church in Jamaica, which has no budget to hire a database expert. I have attempted to design a database for the ...
user avatar
  • 1
2 votes
1 answer
59 views

Microsoft Access: Using other fields in an Autonumber

I'm trying to use Microsoft Access to start an employee database. However, I want the display of the Employee ID to be the initials and then their number. For example, John Smith with the ID 0002 is ...
user avatar
  • 21
1 vote
1 answer
100 views

How to refer to Field Name with a ? in it in MS Access VBA code [closed]

Simple question, but I am new to databases. I have a field called 'ActorRetired?', and in some VBA code I need to set the value of it to -1. But When I try: Me.ActorRetired?.Value = -1 I get the ...
user avatar
0 votes
1 answer
89 views

Microsoft Access Move Multiple Rows In Table1 To A Single Row In Table2

I'm new to Microsoft Access so my terminolgy and understanding are limited, please bear with me. I am interfacing a piece of lab equipment via Serial/ASTM/ODBC to MS Access for Office 365 MSO 16.0.12....
user avatar
  • 1

1
2 3 4 5
14