Search results for query: *

ES

I have tried everything I know in VBA to capture when a line item has been deleted. Key press, key down, key preview. Do you have any ideas on how to do this?

Thank you for your help.

You are correct in everything except that it wouldn't find a user defined field 1. That is how I know that it is an invalid bin, because the "correct" ones had a name in the user field 1 and the ones macola creates do not

After you tab off of bin_no it asked you if you want to create the bin, if the user hits yes it goes to the quantity field. There is where I am calling the above procedure. I put a name in the user defined field 1 to differentiate the bins I created vs the bins that macola automatically makes...

The code to determine if the Bins Exist is what freezes. Function getBins() On Error GoTo getDescription3_Error '**********VARIABLES***************************| Dim rs As New ADODB.Recordset 'Recordset | Dim strSQL As String 'SQL command | Dim strItemNo As String ' Item...

I am using Macola ES When they come to the IMINVENT screen that shows the bin and quantity to be put in that bin.. what I was doing when they tabbed off the bin no field I did a select on iminvbin_sql where the item_no, bin_no, and location existed.. if they didn't exist I deleted from the...

thread639-1707832 In this thread the person said that you can add code to limit creation of the bins. However there is a lock on the iminvbin database when it is on this screen causing any queries to time out. Do you have a way around it. Or an example of how you got around the issue? thanks,

I am playing with the bank transaction table and I am trying to find a lookup table for the type and status.. what do the letters stand for. for type I have C S W for status I have C J V

I am trying to make the customer field a combo box. The customer is used to quick books where you enter the customer name, what I want to do is populate the customer field with the customer names and when they select one it grabs the correct number from the cicmpy table

Hi, I am working with the order entry screen, and I wanted to make the Customer Entry like the Type (how you type O and Order comes up) So I change the customer field to look like this. http://i.imgur.com/S6pMKpK.png 1st question, Does it automatically grab the customers from the cicmpy...

I have tried that as well.. For example In the PO & RFQ tab i added a VBA only field under weight. When weight.lostfocus i sent it to the new field. When it got to the new field the focus automatically went to the Item listbox without even setting off the new field.lostfocus

When I add a flex field ( a new one, not unhiding) and I try to include it in the tab order, everything goes nuts. I tab into it and the tab just goes to another screen or a field that isn't even nearby. Has anybody had any luck with this?