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,678
questions
1
vote
2
answers
51
views
Sql query not return data
I use this code for choose code number a procdut in VBA Access and test for found duplicate save product.
Dim db as dao.database
Dim rs as dao.recordset
Set db = currentdb
Sql_string = "SELECT ...
0
votes
1
answer
88
views
SQL audit log files are getting too large
For context we have a huge MS Access environment and we are trying to get rid of it. We have removed the previous data table locations and provided an SQL DB for them to connect to instead. One of the ...
0
votes
1
answer
37
views
Access-Dynamic Forms
I have a form "alpha", which I am trying to dynamically alter. My code currently is very simple:
Dim frm as Form
Dim strName as string
StrName="alpha"
Set frm = CreateForm(...
1
vote
1
answer
41
views
MS Access form; only lock the controls when value is 0 and not when the value is empty
I need to lock all controls on the main form and a subform when the total of the sub form is 0. The unbound control on the main form holding the value is named sumBalance with the control source ...
0
votes
1
answer
50
views
Simultaneous connections in an access database
Issue:
I have two applications one desktop and one web application that interface to the same access database (I know it is not the best, but the desktop application was developed years ago and it is ...
0
votes
0
answers
58
views
VBA MS Access bind ADO recordset to server side cursor
I am trying to bind ADO recordset from SQL Server to Form but cursor to be on server side. If I use adUseClient, working fine, but I can't find way to use adUseServer. Any help would be appreciated.
...
0
votes
2
answers
52
views
I can create query on MS Access and retrieve data from server with sql statement Got error with pass-trough query?
I have SQL Server developer edition installed on my laptop. I can create query on Microsoft Access and retrieve data from server with this sql statement:
SELECT Products.*
FROM Products
IN '' [ODBC;...
0
votes
0
answers
27
views
Update datagridview control in c# with Access Data Source
**I am programming in c#, and I have a problem with a datagridview. The datagridview data source is an Access table, and it allows me to add new records without problems, but it does not allow me to ...
1
vote
1
answer
20
views
MS Access (office 365) linked tables to SQL server are giving me date fields with the day of the year appended to the year
MS Access is converting SQL Server date format "2023-01-01" into 01.01.20231
or "2023-02-28" into 28.02.202359.
The appended number is the day of the year. Anyone have an idea why.
...
-2
votes
1
answer
59
views
No value given for one or more required parameters. in Vb6.0
Private Sub cmb_dept_name_LostFocus()
Call CloseAllConnections
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Data.mdb;Persist Security Info=...
0
votes
0
answers
30
views
i have a main form and a subform inside. the subform is a continous form connected to the main form by parent and child link
I want my subform to have a sequential numbering on the left part and it will be dynamic depending on the loaded data from the relationship between the main form to subform by the parent and child ...
0
votes
0
answers
44
views
Change the Outlook folder that a linked table in Acccess is pointing to using VBA
I have an Access 365 application with a linked table containing emails from a given Outlook folder. I want the user to be able to change the folder that this linked table is connected to from within ...
0
votes
0
answers
29
views
How can I set a simple delivery date in ZugFerd/konik?
I try to set a simple deliver date in Zugferd/konik. I got the class example from Access-im-Unternehmen and it runs fine for all examples given there. I call the class from Access VBA, and I'm able to ...
0
votes
0
answers
58
views
MS Access handling current value Combo Box not in Row Source anymore
I have a subForm with a Combo Box with Control Source=MemberID and a Row Source Type=Table/Query, the Row Source is a SQL for the table Members.
The current value of the Combo Box is not available ...
1
vote
1
answer
42
views
Query without Locking in MS Access
I have various csv files that export daily with raw data. I link these files into an access database and then have select queries that connect spreadsheet dashboards to the database. Several users ...
0
votes
0
answers
28
views
Having trouble with MS Access percentile query
I have a MS Access table with a Category field and DollarAmount field.
I'm trying to query the table where it groups the data by Category and then shows the 10th percentile of the DollarAmount for ...
1
vote
2
answers
36
views
VBA Using InStr() match a record in Table A to a record in Table B, then update a field in Table A with a value from the matching Table B record
I'm having one of those days where everything has gone blank.
Simply - I have two tables, called WordyA and WordyB.
WordyA contains a field called 'Answer' and may contain values such as 'Excellent, ...
0
votes
1
answer
47
views
MsAccess subform current record highlight
MsAccess by default highlights the current record of a subform with a different background color than defined in Section.Backcolor or Section.AlternateBackcolor.
Is there a possibility to change the ...
-1
votes
1
answer
134
views
How to count the ponderated occurrences of each string accross the whole table and all columns with SQL?
morning !
here are 3 tables :
materials :
lists all the materials available :
material
max
animalfat
30
arrow1_broadhead
40
arrow2_smallgame
40
arrow3_poison
8
arrow4_fire
8
arrow5_dynamite
8
...
0
votes
0
answers
54
views
Extract data from older version of microsoft access mdb using pyodbc
I have a lots of access .mdb file that I need to process using python and that data to store in excel file. Currently I am testing pyodbc library, everything works fine with test databases created in ...
-1
votes
1
answer
78
views
How do I refer to a field in a lookup query and complete action based on value?
I am working on a database for my store inventory in MS Access.
There is an "orders" form where my staff types in the item and the quantity the customer requested. Right now, there is ...
0
votes
0
answers
36
views
Ms Access - VBA - ADO conflict [duplicate]
In my access VBA code (Access Professional Plus 2021), I simply want to check if a table exists with the line :
If Not DBEngine(0).TableExists("MyTable") Then...
I wanted to, hence, add the ...
0
votes
0
answers
59
views
Getting error number 3464 data type mismatch in ms access vba
I'm not sure if it is because of problems in the below SQL coding which gives me both the Error 3464 Data type mismatch in criteria expression, and runtime error 91 object variable or With block ...
0
votes
1
answer
33
views
One to many relationship with a composite key table
There may be a better way to do this, but here it is
I am trying to record shipping prices
The elements are
shipping zone
shipping weight
3 carriers UPS, USPS, FEDEX
7 Zones 2 through 8
Table 1
UID
...
1
vote
1
answer
72
views
Access 365 convert text back to BigInt
I have an entire process in Access with many queries that was written before BigInt was supported. There is a table that I had to import because it contained a BigInt field. Now that I'm on O365, I ...
0
votes
0
answers
67
views
VBA SQL syntax fix selection
please help me with this code. I dont know any VBA and am barely familiar with SQL.
This is the DB at the company Im working.
I want to change the INSERT with SELECTED values:
I want to use this logic:...
0
votes
1
answer
44
views
Access - compare headers on two tables
I have two tables. Each should have the same headers. However, we find that one table will be missing a column (reports received by a 3rd party)
is there a way to check that all the headers on table ...
2
votes
1
answer
71
views
Access.Form issues using CallByName in MS Access (also how to get Inter-form Communication working)
The background here is that I've been periodically attempting to implement a nice generic method for communication between non-modal, pop-up access forms and their calling form (why is basically ...
0
votes
0
answers
55
views
Access Error msg: Syntax error (missing operator) in query expression [duplicate]
This is the relevant SQL:
strSQL_SRC = "SELECT tblGroupEmailType.GroupEmailTypeID, tblGroupEmailType.GroupID, " _
& "full_PGAL_Sth_Master.[Office-Email], &...
0
votes
0
answers
53
views
Run 32 bit python script in a 64 bit program
I am having an issue with my current program. I have a GUI program I made using pyside6 (using python 64bit). The program needs to write data to a Microsoft Access Database that is stored on a network ...
1
vote
1
answer
82
views
MS Access/SQL query with duplicate records
I need some help figuring out how to structure a query in MS Access to be used to create a monthly report of profile/role changes of the employees. Table tbl_mov is made by comparing staff on month[n] ...
0
votes
1
answer
43
views
Access button feature lost after splitting
I created an access database that had multiple menus forms, some of which only linked to other menu forms. For Example i have a main menu form, on this form i have a button to take you to the ATL Menu ...
0
votes
1
answer
46
views
How can read the list output and load into ms access?
If anyone can help with the python script
My output is list format which I need to insert into ms access.
I achieve the list from the below python script.
import csv
import urllib
import pandas as pd
...
-1
votes
1
answer
89
views
Need More Verbose MySQL ODBC Error Message [duplicate]
I am using an MS Access form to update a MySQL database via ODBC. The form has three fields that can potentially cause a foreign key constraint violation. When one does, I unsurprisingly get a "[...
1
vote
1
answer
23
views
Field in DB Form display Index number vers content from field the bound table
Hello All, I'm copying records from one table "Abgabe_Unterlagen" to another table "Ordner_Liste" after a condition is met.
I cannot get the all the entries from the table "...
-1
votes
1
answer
45
views
Can't save the value of textbox when i close the form and reopen it again
Help please
I wanna keep my textbox value displayed when i close the form and reopen it again in microsoft access
I tried various solutions but all failed whether macro or vba codes in microsoft ...
0
votes
0
answers
30
views
How to add a gradle ODBC driver to connect with xlsb files
I tried connecting with an xlsb file as a Database to support a legacy process.
(Since the Apache POI for xlsb files is not supported well)
Below is my code:
try{
Connection ...
0
votes
0
answers
49
views
Add new record to existing table in MS Access DB
I'm trying to use a Command button in a Form to add a new record to an existing table but I'm not getting it to perform.
Private Sub AddRecord_Click()
'On Error GoTo Err_AddRecord_Click
Dim ...
0
votes
1
answer
41
views
SQL - Extract latest transaction dates from a table grouped by asset (MS-ACCESS 2010)
I am building a query to display the most current transactions (date) from a transaction table which are grouped by "Asset" (column B) so I can assign a current status to the asset.
Table ...
0
votes
0
answers
30
views
Access mdb file Cannot reference itself
I have an access database I am migrating from an older version. I have a form with a grid on it. When I right click on the object name and select Definition I get a popup that says "Cannot jump ...
1
vote
1
answer
48
views
how to gather categorized monthly sales in ms access form and retrive them as new record per month-product-category
I have designed a sales budgeting system using "MS Access" in which users can assign sales Value in addition of sales price for different months along with some other functionality.
Here is ...
1
vote
2
answers
99
views
Copy records from one Table into another by VBA
I have a DB that collects input via a Form"Abgabe_Unterlagen" into a Table "Abgabe_Unterlagen."
Tables and Form:
After all actions are taken and records are completed the user ...
1
vote
2
answers
66
views
How to open Access from the taskbar?
I had being reviewing the forum and trying several ideas but still have the problem. I am running Access 2013, in a form I hit a button to spell and grammar check a text field. The check is done ...
-1
votes
1
answer
43
views
MS Access SQL Select most recent date per ID and per Skill
I have this table where each candidate has multiple skills and each of their skills has multiple entry dates (to track their progress in improving each skill over time).
I have this sql statement:
...
0
votes
1
answer
101
views
Sending email via Outlook 365
I am updating an old program. I noticed in the new build the email send doesn't work.
I searched for the reference. Is there a way of sending without the reference or where is the reference for ...
-1
votes
1
answer
40
views
Using MAX(), GROUP BY and INNER JOIN together
I can't quite see how to make this work but maybe I am just tired.
I want to see all the records from survey that have survey.depth greater than collar.max_depth. The linked fields are hole_id in both ...
0
votes
0
answers
22
views
Microsoft Access Connection using Python error [duplicate]
import pyodbc
from PIL import Image
import io
# Connect to the Access database
conn_str = (
r'DRIVER={Microsoft Access Driver (*.mdb,*.accdb)};'
r'DBQ=C:/Users/MeriAnes/Desktop/base5.mdb;'
)
...
0
votes
0
answers
46
views
Signing an Access file without an extension .accdb or .accde does not work
For some time now it has been possible again to sign Access VBA code with the current Access 365 version.
This also works as long as the extension of the Access file ends in .accdb or .accde. If this ...
1
vote
1
answer
61
views
C# & OleDB error with SQL parameterized query
First of all sorry if the formatting is poor, I'm new to this.
Okay so I recently started learning C# in order to program a local database software. Now the book I'm using has a chapter on this but at ...
1
vote
0
answers
74
views
Type mismatch error when calling a procedure that returns a string array
I have a function procedure called GetOfficeEmailAddressesForGroupID.
This is the code for it:
Public Function GetOfficeEmailAddressesForGroupID(lngGroupID As Long) As String()
' this procedure ...