57,924 questions
-3
votes
0
answers
31
views
MS Access Append query halted by mysterious key violation error [closed]
Trying to append rows of data from an imported table into a pre-existing table in my database but all rows failing to append due to a key violation error. There's 10+ fields but I systematically ...
- 1
0
votes
0
answers
77
views
MS Access Exporting Excel file formatted in a way different than what is saved and date in the wrong format
I have setup an MS Access database which handles information imported then exported to an Excel spreadsheet.
Previously the exports were done through the saved exports within MS Access but it required ...
- 553
Advice
0
votes
0
replies
22
views
MS Access -7711 Error MySQL Connector Cannot Make ODBC Link to Tables (Solution Found In Malwarebytes Settings)
This is not actually a question: I simply stumbled upon a solution. In setting up a new (Win11) computer I was having trouble making my usual connection between MS Access on my machine and a MySQL ...
- 103
-1
votes
1
answer
100
views
VBA Code for Recordset to pull information from Table to Form
I am working on pulling information from a table into a Check In & Out form. We will be cataloging helmets using barcodes. With the way I have the form set up, scanning a barcode will ...
-4
votes
1
answer
113
views
MS Access: I have a problem with an object declaration
Someone can tell me what is wrong with my code?
When I click on the btn_prelrep button, I want to get information from equipment input control, that information is concatenated with the path of a file ...
- 459
1
vote
1
answer
107
views
Exporting to PDF using fields as the name
(Follow-on from: MS access Split report and export each row as a PDF )
I am exporting files to PDF based on a a report. Initially to get it working I was naming the PDF files after the Table's ID ...
- 553
Advice
0
votes
6
replies
133
views
MS access Split report and export each row as a PDF
I am completely new to Visual Basic as a coding language coming mainly from Java and SQL but rusty in both of them
in current role I am working with more Microsoft Access Databases but I need to ...
- 553
-1
votes
1
answer
74
views
The objects in my MS Access form display like an Excel instead of a form [closed]
If I double click on the form from the "All Access Objects" pane, it displays correctly.
If I try to display using the following code:
Public Function lookupTitle(ByVal jobTitle As String) ...
- 649
Advice
0
votes
3
replies
105
views
ucanaccess drivers for DBeaver
I am using DBeaver for my students during SQL exams with a MS Access database. The drivers cannot be updated with the ucanaccess driver because the internet is blocked during exams. How can I update ...
-1
votes
1
answer
71
views
MS_Access Use buttons to filter Subform
I am building a visual organizer for a bookcase in MS Access.
I have a main form with a grid of buttons (representing locations like "A1", "B3", "D1"). On the right side, ...
- 3
0
votes
1
answer
111
views
Microsoft 365 Access VBA DoCmd.TransferText Error
I am running Office 365 on a Windows 11 machine.
I created an Access database that loads tables from csv files, runs two queries and creates a CSV formatted report file through the use of modules, ...
- 11
1
vote
2
answers
149
views
How to show true string in Access VBA Listbox
I have here a listbox showing data from tbl2026Test table (with ID as its own autonumber) by a simple listbox rowsource code:
Dim statInProg, statPClarif As String
statInProg = "In Progress"
...
- 785
-1
votes
1
answer
112
views
Check if values from a column exist in another table [closed]
I'm using SQL in MS Access. I have two tables (table_original and table_new) and I want to iterate through each row of table_new and check if the ID column exists in table_original. If the ID exists, ...
- 81
0
votes
1
answer
179
views
Get records where an entered value is in any two columns
Step by step I have made a simple Access file with several tables, forms and queries. All those and also all columns are in Portuguese, but I'll translate them.
The database is related to teabags, ...
- 9
0
votes
1
answer
136
views
MS Access to Excel with CopyFromRecordset
In my Microsoft Access application, I have several table views where I've added the ability for my users to export the results to an Excel spreadsheet. It works fine for all but 2 of my customers. ...
- 59
0
votes
1
answer
110
views
MS Access macro command issue
I have in an autoexec macro with an action of Run Code. The function name is Opening(). The function looks like this
Public Function Opening()
DoCmd.RunCommand acCmdWindowHide
...
- 11
0
votes
1
answer
82
views
How to add an “Other” option to a List Box in Access Forms that allows typing a custom entry using VBA Body
I’m creating a form in Microsoft Access with a List Box for users to select their usual food preferences. The list box options are:
Meat-based (beef, chicken, pork, fish, seafood)
Plant-based (...
- 1
0
votes
2
answers
70
views
Passing an existing GUID as a variable value when creating NEW SQL record via Access
I have SQL database with the following tables. The table structure is condensed for this question.
tbl.Vendor
VendorId (guid)
AccountNumber
Note
tbl.VendorAlert
AlertId (guid)
VendorId (guid)
...
- 11
0
votes
3
answers
146
views
How to randomly assign a unique ID VBA Access
I have here a simple form with a button that is supposed to assign a unique ID of a selected fruit with a Status of 'New' to a FruitPicker (person) every click. Unique ID that will be assigned (may be ...
- 785
0
votes
2
answers
61
views
DLookup with Multi Criteria assistance?
I am seeking to create a multi criteria DLookup for my DB and have not had much luck. I have a db, has 1 form with 3 sub forms sort of like a cascading combo. Lets say I put "Test" in first ...
2
votes
1
answer
121
views
editing form module code programmatically
I have some tools I use for my development and I need to be able to add text to form module, replace and deletee. While this is relatively simple with standard modules, it seems that form modules are ...
- 437
0
votes
1
answer
93
views
User Friendly Duplicate value message [duplicate]
I want to check to see if value from a form exists in Microsoft Access table using vba or macro that is user friendly but need help putting it together.
I've tried, Private Sub Donor_Key_LostFocus() I ...
0
votes
3
answers
148
views
Access VBA German Umlauts
I have a form with 20 text templates which are being inserted in to a textbox, each one with it's own button "Text 1", "Text 2", ... "Text 20". Up to "Text 17" ...
- 7
0
votes
0
answers
62
views
Batch Files sometimes hangs up computer after running when running through MS access M
I run a daily program to convert a pdf to Excel via pdf2xl. Every once in a while the program runs, but the command icon shows it is still running after everything is done. The clock on the computer ...
- 11
0
votes
0
answers
67
views
How to make multiple SQL statement transaction atomic in MS Access? [duplicate]
I needed that both DELETE SQL statements will be performed, or none of them. The tables are linked to SQL Server.
I tried this:
Private Sub onDelete_Click()
On Error GoTo HandleErr
...
- 3,782
0
votes
0
answers
55
views
This record can't be saved in MS Access [duplicate]
I have a popup form in MS Access for editing records that are connected to SQL Server.
It is automatically synced with SQL Server when I press Ctrl+S or go to another record.
I have defined this ...
- 3,782
0
votes
1
answer
133
views
MS Access VBA open a record set using a union query in which each query in the union reference two form date fields: FromDt and ToDt [duplicate]
When creating a recordset I get this error => 3061 To Few parameters, expected 2. How can I resolve this error?
I have a union query and it runs fine:
SELECT * FROM q_trip_usa
UNION
SELECT * FROM ...
- 373
0
votes
2
answers
109
views
MS Access: Entering Record With Apostrophe Produces Error
I have an MS Access form for entering song performances. It looks up titles from a table. If the title isn't there, it asks if you want to add it.
Private Sub SongTitle_NotInList(NewData As String, ...
- 1,234
0
votes
1
answer
121
views
Query with WHERE clause on a UNION query results in a table scan without using the indexes
An MS Access query with a WHERE clause on a UNION query results in a table scan without using the indexes.
Example: There is a table like this:
CREATE TABLE tblFigures
(
EntryDate DATETIME,
...
- 63
0
votes
0
answers
58
views
Importing SA OLE DB into ACCESS
I want to import some SAS files into ACCESS. I used one of Gord Thompson's suggestions from Insert into ms Access from SQL Server using OleDb provider. My SQL string is SELECT ID, LastName INTO ...
- 17
3
votes
1
answer
176
views
VB6 Adding or removing a database password using DAO
I have a large VB6 application (I know - it's ~750 kLOC, and I do have an exit strategy, but I need to limp along with this a bit longer) using DAO (higher performance for single user than ADO). I ...
- 639
0
votes
3
answers
221
views
Insert environment username into SQL in a MS Access form
I have a MS Access form with an edit button.
Before it edits the record, it runs this code to backup to a changelog table:
DoCmd.RunSQL "INSERT INTO PlanningChangeLog SELECT * FROM Planning "...
- 33
2
votes
0
answers
62
views
How can I show a picture (.png) in an email created in ms-access vba? [duplicate]
I am using the following code in Access. I have created logo.png to be placed at the end of the code. The file does exist in the Signatures folder. The issue I am having is that 2 days ago the code ...
- 25
-1
votes
1
answer
180
views
Make a search button in VBA that uses textboxes as input/output
I have some experience coding in VBA for Excel, I managed to create an excel userform that connects to an access database.
But now I want to switch to a complete access solution, with a split backend ...
- 33
0
votes
1
answer
52
views
MS Access 2016 Subquery
I have gone all around the houses with this trying to use a subqueries etc but just cannot get this to work and I am thinking it should be easy. So this is what i have:
SELECT DISTINCT Register....
0
votes
1
answer
88
views
Access Continuous Subform: Combo Box RowSource Filtering Per Record Breaks Display
I'm building a questionnaire data entry form in MS Access. Each question belongs to a questionnaire, and each question has a related answer set (e.g., forward-scored vs reverse-scored Likert scales) ...
- 958
2
votes
1
answer
69
views
Merging Count Distinct and Group By Range in MS Access SQL?
So, I've got a table with data and their respective acqusition time (in hour:minutes format) on it.
What I want to do with it is:
Count the distinctive values
Display the number of distinctive values ...
- 23
2
votes
0
answers
119
views
Changing From field to monitored email address
There are five individuals in our department. We each have our own email address, [email protected]. All of us monitor an email address, [email protected].
We sometimes send emails from our ...
-3
votes
1
answer
96
views
Access IIF statement to choose values from multiple tables
I have 3 Access 2010 tables cont, cond and prop.
All tables have 3 fields: table cont the key ID_cont
and the fields cond_ID and prop_ID that are related
to the keys ID_cond and ID_prop of cond and ...
- 11
0
votes
1
answer
91
views
Send message with multiple lines in Outlook email
I am trying to send Outlook email using Microsoft Access.
In the email, I want three cells of data.
Email
Pin
FirstName
I also would like to change the "From" email address from my default ...
0
votes
2
answers
80
views
Access Formula to Auto-Number Rows by 4's
I have seen variations of my question answered here:
https://stackoverflow.com/questions/70052620/access-query-counter-per-group
https://stackoverflow.com/questions/70388274/how-do-i-make-it-so-that-...
- 3
0
votes
0
answers
83
views
Visual Basic for Application to Pull Twitter Feed Data - Error 429
I have an ms access database where I monitor social media posts and track the likes, shares, etc. of various sites. This has been a manual process which takes too long, requires too many people to do ...
0
votes
1
answer
66
views
MSAccess VBA Find Text in Word Document Select All Text After Find
I want MS Access to search for text in a Word document and then, when it has found the text, select all of the text following the find to be analysed further within Access. I have the code working ...
- 43
0
votes
1
answer
87
views
Query with aggregate function and left join works correctly in Access but return incorrect result when connected from Excel
I am linking to tables in Snowflake from Access and running the following query:
SELECT SIMS_CLAIMANTLOG.LOGID
, Sum(IIf([processeddate] Is Not Null And [reservetypeid] In ("2","3&...
0
votes
0
answers
40
views
Configuring connection from MS Access to SQL Server 2017 with persistent database credentials [duplicate]
I have an MS Access database on a client computer providing a front-end to a database in SQL Server 2017 on another computer (using tcp:...,1433). I have set up a login/user in the database to be used ...
- 1,413
0
votes
0
answers
51
views
How do I filter an MS Access subform on the main form's OnActivate?
I have an MS Access 2016 form that has a subform. During the OnActivate event, I want to set the source object of the subform and then set the record source of it, then filter on txtComplete = 0. ...
- 702
0
votes
1
answer
111
views
Updating Linked Table not Supported in this ISAM
I have a csv file that is extracted daily. I created a query in MS Access that reads the data from this csv file and updates the corresponding rows in the SharePoint list "sp_list", but only ...
- 81
0
votes
1
answer
92
views
MS Access Reports: How do I group by two fields on the same level (OR?)
I have a database of music manuscripts that looks like the below diagram.
A 'Source item' belongs to a certain manuscript (source). A source item is then categorized as EITHER a 'Section' of a 'Piece' ...
0
votes
1
answer
76
views
Linked Table in MS Access via PowerShell
How can I access a linked table in Access when using PowerShell?
I have a .mdb database, within which is a linked table to an external CSV file.
When using Access, all works well - I can open the ...
- 43
0
votes
2
answers
80
views
Select only positive values between 2 dates as a calculated column
I have a table that has NAMES, DATES and PRICE columns. I'm running a query against that table to have a summary based on Name and show 2 totals. The values in PRICE are positive and negative.
I ...
- 19