Cory Posted June 10, 2005 Report Share Posted June 10, 2005 Reader’s digest version: If I have a long list, 1000 approx, of text items and I want the user to choose one how can I do this? In Access I can create a list box with the display source being a table so that when the user enters the field they can just start typing and then select the one they want. Maybe there’s another way that differs slightly? Everything from here down is supplementary, don’t both reading unless you want to help and I don’t make sense. <g> Specifically what I am doing: I have created several macros for disposing of PDF scans in a paperless conversion project. Scanners output PDF’s and I have ME pop them open, ask the users for several bits of info then enter meta data into the PDF, save and then rename the file with a standard convention and move it to the proper client folder and subfolder based on that characteristic info. My sleazy workaround: Don’t laugh but right now I use the client folder list and the directory command to allow the user to select a clients name to be used in a later path and elsewhere. Problem is I’m modifying the macro to access via FTP instead of UNC so it doesn’t work there. My sleazy solution? Create a temporary directory structure on the users local machine simply as a place to store the 1000+ text variables and delete it later. Then have them use the folder select command. Problem is with my sleazy workaround(s) is that, 1- they have to start from scratch every time browsing, and 2- I can’t do more with the items like remembering past input. For instance I was thinking it would be nice to have a sort of MRUD except it would be clients and keep score so if they do a bunch from one client they could have a ‘top five’ list to shorten their input. 3- If I use the UNC variant but have a remote user using VPN directory browsing is too slow. Comment on HTA: I saw Floyd’s stimulating post on the HTA but after a few minutes of stumbling around I felt as if it was going to be a research project to get it to do what I want so I though that instead I would write a post to see if there is an easier ‘old school’ way. Related posts: I’ll post a message here in a few minutes about FTP in ME. This is the case of the day but this post is more generic and I’ve had several things like this. What I am doing is using the directory list from the FTP site as the 1000+ string variable list. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.