changing a field in BCM globally kenago 3/21/2007 9:45:13 PM how do i change the "status" field in ACCOUNTS from "checked" (default) to "unchecked" (blank) globally in one action vs. having to go into each ACCOUNT record and unchecking it manually? Is their an SQL command or some other way to accomplish?

RE: changing a field in BCM globally Monica Tsang (MSFT) 3/21/2007 10:38:00 PM Hi Thank you for your question. Unfortunately, BCM does not currently support bulk editing, however we will consider it in future releases. Thanks. Monica Tsang [MSFT] "kenago" wrote: [Quoted Text] > how do i change the "status" field in ACCOUNTS from "checked" (default) to > "unchecked" (blank) globally in one action vs. having to go into each ACCOUNT > record and unchecking it manually? > Is their an SQL command or some other way to accomplish? >

RE: changing a field in BCM globally Martin Stockwell 3/22/2007 10:07:03 AM try and connect to the database via ODBC in access, once you find the table of data your after, you can just change the value, then close the database... you can find out how to do this here.... in the "How To" section http://msdn2.microsoft.com/en-us/library/aa431857.aspx hope this helps "kenago" wrote: [Quoted Text] > how do i change the "status" field in ACCOUNTS from "checked" (default) to > "unchecked" (blank) globally in one action vs. having to go into each ACCOUNT > record and unchecking it manually? > Is their an SQL command or some other way to accomplish? >

RE: changing a field in BCM globally kenago 3/22/2007 2:52:03 PM Thanks to both for your replies. I will check the link an possibly try through ODBC (Access). Here's a followup Q, maybe addressed to Monica or anyone else: When you create a new ACCOUNT record, when the form opens, the ACTIVE status field displays BLANK (unchecked). When you save the record, it turns this field ON, (checked). Is there anything I can change in the properties or otherwise to turn this process OFF? K "Martin Stockwell" wrote: [Quoted Text] > try and connect to the database via ODBC in access, once you find the table > of data your after, you can just change the value, then close the database... > you can find out how to do this here.... in the "How To" section > > http://msdn2.microsoft.com/en-us/library/aa431857.aspx > > hope this helps > > > "kenago" wrote: > > > how do i change the "status" field in ACCOUNTS from "checked" (default) to > > "unchecked" (blank) globally in one action vs. having to go into each ACCOUNT > > record and unchecking it manually? > > Is their an SQL command or some other way to accomplish? > >

RE: changing a field in BCM globally Monica Tsang (MSFT) 3/22/2007 4:42:13 PM Hi To address your follow up question, the answer is no, it cannot be set to unchecked by default but we will take that into consideration for future releases. However, you can create a custom checkbox on the Account form and set it to unchecked by default. This way, you do not have to rely on the 'Status' field to track whatever it is that you need, but rather replace that with your own customized checkbox. Thanks. Monica Tsang [MSFT] "kenago" wrote: [Quoted Text] > Thanks to both for your replies. I will check the link an possibly try > through ODBC (Access). > > Here's a followup Q, maybe addressed to Monica or anyone else: > > When you create a new ACCOUNT record, when the form opens, the ACTIVE status > field displays BLANK (unchecked). When you save the record, it turns this > field ON, (checked). Is there anything I can change in the properties or > otherwise to turn this process OFF? > > K > > "Martin Stockwell" wrote: > > > try and connect to the database via ODBC in access, once you find the table > > of data your after, you can just change the value, then close the database... > > you can find out how to do this here.... in the "How To" section > > > > http://msdn2.microsoft.com/en-us/library/aa431857.aspx > > > > hope this helps > > > > > > "kenago" wrote: > > > > > how do i change the "status" field in ACCOUNTS from "checked" (default) to > > > "unchecked" (blank) globally in one action vs. having to go into each ACCOUNT > > > record and unchecking it manually? > > > Is their an SQL command or some other way to accomplish? > > >

Re: changing a field in BCM globally "Mukesh Agarwal [MSFT]" <mukeshag[ at ]online.microsoft.com> 3/23/2007 1:10:06 AM Here is a tip to bulk edit the Active field. In account folder, change the view to [by Active]. View->Current View->[By Active]. It will show you accounts grouped in two groups. You can select multiple accounts from one group and drag and drop them in other group. This will automatically chnge the Active field. -- Mukesh Agarwal [MSFT] Visit team blog at http://blogs.msdn.com/bcm This posting is provided "AS IS" with no warranties, and confers no rights "Monica Tsang (MSFT)" <MonicaTsangMSFT[ at ]discussions.microsoft.com> wrote in message news:3F52B53A-AED1-4799-B7A5-9ABB65B0413F[ at ]microsoft.com... [Quoted Text] > Hi > > To address your follow up question, the answer is no, it cannot be set to > unchecked by default but we will take that into consideration for future > releases. > > However, you can create a custom checkbox on the Account form and set it > to > unchecked by default. This way, you do not have to rely on the 'Status' > field > to track whatever it is that you need, but rather replace that with your > own > customized checkbox. > > Thanks. > Monica Tsang [MSFT] > > "kenago" wrote: > >> Thanks to both for your replies. I will check the link an possibly try >> through ODBC (Access). >> >> Here's a followup Q, maybe addressed to Monica or anyone else: >> >> When you create a new ACCOUNT record, when the form opens, the ACTIVE >> status >> field displays BLANK (unchecked). When you save the record, it turns this >> field ON, (checked). Is there anything I can change in the properties or >> otherwise to turn this process OFF? >> >> K >> >> "Martin Stockwell" wrote: >> >> > try and connect to the database via ODBC in access, once you find the >> > table >> > of data your after, you can just change the value, then close the >> > database... >> > you can find out how to do this here.... in the "How To" section >> > >> > http://msdn2.microsoft.com/en-us/library/aa431857.aspx >> > >> > hope this helps >> > >> > >> > "kenago" wrote: >> > >> > > how do i change the "status" field in ACCOUNTS from "checked" >> > > (default) to >> > > "unchecked" (blank) globally in one action vs. having to go into each >> > > ACCOUNT >> > > record and unchecking it manually? >> > > Is their an SQL command or some other way to accomplish? >> > >