Is there a list of characters that Word considers equivalent on Fi
Word's Find will find "equivalent" characters. For example, a find for
straight quotes will also find curly quotes, and a find for a space will also
find a non-breaking space.
Where can I find a list of the characters that Word considers equivalent in
...Autofill In Linked Forms
I have created a couple of forms by selecting all the fileds in the form
wizard from two tables:
1. Suppliers (Fields: Supplier, Address, Contact, etc.)
2. Products (Fields: Supplier <Lookedup from Supplier Table>, Product, Rate,
Upon clicking the toggle button on Suppliers form I have the Products form
opened. However, as I enter the data in it, I want the Supplier filed in the
same be automatically be filled with the Supplier name as in the opened
Supplier form so as to be filtered and displayed the next time I open the
same instead of manually inserting the sa...Problems with Outlook hanging (possibly CRM1.2 problem)
Apologies for the cross posting, but I'm not sure which is th ebest
newsgroup to help...
I'm Running a server with SBS 2003 & exchange. Installed CRM1.2 (at the
moment it's only on the server & I can access via the web). I've not yet
installed the Outlook client on my laptop.
The problem is that I've been experiencing major "hangup" problems when
connecting my laptop to the server. Everything works fine until I open up
Outlook, then, although I an "ping" the server I am unable to access it
either from Outlook to synchronise emails, ...how do i change the default value of measure from points to inche.
how do i change the default value of measure from points to inches when
setting the width and hight of cells?
You don't. Excel uses only points for these measures
remove CAPS in email address
"yoyo4u" <email@example.com> wrote in message
> how do i change the default value of measure from points to inches when
> setting the width and hight of cells?
Row heights are measured in points. There are 72 points to an inch.
Th...rollback combobox to 'BeforeUpdate' value
How do I set a combobox to a previous value? When finished updating a
particular record the user selects an identifer in a combobox to advance to
the next desired record. I use the BeforeUpdate event of the combobox to ask
a yes/no question. If NO I want to stay with the current record and this
works. the problem is that the combobox has been advanced to the new
selection and stays there. Now I have the identifer for one record in the
combo box but the form is still (as it should be) on the current record.
I need to roll back the combobox to what it was before the update bu...How to have combo list sorted
I have set the following data name:
How to get all data in the right onummeric order?
It seems to be with offset($D$2,0,0,counta($D:$201),1).... likely looks
like the upperformula I use.
But the combo is not sorted when I use it.
You would have to sort the source data:
Whatever's in this range Par!$D$2:$D$201 needs to be sorted.
"AA Arens" <firstname.lastname@example.org> wrote in message
>I have set the following data name...Changing source links in powerpoint
I currently have a powerpoint with source links to other powerpoint slides.
These source links are currently internet address based links. I'm trying to
change these current internet addresses to new internet addresses and each
time I try I receive the error message: "You cannot use an internet address
here. Enter a path that points to a location on your computer or on the
network". I've been able to change the source links in the past and only
began to encounter this problem around mid December. Does anyone know how to
correct this or explain why I can no ...Hiding scrollbars
I have a CListCtrl with a manually implemented vertical scrollbar.
Is it possible to allow scrolling in the properties of my CListCtrl and be
able to disable the vertical scrollbar so I can use the horizontal one only?
It was more a case of showing the Horizontal scrollbar that was needed than
hiding the Vertical.
Even though NoScroll is set in the properties, can I assume then that this
ShowScrollbar(SB_VERT, FALSE) and ShowScrollBar(SB_HORZ, FALSE) are set?
"Tony" <email@example.com> wrote in message
news:OjfQkQdCFHA.3...Chart to show Portfolio Value over time?
I'm using Money 2003.
I would like to be able to see the $ value I have in my
portfolio over time. So that I can weep.
Money does have a chart view that allows you to see the
PRICE history for a given stock over time - but not the
dollar value of your investment in the stock over time.
In fact, I can't seem to find a view at all that shows you
the net value of your portfolio/individual stocks changing
The best I've been able to do is to use the "Net Worth"
report and unselect all the other accounts. This has
insufficient granularity (months instea...How can I combine data from a list?
For example: suppose I had a very simple list, with two columns: "Name" and
"Number". The category "name" has three items: Dog, Cat, and Dog. Each of
those three items has a corresponding "number" value: 3, 4, and 5. I'm
trying to find a function that would recognize the fact that I have "Dog"
listed twice, and would sum the 3 & 5 values listed next to each "Dog",
leaving me with a two-item list: Dog, 8 & Cat, 4.
Is there a way to do this?
A Pivot Table will do that nicely for you:
Set the Name as a ROW and the ...Insert empty numeric value
In VB, I have three textbox which are amount1,amount2 and
amount3. After user enter
the value in the textbox, I will insert the value into Access table.
The table have three columns
amount1 , amount2 and amount3, and all are nummeric Type. However, if
the user do not enter
any value in textbox . The insert statement will become as follows:
Insert into table1 (amount1,amount2,amount3) values (,,) Then access
there is syntax error in insert statement. Does that mean I cannot
insert empty value for the
numeric value in access.? How to solve this problem. Than...Possible to Look Up Records by Initials?
I have a user who's telling me that prior to this weekend in CRM, she could
lookup user records by initials rather than typing in part of the name. I
don't see where that setting would have been marked in CRM. Has anyone else
heard of this? If so, how did you implement this type of search
Steps to recreate problem:
Account Owner field's magnifying glass
Assign to another user fields magnifiying glass
Look Up Records' Look For field = initials of user you're attempting to Find.
I doubt you can use the init...Subtracting value from main form
I have a borrow module which will alow user to return item separately. So, I
have get the structure of returning it separately.
In my main form is the borrowing item, with the loaned quantity and the owed
quantity (will be calculated).
In the subform, there is the returning transaction. User will need to key in
the quantity returned and it will be automatically deducted from the quantity
But how am I supposed to get the quantity deducted while it 1 is in main form
and the other is in subform?
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-fo...Is it possible to add a "View" button under the purchase order section?
Would be nice to have the abilty to allow someone to be able to view the
purchase order as opposed to the given "new, delete, edit, or receive"
buttons. This way someone who needed the information and did not have the
appropriate security would not be able to delete or change the PO. I tried
to CTL S the new, delete, edit and receive buttons, but that basically locks
them out completely. Is this something that may be possible?
You can make excel pivot table so any employee can view that worksheet from
their terminal. This way you can define the fields you want to show as well
...Replace null value with the previous value?
I have a database that was just imported that has approximately 388000
records. The problem is that there is information about a person in multiple
different records but the name did not come across with each record. (So I
have 10 records with information for a certain name, but the name only
appears in field 1 of the first record and not the subsequent 9, etc.) I
need to create a query or expression that will fill field 1 with the
preceding value if it is null. This way I will have all the information for
field 1 in a manner that I can link and combine data.
Simply I need to fil...How do I convert a list to an Excel file?
I have a WORD file with 48 lines of comma delimited data in the form:
I would like to convert the WORD list to EXCEL.
When I attempt to open the WORD file in EXCEL, I thought a conversion window
would appear....what I actually get is "incorrect format"
Save the WORD file as a plain text file.
Then, when you open the file in Excel a Wizard will open
and step you through it. Just select COMMA as the
>I have a WORD file with 48 lines of comma delimited data
in ...How do I find a value on a line?
I made a line graph of data to use as a calibration. I know the y value and I
want to find the X value. Is there a way that I find find this specifically
on the line without using a trendline formula or guessing by looking at the
The only way to find a specific value is to use the formula.
If you can accept piece-wise linear interpolation, see
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity s...Calculating values for empty cells.
I have a very simple problem that I cannot find the answer to. I have data
in two columns, some of the data in one of the columns is missing and I want
to automatically extrapolate what the data should be based on the trend. How
can I get Excel to fill in empty values without overwriting the known
values. Below is a sample of my data.
Not sure what yo...Default value for custom field?
How can I populate a custom field with a default value?
Specifically, I have a custom field "DisplayName"
associated with the Quote Detail object. I want initially
to populate this field with the value of the product name
field when a new product is added to a quote. The user can
then edit the DisplayName custom field if desired. The
DisplayName custom field will be used as the product name
on a Crystal Reports quote form.
...Possible to create a rule to alert on BCC messages?
Using Outlook 2007/Exchange Server 2007
I sometimes miss that I'm receiving an email as a blind copy. I was hoping
to create a rule to alert me when I'm in the BCC field. However, when using
the rules wizard, I only see the options regarding my name in the To or CC
field. Is there a way to create this that I may be missing?
In article <#pJLIK1ALHA.4704@TK2MSFTNGP06.phx.gbl>, firstname.lastname@example.org
> Using Outlook 2007/Exchange Server 2007
> I sometimes miss that I'm receiving an email as ...Payables Transaction Edit List
Our customer had the following error print on the Payables Transaction Edit
List: **ERROR: One of more landed costs need to be apportioned.Document
Total. This prevented the user from posting the batch. The batch went into
However, the error message did not appear when logged in as 'sa' and 'sa'
was able to post the batch. This customer does not even own the landed cost
module. Plus, this was an A/P invoice, not a POP invoice. Why was this
...CTreeCtrl::DeleteAllItems requires resetting the image list, why?
If I call a CTreeCtrl's DeleteAllItems method it seems that I also have to
set the controls image list again otherwise the control does nt show either
the items icon or text.
The following fails:
m_tree.InsertItem(_T("Test"), 0, 1, TVI_ROOT, TVI_SORT);
Where as the following works:
m_tree.InsertItem(_T("Test"), 0, 1, TVI_ROOT, TVI_SORT);
I am trying to use the list box function from the control
toolbar. I am not sure how to get the listings I want in
the list box. Is there certain VB coding that is needed?
Any help will be appreciated. Thanks.
No VBA code needed. In Design mode, click on your list box and select
Properties from the Control toolbox (or right-click your list box and select
Properties), then scroll down to the ListFillRange Property and indicate the
cell range address that has the items you want to appear in the box (i.e.,
A1:A10). Then exit out of design mode and test your list box.
"Tod...visited links no longer change color
The links still work when clicked but, no longer show purple when visited.
This happens in both Outlook and Outlook Express. Yesterday I tried making
fonts a little larger as I have eyesight problem. Not sure if this is when
the link color problem started.
What I did exactly is:
*Tools > Options > Mail Format > click "Fonts" button > click "International
* At first I went through the list making each one "Larger" font size.
* I realized that it's probably only "Western European" I need to change, so
all others were set ...Re-exporting functions from dynamically linked DLL
I have the following situation:
I have a 3rd party DLL which does not include a LIB file, just a header file
with typedef declarations for exported functions (It is intended for dynamic
I need to wrap the DLL to allow for callbacks to my own code (in Lisp), and
to do this I need to load the DLL using LoadLibrary and access each function
that I need using GetProcAddress.
So for example:
The third party header will say:
typedef INT (WINAPI * lp_function)();
Then in my c wrapper file:
#define DllExport __declspec(dllexport)