Questions tagged [microsoft-access]

Microsoft Access is a rapid application database development tool.

Filter by
Sorted by
Tagged with
2
votes
1answer
41 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
0answers
9 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
9 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
57 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 (...
0
votes
0answers
6 views

Multi value cells for reports

We use MS Access to create inspection reports on a daily basis. In one of the columns we put an operation number associated with the item to be inspected and when a report is pulled you put in the ...
0
votes
0answers
4 views

Is there a setting to make it easier to resize MS-Access Subforms?

Recently I find it difficult to resize subforms in MS-Access with the mouse. If I move the mouse over the bottom right corner of the subform then it's relative easy to find the spot where the curser ...
1
vote
0answers
9 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
27 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
0answers
11 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 ...
0
votes
1answer
54 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
19 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 (lets name it Letters), is "XYZ". The thing is some entries start with XYZ, in some it's somewhere in the ...
0
votes
0answers
21 views

Cannot installing visio on windows 10

i have problem installing Microsoft visio on windows 10 either 64 bit or 32 bit, when i try in 64, it said that there is 32 bit program (Microsoft Office Professional 2013) on my device, and when i ...
1
vote
1answer
441 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
59 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
0answers
11 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
111 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
17 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
0answers
48 views

Converting from .accdb to .mdb

I want to use MDB Viewer Plus to convert a .accdb 2007 to a .mdb of 2003 but I'm getting this error: I'm on a work network and can't download much, so I'm stuck using MDB Viewer Plus and wanted to ...
0
votes
1answer
16 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
0answers
37 views

MS Access Linked Excel File “External table is not in the expected format.”

I connect excel sheets to access databases via this option: External Data > New Data Source > From File > Excel The access databases and the excels file are both located on my C drive. When I ...
0
votes
1answer
46 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 ...
0
votes
0answers
11 views

Has MS Access 365 passed Alpha phase yet?

I am trying to solve what I thought is a simple task: Import a CSV file into MS Access 365 (V16.0.12624) do some data manipulation Save data a CSV file This is what I encountered: 1) Import: Import ...
0
votes
0answers
22 views

Microsoft Access: Linking a table post to it's form

First time writing here! I am creating an CRM-like system in Access. I have a table consisting of wards on a hospital. I have made a form with an UI where information can be stored etc. I am now ...
0
votes
0answers
115 views

How to export Access database table exceeding 4 million records to Excel?

I have an Access database with 1 table with over 4 million records. I would like to read this in with Python, but the pyodbc module is giving me issues. Another approach I'm considering is to export ...
0
votes
1answer
100 views

Import text as text in Access

I'm trying to load a large CSV file into Access, since I am joining tables that are too large in Excel, and I've been having issues with Access's "intelligence" (or lack thereof) in the ...
1
vote
1answer
199 views

Microsoft Access: Query to delete duplicate data but keep most recent

To my surprise, I've been having trouble finding an answer to this question for my specific case. I have a table with ID and date and I would like to keep only one ID, and that is the most recent one. ...
0
votes
1answer
148 views

Copy attachments from records in one recordset into records in another using VBA in MS Access

I've almost got this working. I'm thinking I really just need another set of eyes on this. I think my problem is just a simple programming structure issue. Either too many loops or opening/closing ...
0
votes
1answer
12 views

Configure one form to be floating while the rest are tabbed? MS Access 2016

I have an MS Access database that is currently configured to use "Tabbed Documents" as shown in the "Current Database" properties. I like the appearance and cleanliness of tabbed ...
0
votes
0answers
17 views

Shortcut Argument to Open a File with Microsoft Access

I'm using SSE Setup to create executable installer to distribute my application which has extension .sdb and I want to open this application with Microsoft Access. In SSE Setup, we have option to add ...
0
votes
2answers
157 views

Using VBA in Microsoft Access to read a Microsoft Excel workbook and then close it gracefully

I almost have this working. However, what I'm finding is that Microsoft Excel remains open in the background (as visible in Task Manager) even after my VBA procedure is completed. If I run the ...
0
votes
1answer
183 views

MS Access VBA; select records from table filtered by date

I have a table called tblAuditForms. This table includes a date column called AuditDate. The table stores the date in "short date" format, so the time is not stored in the table. I want ...
0
votes
0answers
7 views

Access 2019 - Err 13 data mismatch - everything works fine on Access 2010

does any of You spotted recently a problem with Access 2019 - and error 13 data mismatch? The error occured "suddenly" - till few days ago everything worked fine. Could it be some update of Access or ...
0
votes
1answer
24 views

