I am using this formula fro
It works great but it assumes they work through lunch. I have trie
unsuccessfully to modify the formula (mainly because i dont understan
Lunch runs from 12:00 u...setlinkondata and application.caller help
I have the first code in the "Sheets1" code block, and the next in a
general Module. The setLinkOnData seems to work as when I manually
update the DDE link I do not get the beeps signifying that it's
running the first sub. When I step through the second one, it crashes
with Error 2023 at
If anyone can tell me how to get application.caller to work or else
how to pass the range as a parameter between the subs, I'd appreciate
aLinks = ActiveWorkbook.LinkSources(xlOLELinks)
If Not IsEmpty(aLi...Application OK in Win2000 but crashes in WinNT
I am developing my application(Dialog based) using VC++ in
Windows 2000. The application was working fine in Windows
After compiling to the release version and copying it to
Windows NT, the application fails to start up.
After debugging in Windows NT, it shows that my
application fails to create the dialog box with the
DoModal() function. It fails when the function
...Usage of code samples in commercial applications
Is it legal to use code samples found in sites like Codeguru/ CodeProject in
our commercial applications? Are there any license issues that need to be
taken care of ?
It is legal unless specified otherwise. Most of the people posting code
snippets are doing it because they got something from somewhere at some
point and they want to give back. There are some more complex things that
are restricted or where someone will say, "you can include but you must have
this copyright", but for the most part people are just sharing code ideas.
I've actually ended up us...Lunch the application after login page and before desktop !!!
Is there any way to lunch the application after login page and
before desktop? I know one way to add the entry in Runoncekey. I
want this application to run every time the user log in. Couple of
problem with Runoncekey....
1. This key is meant to use just for one time application
2. User can use cntr+alt+del and cancel the application.
I want this application to stay there till user hits "OK" and then
show the desktop. There shouldn't be another way for him to skip this
Can anybody help?
Not possible. The only way you can do it is by cha...Record and play macros in application
I've been asked if I can add a macro record/playback facility to an
application I've developed.
Does anyone know if there's an API for this? Failing that, does anyone
have any suggestions how I should undertake this task? Pitfalls to
avoid? Anything at all really.
It seems, at first glance, that there's two ways to do this; add a
'record' option (in the code) to every place a user can "do" something
(e.g. a dialog is about to be displayed, control values have been
changed) or to somehow record mouse clicks and key presses whilst
recording. Both m...Did You Spend $7 On Lunch Today???
Do you want a real value for your money that gives you a TRUE return? All
this for mere lunch money! Click here for full details:
...Detect page change in PropertySheet?
Hi, I have a property sheet that is the parent of several property pages. If
the user clicks a tab to change to another page, is there a way I can detect
this (and possibly prevent the change) in the PropertySheet dialog? Does
windows/MFC send any kind of message to the PropertySheet dialog?
I looked at all of the over-rides and WM_ message, but cannot see anything.
Not directly. You can catch that in the CPropertyPage and relay the message
to the CPropertySheet. (I know you are asking, why doesn't the
CPropertySheet get the notificatio first? who knows!)
"...Problems porting application from VS6 to VS.NET
This message is in MIME format. The first part should be readable text,
while the remaining parts are likely unreadable without MIME-aware tools.
Content-Type: TEXT/PLAIN; charset=iso-8859-1; format=flowed
Hello. I am experiencing problems with my application when I try to=20
compile it with Visual C++ .NET.
It consists of a main program which loads an MFC extension DLL with its=20
own dialog box and some ActiveX controls.
The program runs without errors when compiled with VC++ 6.0.
There appeared to...possible to enumerate page numbers?
If any CRM object has big data(let's suppose that Opportunity has 50000
in the View, you can see those data by page number.....
However, by default, it only navigates by one page...In other words, if I
want to see 15 page, I should click 15 times to look at the page...
Any way page number can be customized via CRM system customization?...
I couldn't find it...
For example, if I want to have viw something like this...
1 2 3 4 5 6 7 ..........(Would be last number of page number)
In this way, if I want to look at the 15 page, I only need to click 15
Thanks....log in page message
on my login page, one of the users always has a message
that there is 1 unread email, but there are no unread
Not in Outlook Express either?
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Bob" <email@example.com> wrote in message
> on my login page, one of the users always has a message
> that there is 1 unread email, but there are no unread
> emails anywhere.
...User account mechanism in an application
I want to make an application which has an user account mechanism. Every
user should also have specific permissions. The administrator can create new
users and give them permissions for several functions in the Application.
For now I have a simple inifile which is stored encrypted ( a simple user
"database") (user.dat). This inifile contains information about what users
exists and what permissions they have.
I know that is not the best way and thats why I am posting - the key for
this file is always the same and hard coded in the application. This is a
very bad way but wher...Creating Modeless Dialogs continually causing application to grow
I have a dialog applicatin that needs to create modeless dialogs over and
over again. The main application waits for the modeless dialog to finish,
then repeats the procedure. I've written a simple test application that
seems to exhibit the same symptoms.
Main Dialog with some code removed to simplify: ( NOTE:
CModelessDemoDlg::OnBnClickedButton1() is used to begin the test of creating
CModelessDemoDlg::CModelessDemoDlg(CWnd* pParent /*=NULL*/)
: CDialog(CModelessDemoDlg::IDD, pParent)
m_hIcon = AfxGetApp()->...What event does application call when it is ended abnormally?
I use MFC Visual C++ 4.2.
I need to know what event / function will be called by the application in
case of they ended unexpectedly due to errors / power supply problem, etc?
I will need this to decide the end of server-client connection in case one
of them experiencing error and must be ended abnormally.
>I need to know what event / function will be called by the application in
>case of they ended unexpectedly due to errors / power supply problem, etc?
Sounds like you're looking for WM_LOWVOLTAGEDETECTED ;)
If your hardware is dead, so is your software :)
>...Server Error in '/' Application. ==> Login failed URGENT ISSUE
i am getting the follwong error when i try to run my CRM 4.0 on web
client. I have done all installation correct and still struck with this
problem. Your help in solving this issue will be very helpful as this is an
urgent issue with us.
I am attaching the error i got below
Server Error in '/' Application.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace...Save Application State to XML: How to have each module create a "Node"?
I have an application which is built from many modules. I re-use the
modules in different applications.
I'd like to have each of my modules implement a "SaveState()" method.
The method should return the state of the module (and any modules it
contains) in some nice, easily parsable and savable format. I think
this format should be XML.
So should each module return an XmlElement, an XmlDocument, or an
XmlDocumentFragment. I've been experimenting and I can't figure out
the best way to do this. I'd like to do it "right" because I'll be
doing this a l...Application.wait
Can anyone tell me what library reference I have to install to use
application.wait in my VBA in access 97 ?
There is no Wait method for the Application object in Access.
What are you trying to do? You might be able to use the Sleep API (see
http://www.mvps.org/access/api/api0021.htm at "The Access Web" for an
example), or, if you're trying to wait until a shelled process is finished,
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"jon" <firstname.lastname@example.org...Assumed Lunch
I need a VB code for assumed lunch.
=(E6<D6)+E6-D6+(G6<F6)+G6-F6 is the code I am currently using to calculate
total hours worked per day.
D6 is "StartWork", E6 is "StartLunch", F6 is "EndLunch" G6 is "EndWork".
Our employees do not punch out for lunch unless if they are going to be
longer than 1/2 hour. Otherwise we just assume 1/2 hour or "no lunch" if
they write "no lunch" on their card.
To address the assumed lunch:
What I need is a VB code so that what I enter in "StartWork" (E6) is
automati...Reload the current Page Programmatically
How can I re-load the current page within a code behind event file. I'm
changing the page Theme and want re-load the page with the new Theme
"King Coffee" <email@example.com> wrote in message
> How can I re-load the current page within a code behind event file?
...Milo: Struggling with trying to create a 8.75 x 11.25 bleed page P
I've been trying all kinds of things with MSPublisher and Adobe Acrobat to
create an 8.75 x 11.25 document so that the printer can truncate it to 8.5 x
I've sort of found a way to make the page the larger size and declare a 1/8
1) when I go to look at the page, it thinks it's one of four pages because
it exceeds 8.5x11
2) the PDF I create with Acrobat cuts off anything I have in that 1/8 frame
around and gives me just the document background color there. So it's not a
true bleed of the pictures I'm putting on the page...just a bleed of the
backgr...How to use my application to download a file on a http server?
<a href = "1.rmvb" >download</a>
I use WebBrowser ActiveX in my application.
If I click download on WebBrowser ActiveX,My application will use IE to
download.But I want to use my download application
to take the place of IE.How to do I should?
Try using URLDownloadToFile.
Ajay Kalra [MVP - VC++]
"Z.Smith" <z...Saving Excel Spreadsheets as a Web Page.
I just reloaded my old Office CD on a new computer that
uses Windows XP. I lost the "Save as HTML" option that I
had on my old Windows 98 operating system. How can I get
this feature back?
You have to enable the "Internet Assistant Wizard" add-in...
1. Tools | Add-ins...
2. Select the "Internet Assistant Wizard" option.
3. "Save as HTML" now appears on the file menu.
If you find that the Internet Assistant Wizard is not in the options, you
need to install it from the CD (along with any other add-ins you may need).
&quo...Quick Part page layouts
I am trying to set up a template in Word 2007, with protected styles, that
has Quick Part items that insert a custom layout (margins, header, footer,
page nos. etc) in either landscape or portrait orientation.
One QP would insert a section with portrait layout (with a different first
The second QP would insert a new page section in landscape (with different
The final QP would insert a new page section in portrait (with the same
margins etc., as the first section).
The second and third QP would not have a different first page.
I have tried ...How to get the applications folder path
what is the VBA command to get the application folder path in mac office 2004?
Can't be done in VBA: look in the AppleScript dictionary.
On 4/12/09 1:09 AM, in article
A72637CD-D311-45BE-AA70-7B5AE24CADC5@microsoft.com, "Mac Office Developer"
> what is the VBA command to get the application folder path in mac office 2004?
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Wo...Grant permissions to a single application
Is there a way to limit user's access to data files only if the request to
open a data file comes from a particular application ? As an example: Let's
say you have a Word document and only want users to be able to access that
document thru Word--not Windows explorer, not any other app.
On 12/03/2010 21:16, Dave Mc wrote:
> Is there a way to limit user's access to data files only if the request to
> open a data file comes from a particular application ? As an example: Let's
> say you have a Word document and only want users to be able to access that