Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Lookup Window

Lookup Window

Lookup Window

I'm using Version 7.5. In the item Maintenance Window, when I onpen the Lookup window, I would like to have Item description instead of Short description showing by default. I have the VBA modifier. Can I do anything to switch this?

RE: Lookup Window

When you are in the lookup window, click on the drop down arrow for Additional Sorts.  By Description is the first choice.  Is this enough?  Or are you looking for it to default to that?

RE: Lookup Window

Looking for it to default to that by removing short description and replacing it with Item Description

RE: Lookup Window

Add the window to VBA and add the Short Description Button and the Find String. Then paste in the code below.

Option Explicit
Private DoOnce As Boolean

Private Sub ASILUFindString_AfterGotFocus()
    If Not DoOnce Then
        ShortDescription = 1
        DoOnce = True
    End If

End Sub

Private Sub Window_BeforeOpen(OpenVisible As Boolean)
    DoOnce = False
End Sub

David Musgrave
Senior Development Consultant
Asia Pacific Professional Services

Microsoft Business Solutions


Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

RE: Lookup Window

I don't want it to sort by Short Description, I want when the item look up screen appears, it shows me item number first column the short description second column. I want to do away with the short description column and replace it with the Description.

RE: Lookup Window

You need to modify the Window using Modifier:

1)Tools -->Customize -->Modifier -->eEnterprise --> New --> IV_Item_Number_Lookup

1) Open the Item Number Lookup Window from Item Maintenance
   Selct Tools -->Customize-->Modify Current Window

Once you have the form open:
2) Select -->IV_Item_Number_Lookup from the Windows tab.
3) Open --> Double click on the area below the column headers marked IV_Item_Number_Scroll
4) Another window will appear with the data fields.
5) Switch the Description and Short Description fields (you may need to adjust the field lengths as the description field is quite long.
6) Give users access to modified form.

Hope this helps.

RE: Lookup Window

There's a dotted line on that window that separates the 1st and 2nd lines. It won't allow me to drag the Item Description field to the first line only below it.

RE: Lookup Window

Ok, I was able to move the Item Description to the 1st line. Now my question is, how do I change the heading button to say Description and not Short Description. Also, when I click the heading button for description, I want it change the search box above to search the Description field and not the short description field. Thanks

RE: Lookup Window

The column descriptions are on the first screen after opening the window (right above the area marked IV_Item_Number_Scroll).

You have to change the Text Icon (A) from the tool box and click into the description field that you want to change.  When you are done click on the pointer (arrow) Icon in the toolbox.

RE: Lookup Window

To search by description you don't need to do a modification.  

Click on the Find button -->Click on the arrow by Item Number -->Several search options are displayed -->Select by description from the list.

The find button will now search for the description that you entered in the Find text box.

RE: Lookup Window

Sorry for another question. Right above the area marked IV_Item_Number_Scroll is 3 buttons that are labeled from left to right: ASI_LU_Column_Array[1] , ASI_LU_Column_Array[2] , ASI_LU_Column_Button_Drop_List. Where is the Description button located?

RE: Lookup Window

what version of GP are you working with?  I'm working with 6.0 I don't have the buttons you describe and the description fields for the column are on the fist screen that appears.  

Try saving the screen then re-opening it.  On my screen the column descriptions are at the top of the first screen that opens (right below Sort By IV Items).

RE: Lookup Window


RE: Lookup Window

You will need some 7.5 expertise with the descriptions then. It's probably a simple solution.  Have you tested the screen to see if the actual short description was switched?

RE: Lookup Window

The column headings are buttons in 7.5, you click on them to sort the column.

RE: Lookup Window

Since the column headings are buttons, maybe you can get properties for the buttons.  Try Right clicking on the button, using the toolbox, or the menu options at the top of the screen.

RE: Lookup Window

The buttons are setup in arrays.

RE: Lookup Window

I don't know about those arrays in 7.5; I'm even wondering now if the columns should be adjusted in the same way as 6.0. Is the item description now showing on the first line when you view the lookup window?

RE: Lookup Window

The description shows fine, only the column heading says Short Description.

RE: Lookup Window

I was hoping someone else would jump in here.  Anyway we'll be upgrading to 7.5 next week so I'll check then and let you know what I find.

RE: Lookup Window

ok, thanks for your help.

RE: Lookup Window

I finally got a chance to look at the modifier in 7.5 now.

To modify the column headings click on the text icon (A) in the tool box and click on the heading that you want to change.  You should now be able to change 'Short Description' to read Description and vise versa.  

You may need to adjust the vertical line used to separate the headings and also make sure that the Item Number heading does not overlap the Description heading.

When you are done click on the White Arrow in the toolbox.

Save the window and give users rights to the modified window if you haven't done so already.

Let me know how it goes.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close