Vivirtruvian
Registered User.
- Local time
- Today, 10:44
- Joined
- Jun 20, 2017
- Messages
- 19
Hi all,
Shall keep this brief thanks to exhaustion:
Say I have a pallet ID 123456789
That ID goes into our system (this is how it is received as transmitted data from a customer)
However, the pallet itself has a barcode that scans as 00123456789
When I scan the barcode (into a form control, [forms]![frmSearch]![combo9]) I want my database to find pallet 123456789.
I have tried ID = Like "*" & [forms]![frmSearch]![combo9] but I get nothing. The query works if the form control and the pallet ID match identically, so there is nothing else confounding the query results.
I know in my loins what I am asking Access to do is the wrong way around... all I want it to do is find the in the database when the form control has some additional numbers around it.
Shall keep this brief thanks to exhaustion:
Say I have a pallet ID 123456789
That ID goes into our system (this is how it is received as transmitted data from a customer)
However, the pallet itself has a barcode that scans as 00123456789
When I scan the barcode (into a form control, [forms]![frmSearch]![combo9]) I want my database to find pallet 123456789.
I have tried ID = Like "*" & [forms]![frmSearch]![combo9] but I get nothing. The query works if the form control and the pallet ID match identically, so there is nothing else confounding the query results.
I know in my loins what I am asking Access to do is the wrong way around... all I want it to do is find the in the database when the form control has some additional numbers around it.