system date returns null
Testing for the year returns a null using the system date. I am using
Access2007. This worked in Access2003.
My code is:
190 If Right(Year(Date), 2) = txtEYear Then txtEYear = ""
When I run the code and check "date" with debug, it shows 'null'.
On Sun, 14 Feb 2010 14:21:02 -0800, Dave
That's unusual. Does your code compile? Check a code window > Debug >
Microsoft Access MVP
>Testing for the year returns a null using the system date. I am using
&...Fixed Asset Import Multiple Times?
We have a new client on GP 9.0, SQL 2005. They are just starting to use
Fixed Assets. We are planning on doing the initial import of fixed assets
via Excel and the Fixed Asset Import Wizard. However, they will have many
acquisitions in the next few months/years of additional companies (from which
they will acquire many new fixed asets at a time).
Can we do additional imports (from excel and the FA import/export wizard)
for new/additional fixed assets we acquire during these acquisitions?
We would want to maintain all our current Fixed Assets, of course, and j...Changing the Default Activity Time
I would like to change the default time shown when creating new Activities.
The current default is 30 minutes. We woul like to reduce this to 5 mins etc
depending on the Activity.
You cannot do this in CRM by using the standard tools. You could try and
edit the activity aspx page and use some client side scripting to change the
picklist value at runtime.
> I would like to change the default time shown when creating new Activities.
> The current default is 30 minutes. We woul like...How to set timer to expire at a given clock time (midnight, for example)
Is there a way to use SetTimer (or something else) such that a timer event occurs at the same time every day
Look into waitable timers. You won't get a timer event, but you can have a thread block on
it and when the block releases you can post a message that the timer has fired.
On Fri, 28 May 2004 13:56:04 -0700, "Bruce" <firstname.lastname@example.org> wrote:
>Is there a way to use SetTimer (or something else) such that a timer event occurs at the same time every day?
Joseph M. Newcomer [MVP]
email: newco...Re-post Didn't appear first time
Hi hope you can help!
I have a number of copies/versions of the same spreadsheet (layout)
which I now have to do a column content count on ie
but I only need to count this if another total in the same column is
greater than 0 zero
I can do this with an IF statement, but of course when I copy the
formula into the other workbooks the original sheet reference
remains. I thought I might be able to use INDIRECT() but can't see if
this can be tied to an IF()
As always any help or other suggestions would be welcome.
CountIF is looking i...Combined bar/Line graph defaults to bar
In Excel 2007 I have a Combined bar/Line graph get it's data from a pivottable.
Intermittently, when I change the pivottable filters, the combined bar/Line
defaults to just a bar graph.
I have tried 2 approaches with the same results -
1. Have the graph select each set of data from a range
2. Have the graph point generically at the pivottable and dynamically adjust
Thank You in Advance,
Pivot charts are notorious for resetting their formatting when the table is
refreshed or re-pivoted. What you have to do is change each series: right
click on th...Axis Break in Graph
Is there an excel macro, add-in or software package
available for sale/download to create a graph or a chart
with a broken axis? I am looking for a tool that is easily
These are not automatic solutions but they will show you how to solve
For line chart see,
> Is there an excel macro, add-in or software package
> available for sale/download to create a graph or a chart
> with a...Automatic marking messages read
I am using Outlook XP. How do I change the amount of time I have to look at
a message in my inbox before Outlook automatically marks it as read? I know
how to mark it as read manually.
Daniel L Newhouse <email@example.com> wrote:
> I am using Outlook XP. How do I change the amount of time I have to
> look at a message in my inbox before Outlook automatically marks it
> as read?
>I know how to mark it as read manually.
Edit>Mark as Read.
You would do well to peruse your menus and options and to read the Help th...Automatic addition to payee list
I travel all the time in a motorhome, and use Visa for
most expenses. I download my Visa transactions as QIF
files and import them into Money 2003. My problem is that
Money automatically adds each new payee to the list of
payees. My list of payees just keeps growing and Growing
Does anyone know of a way to stop the automatic addition
to the list? I know I can manually remove them, I would
just rather they weren't added in the first palce.
"Travel'n Bill" <firstname.lastname@example.org...Clicking a cell...... automatically to another cell?
Is it there a formula, that if you click on a Cell,
you automatically go to another Cell in that worksheet?
(without using a macro?)
try usig a hyperlink ('Insert - Hyperlink')
>Is it there a formula, that if you click on a Cell,
> you automatically go to another Cell in that
>(without using a macro?)
You could also use an =hyperlink() formula.
David McRitchie posted this and it might help you:
=HYPERLINK("#...Format a Date Using Field Properties
I know how to do this in Visual Basic and Assembler but having trouble with
the Syntax in Access
On the Format Event on the Properties Menu for a Field I have ("mm/d/yy")
I have been guessing and trying to find an example on the WEB and in Access
Help and still cannot determine what I am doing wrong.
All I want to do is display the year as two characters instead of four!
On my Format Tab, On the Format Line (The first line) What Syntax does it
want to do this very simple task!
Thanks in Advance
mm/d/yy (no quotes)
Doug Steele, Microsoft Access MVP
http://I.Am/Do...Automatic Pareto data with Formula
I want to create a data table for use to create an Automatically updated
Pareto Chart, for this I need that the values automatically be sorted in
descending order, so I have the following example scenario:
Column A has Labels and Column B has Values
C - 3
D - 2
If I use the following formula:
I get B, but there are two 2 and if I use the 3rd largest:
I also Get B instead of the required D.
How can I get it so the end results looks like this:
...Convert Date Format
I receive data with the date format as "20051106" [6 Nov 2005] which is OK
for me but end users want to see it in the more conventional "dd/mm/yyyy"
format. How can I transpose the data and insert separators.
You could use a formula such as
assuming your data was in cell E20
> I receive data with the date format as "20051106" [6 Nov 2005] which is OK
> for me but end users want to see ...Graphing in EXCEL
I have a question to do with graphs. For example here is my data
and I want EXCEL to graph it exactly this way (See below) (with the data
labels included) (sort of like a scatterplot but not quite)
X banana Xbanana
X grape Xgrape
1 2 3
How do I do this? Please please answer my question. Thanks a lot in advance!
If I cant do this ...Auto enter date?
Hi! me again!
is there any way i can get excel to auto enter dates that jump by 7 days
every 7th cell along?
Ive worked part of this out.
in cell G1
in cell M1
but its displaying the time...i just want the date....
"R.P.McMurphy" <email@example.com> wrote in message
> Hi! me again!
> is there any way i can get excel to auto enter dates that jump by 7 days
> every 7th cell along?
> s...using time
Having a problem using time in my calulation.
Trying to find out the number of people that past a point for
1,2,3,4,5,6,7,8,9,10,15,20,30 minutes in columns head while I have 55,
100, 160 and 200 in rows. I have sum=(55*(60/col))
Col 1 2 3 4 5 6 7 8 9 10 15 20 30 minutes
Then I want to use 5,000 divided by the rows/cols further down the
sheet using the same time figures. I try doing sum=(5000/row/(60/col))
where the results should climb as the time gets higher, but results is
Col 1 2 3 4 5 6 7 8 9 10 15 20 30...Time Table Problem
I'll try to give as much detail as I can on this problem in order to
increase possible solution alternatives.
In a excel workbook, I have 4 Lists on Sheets 1, 2, 3 and 4 column A:A
The list on Sheet1 shows "names of teachers".
The list on Sheet2 shows periods (10 periods for each 5 working day of the
week) that can be used throughout the week e.g (Mon1, Mon2, Mon3,....,
Mon10), (Tue1, Tue2, Tue3, ....,Tue10), .........., (Fri1, Fri2, Fri3, ....,
Fri10) totalling to 50 periods.
The list on Sheet3 shows the lesson names+classes to take it (in the format
lesson...How to login first time from client
I installed the server GP10.0 and created the users. Instlled Clinet software
and can test ODBC connection successfuly. I started GP . it asks me to run
the GP utility, if i login with user account i created in SQL, it asks me to
login as sa account, if i don't chose to run the GP utility it will quit and
i don't get any login page, please HELP
Login with the 'sa' account!
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
My problem: I am trying to have one date minus another date. I want to
display the difference in days. Help!
DateDiff("d", [StartDate], [EndDate])
> My problem: I am trying to have one date minus another date. I want to
> display the difference in days. Help!
...Login time to Dynamics GP
We upgrade dot Dynamics GP and now the login time for several users is very
long. It is taking most users several seconds, 3-10 to log in. For some
others it is taking minutes to get into the system for them to be able to
work. I have not found anyhting on Customer Source and have not heard back
from Microsoft yet. Does anyone have any ideas? We are connecting to GP via
citirx connections on a windows 2003 box.
Backup Dynamics database (to be safe)
Delete from dynamics..SY07110
Login as admin and you will see good speed again.
I must do this every month t...Convert text to time format
I am unable to convert a piece of text that i copy paste from an
external source to time format. Suppose I copy, "July 24 2006, 05:31
PM" and paste the same in excel it just assumes that that the entered
data is text and I am unable to format the same. I need to convert this
to the time format for proceeding with certain calculations. PLease
|Filename: TTT.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5111 |
+-------...Pivot and Graph
I have a pivot table displayed with data populated using c# code.
I want to create a graph out of ONLY the FINAL summary rowS.
If I create a pivot chart, then it gets messed up if I expand the pivot table.
If I manually copy paste the sumary values into another place and draw a
graph based on that, then when the pivot table data is re-updated by c# code,
graph would go out-of-sync.
If I refer to the summary cells somewhere and use that for the graphing,
then also when I expand/collapse the pivot table, then the location of the
summary rows change and so my graph goes blank.
One pos...Automatic BCC possible with Outlook?
I've just switched to using Outlook, and discovered there doesn't appear to
be a way to always BCC myself. Is there a way to do this, that I just
haven't figured out yet?
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
See if this helps:
"Don" <firstname.lastname@example.org> wrote in message
news:ere1b1tjqf2j78sn7kauiudrpepard6qgo@4a...How to delay ToolTip display time in CListCtrl Control
I create a CListCtrl object with LVS_EX_INFOTIP and Report style
the Tooltips display time is too short, how to delay ToolTip display time in
CListCtrl::GetToolTips() returns the CToolTipCtrl Control
CToolTipControl::SetDelayTime() sets the delay time.
"Smallfrogs" <email@example.com> wrote in message
> I create a CListCtrl object with LVS_EX_INFOTIP and Report style
> the Tooltips display time is too short, how to delay ToolTip display time
> CListCtrl Control
C...Incorrect time on Outlook account
On one of my Outlook accounts, whenever I receive a message it shows the
time being 6 hrs in front. I contacted my provider and they say their server
times are all correct. If it was showing a server default, the timezones we
are in means it would show as arriving 6 hrs behind?? It only shows the
incorrect time on the inbox page -when I open the message the time is
Another account I have with another provider does not have the same problem
so it has to be at their end???
Any help would be appreciated.