Hi All,
Can anyone help me with a statement to Find a Access db record specified from a Userform in Excel.
I use the below to find the last entry in Access whuch works great.
hsDBFullpath = "G:\QUALITY CLINIC\DATA\LongsInspectionDb1.accdb"
hSQL = "SELECT MAX ([ID]) FROM [Inspectiondata]"
Now I need to adapt this to "SELECT" the batch number ([BatchNumber)])FROM [Inspectiondata]" using the TEXTBOX (txtbatchnumber) from an excel userform.
Any ideas ?
Bookmarks