MS Access 2013, where is my toolbar and vba editor?

I am trying to get into the codes for my access file, my file has no toolbar options, do I have some light version of access or something? or is this file locked? Was trying to get to full options ...
0
votes
0answers
82 views

Importing huge dataset held in POWER PIVOT table to Microsoft ACCESS

Background I am trying to make a database, but am having issues importing data into microsoft access. I have huge files, 4000,000 rows long and each one needed merging with much smaller tables. What ...
1
vote
1answer
2k views

Access Database repeatedly “in an inconsistent state” and “caused a serious error” - recurring issue

We have an Access Database that lives on a server in a shared folder. A few months ago the database was unopenable due to error messages like: The document caused a serious error the last time it ...
0
votes
0answers
13 views

Inserting values from a ComboBox selection

I am a beginner using Access. And I am creating a database to log telephone calls. I have two tables, one called 'Families' and another one called 'Call Records' 'Families' has the following fields: ...
1
vote
0answers
27 views

Search / Export MS Access Schema and Forms

I am adding features to a complex Access database with many forms, tables, and queries. It is often quite challenging to locate the source of some behavior. Is it VBA code? Is it a form property? ...
0
votes
0answers
22 views

Strange MS Access Behavior - is this corruption?

Not sure where to turn with this. We have no MS Access Experts, but of course, we have a bunch of Access databases floating around that people use All of a sudden, on 4/1, a given database lost all ...
0
votes
1answer
25 views

Allow only one checkbox per unique user in Access Table

I'm building a list of phone numbers. Each person can have multiple phone numbers. I want a way to indicate which number is the preferred contact number, however, I'm uncertain as to how to make it so ...
0
votes
0answers
5 views

Microsoft Access Show data entries that violate Field Validation Rule

When changing the validation rule for a field (or clicking run validation tests in design view) Microsoft Access will prompt me with a message box in case some existing data violates the new rule. I ...
0
votes
0answers
18 views

Chart Axis Colour in Access Modern Chart

I have a bar chart on one of my forms and would like to either remove both X and Y axes lines or alternatively change their colour so they do not show. I can't see any of the option in properties and ...
-1
votes
2answers
55 views

How can I extract specified values from a string in excel document? [closed]

I have a column in excel that is linked to a table in Access. How can I extract certain values from the string when the values and location vary by row? I have a query linked to this table so I am ...
0
votes
0answers
32 views

Is there a way to run ms access applications with vba code correctly on mac?

I am trying to run MS Access application that includes VBA code on a mac device but unfortunately, there's no access version for mac os. So I ran windows 10 on it using bootcamp and installed ms ...
0
votes
1answer
24 views

Conditionally update field in datasheet view when row is modified? [closed]

I have a requirement for an Access Database to add 3 new fields: [Entered By], [Entered On], and [Reviewed By]. Part of the requirement is that when the record is modified the [Reviewed By] field ...
0
votes
0answers
21 views

How can I add a specifc Text to a column in a query and have it a specific data type and length, for dbase export?

The following query will be exported as a dbase 3 database: Select A, B, "TRUE" AS C FROM [List] WHERE B LIKE "cont"; If I export this, the dbase will read for colum C C,C,254 Means, C the name, C ...
0
votes
0answers
21 views

open MS Access database with username from cmd - with shortcut possible too?

I have to open a Access Database with a username. I have to use cmd SET username=yyy And open the database from there, command found here Is it possible to open this database with a given username ...
0
votes
0answers
161 views

How to link multiple fields in two different tables in MS Access

I am teaching myself MS Access to set up a master contact list and I am running into a problem. I have table of PEOPLE and a table of ORGANIZATIONS. In tbl_PEOPLE I have multiple fields including ... ...
0
votes
0answers
112 views

Rich Text Box Hyperlink does not work in MS Access 2016 Split Form Datasheet Section

I am using a Split Form which has a Rich Text box containing HTML formatted hyperlinks to certain files on my local computer. Everything is working fine except that when I open the Split form in "Form ...
0
votes
0answers
450 views

How to setup Oracle ODBC for MS Access 64bit on windows

I have used more time on getting ODBC for Oracle to work than I would like to admit. The crest is simple. Link tables from MS Access to Oracle Everything is running 64bit. Oracle Express 11.2G, ...
0
votes
0answers
9 views

Optimize data import to MS Access 2016

I am having a problem where I attempt to import a file to Access, but the import process bogs down and Access crashes. I am doing this in a desktop environment, and must use a specific desktop for it: ...

1
2 3 4 5
15