Picture as input tool
I am creating a database for welding flaws in my business. I have 15 different things which are welded and each weld can have up to 15 different sectors.
So instead of a user finding the correct location of a 15*15 grid, I am wanting a picture to appear and then the user can click where the problem is.
The picture will be split up into the sectors and then the out putted value will be put into the spread sheet correct according to where he/she clicked.
This is probably simplest to invoke using a userform with an image.
If the 15x15 matrix is equally spaced then you can calculate the required sector from the x and y position on the mouse down event.
Otherwise place transaprent controls over required areas.
Then the relevant information can then be updated on the spreadsheet.
Would it be possible to have a drop down menu with each sector that you could select one of ten different flaws that are possible.
Cheers, forgot to add thatsorry
Yes.
If you use the userform approach then add dropdowns near to the associated sector of the image,
I have not done such things since school, I can remember creating boxes which could be used as buttons but how do you do that now?
Regards
Check out Debra Dalgleish's site
http://www.contextures.com/xlUserForm02.html
Ah, I am just in way above my level here, I thought it might be a bit easier to understand. I am just stuck and not quite sure what everything is what im doing, thanks for trying though.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I have attached the basic layout.
In the yellow sector is the area in which I want the data to be entered using a form kind of window with drop down menus. IE, It will use the part number, then it will ask what sole plate (15 of these, only 4 in DB atm), then ask which Defect then a quantity box. From that form I am wanting it to fill the yellow box according.
I am not quite sure where to start I tried to run through the VB stuff and changed words as I could but it wasn't from scratch but for a different set up I wanted.
Hope this helps because my head is hurting...
P.S. Any help is appreciated loads.
Regards
Kieron
Basically the fields I want inputted are: Part Number, WO No. Type Defect. In the menu it should have options 1-14 for which sole plate and then diferent positions depending on which one you choose, for example sole plate one has 12 positions where as sole plate 2 has only 8 positions.
Sorry.
Last edited by Kieron Watson; 09-20-2010 at 09:21 AM. Reason: Wrong File Uploaded
Currently I think your post is too vauge to expect anybody on a free forum to solve the problem. It could be what you really need is a consultant.
Observations more than specific help.
Each weld location can have multiple faults so you need to use controls that allow for multiple faults. This means a listbox rather than dropdown box.
You have not provided any information about the picture of the weld locations you originally mentioned. But at a guess I would think that 15 areas in a single image would mean that then fault gathering would need to be done in a separate form in order to avoid over crowding.
Is this what you want? There's no picture si I've added a userform
That is almost exactly what I am looking for, the only problem is I added a little extra into the equation which makes it so much harder
Each soleplate has a different amount of locations. I can change all that, I just kind of need help on making template like you almost did (well you did on my lack of info, sorry
You'll have to explain what needs changing
On the new updated sheet I have the fields which I want, but not all of them because it will be 2000+ when its finished.
I want a form which you input: Work Order Number, Select from drop down menu which one of the 14 sole plates, then depending on which sole plate select a sector from another drop down box, and then select the fault, enter quantity. Hit enter, and that point will be filled with a quanity in the database.
Then the operator can then select another fault, generally from 5-20 faults per part. And close when he/she is finished.
OR
Have a drop down menu select sole plate, select sector, and then fill in the 10 faults as you have before and hit enter then the data is inputted into correct location.
Is that enough, just say if not and ill try explain better, pretty new to this that is all.
Kindest Regards
Kieron
It sounds a big project for the Forum. I've given you the basics for creating a form, you can work from that to add more controls
I understand some of the code but alot of it I dont. For example if I wanted to use the same code but for another section containing everything the same but the only difference is, is the coloum name. Is that just a case of copying and pasting and changing the letters? (Just I cant see the ones where they are now due to the code)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks