Problem in Access 2007

[KimTong via AccessMonster.com]

Dear all,

I just installed Access 2007 in my computer, and I followed all the defaults.
I did 'Command Button' on design view, but when I changed to form view and
click that button, it didn't work. I tried to do the other 'command button',
and they all didn't work in Acces 2007.

Then I have to change everything in Macro, and it's worked. It seems all VB
script don't work in Access 2007. Is anyone can tell me why it happened like
that? Thank you in advance.

KF

 

[Douglas J. Steele]

Have you added the folder where the database exists to the Trusted
Locations? Access won't run VBA code unless you have.

Click on the Office button, then follow the path to Access Options | Trust
Center | Trusted Locations.

 

[KimTong via AccessMonster.com]

Hi Douglas,

I still don't get your suggestion about 'Office button', where is that button?
ANd also the for the other part, such as Trest Center | Trus Center. Because
in Office 2007 all layout looks different, so it's hard for me to find it.
Could you explain it to more detail, please?

Thank you. I appreciate it.

KF

Have you added the folder where the database exists to the Trusted
Locations? Access won't run VBA code unless you have.

Click on the Office button, then follow the path to Access Options | Trust
Center | Trusted Locations.

Dear all,

[quoted text clipped - 12 lines]

KF

 

[Douglas J. Steele]

The "Office Button" is the big button at the top left-hand corner of the
program. Click on it, and you should be able to follow the rest of the
instructions.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Douglas,

I still don't get your suggestion about 'Office button', where is that
button?
ANd also the for the other part, such as Trest Center | Trus Center.
Because
in Office 2007 all layout looks different, so it's hard for me to find it.
Could you explain it to more detail, please?

Thank you. I appreciate it.

KF

Have you added the folder where the database exists to the Trusted
Locations? Access won't run VBA code unless you have.

Click on the Office button, then follow the path to Access Options | Trust
Center | Trusted Locations.

Dear all,

[quoted text clipped - 12 lines]

KF

 

[KimTong via AccessMonster.com]

Hi Douglas,

I'd like to try to add the folder, they gave me the default likethis: C:\
Program Files\Microsoft Office\Office12\ACCWIZ\. I save my Access data (back-
end) in \Data folder and the front end in \My Documents.

Which folder I should put in Trusted location? Also If I save my back end in
2 or 3 different location/folder, what's gonna happened? Thank you in advance.


KF

Have you added the folder where the database exists to the Trusted
Locations? Access won't run VBA code unless you have.

Click on the Office button, then follow the path to Access Options | Trust
Center | Trusted Locations.

Dear all,

[quoted text clipped - 12 lines]

KF

 

[Douglas J. Steele]

You'll definitely need the location of the front end put there. No harm, I
don't think, in having the back end location there as well. You can store
multiple locations.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi Douglas,

I'd like to try to add the folder, they gave me the default likethis: C:\
Program Files\Microsoft Office\Office12\ACCWIZ\. I save my Access data
(back-
end) in \Data folder and the front end in \My Documents.

Which folder I should put in Trusted location? Also If I save my back end
in
2 or 3 different location/folder, what's gonna happened? Thank you in
advance.


KF

Have you added the folder where the database exists to the Trusted
Locations? Access won't run VBA code unless you have.

Click on the Office button, then follow the path to Access Options | Trust
Center | Trusted Locations.

Dear all,

[quoted text clipped - 12 lines]

KF

 

[KimTong via AccessMonster.com]

Hi Douglas,

How about if we have front end on 2 different locations?

You'll definitely need the location of the front end put there. No harm, I
don't think, in having the back end location there as well. You can store
multiple locations.

Hi Douglas,

[quoted text clipped - 21 lines]

 

[Douglas J. Steele]

As in you're running it on two different computers?

Trusted Location is on an installation basis, not on a database basis.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi Douglas,

How about if we have front end on 2 different locations?

You'll definitely need the location of the front end put there. No harm, I
don't think, in having the back end location there as well. You can store
multiple locations.

Hi Douglas,

[quoted text clipped - 21 lines]

KF