Questions tagged [ms-access]
Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server, can also be used as a database server for Access applications.
ms-access
57,827
questions
0
votes
0
answers
23
views
MSAccess - TransferDatabase command not transferring data
I am trying to transfer the data and table structure from one database to another.
My database kept bloating so I moved my linked tables to a separate database and I'm attempting to pull them into a ...
0
votes
0
answers
18
views
MS Access combo box and text box control source
I have a combo box and a text box in a form. The Text box value Control Source is set to the value of combox box + 1. But if the combo box value is 0 or empty the Text Box shows #error. I even tried ...
0
votes
1
answer
23
views
Sending Multiple Attachments to an E-Mail from Access vba
I have the following line of code that will attach an 'attachment' to an e-mail that is being automatically created:
objMail.Attachments.Add AttachmentText
AttachmentText is a string variable with ...
1
vote
1
answer
15
views
Multiple filter between date and category on a subform in MS access >> Type mismatch error
I'm new for the MS Access development. I have been getting a problem to filter subform between filter date and category. It show an error statement that "Type mismatch". I try a lot, but ...
0
votes
0
answers
23
views
Compile Error when opening an Excel spreadsheet from Access
I have various routines within an Access database system that open Excel, open a workbook, make changes before saving it, closing it and quitting. Basically, I use this code:
Dim objExcel As Excel....
0
votes
2
answers
25
views
Query the lowest sub-value where the main value is grouped
I am trying to create a basis for a list of products in an MS Access Query. The basis must later be used in a form where the products are visualized with only one of the many images associated with ...
-2
votes
0
answers
27
views
Using batch files to lock closing an application until something is done in the application [closed]
I am trying to create a batch file that will open an application, closing it after 5 minutes. Then open an microsoft access form and not let you do anything else on the computer until the access form ...
0
votes
1
answer
18
views
SQL UPDATE/INSERT with UnityJDBC - MultiSource Plugin
On SQuirrelSQL client I have installed the plugin "*UnityJDBC - MultiSource Plugin" that allow multiple sources.
I need to an INSERT or UPDATE on a PostgreSQL, but i alway get an error, even ...
0
votes
1
answer
31
views
Can I create a query on people attending workshops with a many to many relationship showing a matrix of how many workshops in common?
I'm using MS Access 2016
I have a visitor table, a workshop table and a linking attending table.
I would like to query this and get a matrix of numbers showing each one in relation to each other in a ...
0
votes
1
answer
34
views
How do I clean up a remote drive using a recordset?
I have a sorted record set ("NewTbl") of the contents of a remote disk drive. This shows a great number of duplicated files and other anomalies. The record set holds the file name, its ...
0
votes
0
answers
26
views
Use query criteria to filter storeName column
I have a form f_Responses with a combobox cboCustomers for getting customer responses. There are two append queries "q_ClearCustomer" and "q_AppendCustomer" behind the On Click ...
0
votes
0
answers
16
views
When I install Access Runtime 2019, Programs and Features show I installed Access Runtime 2016. Is this only 2016 in name only?
I downloaded and installed the executable for MS Access Runtime components from https://support.microsoft.com/en-us/office/download-and-install-microsoft-365-access-runtime-185c5a32-8ba9-491e-ac76-...
0
votes
0
answers
24
views
Access Query - update fields by year
I'm tasked with revamping a process to use Access instead of Excel due to the volume of data involved. This process has 4 years of data; 2021 - 2023 are completed and no changes will be made to these ...
0
votes
1
answer
47
views
Why does my Access control source expression treat the drop-down field selection as a number rather than string?
I am creating an MS-Access form that is supposed to auto-fill the ID number based on the year of the data entry, plus a selected entry type. The entry type selection is from a drop down list on the ...
1
vote
0
answers
37
views
Why do I get "Too many client tasks" accessing an MS Access database through MFC via ODBC despite closing my connections?
I have an MFC/C++ application which accesses an MS Access database via ODBC using MFC's CRecordset class (All very "last century", I know, but so is this app I'm trying to maintain so bear ...