If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Msg Box displaying current scan
I have appended query that scans a part number as shown below:
INSERT INTO Triggers ( [Part Description], [SPMK Loc], [Container Type], [No Of KB], Qty, [HP2 Location], Supplier, [Part Number] ) SELECT Products.[Part Description], Products.[SPMK Loc], Products. [Container Type], Products.[No Of KB], Products.Qty, Products.[HP2 Location], Products.Supplier, Products.[PN BRCD] FROM Products WHERE (((Products.[PN BRCD])=[Enter Part Number] Or (Products.[PN BRCD])="Msg")); However, when I scan the number I need to prompt a confirm message stating: Please confirm scanning part number (displaying the part number that was scanned) Is it possible to do it in macro? How? I need your help please. Thank you majic |
Thread Tools | |
Display Modes | |
|
|