Data Entry Form from Excel 追蹤

0
Avatar
Lon EMPENO

I've been designing a label for a week and I am struggling with how to connect my database (excel) to my data entry form. I have field names VendorID#, ItemNum, and ItemDesc.

So, I would like to add these field names to my data entry, so when I select the VendorID#, the other two field names will also populate. Also, I have another field name that I would like to add to the data entry which is a manual entry. Overall, I would like to see all these options in one data entry form, if possible.

Right now, I have to go to the "print" and "select records" and select the records. 

I will appreciate any help or inputs from the community. 

6 意見

0
Avatar
Pete Thane
評論操作 永久連結

I take you have linked your label to your database and so in the Template view on the column on the left you can see your database fields and can add the appropriate fields on to your label from there

For the record selection you have a couple of options, use the Select Records from the Print Screen, that it looks like you are using now, add this option onto your Data Entry Form or add a database filter/query and leave it as a separate option or add this to your Data Entry form too. 

The database filter/query can be enabled in the Database Connection Setup screens as shown below and you can give the Query a "name" if you wich and change the Text Label or the question the users see to something appropriate which for the screenshot below could be something like "Enter Product Code" for example

For the Select Records option on your Data Entry Form you can add from the Data Entry Control dropdown a Record Picker (or Drop Down Record Picker) and the users can use that to choose the record they require. Once added you can go into the Properties of this and amend various items including adjusting the size of the columns in the table and the order etc. This will allow the users to see the fields you mention or often I will include and Picture>Preview of Template on the form so that the operators can see the "live" data on the screen. 

Also from the Data Entry Control dropdwon you can add Text Input boxes and link these to any manual entry fields you need and you can also add additonal text or number entry boxes and link them to the number of labels (Copies) or even your Database filter if you have one.

I hope this helps

  

 

 

 

0
Avatar
Lon EMPENO
評論操作 永久連結

This is great! Thank you very much!

We actually just upgraded our Bartender Professional to Automation, and so far it's working fine and meet my needs. 

I have a follow-up question though. So, I designed a label with a barcode with embedded re-sort information in it. Every time a worker scans the barcode it will tell the worker if that particular pallet is on hold for pits/stems and it will show the numbers of pits/stems found in the pallet as well. My dilemma right now is, we also monitor the micros of that particular pallet(lot code) but micros results are delivered after a week or two.

1. How can I prevent the shipping personnel from sending out the pallet if there's still no micros clearance? Is there a better way of addressing the issue?

2. Is there a way I can update the printed label after a week or two like unselecting a check box of micros or something? 

Sorry for all the questions I threw here. I am open to any suggestions. 

0
Avatar
Pete Thane
評論操作 永久連結

If you logged in the spreadsheet whether the micros had been received (you could add a Micros column and the uses add a Y when received or similar) and then use could add an extra filter to your database connection that 

Micros equals Y

so the labels would only print is that column has the correct value

0
Avatar
Lon EMPENO
評論操作 永久連結

Great! I will try this option. Thanks!

0
Avatar
Lon EMPENO
評論操作 永久連結

I have a question about the record picker on my form. Is there a way I can set up the number of columns permanently?

Right now, I have several columns showing on the record picker, and I use the "Hide This Column" option every time I start using the form. But let's say if I close the bartender app for the day and open it again the next day the hidden columns I hid are back again.

Is there a way I could just permanently keep certain columns to show in the record picker? The reason I want to keep it this way is because some of the columns are irrelevant or not useful at the moment. I appreciate any input!

0
Avatar
Pete Thane
評論操作 永久連結

Odd not seen that happening before. If you save the label after you have amended the form and columns etc it should stay as it is.

The only time I have had to readjust this is if I have relinked to a different database.

登入寫評論。