Search results

yes there are many parts, and they can change, maybe add/delete afew. is there anyway i could load all the parts from parts table, add extra column for qty, then save to stocktake table?

yes, that is true

help? please

I will print off a report that has all parts listed on it, with a box for the person who carries out the stock take next to each item to enter quantity. After that report is filled in, the information need to be inputted into the data base. So in my database, i need a form that lists all parts...

Hi I'm having problems trying to design a stocktake form. I need a form that displays all parts from my parts table with a box next to it, which will be used for stocktake quantity. After the quantity are updated the information is saved to the stoctake...

Ok, but how do i show the partid/part name/ part code from one table, and a qty box on the end, when the qty box is filled it stores the part details and qty to another table

Hi I'm trying to design a stock control database, I could do with some help, I would like a form that looks like this Date (Today) Title - Part Name / Part Code / A Shift / B Shift / C Shift / D Shift Lists part 1 / code 1 / qty box / qty box / qty box / qty box part 2 / code 2...

thanks very much worked a treat. cheers simon

hi wayne i have not coded the button yet, i'm finding it difficult, this os what i got behind the button Dim i As Variant For Each i In ListSNRT.ItemsSelected 'this is the bit i'm find hard, currently all items in the list have no for completed, i need them to be changed to yes...

Hi I have a list box called listSNRT on a form, with a button at the side, when I press the button all selected values in the listbox updates. The listbox has a column called completed, which is yes/no. When I press the button I need the column value to change from no to yes. Now how do i...

I trying to use the following formula to add the date, looking up a valbe from another table =DateAdd([Frequency]![FreqValue],[Frequency]![FreqInterval],[Last Date Done]) table 1 task start date freq table 2 freq=fornight freqvalue=d freqinterval=14 anyone see where i'm going wrong?

I dont need it to keep a record, as i plan to print off what tasked are need to be done today or this week, it is more as a reminder of jobs to be done. i like the idea of a done field, but i dont want to be updating it every day, just autorun, print list off, then close

Hi I'm trying to make a Maintenance scheduler, the task are repeated every week, monthy, quarterly, bi-monthly, or yearly. how do i get the database to repeat tasks after their due date has expired? for example table TASK-overhaul machine FREQUENCY-monthly START DATE-1st/jul/07 DUE-(start...

I got solution now thanks it was this Forms!NewPM.PMTaskNo = Me.PMListbox Forms!NewPM.PMTask = Me.PMListbox.Column(1) cheers next question if i wanted to delete record from listbox with delete button what code would i need

does this give me the info from column one in one text box and info from column two in the another?

hi i have a text box with a button at the side that opens a form, from a list box you select a task, this info is then transfered to the orginal form and put into the text box i would like another text box below that text box, when there is a task in box above, the task desciption is in the...

thanks you

Hi I have a combobox on a form, with you press the down arrow, a new form opens with a list box. I have a button on that form to select the value from listbox and transfer it to the combobox on previous form. So what code do i need for that select button to transfer value from list box to...