Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...Creating array of specific object types dynamically
little gotcha. Some COM objects requires array of specific type.
To give you example, following DOESN'T work:
[array]$X = @()
However below code works:
[int32]$X = @()
For my framework, array type can be dynamic and I don't know in advance what
type it's going to be. So what I would need is below:
[$PropertyType]$X = @()
This doesn't work with error message "Unable to find type".
As a workaround, I solved it using following:
Invoke-Expression "[$$PropertyType]`$Var = @()"
This code works as expected, I am just curious if ...Distribution Files for MFC in VS .net 2003
I have an app that was developed under Visual Studio VC++ 6.0 & MFC and
deployed at our customer site.
I have since installed Visual Studio .NET 2003 and rebuilt the application
under the new development environment. I wanted to do a quick test of the
executable and copied it up to a test machine and tried to run it. I got a
series of "unable to find xxx.dll" errors.
I realized that none of the new DLLs were installed on the test machine.
Does anyone have a pointer to a good document on what distribution files are
required? I know about the obvious ones like MFC71.DLL...Save formatted text from RichEdit control to rtf-file
How can I save the text from Rich edit control (2.0) to *.rtf , *.txt ,
I tried to get the buffer and putting the buffer to file, then saving
but the text in the file is something different.
Please let me know what to do?
Here is the Code I ma using:
mFile.Seek( 0, CFile::begin );
int iTotalTextLength = m_oChatMessageControl.GetWindowTextLength();
HWND focusWnd = ::GetFocus();
cBuffer2 = m_oChatMessageControl.GetSelText();
I was wondering. How come it is possible to clone a file (using right
click copy/paste file), but not possible to do this for other documents
(apps and clip-art etc)?. Could it be possible to have an add-in in
excel to prevent people from copying documents on their desktop??
You can copy files that way (rightclick|copy, rightclick|paste).
But most windows applications are no longer just simple .exe files (like back in
the old DOS days).
They usually have tons of other stuff that gets installed with them--and that
stuff gets scattered all over your harddrive (windows folder, wi...automaticly create graph
what i would like to do is create a spread sheet where by i entered the fixed
and variable costs as well as the selling price. i would then like a graph to
automaicly change and display the this info.
Does anyone know how to do this.
Decide which cells on the spreadsheet you wish to include in the chart.
Select those cells. Follow the menu option: Insert/ Chart, and answer the
questions in the wizard.
Have you looked in Excel help at the topics concerned with charts, starting
with "Create a chart"?
Have you looked at the training material under
http://office.microsoft.com/...Trying to create an Update query based on HR data to find upline V
Hi All, looking for some advice. I have an HR table that contains employee
information but does not contain management chain info. Basically i am trying
to determine who the employees upline VP is. The fields i have to work with
are [Employee Name], [Manager Name] and [Job Title]. I figure the logic would
be to check the employees' manager and if the manager is a VP (based on job
title), return the manager's name to a field called [VP]. If the manager is
not a VP then check that manager's manager, so on and so forth until a VP is
Any ideas would be much appr...Create static text from cell reference
I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1
This gives me the contents of A1 on a line above the contents of B1 and
What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...how to build the netsample ipconfig to the exe file?
i want to make ipconfig.exe.
and i could found the sample code.
but it source code builded to the lib file.
in ipconfig sources files,
the project is .lib file. but the source code has a _tmain() funciton in the
it's looks possible to compile to the exe file.
how can it compile to the exe file?
You can add the SYSGEN_NETUTILS and you will have the ipconfig.exe
integrated to your OS.
Search ipconfig in the cat...How do I export Lotus Approach files into an Excel spreadsheet?
I need to export data from Lotus Approach to Excel; please help. I am using
an old version of Lotus SmartSuite 9.5 and I have Microsoft Office 2003 Basic.
Well, I don't know Approach at all but is there a common file format that
both use e.g. comma delimited. If so , save in that format from Approach and
import into Excel.
> I need to export data from Lotus Approach to Excel; please help. I am using
> an old version of Lotus SmartSuite 9.5 and I have Microsoft Office 2003 Basic.
...Creating a Graph
i want to create a grapg dynamically getting the values from a file..
take for example the first row is the x axis and the second row is the
y axis. i am planning to do this in mfc. what needs to be done for
this.. if somebody has an example relating this please send me the
link or the code.. thanks
Read the data. Plot it.
First, you have to read the data. You read the data and build an array of <x,y> pairs in
whatever way you want to save them, e.g., int, float, double. This is pretty elementary
To do a graph in a very fancy way, you should use an existing gra...retrieving folders.old file
probably been posted before, but need some help. i was
getting the "MSIMN has caused an error in directdb.dll" i
found the solution by renaming the folders.dbx file to
folders.old. here's the problem, i opened express back up
and my sent folder was empty. my question is, how or can
i retrieve that old sent message list??
...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...Need code snippet to read offline PST file
I have a PST file in my local hard disk and have requirement to read
PST file and parse through all folders and then each message item in
all folders and then segregate them to different folders based on
Please kindly send the code for the above requirement.
Thanks & Regards
You're going to have to write your own code. Do you know anything about
Outlook programming at all? You can start out by looking at information and
code samples at www.outlookcode.com.
[MVP - Outlook]
http://www.slo...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...Any FREAKIN' way to import DBX files into Outlook 2003
Importing via Outlook | Import from another Program or File
Importing via Outlook | Import Internet Mail and Addresses
Exporting from Outlook Express
Tried Many, many times...
Can Microsucks make this any more complicated...
It's a FREAKIN' DBX file collection
NO - No other Application has it Open.
YES - The Files ARE there
YES - the Internet Account IS there
Yes - I've wasted more of my time IMPORTING into Outlook Express in
VISTA just to RE-EXPORT back to Outlook. What a bunch of freakin'
Another 2 hours wasted - because one Microsoft applica...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...Opening .prn files in XL2000
I am using a software that does not save data/reports in .csv or .xls
formats; only in printed versions. Is there a way to save the printed
report in a file and open the file in XL2000? If there is, how is the print
file produced, where is it saved, etc? A friend suggested setting up a
generic printer but didn't know how to go about it.
You may want to give that other software just one more chance--look under File
and see if there is a SaveAs option. You may find something upon further
But if you want to add a generic printer, I think it'll depend on your version
of win...Import reg files into Registry, without UAC
I've got a .reg file to be imported silently in a batch. The file contains
only entries in HKEY_CURRENT_USER, therefore can be imported without
This works well with the regedit /s switch on limited accounts, however on
admin accounts, elevation UAC prompt is still shown, even though it's not
How can I prevent this?
Jens M�ller wrote:
>I've got a .reg file to be imported silently in a batch. The file contains
>only entries in HKEY_CURRENT_USER, therefore can be imported without
>...Retreive a deleted file
How can I retreive a delted file
If you have setup Excel to automatically create backup copies; then check
that folder for the last backed-up version....If it is from your PC, check
out the Recylcle Bin (on your desktop) and restore the file. If the file was
on a network drive you may need to contact your network administrator and
check whether they can recover.
Jacob (MVP - Excel)
> How can I retreive a delted file
Go into your Recycle Bin. If deleted from there;
Where do i find my log files?
On an NT based system: go to start, run, type eventvwr,
then hit enter. There you'll see the application, system,
and security logs.
>Where do i find my log files?
...Create a Loop for create a phone call
Excuse me for my bad english
I am developing a workflow, which must create automatically phone calls and
assign them to certain users of the following way: it must create the number
of 10 calls and to assign them to user 1, to create 5 calls and to assign
them to user 2
the data of the phone calls is in a database
I am trying to create a loop but I have not found like
I am thankful for your help
You will need to do this using the CRM SDK/web service. Do something like :
CrmService service = new CrmService();
// Setup the CrmService class here
foreach (U...Creating formulas to calculate time on a 24 hr time clock
I have to create a spreadsheet that will calculate total
hrs worked. I've tried several different ways but I guess
I don't know enough about building formulas to actually
make the thing work. For example, I used a basic formula
D3=A3-B3+IF(A3>B3,1)*12. This works to show the time but
not the number of hours worked. If an employee comes in
1/2 hour late, it does not properly calculate this. How
can I correct my formula?
I have tried your formula and it works fine (with start time in B3 and
finish time in A3). Format the reult as h:mm and it's OK.
"MWI...how to read .MSG files without Outlook ?
How to read .MSG files without Outlook ?
Do you know a good .msg viewer ?
Thanks to everybody ...
to the best of my knowledge, there isn;t a msg viewer. You need to use
outlook or exchange messaging client.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
...Need to show file properties dialog box
I need to show the shell's file properties dialog box. I tried
converting old vb6 code into vb.net but it gives me error. Here's my
Private Structure SHELLEXECUTEINFO
Dim cbSize As Long
Dim fMask As Long
Dim hwnd As Long
Dim lpVerb As String
Dim lpFile As String
Dim lpParameters As String
Dim lpDirectory As String
Dim nShow As Long
Dim hInstApp As Long
Dim lpIDList As Long
Dim lpClass As String
Dim hkeyClass As Long
Dim dwHotKey As Long