Time Stamp form open and close
I have a form that is used to enter data. I have a time stamp for each entry
but would like to capture the data entry session for an immediate printout of
a report on the entries.
Upon entering the form I would like to mark a variable with a time stamp,
allow the user to enter all they want, then when they exit the form, record
the end with a time stamp. I would then like these two time stamps to be
used to capture the data for a query then report.
Any suggestions on what would be the best place to start?
learning by playing
It sounds like you are trying to save user...Closing down Outlook 2003
Just upgraded my Office XP to 2003 and everything works
just fine with the exception of Outlook which hangs and
won't close down properly. After a "forced" close, it
won't start unless I reboot the PC. Any ideas?
I would do a Detect and repair from under the Help menu in Outlook 2003 and
see if that helps. It could also be related to 3rd party products, try
starting Outlook in "Safe" mode and see if you can close properly.
296192 OL2002: Additional Command-Line Switches
sa...Change "Close Opportunity" form
How can i change the "Close Opportunity"-form? We've installed a Dutch
version of CRM, so I don't know how the topmenu-values are called, but here's
When you are in an Opportunity and you click on Actions -> "Close
Opportunity...", there will pop-up a form. And i want to change that form but
i can't find it....
What do you want to change? The only thing you can control on this form (in
a supported manner) is the list of values in the drop downs.
MVP - Microsoft CRM
"AmonRa" <AmonRa@discussions.microsoft.com...Closing a form error 2585 This action cannot be carried out while processing a form or report event
Closing a form error 2585 This action cannot be carried out while
processing a form or report event.
This message is occurring in a pop-up I have created to add line items
to an invoice.
The form works fine if they create a line item and click the ITEM DONE
button which adds the item to a temporary table and then executes Call
This is the code executed which simply determines which module called
it, reopens that form, and closes the current form. This work fine
under normal circumstances.
If Public_CALLED_LINE_ITEM...Additional lookup for contacts on opportunity form
I try to customise CRM 3.0 without any training - therefore a question
for which I need some help.
On the opportunity form exists a look-up (potentional customer) for
contacts/accounts. I'd like to add an aditional one to the form (to
replace the decision maker).
I tryed to create a new field on the opportunity entity but there's no
field-type "look-up". It's also not possible to create a new
relationship to the contact entity (both system entity's).
Does anybody of you know how I can do this? (if yes - please explain it
Look...HTML Status Bar
It there a way for me to customize the status bar to show the item picture
after a item is scanned?
Copy and past the code below into Notepad or Frontpage and save it as an .htm
If you use Notepad be sure to change the File Type to All Files. Or just
piece the code that you need from this example into your file.
I modified this to display the image of the last item added to the
transaction or the currenlty highlighted item. If the item does not have an
image assiged then it displays a generic 'no image available' pic.
<meta http-equiv=...can't close the PO Entry window in GP9
A user created a PO and printed it. He opened it again and didn't know
what's gotten to him, he deleted the line items. Now we couldn't close the
PO Entry window. We even tried to put the item back to the line but it said
we can't change item once the PO has been released. Before I'm going to
shutdown the computer to close the GP app., please anyone could shed some
lights of how to close the PO Entry window in a nicer way.
Are you getting an error trying to close the window? Or is it just not
Dynamics GP MVP
Flexible...Outlook Folder List Will Not Close
When I close Outlook, the folder list stays on the screen
as if it is frozen there. I have to refresh the screen to
make it go away. Anyone have any ideas as to why this
happens? Also, it only happens for one user profile on
In O2003, IMAP, Inbox, there is a default view called "Group Messages
Marked for Deletion". The view groups the message marked and not
marked for deletion by using this field (IMAP Status) in the Group By
box. I tried to locate this "IMAP Status" field but cannot locate it.
I looked through all the available fields but cannot locate it. Does
anyone know where it is located?
...Highlight Row Based On Condition-So close
I currently have the below to highlight the cell based on a condition of
comparing a date in column (I) and if it's greater than 90 days past then
highlight the cell - what I need to do is highlight the row from columns A-J,
This has to be programmed and if there is a better structure then I am open
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLessEqual, _
Selection.FormatConditions(Sele...Get column name and data type from closed workbook
Good day Group,
Found the code below from this group that helps me to retrieve the Sheet
a closed Workbook. Is it possible to get the name of the columns (fields)
a Worksheet in a closed Workbook in the same way? Is it posssible to get
the format (data types) of each column? As new to this I�am grateful for
Dim cnn As ADODB.Connection
Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table
Dim lRow As Lon...Close RMS from the command line?
I am running maintenance on a scheduled basis and need to make sure that RMS
(POS, Manager, and HQ Client) are not running when I'm running maintenance.
Specifically, I want to clean up all the .tmp files from the %TEMP% folder
from the command line, and these are often in use by RMS.
How do I stop the applications from the command line?
try stopping the database with: net stop mssqlserver
this would crash rms and hqclient but might leave the program open with an
error message on the screen, so not sure if it would release the temp files.
if that works, start th...How to handle renewal product/ Opportunities
We are having a discussion here about how to handle new and renewal products/
opportunities. One group wants to mark opportunities as either new or
renewal and the other wish to mark the product as new or renewal. The
marking of opportunities as new or renewal, adding an attribute to the
entity, allows us to filter the opportunities reports by this attributes.
However other group feels that the attribute on the product better reflect
the true product allowing us to mix opportunities with new and renewal
products. Is there a best practice for handing this issue?
*Side note: Our pr...Add a close icon to Excel's Toolbar
All of the office applications have an icon associated with the close
function. I always add this to my toolbars but in Excel it displays as text
rather than an icon. Minor but why not be consistent
Right-click on the "Close" button on your Toolbar and hit "Default style"
Should change to a folder with an arrow.
Gord Dibben Excel MVP
On Fri, 10 Dec 2004 09:55:06 -0800, "SNiness"
>All of the office applications have an icon associated with the close
>function. I always a...Macro to open and close addins
Can anyone provide an example of a macro that loads and / or unloads an
add-in file when run? For example, if it loads the add-in I would want to
see the file appear in the add-ins available dialog box. When it unloads the
add-in, it would then be removed from the dialog box. Thanks for your help.
If Not Application.AddIns("Analysis Toolpak - VBA").Installed Then _
Application.AddIns("Analysis Toolpak - VBA").Installed = True
If Application.AddIns("Analysis Toolpak - VBA").Inst...Opportunity Workflow Rule and Sales Process conflict??
I have the following scenario:
When an opportunity is created, a workflow rule fires which:
Assigns the new opportunity to user Gail
Sends an email to Gail to tell her about her new opportunity
I also have a sales process that fires on Opportunity Create which has a
number of steps, and the first step creates a Phone Call task for Gail to
However for some reason this phone call task creation is failing. At first I
had the sales process set up to create the task for the opportunity owner,
but then I thought that the problem might be that the assign rule was not
fi...Files deleted for no reason
My Inbox,Deleted Items and Sent Items folders were
completely empty when I opened MS Outlook 2002 this
morning. My calendar, task list, contacts, etc. are just
fine. My husband didn't lose any e-mail nor have any
problems whatsoever under his log-in. I can't seem to
find info ANYWHERE that is helping me locatem these lost
e-mails! Help me, please...
TNT Siebert cogitated deeply and scribbled thusly:
> My Inbox,Deleted Items and Sent Items folders were
> completely empty when I opened MS Outlook 2002 this
> morning. My calendar, task list, contacts, etc. are just
&...Content of emails is changing without any reason !
I changed operating system last week. From Win XP to Win 7. Used to work
with Outlook Express at full satisfaction.
I could transfer most of my emails automatically with export/import features
of Microsoft software.
But I suddenly discover 1 very big problem (bug ???)
I am used to work with several maps, and hereby go to several levels deep.
Such as :
Date of action
Name of patient
So sometimes maps can go several levels deep.
When I check ema...Lead Batch Conversion to Contacts and Opportunities
Has anyone come across a solution for running a bult conversion process of
leads to contacts, and opportunities?
For example, I am importing a bunch of leads. Instead of going on by one
and converting these leads to contacts and opps I want to do it in batch.
Any suggestions is greatly appreciated.
Thanks for the help!
...Toggling "Shutter Bar Open/Close Button"
I would like to expand and contract "Shutter Bar Open/Close Button"
inside a module. However, I haven't figured out what method or code
is needed in order to manipulate it.
I would also like to be able to expand or contract features on the
Shutter bar (Navigation Bar) like Forms, Queries, etc.
...close form automatically after say 2 second
I guess I cannot close msgbox after predetermined time in code. So I want to
use a form to display message and close automatically in 2 seconds. How to
Check the Access help for the OnTimer event.
"Song Su" wrote:
> I guess I cannot close msgbox after predetermined time in code. So I want to
> use a form to display message and close automatically in 2 seconds. How to
> do that?
These code works. How to supply message to the form in code?
Option Compare Database
Private Sub Form_Open(C...Word 2007 Close QAT Closes Word Session
Unsure how this happened (user stated that it just "started" happening)
User has placed a Close command in his Quick Access Toolbar.
Whenever the user has only one document open, and he clicks the close icon
in the QAT it closes the entire session of Word not just the document.
I have removed and replace the command, same thing happens.
Any suggestions on how to remedy this would be grateful.
Your user has placed a Close or Exit (which closes the Word session) command
on the QAT - delete that command and replace with Close command (which closes ...THIS NEWSGROUP HAS BEEN CLOSED
(My apologies for using full caps in the subject, but I really want this post
to draw attention).
On July 1, 2010, Microsoft has closed this newsgroup. This means that you
might not be able to make any posts here anymore, and even if you still can,
others won't see your post and you won't get any replies.
It's highly recommended to post your message in one of the Microsoft online
forums instead. There's no forum specifically aimed at Windows Media Player,
but you can go to
On that page, fir...Status bar will not fire onclick events
I am trying to add an event to an href like:
but for some reason the onclick event will not fire. I can change it
to the ondblclick event and it will fire fine. Does RMS block the
onclick event somehow or can other people run this status screen fine
and I have some security setting messed up?
So nobody in this forum has e...CRM 4.0 Email Router: "Incoming Status: Failure" when setting exch
When I set my email router using exchange server as inbound, I got a error
Incoming Status: Failure - The underlying connection was closed: Could not
establish trust relationship for the SSL/TLS secure channel. The remote
certificate is invalid according to the validation procedure.
The SSL certificate installed on the server and web test no error.
Anyone knows how to fix the problem?
I'm searching for the same answer - did you ever find one?
> When I set my email router using exchange serve...