Bullets in field not indenting
I have a field in my table tblCourses. One of the fields in that table, a
memo field, is memCourseOutcomes. So the table contains the courses we have
and that field contains (as suspected :)) the course outcomes but in bullet
I want to use this table's fields in a report but i want those bullets to
show as bullets (indented appropriately).
Now in the table design i see there is an option to change the field to
"Rich Text" - Is that what im suppose to do?
IMO, I would normalize the table structure so you didn't store multiple
course outcomes in a si...Help with "memo" field in Purchase Order subform
I have a form/subform for entering vendor purchase orders. I would
like to be able to optionally enter info (in a memo field) for each
line item in the subform. For example, one of the p.o. line items
might be a "special order" for a customer. I would like to be able to
enter the customer's phone number and other information about the
customer for that line item.
Ideally, I would like to click a field on a line item in the subform
and have a "window" pop up that would allow me to enter the customer
information. After entering the info, I would press the 'Es...Public Store Age Limits
I installed SBS 2003 Standard Edition. I moved public folders from an
old Exchange 5.5 server to a .pst file and then from that .pst file
into the public store of this 2003 Exchange server. Exchange set the
Age limits of all these folders to 7 days. So all the e-mails from
over 7 days ago are gone from all the folders with the Public store.
In system manager, servers, server name, first storage group, public
folder store, public folder instances, it shows as a title bar removed
older than and the date of 2/10/2004. I changed the age limits for all
folders to use public store default and made t...Are MFC FTP classes limited to 32bit file sizes?
I have found that when using the GetLength member of the CFtpFileFind class
that the filezizes are limited to 4GB (0xFFFFFFFF).
Now I know that in old versions of MFC, GetLength only returned a DWORD and
one needed to use the Getlength64 function. However I am using VS2008 and
GetLength returns a ULONGLONG.
I then heared about a possible bug in MFC so I derived a class from
CFtpFileFind so that I would be able to see the actual WIN32_FIND_DATA used.
And indeed the low order DWORD is set to 0xFFFFFFFF and the high order DWORD
is set to 0x00000000.
I know that this is not a server issue...Costom Field to PWA Site Template
I have a Custom Field with lookup Table having the name of the Project
server Site Template now i want to create a WSS Site based on the Custom
Which i was able to create it, but i am not able to link it with the Project
server as only those site can be linked which temaplte is there in the
workspace provisioning settings...
Is there other way of doing this ??
See the instructions on Registering a Template in this link:
Note that you should not use a site that has previousl...SQL Field Limitations
I understand that there are 8000 character limitations on
tables in SQL that affect CRM's ability to extend
customizations on any particular object. I also
understand that once a field is created in CRM and
deleted, that, currently, those characters are not
recoverable. Is there any way for me to quickly determine
what usage level I am at on a particular object (current
and orphaned) via SQL query or otherwise.
Thanks in advance.
P.S. I did not do the original deployment and am unable to
get any info from those who did.
deleted? You can't delete a field via CRM,.....you &q...Memo field in cross tab query
Am using Access 2007. I'm linking to a "View" in SQL Server 2005. I want to
create a crosstab query based on that view, however some of the fields in the
view table are Memo and will not show up as options in the cross tab query
Is there a work around for this?
Thanks! Your help is very much appreciated!
You could use a select query that has calculated field to pull the left 255
character of the memo field.
Build a little - Test a little
> Am using Access 2007. I'm linking to a "View" in SQL Server 20...Shipping Field in Purchase Orders
Does the "Shipping" field in the purchase order window actually do
anything other than hold the values of shipping? Or does it append those
values into the "Cost of Goods" or cost of anything?
I am asking this because recently my boss asked me why there was no
shipping charges appended to the cost of goods on a recent purchase order.
Meaning, why wasn't there $.57 added to each item cost to cover the shipping.
I of course replied that the shipping amount was entered into the purchase
order, but then I got to thinking, "does the shipping field even do...Public folder issue, "messaging interface has returned an unknown error"
I'm running a SBS2003 domain and just added a public folder and a
customized form for entry into the public folder. All of our clients
(all XP Pro, Outlook 2003 with all updates) can get to that folder and
use the form without any difficulty except for one. On one computer I
get the classic "The messaging interface has returned an unknown error.
If the problem persists, restart Outlook." error message.
I have tried a repair install, no change.
I have tried making a new profile, no change.
I have tried adding / removing his PST file (currently he's not even
using a pst file...Calculated field in a pivot table
I have a large pivot table in the format as shown at the bottom of
this post. I simply want to add a calculated field to the table for
each function that multiplies "Avg%Compt" by "Avg hours" for each MS#,
done for each Funct within each Subtype within each Type. ie MS1 for
Type A, Subtype 1. Funct ab, = 2.382 (60%*3.97) and MS2 = .5955
I cannot get this to happen. Can anyone show me how to set this
Type Subtype Funct Data MS1 MS2 MS3 MS4
A 1 ab Avg%Compt 60% 15% 15% 10%
A 1 ab NumPermits 301 301 301 301
A 1 a...Database size limit on SP2
Could you please to explain about database size limit on SP2 by example?
Harddisk 70GB with freespace 25GB.
If I setup database size limit to 30GB.
If I setup database size warining to 75%.
Could you please to explain behavior when the configured database size limit
On Mon, 6 Feb 2006 04:48:27 -0800, "Mesak"
>Could you please to explain about database size limit on SP2 by example?
>Harddisk 70GB with freespace 25GB.
>If I setup database size limit to 30GB.
>If I setup database size w...Using workflow to update fields
I am trying to write a workflow rule but am getting a bit stuck!
We have a field to 'contact someone every x months' which is a picklist.
When we create a record we want the system to identify the date it was
created, then use the value of 'every x months', e.g. 3 to update the 'when
next to contact field' which will be a date format. Si it would update the
field to show three months from when it was created. Once the date was
reached we would then want it to update to the next 3 months.
I hope that makes sense - is this possible to do?
Any help & advic...Cannot add fields to a CRM View
I am trying to add fields to CRM Orders view. I need to get the contact
information, and those fields are not available when I attempt to create a
view in Orders. I can easily create a SQL view that does what I need. How
do I get CRM to add fields which are not available in the list?
First, add the fields to the Order Form. Then publish. Then remove from
Order Form. Then publish again
The fields should now be available to add to views
"David_SQLDBA" <DavidSQLDBA@discussions.microsoft.com> wrote in message
news:172...Query in a subform field
I have a database that tracks vacation time. The main form has the basic
employee information and the subform has a list of all the days taken. If
someone takes off Nov. 23-24, the calculated field at the end of the row will
list 1 day. However, this calculation is not working. (I'm using DateDiff).
So I decided to write a query which does work, but I'm not sure how to
attach this query to the calculated field. Is this possible to do?
Thanks very much.
Post your DateDiff calulation for suggestions.
Build a little, test a little.
"Joanne&qu...memo field is limiting characters
I have a form that has two memo fields - both are set to "can grow" and you
can type as much as you like into the fields but when you move on to the next
one the entered text is truncated to 255 characters??
Allen Browne has an excellent short paper on this phenomenon:
The Can Grow Proeprty, by the way, only applies to reports or forms ***if
they're being printed*** which, of course, they shouldn't be.
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via Acc...inbox limit
>From earlier postings I gathered that there is a 2GB limit on the
Outlook Inbox's PST file. I think there is a limit of 64,000 messages
as well. How can I increase this limit on MS Outlook, on MS Windows XP
Can't increase it when running Outlook 97 thru 2002. (Its hard coded into
Outlook 2003 is the only version that breaks this bearer with a new PST file
format. Out of the box it has a software limit of 20GB (unknown item count
because performance basically degrades after a bit). This file size limit
can be increased...Required Field
I have a field on my form that is required for all new records created. This
is the code I have in the BeforeUpdate event on my form.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsNull(Me.RequestedBy) Then
MsgBox "You Must Select Your Name!"
Cancel = True
It doesn't seem to be working properly. Right now if I created a new record
and didn't fill in that field and just clicked the close button on my form I
do get the msgbox but then the form closes. Am I missing something here? It
doesn...Counting the number of fields in a column that have data?
I have an Excel document with about 5,300 rows. One of the columns has
data entered only into some of the fields, maybe 100 of the 5,300 rows.
Is there an easy way to get Excel to count all of the fields in that
column that have data entered in it?
On 1/25/10 4:57 PM, in article eW3gilgnKHA.1548@TK2MSFTNGP02.phx.gbl, "Rick"
> I have an Excel document with about 5,300 rows. One of the columns has
> data entered only into some of the fields, maybe 100 of the 5,300 rows.
> Is there an easy way to get Excel to cou...Exchange 2003 Message limit Problem
I have several users that are getting a NDR when trying to send a message
with an attachment more then 5mb. I have checked the Global settings, SMTP
connectors, and server properties and there is no limits. I also checked the
routing group. I dont have access to check the AD user accounts, but i
doubt that its set there since its only a few people with the issue. Does
anyone have any suggestions? I was thinking maybe its a corrupt SMTP
I appreciate any help that can be provided.
Is the recipient inside our outside your organization?
Ben M. Sch...Make Bit field control value of float field
I've made bit field with the default options of yes and no: new_Q1
Then i've made a field to collect a amount of points, incase the bit is set
to yes: new_Q1p.
If i select the format of the bit value to "list" my script works fine. If I
select "check box", it does not work.
Can any one help me modyfi the script to work with the check box?
Regards, Jacob Mondrup
This is the script I use:
var point = 0;
var get_status = parseInt(crmForm.all.new_q1.DataValue);
switch (get...How to Count Records from a Field in a Report Form
I have a dbase with many fields with dates. One field is a text field and
will only accept certain 2 character alpha characters such as MA, NA, SA,
What I need is a report of that one field which will only give me a number
total of each group of characters (MA's, NA's, etc...) and finally a grand
Thank you for your help!
>I have a dbase with many fields with dates. One field is a text field and
>will only accept certain 2 character alpha characters such as MA, NA, SA,
>What I need is a report of that one field which wi...Limits?!?
Another question people :)
- I setup a user w/ a mailbox limit of 1,200,000 kb
(1.2GB) using AD Users n Comps
- The users is not using the default size limit in Sys Man.
- The user NOW HAS A LIMIT of 120MB??? The email was sent
to him saying he has exceeded his limit.
Anyone know what hap? Anyone know how to change it to
...Vote Tracking issue
Hello everyone. I recently sent a vote out to our exchange users (approx
400-450 users), and noticed that as the responses started coming in, I had
to open each one to tally the vote. No problem, I can handle that.
The issue is, there are about 75-100 that are not being counted and still
remain in my inbox. Is there anyway to process or re-process "Vote
responses" so these missing votes can be counted?
Forgot to mention, I'm using OL2003 with Exchange 2003.
"CC" <email@example.com> wrote in message
news:%23fPZkngYFHA.3840@tk2msftn...Limits of Pivot chart
I created dynamic pivot chart based on Pivot table. But I don't like this
chart much since it change to default when I "refresh data". My question
How can I create a normal dynamic chart based on a pivot table which will
not change to default when I hit refresh data?
Thanks for your help.
See here for more information on the bug regarding pivot chart formating
and how to work with and around them.
> I created dynamic pivot chart based on Pivot table. But I don't like this ...CRM integration for GP: reinstall issue
When I uninstall and reinstall CRM integration for GP, I get a message that
"the user specified does not have all the required CRM privileges." The
Integration User in CRM is a system administrator, and the
domain\integrationuser account is a member of the domain admins group.
What other privileges should the account have? Did I uninstall incorrectly?
Is the domain\integrationuser account a CRM administrator?
"Pete Grare" wrote:
> When I uninstall and reinstall CRM integration for GP, I get a message that
> "the user specified does not hav...