Exposing Creating User's team membership
Can anyone demonstrate (or point me in the right direction) the following:-
We have a number of sites, and a number of teams which map directly to the
sites and have the same name as the site (eg siteA has a corresponding team
called siteA). When in an opportunity, I would like to obtain the value of
the creating user's team, and use this to set a value in another picklist. I
am having trouble retrieving the team membership of the user that created
the opportunity. Does anyone know of a way to do this? I am not even sure
where to start looking at this.
Hi Fen...Cannot Create _MSCRMDistribution database when i reinstall CRM
I built a front end CRM Server, using the 5 license keys MSDN_Subscriber.
Had to uninstall this and reinstall CRM as we had another 25 licenses under
the name of our company.
Problem is, i've reinstalled CRM and the new organization key, everything
looks and works absolutely fine, however there are only three databases, the
companyname_MSCRMDistribution is missing.
So... Gone into Deployment Manager>Servers Manager>Configure SQL Server
which is supposed to create this database? I just get an error in the event
Event ID: 0
dmLog: Failed to execute t...Custom LDAP/OPATH query to create custom address list?
I'm going to ask this again because it seems to be a big problem going
to exchange 2007. How does one create a custom LDAP query to an
external server to build a custom address list? It would be nice to
be able to create custom address lists built on LDAP queries to Active
Directory or OpenLDAP, etc.
Can this be done?
Only recipients in Active Directory can appear in Address Lists.
You would have to import external recipients into AD as Contacts to be able
to do this.
MVP - Exchange
NEW blog location:
jkcsaj djladfh dvkldw w
please go play in another newsgroup.
"���� �������" <email@example.com> wrote in message
> jkcsaj djladfh dvkldw w
...How to create a stacked bar, line combination chart
I am having trouble creating a stacked bar and line combination chart. The
standard excel charts offer a bar and line chart option, but does not seem to
stacked bar and line option.
Has anyone done this type of chart?
I just asked a very similar question, but didn't get any answer.
However, I did figure out a way to get it to do what I wanted.
1. Start with a plain stacked bar graph and chart everything you want
in that format. If you choose 2 columns for your X-labels, Excel is
smart and will give you 2 levels of X-labels and will space your chart
columns according to the...adding field to form
I have made continiuse form with 10 field that works (text box in detail and
lables in form header) but when i want to add one more field that text box
is in detail part of form and lable in form header part ,I can not save my
form.and access goes to repair mode after saving and there is no change when
I reopen my form.
...How do I create a formula that lists only the last entry in a colu
See this page Walter
Regards Ron de Bruin
"Walter" <Walter@discussions.microsoft.com> wrote in message news:B7435D17-C9FF-403C-B54D-34349AD2E193@microsoft.com...
...Malicious Code error when opening a custom outlook form
After installing Visio 2003 on XP Professional with
Microsoft Office 2002 installed, I get the following error
when I launch a custom outlook form...
"To help prevent malicious code from running, one or more
objects in this form were not loaded. For more
information, contact your administrator."
Has anyone seen this or know how to address it?
...change the default opening of a form to enter a new record
How can you stop a form defaulting to record 1 when you want to type in a new
record. The only way we are getting round this at the moment is to click on
the icon New record. However, every time we open the form to enter another
record it is always showing record 1
Thank you for reading my post. Hopefully you can answer my querie
Set the form property Data Entry to Yes. That will default to opening the
form for new records.
> How can you stop a form defaulting to record 1 when you want to type in a new
> r...Search Form
I have read some help articles on sub forms, however, have yet to find the
solution that helps me. Some groups have stated that this is not known,
however I know there has to be an easy solution:
I have a form that also has a subform. The two are linked by a field,
[Eno]. When I add records, etc, everything works beautifully. However, If I
wanted to search the form from a SUB-FORM field [EMPLOYEE] from the MAIN
form, It will now work.
I started the search with a unbound text box, - after update which will be
the search terms, however, I am trying to figure out VBA code that will
I have a table for entering tickets, there is a date, violation, and a fine
feild. I have made are report that adds all the fines together. The report
adds all of the new enteries ont it. What I want to do is each week print
out a report with only that weeks information on it but the report shows all
of the information on it even when I filter my table. I was able to make a
new report with the filter information but had to built it all over again. Is
there a way to set up a report and only us it when I filter the information.
Base the report on a query.
In the query
Field: DateFieldNa...Creating Links to Custom Views in the SItemap
Hi, I have been trying all morning to edit the site map to create
links on the left nav to point to some custom views I have set up. I
have different views of accounts like Current Customers, Past
Customers etc and want to be able to create a link in the left nav to
go straight to these views. I have tried inserting the following code
in my site map but when I try to upload it MS CRM complains that it is
an invalid file. It is the params that appear to be the problem as a
link to www.google.com works fine. Am I trying to achieve something
that is not possible or am I doing something wrong?
&l...objects created in 2002 (2000 format) not avail in 2000 boxes
I have created a new query and report in an Access 2000
database. This is the first modification since my PC was
upgraded to 2002. The database is still in 2000 format
(according to the banner). Other users, however, do not
see the newly created query or report? (They are Access
My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
Is this database in a shared folder that multiple people can access, or did
you create your own copy of the database? Maybe you are using the wrong
file. Verify that the file is in 2000 forma...concatenate 04-16-10
I want to combine three cells with 'Concatenate' function and get the result
cell A1 = 10 (emp code)
cell B1 = filename.xls
cell C1 = sheet1'!A1
my coding is
=concatenate(a1,b1,c1) --- it should show the content of cell A1 in
10filename.xls , since the A1 is changeable.
Try the below. (Hope 10filename.xls is open)
=INDIRECT("'["&A1&B1&"]" & C1)
Jacob (MVP - Excel)
> I want to combine three cells with 'Concatenate' function and get the result
&g...auto create a file
i have a time card in excel that i'd like to automeate a bit more.
right now I have a button on the form to save to a specific file, and
it names the new time card by name, date and job #. something like
people have been asking for copies, and it's tough for me to modify the
code for the button to save to their correct path.
right now mine saves to something like /mydoc's/time/billing/.
Is it possible to code the button so that , if the file doesn't exist,
the code can create the correct path. code is as follows:
Sub Save_As_FileName(...How do I create a dynamic chart
I have a database on sheet "D" with 1000 rows of data 79 columns wide.
How do I create a single line chart on sheet "A" that graphs a single row on
sheet "D" where the row number is specified in cell H1 on sheet "A"
This doesn't work:
The chart would graph out whatever D! row number is pointed to by cell A1 on
read other posts today
Bernard V Liengme
remove caps from email
"Nick Krill" <NickKrill@discussions...Workflow against System Created Object
I have built similar workflow in the past, but this one is stumbling me!
We are using c360 Email Marketing -
When a "Communication Audit" is created I need to email the "Contacts
Owner". When a "User" creates a "Communication Audit" my workflow runs
smoothly. But when the Audit is created by the "System" the workflow doesn't
run. Any thoughts or suggestions?
Thanks in Advance
On May 30, 9:29=A0am, awakin <awa...@discussions.microsoft.com> wrote:
> Hello World!
> I have built simil...How do I create a chart title dependant on an Auto Filter
I have created a chart where the info changes depending on
the autofilter results. Is there a way of having the chart
title change to reflect what is in Column A of the
filtered data. I cannot use a cell reference as the cell
reference changes depending on the result of the filter.
Hope I am making sense :-)
Any help you can give would be greatly appreciated
This could probably be better but it works where your title row is a2
mt = Range("a3:a100").SpecialCells(xlCellTypeVisible).Range("a1")
Activ...Trying to create completely server side, document merge
I was given the task of designing a complete web based
document prep system. In simplest terms (using a msword
explanation) create a database of merge fields, and a
library of templates. Allow the webuser to select the
template, merge his DB record, and produce a formatted
document that can be printed or downloaded.
We need to do this without specialized software on the
client, since it will be universally available to
webusers. We considered using PDF, but the creation of the
templates were painfully slow, and the datamerge had
severe space limitations (the form could not adequately...summing in a form..
In my form i have Beginning Mileage, Ending Mileage, Total Daily Mileage. As
of now I have to enter Beginning Mileage, my Ending Mileage is =Nz([AR],0)+Nz
my Total Daily Mileage is =Nz([AR],0)+Nz([LA],0)+Nz([TX],0)+Nz([MS],0)+Nz([OK]
,0)+Nz([Other]). Is there a way that i can make my Beginning Mileage carry
over from the previous record (so i wouldnt have to manually enter it)?
Message posted via AccessMonster.com
Thanks for the reply.
T...Customize Exchange 2003 OWA Custom Forms for Contacts
We have just created a custom form for contacts and would like OWA to show
the custom fields in OWA. How do we do this?
...PRINT INVISIBLE FORM
I have a form A that I sometimes print using the printout command, after
passing some parameters and making calculations.
I want to print the same form A from another form while making form A
invisible. How should I do this?
You should create a report from form a and print that instead of the form.
That way you don't have to hide anything. Reports are meant to be for
printing. Forms are meant for data-entry and showing data...
> Hi All,
> I have a form A that I sometimes print using the printout command, after
>...Add Record from form into two tables
I have a form (frm_Invoice) that records phone serial # from customers. I
want to create a new record in both the tbl_Inventory and
tbl_Inventory_Detail when someone scans in a DEC_SN into the frm_Invoice.
The issue I am running across is that the tbl_Inventory_Details has a child
relationship to the tbl_Inventory. I chose this set up because most of the
inventory is manually entered from shipments received from a warehouse. I
created a form and sub form for the inventory tying the SN_ID from each table
on a one to many relationship.
I do not know how to update both tables at ...How do I set up a Startup Form with Access 2007 ?
When I open a database, I want a certain form to start. This form is
going to be used for a menu.
Please let me know.
Create a macro named Autoexec. Have action open your form.
Build a little - Test a little
> When I open a database, I want a certain form to start. This form is
> going to be used for a menu.
> Please let me know.
On Aug 13, 5:24 pm, kasab <ka...@discussions.microsoft.com> wrote:
> Alternatively, click the Office button ...How to auto create volume bands
I have several thousand data points and I want to group these in a volume band.
I would enter a number, lets say a band value of 200, and the query would
return how many records fell into a band of 200, then increment and bad those
as well until it hits the max value of the records?
If I thought I had too many bands, I could test incrementing by 300 and
continue this until I felt I had a good representation of data.
Is there a way to do this with an Access query without manually building a
You can feed a "band" value into the Partition() function. ...