Clearly I am lost. Any help would be greatly appreciated!
Did you start from a blank layout or try to use the Layout wizard with the Labels option?
What's really weird is that your data is printed out mirror image. The orientation and page size problems could be due to how the layout and printer options are set up, but the fact that it's reversed like that has me wondering if there isn't a printer driver incomatibility involved.
Just to check the obvious:
You did try printing by selecting Print from the File Menu after using print setup to make sure that the correct printer, page size and orientation was selected?
(A scripted button might select the wrong printer, etc.)
So I got it to work. Your question prompted me to start from a blank layout. I had been using the wizard. I had to increase the page size to 1/4" above the actual size of the label. I didn't have a script written for it yet. What a headache and thanks for your help! I have another problem if you are interested...
As I mentioned I'm quite new to all this. I need a script which will open a new record in a different layout, but have it be related to the previous layout.
(sorry I know I am not wording this clearly). My database holds info for a veterinary practice, (owner contact info and medical records etc).
I have an "Owners" layout and need to be able to hit a button which will direct me to the "Patients" layout with a new record, but fill in the "ownerfullname" field with the previos owner I was on and make that record related. I need a variety of these scripts, so I can also create new related medical records for each patient, new invoices etc. At present I have it rigged where I select the owner (and owner PK) from a pop up, but obviously this is not correct.
I would love help! Thank you so much.
Here are some screen shots. If they help...?
The labels wizard is intended for printing multiple column sheets of layouts that you would use in a plain paper printer. Specialized printers such as the Dymo can't use that option because they don't print labels in multiple columns.
For your new question, it may be simpler to set up a portal to Patients with the "allow creation of records via this relationship" enabled for patients in the relationship. Then you can create new related records in Patients just by entering data into a blank row of your portal.
The scripted method also works:
Set Variable [$OwnerID ; value: Owners::__pkOwnerID ]
Go to Layout ["Patients" ( Patients) ]
Set Field [Patients::_fkOwnerID ; $OwnerID]
Go to Layout [Original Layout] ---> use this step only if you want to stay on the owner layout. Leave it out if you want to be on the Patients layout so that you can fill in addiitional data.
THANK YOU for that script, PhilModJunk!!!