Creating a printable form from an axisting Access database

[Gatsoman]

Hi,



Please forgive me if I have posted in the wrong place!

I have an existing access database which an invoicing program is based around. I want to be able to create a printable form (as a 'job sheet') by having selectable fields (i.e. Customer name which will pick up their address too). I have had a go but soon realised I have not got a clue what I am doing

Many thanks in advance!

[Micron]

Best approach is to create a select query that returns all the information you need, then try the report wizard to make a report based on that query. If you need a database form to handle user inputs and/or selections, you should still build the query first, then the form, then the report. Printing a database form leaves much to be desired, hence my suggestion to finalize this in a report. There are lots of tutorials and YouTube videos on making Access forms and reports that you can view. The process is not too difficult to learn, but IMHO, it's not something that can easily be taught here.

[Gatsoman]

Hi Micron,

Many thanks for such a quick response! As I said I quickly realised I was being as thick as humanly possible over this & I also wanted a quick fix! Do you know of any good tutorials or YouTube links I could check out? I would like to get into access a bit more as I don't like not understanding things but I just don't have the time I need to look into it at the moment! - Regards

[Homegrownandy]

Could you briefly describe your business and what you require from your database.

[Gatsoman]

Hi Homegrownandy,

I have an invoicing program which is essentially an Access database. I have a requirement to create a 'job sheet' which can be taken on site & which I want laid out in a particular format. I currently have a form (Word document) but have to fill this in by hand. I would like to be able open an electronic version of this form & populate the relevant fields (i.e. name, address etc.) with data from my Access database!

Hope this makes sense!

Regards

[Micron]

Your Word job sheet can be populated by Access if it is a Word form, complete with all the necessary form fields. However, that might be too daunting of a task for you to take on with time pressures. You can probably make an Access report that looks very much like your Word document.

[Homegrownandy]

http://www.google.co.uk/url?sa=t&rct...39250283,d.eWE

this is a word add on. If you reference an access query with this it will let you use the access fields in the document.

When you hit split the merge it will create a new document for every record on your query.

Very useful.