Questions tagged [microsoft-access]
Microsoft Access is a rapid application database development tool.
773 questions
1
vote
0
answers
76
views
Microsoft Access, exporting to .xls has shortened text fields. How to get the entire field?
Using Access 365 to open a database that was created under Access 2000 (I do NOT have the option of converting/upgrading it!)
Running a report, and sending the results to .xls (not .xlsx, as it doesn'...
0
votes
0
answers
60
views
Embedded picture appears in MS Access on Windows 10, but not Access on Windows 11
We have an Access database that has embedded pictures. the Data Entry user is on Windows 10. The user is on a form, adds a new record, and right-clicks the picture object and inserts the picture. when ...
- 41
0
votes
0
answers
58
views
When creating a Batch File that executes a macro that deletes an Access table, how do I automatically reply Yes to the Delete Table warning message?
The macro is attempting to delete a table and then recreate the table using a MakeTable Access query (Access version Microsoft 365).
Here's the batch file:
start "" "C:\Program Files (...
1
vote
1
answer
145
views
Why am I unable to unlink back end tables in an Access DB?
I have been tasked to work on an Access DB originally created in access 2003. I need to unlink tables and nothing seems to work. The linked table manager is only allowing linking and relinking.
Trying ...
- 11
1
vote
1
answer
209
views
How to combine multiple Access queries into one query?
I have some data relating to my electricity usage every 30 minutes which I have imported into Access. It is on one table ('Consumption') with three fields namely date, time, and usage ('Interval Value'...
- 11
0
votes
0
answers
658
views
Office Deployment Tool doesn't work
I am trying to use the Office Deployment Tool to deploy only the "Office 365 Access Runtime". I created the following config using the Office Customization Tool:
<Configuration ID="...
- 101
0
votes
0
answers
70
views
Microsoft-Access: Unable to save form data into Table
New With Ms Access want to create a little Database for shop.
Here is My Form structure Based on Table "Sales".
Label Name
Customer Name CustomerID(Combo Box)(FK)
Product Name ...
- 5
0
votes
1
answer
87
views
MS Access: How to insert and manage multiple data under 1 customer
We have a milk shop. Many of our customers borrow milk and pay on a monthly basis. In Excel, we were managing the data, now we want to do it in Access. I can't explain this data format by writing it ...
- 5
0
votes
1
answer
257
views
Why does view SQL for query shows blank screen in Microsoft Access?
I am working with a client and when I open a query using the "View SQL" designer it shows a blank screen. The query works when run from a form or using the "Datasheet View."
If I ...
- 101
0
votes
0
answers
180
views
Why does Microsoft Access 365 close randomly and relaunches?
I am running Microsoft Access 365 [Click To Run - Microsoft® Access® for Microsoft 365 MSO (Version 2410 Build 16.0.18129.20100) 64-bit].
I notice that when I try to open forms or switch from Design ...
- 129
0
votes
1
answer
3k
views
Microsoft Access running slow after Windows 11 24H2 upgrade on laptop with Intel AX211 wi-fi chipset
We're running Microsoft Access 365 with a SQL Server back-end. Performance is generally good, but recently we've spate of complaints about the application going very slow when on wi-fi.
Having done ...
- 877
0
votes
1
answer
209
views
How to remove Command Palette from MS Access
In MS Access, when I open a query in SQL View, all the text in the tab is now displayed in a font about 5 times normal with each line numbered. A right click in the tab window produces a pop-up ...
0
votes
0
answers
294
views
Automatically save all printed files to PDF
I have a custom MS Access tool that creates and prints documents to the default printer.
What's the best way to save every printed file from this tool to PDF in addition to printing it?
- 111
0
votes
1
answer
48
views
How can I total the data from two different columns with the same name from two different queries in Access to get a combined total?
I have two queries pulling same type by different criteria. I need to add two columns that are named the same from each query and add them together to get one overall total.
0
votes
0
answers
82
views
linked table in MS ACCESS that is linked to EXCEL worksheet stops at 549 records
I need to do various calculations , analysis and reporting on data in EXCEL file, so i linked the Excel worksheet as a linked table in MS ACCESS. The tables worked great and data is updated seamlessly....
