Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2021, 06:39 AM
komobu komobu is offline Barcode Font Macro Windows XP Barcode Font Macro Office 2010
Advanced Beginner
Barcode Font Macro
 
Join Date: Feb 2011
Posts: 34
komobu is on a distinguished road
Default

I am using the QR Code and not code 39. Qr code works much better and quicker.

Hear is a screen capture of my calendar item:https://www.msofficeforums.com/attac...1&d=1619701970

Here is what the webpage looks like that I have to type in the data
https://www.msofficeforums.com/attac...1&d=1619701970

If I select the Inspector field(1) and type in the inspector, when i hit the tab key, it will take me to 2 then 3 ,4,5 etc.

So, my form line 2 actually enters into webpage 7
My form line 3 enters into webpage 11
My form line 5 enters into webpage 6
My form line 6 enters into webpage 8
and as for the vin, they want just the last four digits of it to be entered in to webpage 12

So now I want to add QRs for the other items on the Webpage form, being

Webpage1
Webpage2
webpage3
webpage4
Webpage5
Webpage9
Webpage10 (Checkbox)


When I run the qr macro, it looks like this
https://www.msofficeforums.com/attac...1&d=1619701970

So I would have to scroll down the form to get to the other fields.



I am hoping to get it to put 4 qrs per line so it ends up looking like this
https://www.msofficeforums.com/attac...1&d=1619701970

What I was wondering about is creating 12 variables. Each variable would have the written text followed by the QRcode.

Then I could simply put each variable plus chr(32) or chr(34) where needed.

I could also just add my items for webpage1, 2,3,4,5,9, and 10 into the code before the for next loop because they really wont change.

Hope this clears it all up

Thanks again for all your help
Attached Images
File Type: png vehinspec.PNG (25.4 KB, 15 views)
File Type: png Want.png (63.6 KB, 14 views)
File Type: png Web2.png (22.5 KB, 14 views)
File Type: png QR1.PNG (36.7 KB, 15 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Barcode Font Macro Barcode Scanning Sueade Excel 1 11-11-2015 04:07 PM
Barcode Font Macro Looping Macro to Change Font, Font Size, and Give Heading 1 WH7262 Word VBA 1 08-26-2014 03:46 PM
MICROSOFT barcode control -changing the barcode image in realtime artner0112 Excel 1 12-18-2011 09:33 AM
Barcode Font Macro Postnet Barcode Doc_man Mail Merge 1 09-29-2010 03:06 AM
barcode add ins ???? quince Office 2 11-11-2005 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft