Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-access]

Microsoft Access is a rapid application database development tool.

0
votes
0answers
17 views

Office 2019 VBA IDE

After installing office 2019 I encounter in some very strange VBA IDE problems (32 bit) (I check it in EXCEL, WORD and ACCESS VBA) Ctrl F - Find dialog, when hitting the "Find Next" the dialog ...
1
vote
0answers
24 views

how do I copy data from one cell to another?

I am working on an expense report that on the main table is listed as "Lodging" in a column. This will have a currency in it for how much was spent. How do I copy the data in that cell to another ...
0
votes
0answers
7 views

ActiveX ListView control in MS Access: ListItems property absent in debugger, but I can add a watch for it

See screenshot. Why would ListItems, arguably the most important property of the ListView object, not be shown in the debugger? Per title, I can manually add a watch for it and expand out the list of ...
1
vote
1answer
13 views

MS Access Conditional formatting not working

Conditional formatting in MS Access is not working for certain fields on my form. I've searched for answers, tried the answers I've found and am still stuck. I have a form with approximately 30 ...
0
votes
0answers
13 views

DB Access - change record with dropdown value

I have a dropdown with a query where I get 4 values (OS: WIn7, Win10, Win8, WinVista) from a table. I now can go to all my Servers and I see their Value since I did this with filling in the ID (I ...
0
votes
0answers
30 views

How do l import data from MSAccess97 or MSAccess4.2 to MSAccess2013?

I am trying to access data from Access 4.2 and Access 97 databases, but all I get is errors like 'Unrecognized database format'. I have tried several options and all I get is error of one sort or ...
1
vote
1answer
19 views

MS Access 2016 report no longer editable after “data type mismatch” error - recoverable? [closed]

After receiving the "data type mismatch" error, which I do know how to fix, I can no longer open the report in Design View. Thus, I cannot get at Report Properties to fix the problem. Is this a know ...
0
votes
0answers
8 views

Count nulls in a row in an Access crosstab query

I have a crosstab query that has dates under the column headings numbered from 1-15. Each row has dates under the numbers. I want to count the columns in each row that have no date. Here's a screen ...
0
votes
1answer
6 views

Is there a way to export a MS Access query or report without showing duplicated cells?

I'm working on a MS Access 2016 database that contains information about a collection of recipe books. I have a few tables for different types of data that are linked to each other using many-to-one ...
0
votes
0answers
17 views

Access Query returning One (1) wrong result

I have a DB that has employee information. When I run a query I include Resignation Date as one of the columns and I place "Is Null" in the criteria to leave out all resigned employees. When I run ...
1
vote
2answers
36 views

Error: Characters found after SQL Statement

I am currently trying to insert a new row of information into a table, and am using the sql view inside of MS Access. When I run this code: SELECT * FROM VersionReleases; INSERT INTO ...
1
vote
1answer
21 views

Transposing columns and values to a key column Microsoft Access

Is there a way I can transpose the data in the format example below. I can export and make it work in Excel but I would really like to be able to automate it in my database. Example: Table Format ...
1
vote
1answer
25 views

Adding a filter to an Access Form

I have an Access DB that tracks all of my students that are going through a certain class i.e. MGMT224 18-01. I have built a filter that already sorts the class numbers and the student numbers for me ...
3
votes
1answer
288 views

MS Access - Grouped query based on MAX field

I am trying to build a SQL Query that takes the following data: +-------------+--------+---------+---------+--------+ | Primary Key | ID | Version | Class | Fruit? | +-------------+--------+----...
1
vote
0answers
36 views

MS Access 2016 auto-sync with SharePoint list on open by VBA

I have an Access database linked to a Sharepoint list. Users will often work on the Access database offline, and catch changes locally. When online again, the user has to manually click reconnect to ...
1
vote
0answers
16 views

Access 2016 - Wizard Error when importing an inbox into Access [closed]

I'm getting a Wizard error when I try to import an Outlook inbox into Access 2016. The error message is: Microsoft Access can't find the wizard. This wizard has not been installed or there is an ...
0
votes
0answers
18 views

Will an Access 2019 .accdb file work in Access 2007?

My client is going to send me an Access 2007 .accdb file. Then I am going to make some code changes to that .accdb file using Access 2019. When I send it back to my client will the updated file still ...
0
votes
1answer
84 views

Excel: How to set up data for Feedback Analysis

I'd greatly appreciate any help on how to set up data correctly in Excel for this analysis (excel professional plus 2016). I'm hoping to be able to analyse feedback collected from training ...
0
votes
0answers
52 views

Microsoft Discovery and Risk Assessment Server 2013 Installation

I am trying to find MSI for MS Discovery and Risk Assessment Server 2013 installation. As a pre-requite this also requires installation of "Audit and Control Management Server". I have not been able ...
0
votes
1answer
24 views

Select cell value not the whole records [closed]

When I'm trying to select all of the value for specific cell using Ctrl+A it selects all of the records,So how can I just select the value ?
-1
votes
0answers
20 views

Access view SQL ad hoc query & output side by side

In MS Access, is there a way to view the sql query window and the related output side by side? I want to be able to write / run sql ad hoc queries and view the output simultaneously so I don't have ...
0
votes
0answers
27 views

Making registry changes to current user not applying outlook settings

I'm attempting to set a handful of registry keys for trusted documents and outlook settings from a batch script I created to launch an application through Citrix. The script works for the most part, ...
1
vote
1answer
147 views

incremental backup with robocopy not working with ms access files

I'm looking for incremental backup of one of my folders in my USB flash drive to my pc I'm using a ROBOCOPY command and has scheduled it on log on event through task scheduler Here's the code I'm ...
-1
votes
1answer
10 views

How to have MS-Access Query Builder return results from multiple “Not Equals” Criteria?

The problem is when you want to use MS Access's Query Builder to perform a search based on multiple 'not equals' values.
1
vote
1answer
29 views

What kind of tables would I need for the following person database made in MS Access 2003?

It's a database about actors and movies. I want fill it with their age too, so I can answer the queries: at what age they made their last movie. what is the average age when they made their movies? ...
1
vote
0answers
66 views

Special characters in filter

I have an Access database for managing trainings of employees. There are 2 cases which are causing trouble and for one I didn't find the solution yet. Case 1: the training name contains C++ Case 2: ...
0
votes
0answers
11 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
7 views

MS Access: Validate field based on another record

I have a table of records. Each record consists of a Machine/line and several productions flows related to the line. I am looking for a way to ensure that there can be only one "Active" record for ...
0
votes
1answer
165 views

How to make a read-only data connection to a read-write locked MS Access using MS Excel?

My concern is that there is a read-write lock in the file I want to connect to because it is being used by an application as shown: Locked MS Access File When I try to refresh the data connection in ...
0
votes
2answers
39 views

How can a read-only purpose data connection to MS Excel/Access from MS Excel prevent the MS Access file from being locked to edits?

My concern is that I use MS Excel to make a data connection with several MS Access/MS Excel files, but there is no writing involved. The only thing the data connection is used for is to extract data. ...
1
vote
1answer
366 views

Exporting Access query to Excel using VBA and creating a secondary axis chart

In MS Access I have a database. I have Form with three TextBoxes and one Command Button. In txttask_plot user writes Plotid In txttask_from user selects date1 In txttask_to user selects date2 The ...
0
votes
0answers
40 views

Access - save your changes to the sharepoint server

When I open an Office 365 Access database I get a message. "Save your changes to the server" with a button labelled "Save to SharePoint Site". This comes up every time I open the database. I close the ...
0
votes
0answers
21 views

How do you add a calculated column in an Access 2010 pivot table

I have a pivot table with totals from Year 1 and Year 2. I want to create a difference column but I can't seem to figure out the syntax.
0
votes
0answers
29 views

Access Database with two different front ends, can't edit when both open

I have an Access Database that is split. I have two different front end files. One is designed for trainers to use and one is designed for managers to use. Up until now, I have been running with only ...
0
votes
0answers
18 views

All INSERTs done through MS Access old untouched forms now fail after creating new unrelated forms

I'm fairly new to MS Access, and the following issue has me completely stumped. I modified an existing .accdb MS Access project by creating new forms via the Form Creation Wizard that allow you to ...
3
votes
1answer
163 views

Counting pairwise combinations from many options in Excel

I have a large dataset of students and the classes they have taken. Each student has taken 12 to 18 of around 80 available classes. Using Excel (2013) I would like to find out, for any given pair of ...
-1
votes
1answer
66 views

Better to use 1 or multiple database tables? [closed]

I am experimenting with databases (using Access currently, as i have it through work). To get acquainted, I am making a database to log catches on my fishing trips. There are several "categories" of ...
1
vote
1answer
26 views

Is it possible to create a “self-relationship” in one table?

I use MS Access 2007 and I want to create a relationship from a foreign key of a table to the primary key of itself. I was wondering if this relationship can be created at the "Relationships" window ...
0
votes
1answer
115 views

How to pass a form radio button value as a query parameter

I am working in Access 2016 and I have a from that the user can select the training type the want to run the report on. All trainings has an option value of 1, Bloodborne has an option value of 2 and ...
0
votes
0answers
74 views

How to unset focus/make cursor disappear in Access?

I have a form in Access; when you put the cursor in a text box or combo box, and then click a blank area, it doesn't go away. Just vexing. I want it to respond like the message field I'm typing in now....
0
votes
0answers
29 views

How to display field in report based on a date

I have an access query that is run from a form based on the employee name they select from a dropdown and a report displays all the trainings for the selected employee. The form has a frame with ...
0
votes
0answers
88 views

Upsert in access

I would like to update specific fields in a table based on data in a seperate table. This would be checking project IDs match, whether there has been updates made and updating the original table ...
1
vote
0answers
490 views

Microsoft Access - Could not find file error, when opening database

This issue is specific to a single computer and a specific file, in a specific shared directory. The file cannot be opened, in its current directory, by any user, from this one machine. The file can ...
0
votes
0answers
17 views

How to merge fields from MS Access form onto a Word Document

I've created a button on a table in my Access database. It generates a MS Word document, which is a letter. My current process has me completing the form by filling in the name and address on the ...
0
votes
0answers
32 views

MS Access Backend hosting

I currently have an MS Access database, split into frontend and backend. The backend is hosted on a Windows 10 pro PC with network sharing. The frontend is distributed to users running a mix of ...
0
votes
0answers
65 views

Using older Access 2000 MDW-file in Access 2013 (and later)

I have an Access application first created in Access 2000. The Workgroup file was created in Access 2000. It worked fine in Access 2007, but when I try to use it in Access 2013 (or later) it says that ...
0
votes
0answers
13 views

Access Database search by checklist

I have a form in Access Database and I would like to be able to select multiple values from a dropdown list and then get all results that match any of the selected values. Unfortunately, I can't find ...
0
votes
0answers
13 views

How to view different MS-Access objects from the same database on different monitors?

I want to view two different objects from the same MS-Access 2016 database at the same time, each on a different monitor. I can configure the database to use overlapping windows, but they are ...
0
votes
1answer
10 views

Access.mdb not retaining original structure when saved

Our Access database currently in the .accdb format (Office 2013) retains a particular structure, showing all the project information on the left hand side (a long list cascading down the screen). Once ...
2
votes
1answer
44 views

Can I use the same Access database for both x86 and x64 database engines?

I have developed a small winforms application (x86 Target CPU) for some of my clients to store data. It uses a Microsoft Access Database. Up until now all of my clients have been using x86 software, ...