Questions tagged [microsoft-access]

Microsoft Access is a rapid application database development tool.

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

Excel Queries suddenly giving "File In Use" on Refresh all

I've been trying to troubleshoot an issue that came up with one of our clients. They have a number of Excel sheets that query data out of an Access Database file, used to quickly view data on some ...
0
votes
0answers
17 views

Change font size in Access Design View

Is there anyway to change font size or whole size of this table in the Design View in Access?
5
votes
1answer
71 views

Access crashes when opening linked table via MySQL ODBC driver

We installed the 32 bit ODBC driver (8.0.27) for MySQL on a Windows 10 machine Made a successfull connection via SSL to a MySQL 8 server Initially tables most table can be opened, but Access crashes ...
3
votes
3answers
156 views

How to unroll a row in Excel, to have a better view for editing?

Let's say we have an Excel spreadsheet like this: Is there an easy way, ideally built-in in Excel, to "unroll a row" to be able to: have a better view of all the data in this row have an ...
0
votes
0answers
14 views

Access database advice

I'm new to access so this might sound stupid. I have few thousands csv files, each one containing few hundred rows of transactions data for an item. Each csv file is a different item. I want to use MS ...
0
votes
0answers
18 views

MS-Access keeps stealing focus from VBA

When I'm working on MS Access VBA scripting, the Access application keeps stealing focus from VBA, even mid typing. So I will be typing code, there will be a pause, a brief lock up, and all of a ...
0
votes
1answer
44 views

I need help designing this query. I can't use a JOIN statement. One column is referenced in two different contexts

