Search results for query: *

I am looking to have a cell that contains a Number, like a Purchase Order Number. When the excel worksheet is opened and a particular cell is changed, then the number will advance 1 spot. Creating a new PO. Any suggestions?

I have built a Purchase Order in Excel and was wondering if I could have the # representing the PO # advance 1 everytime a To: cell is changed? Thanks,

I have a field on a form that when I change the selection I want the first part of that field to be parsed and changed in another field. Example. I have a list box with the following. Books - Doc 7 6180 In the other field, I need this to happen in the on change() cmd...

This did not work IS there an easier method?

I am getting an error telling me it is too complicated?? SELECT MASTER.Order_Num, MASTER.Order_Date, MASTER.Cust_Date, MASTER.Ship_Date, MASTER.Run_Date, MASTER.[IMP], Left([Cell_Loc],InStr([Cell_Loc],'-')) AS Cell, MASTER.STATUS, MASTER.Quantity, MASTER.Customer, MASTER.HOT, MASTER.COLOR1...

I have a query that is looking up the first part of a string in a field. The first part is separated by a "-" i.e. Books - Number 7 DOC 6180 Due to the fact that the first part can be any length, I just need the first part of that field. I wrote this below, and it works for the BOOKS...

I am needing to run a query based on whether a check box is checked or not. What is the code to do that? "Is Not Null" does not work. Thank you,