Đang Thực Hiện

Create 3 simple VBA macros (Microsoft Access 2010)

Create 3 simple VBA macros (Microsoft Access 2010)

I have only basic beginner-level Access 2010 knowledge, so I need somebody to please create 3 simple macros for me. I would like you to use the most SIMPLE solution possible, for each macro . . . nothing fancy, if possible.

In addition to the writing the script or macro (or however you want to do this), I will need you to list the exact STEPS I need to follow to insert that button . . . or script . . or macro on my form. I realize these are “beginner” questions, but that is my experience level at this time.

So, you will need to do 2 THINGS : (#1) write the code, and then also (#2) clearly tell me how I can “insert” that code into buttons on my website.

Each of these macros will be used with my form called: [Violet Fire Books Inventory]

MACRO #1:

(a) Create a button that does the following when clicked:

(b) Go to form control called [Isbn13]

(c) Copy the control's value into the Windows clipboard

(d) Then go to [url removed, login to view] (the [url removed, login to view] website)

End of macro

***********************************************************************************

MACRO #2:

(a) Create a button that does the following when clicked:

(b) Apply a FILTER to show only records that match BOTH of the following 2 conditions:

The value of form control called [Process Now or Later] = “Process LATER after RESEARCH”

AND (also)

The value of form control called [Sold or Not Sold by VFB] = “Unexamined”

End of macro

***********************************************************************************

MACRO #3:

(This is very similar to Macro #2)

a) Create a button that does the following when clicked:

(b) Apply a FILTER to show only records that match BOTH of the following 2 conditions:

The value of form control called [Process Now or Later] = Nul (or “empty”, or whatever you call it when this text-field control is EMPTY, with NOTHING in it).

AND (also)

The value of form control called [Sold or Not Sold by VFB] = “Unexamined”

End of macro

Thanks for your help.

Kỹ năng: Microsoft Access

Xem thêm: microsoft access 2010 macros, access 2010 macro, access simple macros, simple access vba macro, simple vba macro, writing macros, write copy amazon, vba with, writing process steps, steps create website, research microsoft, access writing, create fancy writing, vba macro access, create list vba, vba time, vba for, text macros, microsoft writing, microsoft vba, microsoft macro, me vba, in vba, end vba, microsoft website

Về Bên Thuê:
( 27 nhận xét ) Toronto, Canada

Mã Dự Án: #1063622

Đã trao cho:

torajiv

Details in PM Thanks

$50 USD trong 1 ngày
(54 Đánh Giá)
5.4

4 freelancer đang chào giá trung bình $175 cho công việc này

rhomeu

Advance MS Access(2003, 2007, 2010) programmer here. Please check private message box for more details.

$200 USD trong 0 ngày
(38 Đánh Giá)
6.5
ZhiZhang

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Thêm

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
rajkamalarora

Hi, Please read your private message

$250 USD trong 15 ngày
(0 Đánh Giá)
0.0