Fecth data using Excel Userform

[shaunsheep2345]

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 ?

[BadlySpelledBuoy]

If you already know what the batch number is, because it's in the TextBox then why do you need to retrieve it from the database at all?

Are you trying to pull a whole record based on the batch number stored in the textbox?

BSB

[BadlySpelledBuoy]

Something like this if the batch number is numeric

Please Login or Register  to view this content.

or this if it's text

Please Login or Register  to view this content.

May need tinkering with a little... Difficult to know for sure without sample files.

BSB

[shaunsheep2345]

Thanks bbs, I will give it a go.
The userform in excel selects rows which need updating.
So I have the batch number required and than I'll pull the drecord from the dB and update it accordingly.

[BadlySpelledBuoy]

Aha, that makes sense now then.

Note I've edited the SQL strings above as I forgot to take MAX out of it originally.

BSB