I have an XML file I'm trying to import into Access. I need help formatting the XSL transform to match the data. Right now, the XML imports as 3 separate tables
So I had to create a couple of drop-down lists in Microsoft access and all of them are supposed to have different font colors. I did write the code for a single
I have a MS Access database that has a switchboard on it that opens different forms within the database. For some reason, some of the users like to double click
There's a website that provides weather data: https://www.visualcrossing.com/weather/weather-data-services I want to import that data into a table with a butto
Assuming a table organized thus: Row | School | LocationCode2011 | LocationCode2012 | LocationCode2013 001 ABC 1000A 1000B
I have the following code in an Excel VBA module that looks up the ProjID named cell on the worksheet, selects columns needed for output from dbo_Proj_Dash Acce
UPDATE: It appears that when setting filters or loading the datasheet, access is taking a strange and inconsistent amount of time to load the records. I set a f
I connot able to filter the current user record. I want to display the data of current user only. But I did not understand how to handl query. here is the ss of
I have spent two days researching and try to fix my issue with access form edits. I understand that there may be similar questions out there, but none of the s
So, say i have a record in database like "Something with corn". if i use sql like "SELECT * FROM table WHERE column LIKE '%Something corn%'", the record wont sh
I'm trying to make a GUI using tkinter to select the MS Access Database. I get an error: "General error Unable to open registry key Temporary (volatile) Ace DSN
We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det
I need to encrypt SSN (nvarchar(25)) field in a SQL Server database table. Once encrypted, the Access program needs to be able to decrypt the field for user vi
In MS Access 2016 I have a table named Master that periodically needs to gets updated with ‘updated’ data from a table named NewData. Each table ha
I'm using Access SQL I have data that looks like this:- dealdate value 17-Apr-22 267 18-Apr-22 274 I'm trying to make the data look like this (there will only
` Private Sub Link_Click() Dim OpenLink As String Dim db As DAO.Database Set db = CurrentDb OpenLink = DLookup("Link", "dbo_tbl3_Ranke
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a database with a table that has as its primary key an autoincrement number field I call id. In the datasheet view, I want to create some new records us
I have a form that is selecting emails based on companies that have expired insurances. Some companies have both a Business and personal emails whilst others ha
I'm trying to create a Python script that opens MS Access and runs a Macro. I have the following script: import win32api,time from win32com.client import Dispat