Hi guys.
I have very little experience with databases but have been tasked with creating a few for varying uses. One that I've made is for some technicians and the database will be used to create jobsheets for the techs to have job details and a sign off form. I've created the database and made a form to enter job data into. At the bottom of the form I've added a module called find as you type. This allows users to search for a particular job using a filter (for lack of a better term) that can be applied to any of the entry fields.
I've created a report that will show the data as a job sheet. I've then gone back to the data entry form and created some buttons. General record operations like previous record, next record, save record, delete record, and close form.
I've also put a button to preview report. I assumed (incorrectly it would seem) that this would open the record I was viewing in the report so it could be printed. Instead what I get is every record opens in the report and then I have to click through every page until I get to the desired record and then print it.
I've searched for people with similar issues and tried solutions provided to them. Most of these solutions were based on editing the report click function (not sure how else to describe it) in the vb editor. None of these methods have worked.
Can anyone help me out?? I'm running Access 07 but I need to make sure that the database is compatible with Access 2000.
Thanks for your help.
-Matt
I have very little experience with databases but have been tasked with creating a few for varying uses. One that I've made is for some technicians and the database will be used to create jobsheets for the techs to have job details and a sign off form. I've created the database and made a form to enter job data into. At the bottom of the form I've added a module called find as you type. This allows users to search for a particular job using a filter (for lack of a better term) that can be applied to any of the entry fields.
I've created a report that will show the data as a job sheet. I've then gone back to the data entry form and created some buttons. General record operations like previous record, next record, save record, delete record, and close form.
I've also put a button to preview report. I assumed (incorrectly it would seem) that this would open the record I was viewing in the report so it could be printed. Instead what I get is every record opens in the report and then I have to click through every page until I get to the desired record and then print it.
I've searched for people with similar issues and tried solutions provided to them. Most of these solutions were based on editing the report click function (not sure how else to describe it) in the vb editor. None of these methods have worked.
Can anyone help me out?? I'm running Access 07 but I need to make sure that the database is compatible with Access 2000.
Thanks for your help.
-Matt
