Calling function pointers
I was looking at the Dynamic Array functions exported by commctl32.dll
(prefixed DPA_ and DSA_)
Although there doesn't seem to be anything there that really couldn't
be achieved in VB, I was still slightly disappointed that some of the
more interesting functions (DPA_Merge for example) are exported by
I'm assuming that this means those ones aren't callable from straight
As far as I know, we can call API using ordinal number.
Private Declare Fun...New so-called features in Outlook 2002 -- can they be defeated?
Hello all. Our office recently got "upgraded" to Outlook
2002. It has a couple of so-called "features" which I
find incredibly annoying and impossible to defeat. I'd be
interested if anyone has found a way, other than the
ridiculous workarounds listed on Microsoft's website. The
two features which annoy me most are:
Displaying both the name and the email address in email
Displaying two entries in the "Select Names" dialog box
for everyone who has both a fax and an email address, that
is, virtually everybody.
If anyone can te...Customize Products HTML Custom Field?
I'm looking for a way to add a formatted description to my products.
I'm thinking of using an html doc per each Product. I will then be
able to dynamically update my web site and create catalogs on the fly
using Quark. I've noticed that the contol in the Email Activity might
be useful. Another issue I've encountered is that I'm only able to add
simple custom fields to a form (string, number, pick list etc.)
through the Schema Manager. Any suggestions on how I should go about
this would be greatly appreciated.
I am trying to customize a vertical bar chart, where the x axis is the areas
being measured and the y axis is the units of measurement. I have been
trying to shade a particular range within the overall plot area, not the
entire area. Specifically, the y axis range goes from 40 all the way to 160.
I just want to shade or fill in a specific range (85 to 115) within that
overall range. Is there a way to have that range (85-115) shaded only and
the other ranges (116 and higher, and 84 and lower) left untouched? Any help
would be appreciated. Thanks!
The technique describe here w...Custom Tailoring An Access Report to fit an Existing Form Fed Printer Receipt Fo
I work for a State Correctional Facility as the Mailroom Supervisor and
Computer Help Desk Representative.
While Inmate receipts are still being written by hand there is a Stand-Alone-
Computer Receipt System, consisting of a Stand-Alone-Computer, Okaidata 321
Impact Printer, 3 color part copy form fed preprinted/number receipt form,
and Lotus Approach Software, that generates Inmate receipts.
The flaw with the Stand-Alone-Computer is that when it is used each following
day the following days receipt information is lost instead of being captured
in a database.
I am in the proces...specific rank in column value
I have a column of names, with a column of values next to it that
corresponds. The column is about 100 values long.
I want a table that says
Highest Value / name
2nd Highest Value / name
3rd Highest Value / name
3rd Lowest Value / name
2nd Lowest Value / name
Lowest Value / name
I don't want to use the rank function because i don't want a seperate column
next to my data with its ranks, also because the column is always being
I just want a function that does "look in column B, find rank x, return name
from column a", that ignores blank values.
...FUNCTION problem, Please Advise
I have "IF" formula...
c69 - number.
m4 result if c67=c69
0 if not.
When I'm copying that formula (dragging with mouse.. autopaste) I'm getting
autochanging in formula
a problem is I dont wanna that G69 will change, so it will be in all others
How can I do it?
"Nison Maksumov" <email@example.com> wrote in message
> I have "IF" formula...
> c69...Custome Label sizing
I am using Publisher 2002 SP3
I have a custom label made in Publisher 98 which does not print
I have A4 as default paper size.
Page information is:
3 across 10 down
Page size 6.67 x 2.54
I need this to be 7.0 x 2.5 but it is grayed out.
How can I change that?
What are the dimensions of your labels?
MVP Microsoft [Publisher]
"Robin Chapple" <robinski@ANTI_SPAMmelbpc.org.au> wrote in message
>I am using Publis...Function relating to merged cells #2
Thanks for that Ji
Chisel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=935
View this thread: http://www.excelforum.com/showthread.php?threadid=26677
...Econnect Custom Requesters
One of my developers created an econnect custom requester for an application.
The application is moving from development to production. How can I move
the custom requester?
...Looking for a specific Excel function/formula
Hello-I am looking for the function/formula that will give me th
Cell D4 has a numerical figure-it is a percent
I want cell D6 to show the following:
If Cell D4 is 30% or less, then D6 shows 0
If Cell D4 is >=31% but <=35%, D6 must show 15% (or .15)
If Cell D4 is >=36% but <=41%, D6 must show 25% (or.25)
If Cell D4 is =>42%, D6 shows 3% (or .30)
Message posted from http://www.ExcelForum.com
"petern >" <<firstname.lastname@example.org...Screen size is too small when customizing
For some reason, when I try to edit the Account form and customize it, I
can't get the entire form to fit on my screen.
If I resize the window, it still cuts off the bottom part and there is no
scroll bar available to scroll down.
I'm runnning a laptop with Win XP with resolution set at 1024x768.
I did a ctrl+N and got a scroll bar.
> For some reason, when I try to edit the Account form and customize it, I
> can't get the entire form to fit on my screen.
> If I resize the window, it still cuts off the bottom...Customizing Excel toolbar to add Median function
Is there a way to add the Median function to an Excel toolbar? All I've
been able to add is the Insert Function which takes me to all functions
-- I would like a button that I could click that would take me
automatically to only the Median function.
ksham's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16681
View this thread: http://www.excelforum.com/showthread.php?threadid=318931
...Is there a way to control the height of a row via an excel function?
I'm trying to control the height of a row determined by the contents o
I can't seem to find a function or command that is available to me t
Alternatively, is there a way that I can 'hide' or 'unhide' a row base
on a cell's contents?
Best to you!
Message posted from http://www.ExcelForum.com
The only way I know of controling the height of a row is
by using the Format/Row/Autofit, it might be possible uing
VBA, try posting the question under programing see what
answer you get. However, for the second part of your
questio...Customizing RMS customer statements
Does anyone know how to add verbage to the customer statements? ie. I want
to note what our finance charge policy is on the bottom of the customer
In our Store Misc Utility we have many features one of which is enhancement
to A/R Statement that allows you to configure different Duning notices for
customer that have balanace over 30, 60, 90 etc... As well as allowing you to
soft configure and type hearder and footer messages.
If you want to know more contact me.
Afshin Alikhani - [email@example.com]
CEO - Retail Realm
"jord...Cannot customize Outlook today #2
I have outlook 2000 on some XP pro machines and when they
click on customize outlook today nothing happens
..."Error" ODBC Call Failed
After I converted an Access97 Database to Access2K, some
of the queries opened with no problems, some others gave
me an error message "ODBC-- Call Failed [Microsoft][ODBC
Visual FoxProDriver]Index does not accept Null (#886)"
The database has Visual FoxPro link tables for which I
used ODBC to link them.
Thanks a million.
Check out the KB article at
Try relinking the tables as described. You should use a file DSN as well
when building the link.
Lead Program Manager, Microsoft Office Acce...SUMIF function
Hi, please help...
I am trying to total up commission figures in a column that match a specific
year. Each row contains a cell for the date it was entered, the customer
details and commission earnt.
I have used the SUMIF funtion so far but cannot find the correct criteria
for it to identify the year in the date cell and include the commission in
the SUM if the year matches the criteria.
The formula I have used so far is: =SUMIF(Websites!B5:B31,F2,Websites!R5:R31).
F2 refers to a cell with the current year automatically entered by using the
TEXT function: =TEXT(TODAY(),"yyyy"...customizing a field in customer maintenance screen
I have a field already on the customer maintenance screen that is a user
defined field with a data type of string, but this field only allows 20
characters. This field is not long enough and I can't seem to figure out how
to allow more characters. So, I created a new string field and added it into
the customer maintenance screen. I can see the field and type text into the
field but after I save it and go back in, the text is no longer there. I
think I need to link this field to the table in some way but I'm not sure how
to go about doing that or even what table to link it to...Customizing and changing the default country in Contacts template?
When entering telephone or address information in Contacts in Outlook 2007,
the 'Country' field defaults to 'United States'. Can this default setting be
made a user option to customize and change to another country. For users
outside of the US, it is tedious to continually have to override it.
Outlook will use whatever you have set as the location for your operating
"djwallac" <firstname.lastname@example.org> wrote in message
> When entering telephone or ...Office2007 Custom UI Editor and our Addins-How to show our Addin t
Need to know how to show our add-in tab when using the Office2007 Custom UI
We know how to make the built-in tabs visible but not how to show our
Your addin will be on the addins tab.
Other than that, you need to build a custom group or tab.
"MB34" <MB34@discussions.microsoft.com> wrote in message
> Need to know how to show our add-in tab when using the Office2007 Custom
> We know how to make the built-in t...Possibly an IF function?
this is a 2 part questionI have a list of 11 items in a drop down menu in
column A that when selected I need to have a corresponding value appear in
column B, C and D. I think I can only do 7 nestings and would like to do all
11, plus have the ability to register a 0 for anything not in the formula.
Column A B C D E
Auto Single 10 1 0
Auto Multi 15 1 0
Life 0 0 1 $163
The 2nd part ...Customize autoformat?
Is it possible to customize autoformat? I frequently used "LIST1" but want
to change the default color.
There's no way to change the items in the AutoFormat list. You could use
a macro to change the colours after they've been applied.
> Is it possible to customize autoformat? I frequently used "LIST1" but want
> to change the default color.
Excel FAQ, Tips & Book List
...@which function to use when
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.
On Sat, 9 Jan 2010 01:43:23 +0530, "Sandeep Lohchab"
>Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
>54.52 and I want to know which fuction/formula to use for making these as
>88.25, 89.00, 72.40, 54.50. Please help. Thanks.
Try this formula:
Hope this helps / Lars-...If function with color or bold face
Supposing I want to give a formula that if a particular cell is > 40,
1) make the color green else let it remain as it is
2) Highlight it in bold face in black itself else let it remain as it is
Kindly let me have the answers for both 1) and 2).
Thanks in advance
LEARNING MS OFFICE THOROUGHLLY
Why not use conditional format
keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21287
View this thread: ...