57,925 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
43
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 ...
Advice
0
votes
6
replies
111
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 ...
-1
votes
1
answer
63
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) ...
Advice
0
votes
1
replies
72
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
55
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, ...
0
votes
1
answer
106
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, ...
-6
votes
1
answer
105
views
How do I insert a NULL into a SQL table through a SQL INSERT written in VBA? [duplicate]
I have something like:
Dim strSQL As String
Dim Field1Value As String
Field1Value = iif([some condition], "NULL", [some real value])
strSQL = "insert into tableA (Field1) values (&...
1
vote
2
answers
146
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"
...
-1
votes
1
answer
110
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, ...
0
votes
1
answer
172
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, ...
0
votes
1
answer
125
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. ...
0
votes
1
answer
100
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
...
0
votes
1
answer
81
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 (...
0
votes
2
answers
64
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)
...
0
votes
3
answers
143
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 ...