Search results

Thanks Rich, that did it!

I'm trying to get a certain field from my form to print out on my report. On the form, the field in question is a combo box which actually looks up 3 seperate columns from a db. When I reference the combo box to be printed on my report, the bound field of the combo box is what prints out on...

Thanks for your reply Travis. I ended up figuring it out. I actually needed spaces between the Z and the ID number, not zeros. At any rate, the correct code follows: ="*Z" & Format([Forms]![frmRcv]![identity_column], "@@@@@@@@@@") & "*"

I have the following control source of a text box on my report. ="*Z" & [Forms]![frmRcv]![identity_column] & "*" This basically lets the ID number (identity_column) be read by a barcode scanner, and puts a Z in front of it. Works fine. However, the system we're scanning it into requires...

Casey and Jonathan, Thanks for the help both of you. It was just that the Z needed to be capitalized and in quotes after the *. How sad that I spent so much time on this. This is the working end result: ="*Z" & [Forms]![frmRcv]![identity_column] & "*" Thanks!

Thanks guys, I'll give those ideas a shot, and let you know what happens.

Not sure if I understand you. Are you saying that you added a field to your query called Barcode, and in the Criteria, you added "*z" & [ProductNumberField] & "*" Then you just reference the Barcode field on the report?

still looks the same this option resulted in the same thing being read by the scanner. It is still putting a + sign in front of everything. ="*z" & [Forms]![frmRcv]![Combo4] & "*" With this option the scanner will not even read the barcode. ="*z" & str([Forms]![frmRcv]![Combo4]) & "*" Any...

Thanks for the help. I'll try those suggestions.

I need to print barcodes on my reports. I have just come to find out that our ERP system can only read the barcodes if they are preceded by a Z. I've tried to accomplish this, but the barcodes are not being read correctly. This is the code for my barcode before (when it worked correctly) and...

I'm thinking I can handle this with an IF/Then statement...something like: If Me.cboCat = "Chair - Standard" Then 'print rptStandardChair Else 'print rptOTHER End If Would this work? And if so, could someone please help me with the code??? I'm lost.

My form has a combo box w/ 6 options, all of which have a corresponding report that needs to be printed. How do I have a specific report print based on the value selected in the combo box? The combo box values are: Chair - Standard Chair - Non Standard LS/Sofa - Standard LS - Non Standard...

I appreciate your reply Pat, but the problem is that I'm pulling all of the info for my application from a 1/2 Million dollar software package, and thus it is not feasible or even possible for me to change something within that system. The more likely scenario is that I've probably been pointed...

I have a form in which the user selects the Sales Order number, then all other fields are populated based on that number. Among those fields are info for customers' address. The Issue: I have a shipping table and a billing table, if there is address info in the shipping table, the form needs...