My Visual Database — Generate Qr code

Re: Generate Qr code

null@example.com (sparrow) — Tue, 26 Sep 2023 19:53:18 +0000

https://www.qrcode.com/en/about/version.html

The report automatically expands the QR depending on the number of characters. I tried it with 200 character text. That's where I stopped.
More text means larger matrix size.

Re: Generate Qr code

null@example.com (Destiny) — Tue, 26 Sep 2023 15:55:55 +0000

Hello, is there a possibility of displaying more information in the 'Flashcode' because there is only the name.

Re: Generate Qr code

null@example.com (agusecc) — Tue, 26 Sep 2023 10:01:26 +0000

Hi Derek.
The purpose of procedures 'FrmInputPresence_Edit1_OnKeyDown' and 'FrmInputPresence_Edit1_OnKeyUp are to read the barcode by barcode scanner from the member card, as a sign of entering existing activities.

Re: Generate Qr code

null@example.com (derek) — Mon, 25 Sep 2023 20:57:55 +0000

Hi Agusecc,
I'm not quite sure what you are asking for - perhaps you could explain it in more detail and with an example.
But while I was looking at your project, I thought your data schema looked a bit strange.
Specifically,
1. why do you hold 'barcode' and 'name' in the 'presence' table? Wouldn't it be better to create a relationship to the 'member' table?
2. why do you hold 'activity' on the 'activity' table? Wouldn't it be better to create a relationship to the 'typeofactivity' table?
Both of these would make your script shorter and a lot simpler. They might also have an effect on the approach you have chosen on some of your forms.
Also, in your script, what is the purpose of procedures 'FrmInputPresence_Edit1_OnKeyDown' and 'FrmInputPresence_Edit1_OnKeyUp'? It doesn't appear to do anything.
I simply ask because if there are things that are possibly not configured correctly, it will most likely cause you problems as you continue to develop your project.
Regards,
Derek.

Re: Generate Qr code

null@example.com (agusecc) — Mon, 25 Sep 2023 17:49:59 +0000

Hi MVD, I send to you example my project.
I need your helping for print report member presence
and ajust time barcode scanner automatically.
thanks you

https://www.mediafire.com/file/1eeisreaqf6f65u/Presence.rar/file

Re: Generate Qr code

null@example.com (k245) — Tue, 28 Mar 2023 06:20:23 +0000

sonixax wrote:

Many thanks,
so there is no way to show qr code in the program itself? (only in reports?)

This will require a little more code))

https://k245.ru/en/mvdb-en/qr-codes-in-mvdb.html

Re: Generate Qr code

null@example.com (sonixax) — Thu, 07 Apr 2022 17:36:15 +0000

sparrow wrote:

Barcode and QRcode are generated in the Report.
Now the "Print barcode" button opens the designer. You can switch directly to the preview.

Many thanks,
so there is no way to show qr code in the program itself? (only in reports?)

Re: Generate Qr code

null@example.com (sparrow) — Thu, 07 Apr 2022 17:01:30 +0000

Barcode and QRcode are generated in the Report.
Now the "Print barcode" button opens the designer. You can switch directly to the preview.

Re: Generate Qr code

null@example.com (sonixax) — Thu, 07 Apr 2022 15:51:07 +0000

Wow,
Many thanks.
Is there any way to show them in program itself too?

Re: Generate Qr code

null@example.com (sparrow) — Wed, 06 Apr 2022 19:23:48 +0000

Hi,

Generate Qr code

null@example.com (sonixax) — Wed, 06 Apr 2022 18:50:31 +0000

Hi
Is there any way/example to generate qr code/barcode programmatically?
Also I need qr code/barcode in report (print) form.

Many Many thanks