Anyone handy with access?

pitchfork · 3 Aug 2012 at 12:49

I haven't used Access since second year college so naturally, I have no idea what I'm doing now.
At work at the moment I'm trying to create a database to store scanned in letters from customers, I've managed to create a table and set all the input criteria.

I've done an input form using the wizard.

Few things I'm stuck on:
- How can I make the input form appear blank and ready to enter a new record on startup, it currently has the last record entered when it starts up.
- Is there a way I can just have a button to locate the file and add it to the record instead of a box that needs to be right clicked, add object etc.
- I've been trying to set up a search form for the past 2 hours, I just want a simple textbox to search all the fields at once and pull up any record with matching keywords/ numbers "google" style if you will, I'm stumped

Access 2003

Any help would be much appreciated gents (and possibly ladies, on a computer forum? surely not)

UnworthyBean · 3 Aug 2012 at 13:37

I'm not at a computer at the moment so this is all from memory but hopefully you can improvise.

For the blank for you'll need to change it to input only or something like that.

For the search box, i normally have a form with field you want to search, that will then run a query which picks from that field.

Hopefully that makes sense?

pitchfork · 6 Aug 2012 at 15:39

Cheers mate, put me on the right path, it's all coming back to me now

pitchfork · 7 Aug 2012 at 08:22

I'm having a bit of a nightmare, I'm trying to store a PDF as an OLE object, it opens fine, prints, etc.
But when you go to close it, it locks up and there is an error in access.

The operation on the Adobe Acrobat document failed
The OLE server may not be registered
To register the OLE server, reinstall it

Any idea how I can prevent this?