Search results for query: *

On Exit of the textbox

Hi all, I have a textbox (txtBOL) on a formula that i need to prompt a message if the value is the same as one in the list of my query field (field is [BOL] and query is [merge bol]. Could anyone help me I'm sure it's easy when you know how to use vba correctly :) Thanks a lot

I forgot to tell that this is already a query that get is iformation from 2 table. And thanks a lot PHV!!!

My SQL is like this: SELECT [BOL DATABASE].DATE, [BOL DATABASE].DRIVER, Left([SHIPPING_INSTR],3) AS SHIPPING3 FROM P_SO_MASTER_HEADER INNER JOIN [BOL DATABASE] ON P_SO_MASTER_HEADER.CUST_CODE = [BOL DATABASE].ACRONYM GROUP BY [BOL DATABASE].DATE, [BOL DATABASE].DRIVER, Left([SHIPPING_INSTR],3)...

Hi all, I'm trying to make up a field from multiple row. Here is an exemple: Driver Route DR1 138 DR1 140 DR2 200 DR3 200 DR3 150 DR3 160 I would like to have all route for the same driver on the same cell, like: Driver Route DR1...

thanks a lot for all this information, I'm ok now with your great answer, hope i can help you someday :) (when I will be even better in access) Alea

MSCOMCT2.OCX

When you say relaod access you mean uninstall and reinstall everything?

Thanks for the fast response! Seem like I'm missing some rence, where can i get them?

Hi all, I have a query that need a left function. The field is as follow: SHIPPING3: Left([SHIPPING_INSTR],3) It was working at my work, but when I tried to opened the query at my house with access 2003, it gave me the following error message: Undefined fonction 'Left' in expression Someone...

ok, will try to explain more exactly, sorry sometime you think everything is easy to understand but it is in fact harder when you aren't in it :P I have a query actually that take all the recent information and put it in a table. Its list all the Sale Order No, the status for each one, the...

Add the row where the SO_NO is in status 4 that aren't already in the table (the new pick ticket that was added today by exemple.

Hi all, Here is my problem: I have a table with 6 field that are: SO_NO, SO_STATUS, CUST_CODE, REQUEST SHIP DATE, SHIPPING INSTR, QTY ORDERED I want to delete the entire row only for the SO_NO that are finished (this is taken with the SO_STATUS while "4" is not finished, "9" is finished) and...