DataBase - Customize Window

I wish to make a small change to a window. I open the window, click on Tools
-> Customize...but  'Modify Current Window' is  grayed out. Are we missing
something?

  Marsh replied...

I found my answer...Modifier is required to modify windows.

1) Jhjdfhjkjurklkj (1) Tirilla6099980 (1) Kathylacoketa (1) Hjrykirylkryk (1) Escalofriante (1) Samuelleonc (1) You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page. You are required to be a member to post replies. After logging in or becoming a member, you

application is not trying to execute the merge millions of times. In a 1 minute window, my event monitor showed that the merge was executed no more than 100 times. This Total Cost: 102.028 Cumulative CPU Cost: 117592 Cumulative I / O Cost: 4.08 Cumulative Re-Total Cost: 27.0102 Cumulative Re-CPU Cost: 42558 Cumulative Re-I / O Cost: 1.08 Cumulative First Row Cost: 102.028 Estimated Bufferpool Buffers: 4 Total Cost: 102.028 Cumulative CPU Cost: 117592 Cumulative I / O Cost: 4.08 Cumulative Re-Total Cost: 27.0102 Cumulative Re-CPU Cost: 42558 Cumulative Re-I / O Cost: 1.08 Cumulative First Row Cost: 102.028 Estimated Bufferpool Buffers: 4 Total Cost: 77.0251 Cumulative CPU Cost: 104592 Cumulative I / O Cost: 3.08 Cumulative Re-Total Cost: 2.0071 Cumulative Re-CPU Cost: 29558 Cumulative Re-I / O Cost: 0

same value to all fields what is not correct. Something to try: Option 1 - preferred: Re-cast your function as a user defined function (UDF) and call it directly = from an fieldname or me![fieldname = ] syntax. e this: fieldname] syntax getting compilation error at = 20 You're welcome! he results of your calculation to the function name. I wondered if that lin one function - a 'top level' f = unction, perhaps, call multiple other functions. The ability to 're-use' a = bit of code instead of copying it over and over is one advantage Starting with the code snippet you said is behind your form's before update = and re-casting it as a UDF (all UDFs must be in a standard code module, no strSQL = 3D strSQLlt & vbCrLf & "WHERE ItemID = 3D" & lngPKValue & strSQ = Lrt 'Debug.Print strSQL 'use immediate window to verify created SQL statemen = t = 20 Set rst = 3D dbs.OpenRecordset(strSQL, dbOpenSnapshot) ' for need to u = se the actual fieldname for the suggestion below to work. te and re-casting it as a UDF (all UDFs must be in a standard code module, = not you need to = use the actual fieldname for the suggestion below to work. date and re-casting it as a UDF (all UDFs must be in a standard code module = , not strSQL = 3D strSQLlt & vbCrLf & "WHERE ItemID = 3D" & lvarPKValue & strS = QLrt 'Debug.Print strSQL 'use immediate window to verify created SQL statemen = t = 20 Set rst = 3D dbs.OpenRecordset(strSQL, dbOpenSnapshot) ' check

How do I lock the unhide database window menu option? DataBase We are using Office XP and 2003. I have a database that turned off the special access keys to disable the F11 key to open the database window but there is still the matter of the user going to Window-> Unhide and viewing the database window that way. I thought about customizing the menu bar and removing that option but I to be able to access it. Is there a way to password protect the database window only? I do not want to have to manage users in Access. I want the the database, view their forms and reports but not be able to open the database window or modify the menu bar to see the database window. But I need to be able to get to it periodically to do maintenance. Basically

newsgroup SECURE CODE and PASSWORD will be updated on August 20, 2007. Please complete a re-registration process by entering the secure code mmpng2007 when prompted. Once you have entered the X-WBNR-Posting-Host: 207.46.19.168 From: = ?Utf-8?B?TWFyaWFubyBHb21leg = = ? = References: Subject: RE: POP10600 - Purchasing Invoice Shipment Apply Date: Wed, 2 Jul 2008 07:23:01 -0700 Lines SECURE CODE and PASSWORD will be updated on \ par August 20, 2007. Please complete a re-registration process by \ par entering the secure code mmpng2007 when prompted. Once you \ par have B?TWFyaWFubyBHb21leg = = ? = <MarianoGomez@> \ par References: <79ddbd78-9b55-44cc-b2f3-64f7eb894572@y21g2000hsf.googlegroups.com> \ par Subject: RE: POP10600 - Purchasing Invoice Shipment Apply \ par Date: Wed, 2 Jul 2008 07:23:01 -0700 newsgroup SECURE CODE and PASSWORD will be updated on August 20, 2007. Please complete a re-registration process by entering the secure code mmpng2007 when prompted. Once you have entered the Frank Hamelly, MCP-GP, MCT, MVP" <fhamelly@eastcoast-dynamics.com> Newsgroups: microsoft.public.greatplains Subject: Re: POP10600 - Purchasing Invoice Shipment Apply Date: Thu, 3 Jul 2008 08:43:14 -0700 (PDT SECURE CODE and PASSWORD will be updated on \ par August 20, 2007. Please complete a re-registration process by \ par entering the secure code mmpng2007 when prompted. Once you \ par have MCP-GP, MCT, MVP" <fhamelly@eastcoast-dynamics.com> \ par Newsgroups: microsoft.public.greatplains \ par Subject: Re: POP10600 - Purchasing Invoice Shipment Apply \ par Date: Thu, 3 Jul 2008 08:43:14 -0700