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
When adding a "SqlDataSource" using any version of MS Access database the app simply crashes when you "Test Connection". This happens in the designer when usin
I want to display a query but the column order needs to be sorted according to the value in the column, field with greater value as column 1, then second greate
user can select only one key number at a time and I have placed the code on the listbox in the control both under expression, didn't work- then under code build
user can select only one key number at a time and I have placed the code on the listbox in the control both under expression, didn't work- then under code build