how many lines per sheet in excel 2003
ave they increased the number of lines in excel 2003 or is it still 65536
Still, ever heard of 'categorizing'?
On Sun, 17 Jul 2005 16:04:01 -0700, Des53
> ave they increased the number of lines in excel 2003 or is it still 65536
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Row and column specifications are unchanged in xl2003 (65536 x 256).
I have heard no suggestion that these are likely to change any time soon
"Des53" <Des53@discus...many-to-many relationship
Is it possible to create a custom entity with many-to-many relationship
with another entity in CRM 3.0?
a student can take multiple classes (so if I click on a student
account, I can see the list of classes he has registered)
a class has multiple students (so if I click on a class account, I can
see the list of registered students)
v3 doesn't "officially" support a M:M relationship. But you can create a
new entity that has 1:M relationships with the 2 entities in question, thus
creating a M:M relationship.
MVP - Microsoft CRM...Error with permissions, error sending messages, just too many erro
I must be doing something wrong, because everyone I've shown this server to
says they have nevre seen this many problems with Exchange on an
out-of-the-box installation. It never occured to me that extreme sensitivity
of this application would be the biggest problem I am having with it...
I can right click on a message in my Public Folder contact lists, click on
"New Message to Contact" and it will create an e-mail to the person. Sounds
good right? This process works for every single folder *EXCEPT* one. When I
try to send a message to any contact in that folder (and i...too many named ranges?
I have created several named ranges and they are for list box data
validation. Some of the ranges are over 1000 rows long, and I am also
setting data validtion to 1000's of rows and I think I just got a message
that there is no more room or memory.
Is this a problem?
What else can I do for the look up tables?
You do not say what your system specifications are, and softwar
versions you are using.
Looking up in Excel Help "limits in Microsoft Excel" it shows tha
numer of names is limited by available system memory. The size of rang
referred to would have no bea...How many files is an IMC of Exchange using?
I have an issue with my Exchange 5.5 IMC, which was added after the
Exchange, its Service Pack(4), and Hotfixes were installed. I suspect there
might be some files, if IMC is not just using MSEXCIMC.exe, mis-matching at
Could anyone who knows provide me the info in the subject line?
Thanks in advance
What is the issue?
eric z wrote:
> Hi everyone,
> I have an issue with my Exchange 5.5 IMC, which was added after the
> Exchange, its Service Pack(4), and Hotfixes were installed. I suspect there
> might be some files, if IMC is not just...Query duplicates results due to many-to-many relationships
I have a query with fields from different tables. Two or three of these
field may have one or more entries. When I run the query, if it displays a
record where there are multiple entries for a particular field, it will list
the record multiple times. An example: This DB involves officers using
force - if there is more than one officer involved, each one will be listed
with the applicable level of force and if the subject is arrested, there may
be one or more charges enterer - assuming there are 2 officers with 3
charges, that record may be listed 5 or 6 times, but the multipl...Make Table Query
How do you add (in run-time) primary key and indexing to a table (during
creation or after creation) when it has been created through a make-table
query? Either from a designed query or VBA SQL statement.
...Bug in CEdit::GetLine()??
I am trying to return a string from a single-line edit control using the
CEdit MFC class by following the sample code in the MSDN library. However,
it does not work properly when I try to use a CString buffer but works with a
stack-allocated buffer. Here are the 2 versions of the code. The first one
doesn't work, the second does:
// 'editbox' is declared as a CEdit variable via MFC wizard in the dialog
// class definition.
len = editbox.LineLength();
ptr = buf.GetBuffer(len);
editbox.GetLine(0, ptr, len);
buf.ReleaseBuff...Many to Many Relationship Report
I am hoping this is possible, any help is appreciated:
I have 2 tables:
I am trying to get:
but my query comes out:
CC# Router# Switch#
1002 1 3
1002 1 4
1002 2 3
1002 2 4
Is there a way to get this result?
=?Utf-8?B?...CRM has too many clicks for almost every task.
Initial feedback from new users after 3 weeks in the system is that the
Service module requires entirely too much clicking to accomplish: opening a
case, putting a service activity against that case, closing the service
activity, and then resolving the case. For our service organization, most of
the time this sequence takes longer than actually doing the work the case is
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the mess...concantenate then index match
Is it possible to concantenate one cell with text with another cell with a
number in it and take that result and then use it in an index/match formula
to find a result? Or will it not work? It looks like this:
C1 D1 E1
2 3 A
C3 D3 E3 F3
A 2 3
1 H H H
2 S S S
A3 D D D
Now, Concantenate D1 & E1, then use the Index Match with cell C1 to find a
result of D in cells D4 through F7. Hope I explained my question properly.
...Indexing Outlook 2007
I'm using Outlook 2007.
When i try to do instant search i got this message "results mybe incomplete
because items are still being indexed bla2...
Is there a way to expedite the indexing?
How to monitor whether outlook have finished with the indexing?
...Many to many relationship
Anyone knows how to create a many to many relationship between two entities?
I created both a "many to one" and a "one to many" relationship between two
entities and it worked. But then when I tried to enter the data to have, for
example, many support people speak to the same customer and many customers
speak to the same support person, I could get it done.
Thanks a lot
Notice in CRM how the "Quote" has many "Quote Products" and the "Quote
Products" has one "Product". In CRM, if you were to create a
relationship from ...Bug in 7-day week view Outlook 2003?
Can I ask other folks here to try this one...
I work shifts so my working week is effectively 7-days and I also happen to
prefer the "look" of the WORKING WEEK view with the appointments showing as
vertical time lines... I have noticed that IF the working week options is
set for all 7 days and I then switch to the 7-Day View (using the button on
tool bar) then the display seems to be corrupted... only if I click the
up/down buttons to advance the dates shown will the display be re-drawn
correctly... the other workaround is to click on the MONTH view FIRST then
click on the 7-...CRecordSet and Table Indexes
How can I use CRecordSet to get the index name of a table? If not CRecordSet, what can I use? I need to capture the index name at runtime.
I think you want CDaoTableDef::GetIndexInfo. The TableDef is where the index functions are
Firstly, a table can have many indexes...
It Depends. If the DBMS is SQL Server or one of the later versions of MS
Access then you can use an INFORMATION_SCHEMA view (See SQL Server books
If you are wishing to obtain schema information then the above views are the
right things to use.
If you are wanting to identify what i...Attachments collection bug ?
I'm developping a macro to remove all embedded images from my company's mail
templates, but although the templates actually contains images, the
attachments collection remain empty at runtime. And the part that drive me
crazy: in debug mode, the collection is empty (Count=0, etc) until I expand
manually the "attachments" node of my mailitem object in the "Locals" window,
then the collection is populated.
The embbeded images are of type olOLE and there is no other attachment in
the templates. Is that a bug or am i missing somet...How many data points can you have in an Excel for a Scatter Chart.
I have a customer that has indicated that he can only plot 400 data bites in
an Excel Scatter Chart. Is the correct for Excel 2002 or 2003?
What does a "data bite" represent? What error message do you get?
You should check the XL help topic 'Excel specifications and limits'
specifically the 'Charting specifications' section. One undocumented
limit is that the length of any token in the SERIES formula cannot
exceed be more than about 250 characters. So, if one selects lots of
non-contiguous ranges, it is very possible to exceed that limit.
Tus...how many partitions or drives
i am setting up a exchange 2003 cluster with 2 storage groups
How many Luns or drives should I have total for this cluster?
Each SG needs a LUN for the Store (EDB + STM) and another one for the
You can place transaction logs for both SGs on the same LUN if you want -
make sure they're not on the same LUN as the Stores.
SG1 Store(s) = LUN1
SG2 Store(s) = LUN2
Transaction Logs = LUN3
Quorum = LUN4
Each Node = volume for OS
Scale up = volume for pagefile (I've not felt an overwhelming need to
separate the page file, but some do... ).
Mailroot can be moved t...Help please! Lookup/Index query.
I am trying to run a formula, that will look at the data I have in
spreadsheet 1 and try and match in spreadsheet 2. One it does, it will
transpose data from Spreadsheet 2 column A into Spreadsheet 1 column C.
The difficulty I am having is in matching, there is a slight difference in
how the data is referenced in column B of each spreadsheet, but column B is
the column I need to use for the matching.
I have put some sample data below, does anyone have any suggestions?
...receiving error "id" is not an index in this table error 3800.
When trying to access a table in a exsisting database, I get a error box
stating "id is not an index in this table. Accessing the help button for
this error. The statement of Error 3800 is displayed. Does anyone know how to
clear this up? Is it a failure with Access or the state of the database?
>When trying to access a table in a exsisting database, I get a error box
>stating "id is not an index in this table. Accessing the help button for
>this error. The statement of Error 3800 is displayed. Does anyone know how to
>clear thi...Too many many-to-many?
To all, I hope you can shed some light on this for me.
I am using Access 2003.
I have three main tables
3) Service (general contracting, soil testing, architecture, etc)
I have two 'join' tables to create a m:m relationship between Projects and
Contractors and Contractors and Services
I would like to be able to create a form where I can select a project, then
select one or more contractors, then select one or more services that each
contractor could offer (and track when they start and end those services...Is this a bug?
I have a spreadsheet with numbers in Col. A. The numbers are betwee
.01 and 10.00. All numbers are with 2 decimal places. In Col. B,
have the formula "=MOD((A1*100),2)". The answer I'm expecting is
zero or a one and in most cases this is true. However if the number i
Col. A is 1.14, instead of a zero, I get "-1.42109E-14".
To see if this was unique to 1.14, I filled A1:A1000 with all of th
numbers between 0 and 10.00 in steps of .01 and put the formula i
B1:B1000. Most answers are zero or one, but in 67 of the 1000 numbers
I get a number similar to the one I...I have a column of many many numbers how can i split them up auto
I have a group of numbered data that I can split into different columns using
text to column. I now need to place a blank row in between each row of
diffeerent data. Can this be done
Give a few examples of what your data looks like and what you are
trying to achieve. What do you mean by "different data".
On Dec 3, 8:23=A0pm, Kevin <Ke...@discussions.microsoft.com> wrote:
> I have a group of numbered data that I can split into different columns u=
> text to column. =A0I now need to place a blank row in between each row of
> diffeerent data. ...vc++8.0 bug: access violtation upon any call of any CImageList methods
I have sucessfully imported and compiled a complex MFC 6.0 project from
vc++6.0 (MFC6.0) into vc++ 8.0 (MFC 8.0). It contains several
subprojects (libs and dlls). In vc++ 6.0 those project linked MFC6.0
statically and after I imported it to vc++ 8.0 I set the linkage of
MFC8.0 to "shared". However when I try to compile and link the project
in vc++ 8.0 in release mode (debugmode works fine) I get an acess
violation in afxcomctl32.inl. This happnes whenever I call any of the
CImageList methods. When I comment out all lines that call mehtods of
CImageList everything work fine i...Counting how many different names in a long list
I have a list of 332 names many of them are duplicated. I am looking for
a formula or function that can count how many unique names there are in
Can anyone help?
Quaisne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28052
View this thread: http://www.excelforum.com/showthread.php?threadid=501357
This'll count the number of distinct values in a range:
(adjust the range to matc...