Access 2003
Hi All,
I have a form that users input data once a week, 2 of the columns (IssueNumber,Date) have the same data i.e Issue number for that week will be same for all the records inputed and date will be populated by either the day they input or the date the data gets sent on to another department.
What I would like to do is that once they have completed all the fields etc, that they can press a command button, and it will prompt them for "Issue Number?", they then will type in the prompt the issue number and then hit "OK" and it will update the table with this info. An the same for the date.
I have looked, searched at inputmsg, msgbox, parameter queries, but what I thought would be simple, is turning out to be a nightmare!
Could someone possibly guide me in the right direction? I am not too experienced with VBA, but would I possibly need VBA to achieve this? Or can Acces do it without VBA?
As usual, any help greatly appreciated.
Michael
Hi All,
I have a form that users input data once a week, 2 of the columns (IssueNumber,Date) have the same data i.e Issue number for that week will be same for all the records inputed and date will be populated by either the day they input or the date the data gets sent on to another department.
What I would like to do is that once they have completed all the fields etc, that they can press a command button, and it will prompt them for "Issue Number?", they then will type in the prompt the issue number and then hit "OK" and it will update the table with this info. An the same for the date.
I have looked, searched at inputmsg, msgbox, parameter queries, but what I thought would be simple, is turning out to be a nightmare!
Could someone possibly guide me in the right direction? I am not too experienced with VBA, but would I possibly need VBA to achieve this? Or can Acces do it without VBA?
As usual, any help greatly appreciated.
Michael