Questions tagged [microsoft-access]

Microsoft Access is a rapid application database development tool.

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

How you you create a report in access using only one field from one table?

I have a table [tblCheckIn] with only two fields: PASSHOLDER & CHECKINTIME I want to create a report using CHECKINTIME that shows total number of check-ins we had for each given year. Like so: ...
  • 174
0 votes
2 answers
16 views

How to change the path of Microsoft Office Soap Type Library in Access 2010?

I have OFFICE14 and OFFICE16 in Microsoft Share folder. I have two questions: As you can see the last few words in the path are cutout. How do I look at the full path here. How to change the path of ...
  • 15
0 votes
1 answer
34 views

MS Access Runtime closes database when there is a mirror error. How to Ignore?

There is a MS Access Database. Sometimes there are pop ups errors: "The value you entered isn't valied for this field" and then a Macro error. But that's OK, I just click "Stop All ...
0 votes
2 answers
73 views

Access append, find the records that are lost due to key violation

I made an excel file, I made it exporting an access table, then I edited the excel file being sure it only contained the records that I wanted to append to the original table. now if I use access and ...
  • 1
0 votes
0 answers
22 views

Microsoft Excel cant access the Microsoft Access database if a network path is used

We have this Excel spreadsheet that has a connection to an Microsoft Access database. The Excel sheet and Access database are located in the same folder on a VM but that folder is a shared folder that ...
0 votes
0 answers
79 views

Power Query Opens Source Data and Then Can't Access It

Full disclosure, I'm kinda new to Power Query but I'm running into some weird problems. I'm used to using Data Connections in older versions of Microsoft Office to connect an Access database with an ...
  • 1
0 votes
1 answer
66 views

How to make an exe from Windows XP, Access 2000 run on Windows 10?

I have an exe from my college days, created on windows xp, and it used an access database of unknown version of that time. I tried opening it in my current PC, which is Windows 10, with Office 2019. ...
1 vote
0 answers
79 views

Mail merge using Access query containing long text fields - long text fields are empty in word document

I am trying to do a mail merge in an MS Word document based upon an MS Access query that contains long text fields. For some reason, the entries in the long text fields do not show up in the Word ...
0 votes
0 answers
8 views

Customer addresses: Prevent user from selecting more than one default

I'm working on an MS Access database using the latest version of the software. Here is an abstract version of the problem I'm facing (the real version has nothing to do with customers, etc., so please ...
  • 7
0 votes
0 answers
13 views

MSAccess Opens Multiple instances of itself upon closure

This is a weird one, I have a client with a MSAccess program that does something weird every now an then, as the title implies, when the client closes the DB (program) it closes, but then, it opens ...
0 votes
0 answers
206 views

In Access/SQL, how to do an update with an inner join?

I have a report that is populated by the following query: SELECT tblPassHolders.[PASS HOLDER NAME], tblPassHolders.PHOTO.FileData, tblPassHolders.BARCODE, tblPassHolders.[FAMILY PASS], tblFamilyPass....
  • 174
1 vote
0 answers
155 views

Sharing MS Access dB for multi user edit

I need to share a MS Access database file between multiple PCs so they would be able to edit and view the other's edits in realtime. I have no server to make a NAS and Windows File-Sharing service isn'...
0 votes
1 answer
53 views

Why is this VBA data-fetching function hanging?

I have written this function in VBA to fetch data from a URL. I am calling it from another function that is called in an Access query. The code is adapted from code in an article cited in the comments ...
  • 523
0 votes
0 answers
40 views

Why is this VBA data-fetching function hanging in Access?

I have this function in VBA, which I have used successfully before in Excel to fetch data from a URL: '======================================================== Public Function sURLfetch(ByVal sURL As ...
  • 523
0 votes
2 answers
294 views

Error "Unrecognized database format" when opening a .mdb file

I have a .mdb file which I do not know which version of ms access was used to create it. When I try to open it, I get "Unrecognized database format" error. I tried using MS ACCESS 2003 and ...
  • 181
0 votes
0 answers
11 views

Trusted Location still showing security warning for compiled Access DB path

Asked on Stack Overflow but Super User was suggested Been puzzling over this for a few days. I install a compiled Access 2016 database (accde) into a %localappdata% program subfolder and add that ...
  • 134
0 votes
0 answers
45 views

Append Query with Criteria not working

I have an append query to calculate a total pricing and append to table. The sum columns are working properly but the calculation column is not. It gives the error that it is not part of an ...
0 votes
1 answer
65 views

make ODBC link work over VPN

I've created an Access file that contains ODBC links to our web-based ERP system, with a form full of graphs tracking various company metrics against target figures. The Access file is stored on our ...
0 votes
0 answers
16 views

MS Access, query logic: "If Primary exists, return Primary, otherwise return Backup"

Suppose I have the following table: Item Status Image A Primary A.JPG A Backup A-bu.JPG B Primary B.JPG C Primary C.JPG C Backup C-bu.JPG D Backup D-bu.JPG Each item is assigned at least one ...
  • 7
0 votes
1 answer
37 views

How to compare sets of values pulled from a child/junction table?

I'm relatively new to database work, so I may use some terms incorrectly. Please don't be misled by that. Suppose I have three tables: Items, Customers, and a Junction table that connects the two. (...
  • 7
0 votes
1 answer
32 views

Query that treats blanks as having all possible values

Suppose I have the following tables: Field_1 Field_2 Field_3 A B D A C E A C F Z B G Z B H Z C I Field_1 Field_2 A C Z B If I pull these into the Query Design window in Access and join the ...
  • 7
5 votes
1 answer
661 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 ...
  • 1,347
3 votes
3 answers
332 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 ...
  • 1,502
0 votes
0 answers
20 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 ...
  • 15
0 votes
0 answers
75 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
1 answer
53 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 ...
  • 13
0 votes
1 answer
870 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
1 answer
621 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
1 answer
345 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 ...
  • 11
0 votes
0 answers
31 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 ...
  • 11
0 votes
1 answer
221 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
0 answers
21 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
0 answers
19 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
1 answer
58 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 ...
  • 123
0 votes
1 answer
46 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, ...
  • 325
0 votes
1 answer
22 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?
  • 1
0 votes
2 answers
642 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
1 answer
397 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 ...
  • 1
0 votes
1 answer
59 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....
  • 115
2 votes
1 answer
971 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 ...
user avatar
0 votes
1 answer
57 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 ...
  • 7,082
0 votes
1 answer
324 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
1 answer
63 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 ...
  • 405
0 votes
1 answer
148 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 ...
  • 113
0 votes
1 answer
18 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
1 answer
3k 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 (...
  • 111
1 vote
0 answers
21 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 ...
  • 111
1 vote
0 answers
141 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 ...
  • 11
0 votes
1 answer
279 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
1 vote
1 answer
2k 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 ...
  • 115

1
2 3 4 5
16