Help needed with Microsoft Access

[That Guy]

I have downloaded and edited this Access Template from Microsoft:
http://office.microsoft.com/en-GB/templates/results.aspx?qu=access&av=zac#ai:TC010222095

I will be using it to keep track of supplier returns policies at work.

I have edited the template at home using Access 2010 but will be using it at work using Access 2007.

What I want to do is be able to double click the database file and it load up the main form with the Main Microsoft Access Window hidden and just the form on show.

After researching I think it is possible using code like this:
http://www.tek-tips.com/faqs.cfm?fid=7522

My question is where do I enter this code in Microsoft Access? From what I can see the site doesn't really explain this. Will this code work with Access 2007? and is this the best way of doing it?

Thanks in Advance!

 

[Scougar]

Looks like VBA (Visual Basic for Access) to me. You have to create it There are tools built into Access to let you right VBA scripts. It's been a long time since I did any, but it should be very straightforward.

What you sound like you want to do is make the Access Database and executable. It is possible, but do you really need to do that if you have Access on your machine.

With regard to the 2010/2007 compatibility, I would think you have save it in the 2007 format inside 2010.

I've just got a reghosted machine at work, so don't have Access on here to have a play.

 

[izzop]

Hi there,

Will this achieve what you're after?

http://www.techrepublic.com/blog/msoffice/display-a-specific-form-when-your-access-2007-database-is-opened/1074

I haven't got Access to try it, but along time ago I used to create databases in Access (Version 97 & 2000) and you did need to use VBA to do this, appears you no longer do.

Regards