Sorry to bug, but I got thrown into this project and they didnt' give me much time to complete it. The only book I have on access doesn't seem to be much help either. Anyway...
I have two tables, Tasks and Parts (linked by common field TaskID). Each Task can have many parts. On the TaskInput form I need two buttons, one that inputs the parts manual (opens PartInput form) and a button that imports parts form an excell spreadsheet.
I have the manual button open up the PartInput form to new add, but I'd like it to automatically have the same TaskID as the Task record I just came from and every time I click 'Add New Record' on the PartInput for I want it ot stay that TaskID until I back out to the Task view and go to an new record. I cant' seem to find a way to get this to work.
The same goes for the excell import, my book has a bit on importing but i cannot find a place where it alows you to capture the value of the current record (TaskID) and pass it on to every part that it imports (since there is NO TaskID field in the spreadsheet. TaskID is an autonumber assigned on each new task)
other small probs I'm having:
I have two fields on the Task form that total amoutns from each part associated with the task and adds them to a single value in the Task. I am unclear as how to create a filter that only finds parts related to the current record in the TaskInput form. i.e. if I begin to enter task 4, import the parts from a spreadsheet, the two totals shouls automatically calculate baseed on allthe parts with TaskID 4. I don't have much clue as to coding in SQL and I'm thinking that this must be how I doo all of this becaue I can't seem to find it in any of the creation tools. I am using Access97 btw.
Any help would be greatly appreciated...
I have two tables, Tasks and Parts (linked by common field TaskID). Each Task can have many parts. On the TaskInput form I need two buttons, one that inputs the parts manual (opens PartInput form) and a button that imports parts form an excell spreadsheet.
I have the manual button open up the PartInput form to new add, but I'd like it to automatically have the same TaskID as the Task record I just came from and every time I click 'Add New Record' on the PartInput for I want it ot stay that TaskID until I back out to the Task view and go to an new record. I cant' seem to find a way to get this to work.
The same goes for the excell import, my book has a bit on importing but i cannot find a place where it alows you to capture the value of the current record (TaskID) and pass it on to every part that it imports (since there is NO TaskID field in the spreadsheet. TaskID is an autonumber assigned on each new task)
other small probs I'm having:
I have two fields on the Task form that total amoutns from each part associated with the task and adds them to a single value in the Task. I am unclear as how to create a filter that only finds parts related to the current record in the TaskInput form. i.e. if I begin to enter task 4, import the parts from a spreadsheet, the two totals shouls automatically calculate baseed on allthe parts with TaskID 4. I don't have much clue as to coding in SQL and I'm thinking that this must be how I doo all of this becaue I can't seem to find it in any of the creation tools. I am using Access97 btw.
Any help would be greatly appreciated...
