[ms office - 2016] Assets

[Jawloms]

Hi All,

 

I have a MS Access Database with all my assets in it. I also have a limited knowledge of MS Access!

 

At the moment when we give a member of staff a laptop, that's it, we just give it to them. I'd like staff to sign something saying they acknowledge they have it and they'll treat it nicely. I'd like either Access to generate a form with the data of their assigned laptop, or Word to pull the info out of Access and populate a form. I don't want to run them all off, just the one about the asset I am about to issue. Which way do I go about it please? Googling just seems to generate masses of results of how to run a report showing loads of data, I just want the one record.

 

Stuart

[sister_annex]

I assume that your Database has some form of ID - you're better compiling a query with the data you want in the query designer and using the ID to effectively filter the result to the asset you need. you can create a report based on this query from that point

 

I wrote ours a long time ago and it uses a lot of SQL queries to pull and push data in to a SQL backend - but the frontend is all access

[Jawloms]

Thanks for this. It gave me exactly the starting point I needed, and I have now got my printable form with everything on it I wanted.

[sister_annex]

No worries