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
