Search results

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer) Me.txtPages.Visible = (Me.Page = Me.Pages) End Sub

for i = 1 to 8 me("lbl" & i).visible = true next This code should work if you name your control name lbl1,lbl2 etc. make sure it the control name that is lbl1 and not caption.

Here is a sample of Treeview Main Menu that works like a switchboard. Check it out. :) I made some update to make it more robust.

The only place that I that used a recursive function in life is with Bill of Materials. Master Part Table ID, Parent ID, PartNr, Quantity 1,0, PART A, 2 2,1, PART B, 1 3,2, PART C, 1 Recursive functions works great with Bills of Materials as it allow you unlimited levels of bills of materials.

Thank you clarify the concept. I think i can make it work the only thing i haven't got to establish is how do i handle if a transaction needs to be approved first? Some task require 2 person while other only required one person. inflow requires one person that receives it while issue a work...

I need to track a transaction of an item that could move from inventory(Table A) to a machine(Table C) or to a storage location(Table B) then later move to a machine(Table C). The problem that i face is 1-many relationship in all direction my three options are 1. Table A 1-Many Table B 2. Table...

adding is not a problem, the problem is the old part have to be send out and then received again. then i need to trace to see what part number it came from. the tracebility is the hardest one. source of inflow can be either a purchase order or work order. the problem that i face is each item in...

Cool, didn't thought off that. Your respond actually answer a different question that I so i appreciate the feedback.

Here is a sample of a confirm form. This form will only allow user to exit if the user click on undo or save. The usage of this form is for critical situation. use this method with dialog mode and you have full control of user actions(except when computer crash). Thinh

How do you handle Replacement item in inventory? Let me explain in details of what i mean. You have a part number that is currently scrap. that part can be re machine into different part number. I am thinking of adding new line with the new part number and delete the old part one. The problem...

you need a transaction log that record all the activity of you inventory TransactionID, Action, Date, Quantity, CurrentInventory 1, Inflow, 3/3/09, 100, 1000 2, outflow, 3/4/09, 100, 900 etc on

its part of Microsoft you just need to enabled it under reference and you can add it under insert other, active x control

The one i am using is for 2003, its an active x component.

Here is the table structure that drive the menu system. Works just like a Bill of Materials. let me know if you have any question.

which one are you talking about? Tree structure or Option group

Here is a sample of a live search. Please give me feedback on the design. I like the way it is design but I wonder how it will be when you have 100k records from a performance perspective. This is my contribution to the community. more to come in the future. All feedback are welcome. if you...

Check this menu system out it uses a tree structure This structure give you great flexibility because you can have almost unlimited items. The beauty of this menu structure is easy maintain. it utilize a Bill of Materials approach. sample4 uses a option group.

i don't know exact how your table structure looks like but i would include a yes/no field at the end of table name complete. so when an entries consider complete flag this boolean fields to true so when you run your report specify that you want to see when complete = 0. that should return all...

the role of relationship is for data integrity. With relationship you get some nice feature such as cascading update and cascading delete. If you design your application in smart manner you wont need relationships, But it is recommend to set up relationships because it tells everyone how the...

what event is equivalent of the ESC Keyboard. I know that it acts as a me.undo but i want to be able to capture it that event and make some changes when a user click on esc key.