Access VBA 11 - Pull Data from SQL Database to Textbox

Published: 06 April 2021
on channel: YourProgrammingNetwork

4,149

How to pull data to an Access form textbox from a SQL Server database using VBA.

Schema creation:
CREATE DATABASE CompanyX

CREATE TABLE CompanyX.dbo.tblCustomer
(
CustomerID INT IDENTITY(1,1) PRIMARY KEY,
FirstName VARCHAR(50) NULL,
Surname VARCHAR(50) NOT NULL,
DateOfBirth DATE NULL,
Address1 VARCHAR(150) NULL,
Address2 VARCHAR(150) NULL,
Address3 VARCHAR(150) NULL,
Address4 VARCHAR(150) NULL,
Postcode VARCHAR(9) NULL
)

INSERT INTO CompanyX.dbo.tblCustomer(FirstName, Surname, DateOfBirth, Address1, Postcode, CreatedOn)
SELECT 'Robert', 'Plant', '19480820', '1 Avenue', '1LZ 1LZ', GETDATE()

SELECT * FROM CompanyX.dbo.tblCustomer

On this page of the site you can watch the video online Access VBA 11 - Pull Data from SQL Database to Textbox with a duration of hours minute second in good quality, which was uploaded by the user YourProgrammingNetwork 06 April 2021, share the link with friends and acquaintances, this video has already been watched 4,149 times on youtube and it was liked by 36 viewers. Enjoy your viewing!

2,280