Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IMLOCLBQ Customization 1

Status
Not open for further replies.

spucelik

IS-IT--Management
Sep 21, 2007
22
US
Does anyone know if you can add VBA code to the IMLOCLBQ screen?

To get to it follow this path.

- GO to add a new order in order entry
- On page 2 you can click the Loc/Qty button to get to the item location detail view. This is the screen I want to modify.

If I go to the screen designer as supervisor Macola won't let me design the screen.

Thanks!
 
Open up the VBA editor as soon as you get into order entry. When you get on the 2nd page, enter an item #, then click on the loc/qty button. This will display a list of locations for that item. Hold down the shift key and double right click the list. Go to the VBA editor and you should be able write your code.

Just out of curiosity, what are you trying to do?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Thanks...I was able to get to the code window but I want to add a control to the screen (IMLOCLBQ) so that when the form receives the focus I can look into the IMINVLOC file and pull a couple more pieces of information that is not currently being displayed.

Your help is appreciated.
 
I do not think you can modify that screen. Since you can get to the flex there is nothing stopping you from using a userform to display whatever you want to pull up.

I have the same question Don does though.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.
 
What info are you looking for?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
You can modify this screen, go to system manager, maintain, designer. Bring up the screen and copy the MACOLA screen to SUPERVISOR. Then click on design.

However, you will not be able to change what data populates in the list.

What info are you looking for?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Excellent...this is exactly what I was looking for. Now I can add a control through the designer and also manipulate it with VBA code.

Just to satisfy your curiosity, I'm not wanting to manipulate the items in the list box. When you double click an item in the list box and get to the "Item Location View" page, I need to add a couple text box controls so that it will pull more information on that item from the ININVLOC file. Specifically pricing information.

Thanks again for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top