Hi All,
Thank you for all of the assistance given so far, I wonder if I could trouble you further please?
My project involves the user filling in a form, when they are finished, they submit the form, it is saved and off they go; feeling happy that they have submitted a report. Nothing new there I hear you shout - this is all up and running, but let's face it, a DB table is not very interesting to a group of users.
I would like to add an extra level, I have made a report which echoes the significant aspects of the user's form and have set the source property of this report to a query: “qry_tblReport”.
I can manually go to the criteria in this query and select the relevant “ID” number of the record I want to display and the report is populated, but I would like to set the report to display only the last record in the database, i.e. the record that the user has just created.
I would then, if possible, like to save the report as a .pdf and save a new report saved each time a user fills in a new record. The file save location will be constant, but obviously the file name will need to be different and generated by access / VBA.
The project will be used by people with less knowledge of access than myself, so the process of generating the report and saving it should require no input from them.
Is this possible and how would you go about doing it??
I should point out that I am a real novice when it comes to Access.
Thank you
Puff
Thank you for all of the assistance given so far, I wonder if I could trouble you further please?
My project involves the user filling in a form, when they are finished, they submit the form, it is saved and off they go; feeling happy that they have submitted a report. Nothing new there I hear you shout - this is all up and running, but let's face it, a DB table is not very interesting to a group of users.
I would like to add an extra level, I have made a report which echoes the significant aspects of the user's form and have set the source property of this report to a query: “qry_tblReport”.
I can manually go to the criteria in this query and select the relevant “ID” number of the record I want to display and the report is populated, but I would like to set the report to display only the last record in the database, i.e. the record that the user has just created.
I would then, if possible, like to save the report as a .pdf and save a new report saved each time a user fills in a new record. The file save location will be constant, but obviously the file name will need to be different and generated by access / VBA.
The project will be used by people with less knowledge of access than myself, so the process of generating the report and saving it should require no input from them.
Is this possible and how would you go about doing it??
I should point out that I am a real novice when it comes to Access.
Thank you
Puff