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 ...Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the
query outside of the form, it works fine - prompting me for both criteria.
However when I run from the form, I get #Error#. Can you see what I am doing
wrong? Thanks in advance.
I have two combo boxes that I have put in my underlying query. In the
fields of the query are:
[Forms]![frmSelection Criteria Form]![OfficeNumber]
[Forms]![frmSelection Criteria Form]![Manager]
On the OnClick event is the following:
Private Sub Command6_Click()
On Error GoTo Err_command6_Click
Dim stDocName As String
st...Office 2007 SP1 fails on Windows Update. Then Outlook 2007 won't w
Installed Win 7 Ultimate, McAfee VirusScan and then Office 2007 Ultimate on a
clean hard-drive. All retail versions (from MSDN discs). All appearsto work
Then did a Windows Update and applied 39 important updates, including Office
The Office 2007 SP1 install failed, and after that point, Outlook 2007 no
longer works - it starts but won't let me do anything.
Word 2007 seems to still be working.
What to do? Should I be installing Office 2007 SP2 instead?
Any errors associated with the failed install?
TIP: Insert your Office 200...Microsoft Great Plains SDK Documentation.
Any idea where i can find Microsoft Great Plains SDK Documentation.(We dont
have Microsoft Great Plains License).
If you have a Universal subscription to MSDN you are able to download the
SDK information for Microsoft Great Plains.
Any views contained within are my personal views and not necessarily
Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nath" <Nath@discussions.microsoft.com> wrote in message
&g...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...Lock-Protect documents
Excel 2002 sp2
How do you protect cells from being edited? I need to lock/protect all but
4 cells from being edited on a worksheet. I go into the 'format cells'
properties of the 4 cells and 'unlock' them, and go into the 'format cells'
properties of the rest and lock them. Then I go to tools, protection,
protect sheet, I add a password and check only 'unlocked cells'. This isn't
doing it, I can still edit the sheet, I emailed it to someone else and he
can edit the sheet. What am I doing wrong? Thank you!
You could prompt for a password using an in...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 do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...How to sort calendar entries on "size"
I would like to remove large size calendar entries by
being able to sort on "size". I am able to sort Inbox
items on size but not calendar. My company's exchange
server has email account size quota and a 3rd of that
quota is being held up by calendar entries on the server
side, so I would like to get rid of the unwanted past
celndar entries that occupy portion of my account quota.
Any help is appreciated.
On 11/18/03 9:21 PM, in article email@example.com,
"Umesh" <firstname.lastname@example.org> wrote:
> I would...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...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...clip ART #7
i AM HAVING TROUBLE DOWNLOADING CLIP ART FROM OFF LINE WHEN i DOWN LOAD IT AND TRY TO OPEN IN IT'S ALL FILE NAMES AND NO PICTURES JUST WORDS HELP
When you download from the ClipArt site the file is either .cil or .mpf depending on
your version. Double-click the package and the images will automatically go into your
Organizer/Gallery. You may have lost the association too, right-click the file,
properties, opens with... change, point to your Organizer/Gallery.
Mary Sauer MS MVP
"Janet Price" ...Using atl based win dll with CString functions from the mfc projec #3
I have atl based general windows dll with class which contains functions
which uses CString as parameters or return values. This dll might be used
from the atl or mfc project. Dll can be used from ATL project without
problems but whenever I try to use this class from the MFC project I get the
following linker errors:
error LNK2019: unresolved external symbol "__declspec(dllimport) public: int
__thiscall MyClass::AddMenu(long,class ATL::CStringT<wchar_t,class
StrTraitMFC_DLL<wchar_t,class ATL::ChTraitsCRT<wchar_t> > > const &,long)" ...
If I replace CStri...Lexmark driver for Windows Vista??
does anyone know how to get a driver for my Vista program for a Lexmark X75
Any help appreciated?
On Sun, 3 Jun 2007 15:07:39 -0500, "Kitty Stringfellow"
>does anyone know how to get a driver for my Vista program for a Lexmark X75
>Any help appreciated?
I'd suggest reposting your question in a newsgroup supporting Vista, or
Lexmark. This newsgroup is for questions about designing relational database
Queries in Microsoft Access.
John W. Vinson [MVP]
...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...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...Not using zeros in graphing.
I have a running workbook that has tons of information. I have added a sum
page in order to have all the data summed up in one simple place. I have
formulas that read back into the workbook to link to a cell. Depending on
what moth it is, that cell could be empty as it is a yearly wookbook. For
example, if this is August, then there is information in the workbook up to
August, but none after. With that said, the sum page has the #DIV/0! in the
cell which essentially equals zero. I also have graphs that I have linked to
this sum page. My problem is in order to keep the graphs up to...invoice for envelopes with windows
What invoice template can I use that will consistently place the name and
mailing address on the invoice form so that it will always fit in the window
of an standard #10 business envelope?
There is no standard location for the window. I would suggest folding a
piece of paper and measuring where the window is on the envelopes you use.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Mary" <Mary@discussions.microsoft.com> wrote in message
> What invoi...using vba so search multiple Sheets
i'm trying to search across multiple sheets based on data submitted via an
input box. So essentially, you click the button, a box appears, you type what
your looking for and if it finds it, it'll select it otherwise a error
i found the below code, but it only works if the cell with the value in it
is active (i.e. i've clicked on it).
Dim sheetCount As Integer
Dim counter As Integer
Dim currentSheet As Integer
On Error Resume Next
currentSheet = ActiveSheet.Index
datatoFind = InputBox("Please enter the value to search...DPM and VMM on same server using side-by-side SQL installation
Windows 2008 Std R2 Server, 64bit
VMM 2007 is currently installed (with the built-in default database) SQL
2005 Express Edition, SP3, 32bit.
I was advised by Microsoft that both VMM and DPM could be installed on the
same server (small DR environment)
The VMs are hosted on a Windows 2008 Enterprise Server w/ VS2005R2 - because
the hardware didn't support HyperV.
VMM works great to manage the Windows 2008 VS2005R2 Host running Win2K3
server instances ... after lots of trial and error.
Now, I need to install DPM 2007 onto the same server... DPM wants to install
the 64bit vers...Only new email window?
Is there a way that I could have a shortcut on my desktop that does not open
the whole application, but rather ONLY open my new email window? I send out
a lot of email, and I also have a lot of other apps running.
Please let me know if that is possible. Thank you,
Steve F. <email@example.com> wrote:
> Is there a way that I could have a shortcut on my desktop that does
> not open the whole application, but rather ONLY open my new email
> window? I send out a lot of email, and I also have a lot of other
> apps running.
Create a shortcut whose target is:
"%Pr...Use a VBA Macro inside an Excel Cell
This is a multi-part message in MIME format.
its been helpful to me so maybe it will do good for you too:
how to create a simple macro within Microsoft Excel, and then how to use =
that macro to calculate a single cell value.