on a form, to a new field I have added . The result I get is a bit weird. The
script I run is as follows. Please excuse me if this is not great syntax. I
var dt = new Date()
var d = dt.getDay()
var m = dt.getMonth +1
var y = dt.getYear
var h = dt.getHours
var n = dt.getMinutes
var s = dt.getSeconds
var str1 = "nfq-"
var str2 = "-...Custom Number Format #7
Hi I have a column in Excel that needs to be converted as
follows, I think I can do this using "Format" - "Cells" -
"Custom Number" but am not sure what to type in so it
keeps the first character as text followed by 5 digits
(adding a zero to the end)
The account numbers need to become 6 digit (zero at the
end) but retain the starting letter
If you just want to display the value with an added zero, use
You can convert the numbers using a helper co...Auto Formatting Custom Number
I'm creating a form where you can enter a credit card number. I set a
custom number for the cell and described it as ####-####-####-####.
You can enter a 16 digit number just fine, but when you tab away from
the cell and the custom number takes place, it changes the last digit
to a "0". Has anyone else encountered this? How do I fix it?
CSBUG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28846
View this thread: http://www.excelforum.com/showthread.php?threadid...Customizing UI
I have searched thru the SDK documentation on the microsoft web, and found
"Note Beyond adding custom buttons and menus, developers do not have the
ability to change the functionality of the Microsoft CRM application."
Does this mean that if I want to hide some of the navigation tabs, such as
the Competitors tab from the Opportunity form, it is not possible? Has
anyone done this before? And if so, how? Is it supported?
Found the answer: you can do so with the Security Roles.
"Rich Phan" <rphanNOSPAM@4hae.com> wrote in message
n...Customize Outlook Today does not work in Outlook 2000
For some reason when I click on Outlook Today and try to
Customize the settings in Outlook 2000 the button simply
blinks and nothing happens??? Is there a way around this?
Has anyone experienced this in O2K? Is there any way to
customize the Outlook Today screen easily if this is not
Thanks very much
I have the same problem and have not been able to find a
solution. If anyone has any help it would be appreciated.
>For some reason when I click on Outlook Today and try to
>Customize the settings in Outlook 2000 the button simply
&g...no "recurring pattern" field for tasks in field chooser
I am trying to customize the current view of tasks in
Outlook 2000. The field "recurring pattern" is not in the
list of fields for tasks in the field chooser. This is a
valid field for tasks, and I want a custom report that
shows the freqency of recurrance. Can anyone help?
RecurrencePattern is a complex field that is a binary. All the
recurrence information is kept in this binary blob with various bits
having different meanings depending on whether a daily, weekly,
monthly or yearly recurrence pattern is set in the blob. There's no
possible way that could be displayed in ...Office license in Business Continuity (Commerical customer)
Hi Office Expert,
I would like to ask some questions regarding Office.
My company has around 500 users and working on a BCP enviroment (Business
1) Given that Office via volumn license has secondary right, do I need to
buy another 500 Office licenses for Business Continuity purpose?
2) Does it only apply when the user has a portable notebook; the portal
notebook doesn't need another Office license?
db·´¯`·...¸><))...Custom function returning VALUE error
I am trying to construct a simple function to calculate distance
between 2 points on Carthesian plane. The function I wrote:
Function FieldsXY(startx, starty, endx, endy)
FieldsXY = Application.SQRT((endx - startx) ^ 2 + (endy - starty)
The only result I'm getting is #VALUE! error. I tried to declare all
arguments as integer, didn't help. Help would be greatly appreciated,
as I'm no expert in this :).
alex.k's Profile: http://www.excelforum.com/member.p...Automatically age customer balances
Every month/week/day we can run age customer balances.
How can I do it automatically?
I know that by default system settings it's not possible,
I am interesting in other solution,
run script after any user logged in,
any other issues...
All information are very welcome.
I know there is a system process monitor that appears to run things (like
the "do you want to change the date" at midnight). If you could somehow use
this to run macros, this would be the ticket. (i think you can in GP)? But
...I asked one dex guy if we could in sbf and he didn't thin...Advanced Find for Customer Address does not show Parent id
I need to get a list of Customer Addresses with some criteria in Advanced
find and I would like to see the Contact they are related to. I have selected
the column parentid to be shown in the grid, but it is blank for all the
rows. It seems to be a problem of rights but I am logged in as Administrator.
Can anyone help me?
...Show custom messes up my FREEZE PANE
When I use VIEW->Custom and any views I created, sometimes when I do a SHOW
ALL, my FREEZE PANE is really messed up! Some times it will be off the
screen and I can not get to the data at all until I UNFREEZE, and then I can
reset the FREEZE PANE. I always only lock my HEADER row.
Any ideas how to resolve this? What causes it?
...Modify Address Book/GAL Fields/Tabs
I have an Exchange 2003 environment (SP2 is applied). We use Cisco VoIP for
voice communications, and have added everyone's extensions to the ipPhone
field in ADUC. By default, the address book does not show the ipPhone
field. Is there a way to map the ipPhone attribute to a field which does
show in the address book (perhaps Business 2) or to add a tab to the address
book with ipPhone information?
Thanks in advance,
David J. Baranski
Electrical Equipment Company
...Save Import Mapping Fields
Is there a way to save import mapping information? Once we move to
production and migrate all of our data from ACT to CRM 3.0, we will have
weekly lea information that needs to be imported. Is there a way that I can
save my lead import mappings so I don't have to create it new every week?
Unfortunately not through the Bulk Import wizard. Couple of options ... 1)
create your own import routine in .Net against the CRM web service (this
works great, gives you complete flexibility, but requires a little .Net
coding), and what I'd personally recommend. 2) Use the DMF (Data Migrati...Access, how to base a query field criteria in a macro
I have a form based on a query 'maindata' .
I have based the criteria in the query as one field from form
[switchboard]![hawk] or the same field from a different form
If the first criteria is false (i used the switchboard_dept form) it asks
for the first criteria, is it possible to step through this without the user
seeing this? or is it possible to put the criteria in macro's?
...Customizing home page
Is it possible to customize data display for snippets (such as "Spending by
category") that can be placed on the home page? I am talking about
customizing what time period and what kind of data is displayed.
Zooming in and changing the settings seems to work for some snippets (cash
flow forecast, for example), but not for others - it doesnt work for
"Spending by category". No matter what I set in details, the snippet on the
home page always displays data for the last 30 days.
If you know the way to customize it, or know that it is a known problem,
please tell me the...Custom Draw and CListCtrl
I would like to write a custom draw CListCtrl and the first method I
would like to implement is SetBkImage() (because it doesn't exist on
My question is in which custom-draw method should I draw background ?
What are the steps to follow ?
Have you tried doing it with OnEraseBkgnd instead? Examples of CustomDraw in
ListControl are available at codeproject/codeguru.
"Mosfet" <email@example.com> wrote in message
> I would like to write a custom draw CListCtrl and the first metho...how can I display a custom error prompt?
I have a form that has required fields... How can I display a message that
says something like, "You must enter a city, state and zip code"?
I'm not much of a coder, but if someone can give me an example, I can
usually figure it out....
Thanks in advance!
The basics are that you can display a message box on many events (on even
non-events) on a form, like this
MsgBox "Some message here", vbOKOnly, "Message title"
So if you ant to display the message after controlABC on a form has lost the
focus you can use something like
Private Sub co...CRM hosting for multiple customers
Company A would like to host a CRM 1.2 solution for two separate customer companies, B and C.
There are 2 users each from company B and company C.
Company A would like to just install one common IIS and one common SQL Server for B and C.
The customer environment should of course not be mixed up and both the companies (B+C) should have their own database and CRM configuration.
So, is this possible? Person BB from company B logs on via Internet and get access to company B's database and CRM system when person CC from company C does the same, accessing his database at the same time? Coul...Importing Customer Balances
When using a tool like eConnect or IM to create customers in GP, is there a
way to import a balance? In consolidating from other systems, customers have
balances, but do not need the history of the transactions that make up that
The way I have done this is to import one transaction per customer (either
an invoice or credit memo) with the balance. Name them all something like
BALANCE or IMPORTBALANCE so that it's clear what this is.
Dynamics GP MVP
Want to use Crystal Reports with GP?
http://www.flex-solutions.com/gpreports.ht...Offline Terminal DataBase + Custom Table #2
I use the terminal database offline withe my POS (rms 1.3R).
I create my database with Pos administrator, specifie the server for offline
When I generate Z report , the database synchronize items and customers. But
my problem is : I have a custom Table with Price connected to the Item's
table, and this table doesn't synchronize with the offline database.
Is it a solution to my problem ? or a tips ?
Sorry for my english.
Off course MS not take care what you have added or deleted your own as this
custom table is your own creation so ther...Best Way to Add Custom Control to Dialog
I've written a custom control. Note that this is simple a CWnd-derived class
that has it's own interface, etc. It has absolutely nothing to do with COM
I'm not sure what the best way is to put an instance of this control on a
dialog box. I can create it in the dialog's OnInitDialog handler but it
seems like the dialog would like to know about it before this (for example,
the control doesn't appear to get its font set from the dialog box when I
create it this way).
I just tried adding a custom control to the dialog resource and then adding
a control variable of...Separate Text from Record Field
I have a text field that has multiple pieces of data that I need to separate.
For example 1,2,3 is inside one field. Does anyone know of a way to separate
this field into three separate records by using the comma or some other
Thanks for your help in advance,
On Thu, 2 Aug 2007 09:48:04 -0700, RobSol wrote:
> I have a text field that has multiple pieces of data that I need to separate.
> For example 1,2,3 is inside one field. Does anyone know of a way to separate
> this field into three separate records by using the comma or some other
>...Need to change date in field to whatever I want
I have a database for my research. I need to change the date, so that I do
not have any restraints on my admissions. I have checked the data field for
date of admission and it looks exactly the same in the data field, but for
some reason, the date will not allow me to move forward with 2010. I am not
sure what to do. Can you please help. This seems to be the only field that
does not change to what I need it to change to. I currently am able to use
the date for 2010. in other date fields except for one field. Please any
suggestions. I am very new in setting or using access.
...How to create a Fill-In field code with a selection of information
How to create a Fill-In field code where user enters one of three choices,
associated with three different copyrights and addresses?
Either a DropDown type FormField if you are using Word 2003 or earlier or a
ComboBox Content control if you are using Word 2007.
The former however requires that the document be protected for forms which
cause problems and in that case, you may want to make use of a user form.
See the article "How to create a Userform" at:
and the following pages of fellow MVP Greg...How do I identify a blank field?
I am trying to stop a user adding data into a subform before it's
parent record has been created, so I am testing the key field of the
parent to see if there is one:
If Forms![Order Form]![Order Details].Form!PK_Order = "" Then
MsgBox "You need to start by clicking the New Order / Enquiry
button or the Quotation button."
MsgBox "Order number '" & (Forms![Order Form]![Order Details].Form!
PK_Order) & "'"
Now the display following quite clearly shows me, the value of
PK_Order is '' (that's the quotes on ei...