SetValue Macro command

The UK's most regular instructor-led training courses.
Training information: microsoft access training courses · Access training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2007

Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management course

by - delegate Sarah [8 posts] (2008 Apr 17 Thu, 12:51) Reply

Hi,

I remember my trainer telling me that default secruity settings on 2007 meant that the SetValue command does not appear in the choice of Actions. I have gone into Access Settings, into Trust Centre settings and Enabled all Macros. Reloaded the database - but I still cannot find the setvalue command anywhere - any thoughts?

Many thanks

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 10 Thu + 11 Fri	Southwark	3	book now	£475	£495
2003/XP	2008 Aug 7 Thu + 8 Fri	Southwark	7	book now	£345	£399
2003/XP	2008 Sep 4 Thu + 5 Fri	Southwark	5	book now	£450	£485
2003/XP	2008 Oct 20 Mon + 21 Tue	Southwark	8	book now	£275	£399
2003/XP	2008 Nov 6 Thu + 7 Fri	Southwark	8	book now	£275	£399
2003/XP	2008 Dec 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 17 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: SetValue Macro command

by - trainer Carlos gold contributer [360 posts] (2008 Apr 21 Mon, 15:16) Reply

Hi Sarah

Access 2007 by default only shows macro actions that are trusted.

When you first open the macro design window and drop down the list of macro actions in the Action column, Access displays only 45 macro actions.

To see the complete list of 70 macro actions do the following:

1. On the ribbon, select the Design tab, then click the Show All Actions button in the Show/Hide group.

Hope this helps

Carlos

· Microsoft Access: Unleash the True Potential Today
· Get More Out of MS Access Courses
· Access VBA Handling Errors and Debugging Code
· Microsoft Access Tighten your Security Controls
· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps

Please browse our web site to find out more about
microsoft access training courses and other Microsoft training courses.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips