QR Code from Database

Started by spl, September 05, 2025, 01:41:50 PM

Previous topic - Next topic

spl

I quickly wrote and tested inserting multiple QR Codes into a database field based on other field properties. Did this is MSAccess, so involved ACE Provider. Problem with not including script is dependent on if you have 32 or 64 bit Office. There is a post I made from years ago about having both 64/32 bit ACE Provider on same PC, but, cut to the chase, the Extender is 32 bit.

Bored of reading? The conventional wisdom is to not insert a QR image in a db field but only the link to a file [for display]. So, based on an SQL query you are able to pop up something like the attached.
Stan - formerly stanl [ex-Pundit]

spl

Just a note, Jim added

barImage(Control,FileName)
  
Displays an image in the provided Control.  You can even pass your Dialog Handle if you want the entire dialog background to display the image.  

 WinBatch only permits BMP.  This will take most common formats.

Filename(optional).  Filename of Image.  If you leave it blank it will pull the image from the clipboard but it should only be used for barcodes placed there by barEncode().

   cwin = DialogControlGet(WV_Handle,"pi_WV_WebView2",@dchWnd)  
   barEncode("http://www.jtdata.com":@LF:@LF:"How are you today?",@QRCode,300,300,10,"qrcode.png")
   barImage(cwin,"qrcode.png")
Stan - formerly stanl [ex-Pundit]

SMF spam blocked by CleanTalk