Using onchange event to Hide a field
I would like to dynamically show / hide certain fields on my CRM form based
upon the user's selection from a Picklist. Is there any way to dynamically
show / hide a field on a form using the onchange event of the Picklist?
There is no supported way to do this. You could try setting the visibility of
the associated DIV to false, but no guarantees.
MVP - Microsoft CRM
On Tue, 16 Aug 2005 23:50:12 -0700, "cdobkins"
I would like to dyn...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...Showing a date field as a number
I was wondering if there was any way that I could have a column showing the
date and time (20/12/2007 06:00:00) and another column show the date and time
as a number, (29548). This would be done in a select query, but I am not
Is it possible?
for 20/12/2007 06:00:00
#.0000 (with Decimal Places = to suit your needs)
# (with Decimal Places = 0)
Microsoft Access MVP
Looking for some advice on SQL 2005. I have a table that will usually be
populated by an SSIS package. I want to set the "loaddate" column to the
current time after a record is inserted. Should i do this via trigger or
should i just build a step in the SSIS package to update the column after the
If trigger is the way to go, what is the syntax to create the after insert
Thanks in advance.
You can create a default constraint on the table set to CURRENT_TIMESTAMP. That will handle the automatic date
assignment without any need for coding.
-...Calculation of pricing where both value incl. as excl. tax are whole dollars
For a quotation I need to mention the price in USD, that is including
Both this value and the value without tax should be values that has no
dollar cents as rest value, like USD 30,00.
I am looking for a small tool that gives me the nearest price value
incl. tax above the value that I type in and met above condition.
I type: 1300
Value incl tax 1320
Value excl. 1200
Excel 2003 / VB code ok.
"AA Arens" <firstname.lastname@example.org> wrote:
> For a quotation I need to mention the price in USD,
> that is including 10% tax.
> Both this value and the...Formatting 'Hours' in work field with out decimals
I need help in formating the work hours showing rounded off to next hr,
rather than showing with one decimal. Appreciate help
What about using the Round function?
Round([Field],0) - or something like that syntax.
- Andrew Lavinsky
> I need help in formating the work hours showing rounded off to next
> hr, rather than showing with one decimal. Appreciate help
On Jan 26, 2:05=A0pm, drjayr2002 <drjayr2...@discussions.microsoft.com>
> I need help in formating the work hours showing rounded off to next ...Calculate cumulative elapsed time in Excel?
In column B, I have the time in hh:mm:ss. In column E, I am trying to
calculate the cumulative elasped time (ss) of column B. Please advise.
Use the usual SUM() formula and format the formula cell to
or to display in hour minute format
> In column B, I have the time in hh:mm:ss. In column E, I am trying to
> calculate the cumulative elasped time (ss) of column B. Please advise.
Thanks, that helped. Since I am trying to capture the elapsed time for many
cells, I used =...Font in drop-down field too small
I created a drop-down field with multiple menu choices. I am not able to
increase the font size for those menu choices. The adjacent cells have a
much larger font, and I would like my spreadsheet to be consistent.
If these are data validation dropdown lists, you can't change the font
size. There are a couple of workarounds here:
Juana Cafe wrote:
> I created a drop-down field with multiple menu choices. I am not able to
> increase the font size for those menu choices. The adjacent cells have a
> much larger font, and...Variable field names?
I am trying to execute the following code: -
strSQL = strSQL & Nz([" & strCOM_Year & "], 0)
where strCOM_Year is a string I want the system to use as a field
name. It doesn't like this. Keeps saying 'can't find the field "|"
referred to in you expression', even though I can clearly see in the
debug window that the current value of strCOM_Year is "2006/2007".
i.e. I am looking for the value in the field called 2006/2007.
> I am trying to execute the following code: -
> str...inserting hrs and minutes
I have a cell in my time card that displays total weekly time -ex-
"40:15" is there a way to make it more like this...40hrs,15mins
Message posted from http://www.ExcelForum.com
Use a custom format hh"hrs",mm"mins"
"-Brian-H- >" <<Brian-Hemail@example.com> wrote in message
> I have a cell in my time card that displays total weekly time -ex-
> "40:15" is there a way to make it more like this...40hrs,15mins ?
> ...Pivot Table field settings #2
How can I change the default settings in the field settings? I want it to SUM instead of COUNT. I am having to change multiple fields one at a time. Thanks.
You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.
You could change existing data fields with a macro:
'changes data fields to SUM
Dim pt As PivotTable
Dim pf As PivotField
For Each pt In ActiveSheet.PivotTables
For Each pf In pt.DataFields
pf.Function = xlSum
...Using calculated item to calculate running balances
I have a Pivot Table of a cash book showing monthly transactions per account
as per example below.
A B C D
1 Acc Jan Feb Total
2 100 1000 500 1500
3 200 200 300 500
4 Total 1200 800 2000
5 Running 1200 2000
I would like to add a row at the bottom showing a running balance. This is
easy enough with a normal formula eg B5 = sum(B4,A5) and copied to the
right. This row gets overwritten if the pivot table expands downwards. I
would think adding a calculated item must work, but I do not know how. Can
...insert an interactive excel file into word web page
I'm trying to insert a excel file into a word document with text, and then
save it was as a web page, but I want to keep the excel part interactive.
...Insert | File > Attachmnet-Button Drop Down ;What is the difference between Insert and Insert As Attachmnet
re: "Outlook2003, File-Insert-Options"
On making new-email with Attachment-File(s),
File Menu | Insert | File >>> (Brows and select File to insert )
then we can see the button "Insert", and write side
Drop Down Arrow lower-right side of Dialog Box;
If it clicked,
we can see three options as follows:
Insert as text
Insert as Attachment
I can not recognize/understand the difference
between "Insert" and "Insert as Attachment"
What is the difference between Insert and Insert As Attachment ?
I would appreciate y...Inserting Hyperlinks in a Protected Sheet
I run Excel 2000 and I have a protected worksheet that I share wit
users in my organisation. I want to allow the insertion of a hyperlin
to a specific file type within a specified directory on our server.
1.Protection on disables the insert hyperlink command. Can this b
overcome with worksheet activate code?
2.Can I limit the types of files (preferably by requiring the file t
meet a mask format eg "z-*.xls")?
3.Can I limit the directory that can be linked, by referring to
pathname stored in a cell on the active sheet?
Would appreciate your suggestions.
Thanks S...Calculate Daily Interest, Paid out Weekly
Not sure if the subject makes sense
I have 2 dates
Rate = 8%
Start = 12/28/2009
End = 2/18/2010
This is 7 weeks 3 days
Daily interest = .08/365 = 0.02192%
How do I find what the total for say $35.95 and the end of the period
02/18/2010 - If daily interest is applied at the end of every week.
1. Do I add the 3 days to 35.95 before calculating week1?
2. Is there a built in function that does this
I'm thinking the total should be around 253.20 + the 3 days
What is the principal and when is it paid. Are you talking about one
investment of $35.95...Calc Field to list invoices paid by same check on one line of repo
I have a customer who wanted a check dump file to send to their bank. Once
the bank receives the file (in txt or tab delimited), they will use the
infomration to actually print the checks for the customer. (This is not a
positive pay file situation.) I was able to take one of the check forms and
modify it to get all the data required by the bank. I am running into a
snafu with getting it down to one line per check with multiple invoices
listed one one line. It is listing the total check and one line per each
invoice paid by the check:
Ck 2345 for $800.00 -...Insert with a where condition
Hi, sql 2005
I have an insert statement that is ignoring the where condition. That is, I
want to insert records when they do not already exist in the destination
INSERT INTO dbo.tblmnuGroupPerm
FROM dbo.locmnuTabFunction AS ltf
ltf.mtfID NOT IN
FROM dbo.tblmnuGroupPerm AS gp
Any ideas or recommendations appreciated :-)
It's OK... <oops "redFace">I did not correctly se...Calculation of weather data help
I have a data file (at http://www.weatherweb.net/cliall.dat) which contains
daily weather data from 1881 in the format:
dd,mm,yy,max temp,min temp, rainfall, sunshine, wind speed, wind gust,
What I would like to do is to calculate means for max, min, wind speed, wind
gust and pressure, and also total rainfall and sunshine for each month.
I would like the output in the format:
mm,yy,mean meax, mean min, total rain, total sunshine, mean wind, mean wind
gust, mean pressure
Can anyone give any assistance as to how I might do this in excel to create
a sngle file contain all th...Insert
I want to overtype in a Publisher text box. I find I can only insert. The
"insert" key doesn't do anything.
...Error when adding a custom field through Deployment Manager
I am receiving an error when trying to add a custom field through the
"An error occurred during the addition of the new field. The addition
failed. For more information, see the event log".
The Application event log lists the following entry:
"dmLog: Failed to grant access to the regenerated view Account after
inserting new attribute CFSTest."
My domain login has domain admin privelages and is a member of the
System Administrator role in CRM.
Any help with this would be greatly appreciated!
this usually means the field is already there... if you c...how to insert data in a table
I am creating an access database in which I want to insert data in
already created table.
Vikky <firstname.lastname@example.org> wrote in news:1194124711.012302.269990
> Hi Exprets;
> I am creating an access database in which I want to insert data in
> already created table.
> Kindly help.
Data from where? Do you want to import it from excel, from a text
file, copy it from another table or type it in manually?
PA is y I've altere...How do you insert page numbers larger than 1000?
I have my purchase orders set up as a Publisher document. When our
organization upgraded from Publisher 2000 to Publisher 2002, the new version
set parameters on the page numbers. This was one of those things that worked
just fine in the previous version... Does anyone know how to turn it off or
Hi mregen (email@example.com),
in the newsgroups
|| I have my purchase orders set up as a Publisher document. When our
|| organization upgraded from Publisher 2000 to Publisher 2002, the new
|| version set parameters on the page numbers. This was one of those...DAO recordset on memo type field >255 long
I have a table with a memo field with data frequently >
My ultimate goal is to copy data from that table into a
word document table.
The method I am using is to query the table using a DAO
recordset and then I loop through the record in the record
set and insert them in my word table using vba code.
When the data is > 255 characters long, the characters
after 255 are not displayed properly in the recordset and
therefore in the word document.
Any idea what can be done about this? Maybe a different
method for accessing the data?
...Case (in)sensitivity of table names/field names
I would like to work with Microsoft Access 2003 and Windows XP or Windows
Are table names case insensitive?
What about field names?
Thank you very much for your kind help.
Yes, both are case insensitive, as is data. IOW, a search for either peter
or Peter would find you.
Arvin Meyer, MCP, MVP
"peschrader" <peschrader@hREMOVEMEotmail.com> wrote in message
> Hi !
> I would like to work with M...