Does anybody have some insight on why the following error "cannot define field more than once" comes up in ms access when connecting MySQL tables via ODBC? The
I'm trying to connect a user to my company's postgreSQL Server to access a postgres database via MS Access 2019. Connection should be established via ODCB drive
I stole the format from an answer to a similar question : Insert Image into Word by using VBA The problem I am getting is that it keeps not actually setting the
I'm trying to get the result of a Count query into a variable so I can use it (basically I just need to know if it's greater than 0). My code looks like this:
I am using a Plugin for Version Control with gitlab. This Plugin exports a whole Database to Textfiles which can be commited to a git-repository. You can than b
I am trying to compile my code but every time I get the same error: Syntax error (missing operator ) in query expression ' True Status.Subsystem Not LIKE '''
My long-time running MS Access application will no longer create QuickBooks invoices and is failing on the OpenConnection line with the following error: HRESUL
I have a need to pass strings back forth from a python script to a VBA application running in MS Access. Communication from VBA to Python works great! Communica
I'm currently working on the database integration of my internship project using EntityFrameworkCore.Jet version 3.11. I cant upgrade because I'm using an MS Ac
I want to link a "TimePicker" housed on an Excel macro enabled spreadsheet (it has three textboxes for hrs, min, AM/PM with associated SpinnerButtons [SBs] oper
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to us
My aim: I have a subform in a form and I want to pick up the value of one field in a user selected record in the subform and populate a field in my form using t
I'm trying to make a button in Access, that will open Visio and launch a Data Wizard to create a diagram. I've tried various solutions, but all I get is opening
I would love some help with a query to expand an Access Table I'm working with. I need to generate a range between the min and max numbers and then duplicate th
I have a project with a number of instances of DoCmd.Hourglass -1 <various code> DoCmd.Hourglass 0 <other code> Any time there
I have 3 tables I'm trying to join, and the final table may be missing a record. I'm trying to determine if it's there or not. Notice how table 3 doesn't have a
Bought X times Name Manufacturer 19 Олівець Faber-Castell, Castell 9000 F FaberCastell 14 Наб&#
I´m exporting data to excel with the columns like ID Product Quantity Price Sum Our vendors fill in the Quantity and Price. I want to pass a simple calcul
I want to query records from the access database that matches the current date (system date) The following query works fine if I enter the date literally. SELEC
I have a data structure (array) in Access - 6 columns and 10 rows. I'm trying to write to a range in Excel ie B3:G12. I'm getting tied up in loops, literally. F