I am working in Microsoft Access because this is what my professor wants. I've designed a University database. I have a Student table with a Department code for the student's major (FK to DCode in ...
0
votes
0answers
17 views

How can I view non-default databases associated to a user in Microsoft Access

I have an AD user account nested in a group where the group was given access to several DBs (db_reader) on a SQL 2016 server, Excel is primarily used to interact with the data and when the user starts ...
0
votes
0answers
17 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 ...
0
votes
1answer
60 views

MS Word mail merge: "word could not re-establish a DDE connection to microsoft access"

I have several mail merge documents that I created in MS Word 2007. These have worked very well with MS Access 2007 for years. The only problem that I had to solve during creation of the documents was,...
0
votes
1answer
42 views

Shortcut Shift + F2 for MS Access doesn't work

I started to learn MS Access. On a Youtube video they said that when you use the shortcut Shift + F2 you get a zoom window which is interesting when you want to type a long text. When I try this ...
0
votes
1answer
339 views

MySQL Server configuration, is it enough for my needs?

I've never dealt with MySQL before, so I am very new at this. I am connecting my MS Access front-end to MySQL server. The server configuration is 2 CPU Cores, 2GB RAM and 60GB SSD. The server has ...
0
votes
0answers
18 views

MS Office Update removes my ODBC Connection to MySQL Server

I've had couple times where an Office Update cleared or removed MS Access Database ODBC connection to MySQL server. I have three people using this database, and if anyone updates their Office Suite ...
0
votes
0answers
13 views

Using task scheduler to run MSAccess tasks

I have an access database that transfer data between two server databases. I've been trying to automate the transfer for a while now. I find no way of launching any access file from task scheduler (in ...
0
votes
1answer
79 views

"Operating System is not configured to use this application" when migrating a DB using the Access SQL server migration assistant

I have (re)installed Microsoft SQL Server migration assistant latest version today, and i have installed Ms SQL server Management studio 18 in order to migrate my accdb access database from Access to ...
0
votes
0answers
17 views

MS-Access report: Make Headers be on same row as first row of details

In a MS-Access report, when the data is GROUPED ON one or several fields, each one creates a row where its HEADER goes. While this makes the report very organized and clear, it wastes up too much ...
0
votes
0answers
8 views

How to sort chart by field that is not in the chart?

I have a query table with 3 fields: [Priority] (An integer) [Employee Name] (A string) [Sales] (A Double) In the report, I want to create a column chart of [Employee Name] (x-axis) vs [Sales] (y-...
0
votes
0answers
15 views

How to diagnose why Query in Microsoft Access is returning wrong results

I have a database in which I store information about what work our contractor is doing for us. Basically I store WorkNumber, date when work was done, contract number, subcotnract number (we have ...
1
vote
0answers
10 views

How do I get MS-Access to show the Value for Grouping in my Report instead of only the indexing ID number(s)?

Well...I'm perplexed. I'm pretty new to Access, so I'm not terribly surprised when even simple things escape me. I've created a dB for Safety Data Sheets where I work (thanks, OSHA, for job security). ...
1
vote
1answer
23 views

Disable the 'New' box in Ms Access in favour of a normal dialog

When I start Microsoft Access these days, I'm presented with a truly awful New database dialog that I have to click another button in order to browse to a location that I want. As I'm always creating ...
0
votes
1answer
40 views

How to report on least values in each category in MS Access?

IN MS Access, I have a table with a few different parameters, like this: Element Weight (g) Smallest Dimension (cm) Orange 100 5 Apple 90 4 Banana 130 2 Grape 40 1 These are grouped into sets, ...
0
votes
0answers
6 views

SharedMS Access database will not email using DoCmd.SendObject

I have created a shared MS Access database on our network. If one person is in the database the DoCmd.SendObject command works to "create" a entry, but when multiple users are in the ...
0
votes
1answer
18 views

On Access, How do I Query like if 3 or more fields are 'True' then show the record?

Is there a way to run a query to show records that have 3 or more check box fields selected?
0
votes
0answers
9 views

Importing multiple .cvs files into a single Access table

I have followed the code shown and inserted my own variable / strings as directed. When I ran the code I expected the data to be imported into a single access table, instead the data is imported into ...
0
votes
0answers
42 views

Updating Access Tables from VBScript using Task Scheduler

This is a follow up from this question. I'm attempting to update some tables from an external data source every night. The way I attempted to do it was by using Task Scheduler to open the database and ...
0
votes
0answers
28 views

MS Access sub-form combobox disappears when linked to SQL Server table

I have an MS Access frontend with both an Access and SQL Server 2019 backend. I am converting the Access backend to a SQL Server 2019. However, when I switch my source table tblFiresCostEstimates from ...
0
votes
0answers
13 views

Using a GPO to disable "Ignore DDE requests" in MS Access

I am looking for a way to disable the option ignore DDE requests in ms access with a gpo or a registry edit, but so far my goole-fu has let me down. The only way i found would entail logging in as ...
0
votes
1answer
164 views

Windows Task Scheduler Not Running Microsoft Access Script

I have a script setup in an Access database that I want to run nightly. I've setup a task in task scheduler to run every day at 4:00am. It opens the database, runs the script, and the last line of the ...
0
votes
1answer
21 views

Access: How to use IF function to fill out the specific column based on the value from another column

In Access database, one column is Asset Value that is currency format or it could be numerical, and second column is Insured that is CheckBox or it could be a text format. I have to create code that ...
0
votes
0answers
50 views

ODBC Data Source Administrator not working with Microsoft Access driver

I am trying to create a system DSN using the ODBC DS Admin (32-bit). I need to use the 32-bit version because I will be interacting with a program that is only compatible with DSN's created using the ...
0
votes
1answer
40 views

Excel to access file data tranfer by SQL server

I have an issue While Transfer Data From Ms Excel to MS Access by SQL Server here is my program Public Sub DoTrans() DoEvents Sheets("Temp").Select Set cn = CreateObject("ADODB....
2
votes
1answer
267 views

Open an Access database in LibreOffice Base

I try to open a access database in LibreOffice Base First, I installed LibreOffice sudo apt-get install libreoffice Then I downloaded UCanAccess (http://ucanaccess.sourceforge.net/site.html) and ...
0
votes
1answer
40 views

MS Access 2019 - questions about editing and running SQL queries

In the past I've worked with SQL Server and PostgreSQL, using SQL to run queries. At the moment I'm trying to get more familiar with MS Access, and I run into some problems. I prefer to write queries ...
0
votes
1answer
34 views

MS Access Freeze when opening file

It might be something simple, but I can't find anything on the web yet... When I try to open a file on MsAccess it just freezes completely. No error given or anything. It started with the runtime for ...
2
votes
1answer
54 views

Moving MS Access from on PC to another

I have MS Access on a PC and during the course of a rebuild will need to install it on a different hard drive, I have the CD it came on but no longer have a CD drive. Is there a way to copy to the MS ...
0
votes
1answer
36 views

Access mdb super slow queries

I have an access mdb database file with four tables in it. It's not overly large (46MB). It has run for the last two years with no isses, generally fast and quick to respond to queries. I the last ...
0
votes
1answer
12 views

Need to use logical operation in an MS Acess query field

Let's say I have a table in MS Access. It has a text field, "size". There are only a few values size can take: "tiny", "small", "medium", "large", &...
0
votes
1answer
1k views

How to edit files in EFI partition on Windows 10 [duplicate]

I want to edit my Clover boot entries from within Windows 10 to add back my linux mint listing in clover. I could boot my Linux Mint from clover until I was forced to reinstall my Linux mint instance (...
1
vote
0answers
12 views

Read table metadata from multiple Microsoft Access databases

I have 30+ Access databases in a directory. I think that some of them are forks of other databases in the same directory. A way to detect them is to check creation times of tables, but this way I need ...
1
vote
0answers
35 views

What is the VBA coding for getting data from multiple tables in Access?

I am a newbie in access VBA coding. I would like to get the data from multiple tables which table name begin with "AB" and show the result in the combo box. I have around 50++ tables and ...
0
votes
1answer
78 views

Microsoft Access: How to merge rows and sum values

Sorry if this is an amateur question, I am pretty new to Access but couldn't find this answer elsewhere. I have 8 tables indexed by branch codes, each with 12 columns for amount sold during each month ...
1
vote
1answer
878 views

Microsoft Access Database Engine - cannot install either 32-bit nor 64-bit version

We have a workstation running Windows 10 (1709.16299.2166) with Office 365 on which I was asked to install Microsoft Access Database Engine 2016 for a consultant. After downloading the installer for ...
0
votes
1answer
36 views

MS Access how to show records where in Field is "XYZ"

I Have a Query to show me records. I want it to show me all records when in a Field (let's name it Letters), is "XYZ". The thing is some entries start with XYZ, in some it's somewhere in the ...
1
vote
1answer
5k views

What's the install location for the Microsoft Access Runtime?

I've seen several references online that suggest various locations for where the Access Runtime is installed - but no definitive answer that gives install locations for each version. I'm interested in ...
0
votes
1answer
60 views

Including information from one database into another - MS Access

I have created a new table in MS Access which, for my purposes here, I'll call Table A. It contains a ton of information that staff need to enter for each company or individual. The forms are time ...
0
votes
1answer
79 views

Using a field in another table in a calculated field in Microsft Access 2016

I have a database with two tables, the first is called 'auction' and is a reference to an order I made on ebay. It contains the auction details and, importantly, the total amount I paid for that ...
0
votes
1answer
301 views

1114: A dynamic link library (DLL) initialization routine failed

I have a software application that I wrote which uses Microsoft Jet drivers. Today I had this error when starting the program: I reininstalled my Microsoft Redistributable Engine (2016) and the error ...
0
votes
1answer
29 views

Linking 2 forms using ID

I am creating a database for customer laybyes and deposits. I have a form called active list, what I am trying to achieve is to link the active list form with other forms containing Laybye details and ...
0
votes
1answer
33 views

Access deleted several records when data type changed. How to find which ones caused the errors?

I'm trying to work with an old Access database. It has a column formatted as Short Text that I need to change to numerical data. To attempt to change the data type, I opened the Design View and ...
0
votes
1answer
61 views

Access - Link to Outlook Contacts

in Access I had a linked table sourcing from Outlook contacts, which I then used for further data elaboration. Since some weeks I get "unable to find field" error. I then tried to: create a ...

1
2 3 4 5
15