Chart of Times
I am working with a simple data set comprised of two columns and 24
In column ("A"), I have the numbers 1-24. In column B, I have these
The chart I would like to make would have the numbers 1-24 on the X-
axis and the times listed above on the Y-axis. Ideally, this would be
a column chart.
The times listed in column ("B") are formatted as time. When the
chart is created the X-axis an...Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered
into the Work field for a task, that task's Actual Work is updated to the
same value entered in the Work field. This happens to multiple resources,
but only on some of their tasks and not on others. For example, for the
weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell
in the Resource Usage View) for a given task also appears in the "actual"
The tasks are setup up differently. Some are Fixed Work, some are Fixed
Duration. I believe all have the e...run time error; can not write to object
in 07 have form w/ onclick event of main form that opens a new form
then having text in an unbound control of main form written into a text box
on this new form
run time error; can not write to object
seems be triggered because the new form is opening with no records. the new
form is in Date Entry property yes and when I manually open it - it opens to
a new blank record....but when opening via the onclick docmd...it opens with
> in 07 have form w/ onclick event of main form that opens a new form
> then having text in ...Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if
I enter 10 it is put in as .1 500 is entered as a 5
Goto Tools>Options and on the Edit tab you should see The Fixed Decimal
Places box checked. Uncheck it.
"maryu" <firstname.lastname@example.org> wrote in message
> If I enter a number into a cell it is put in like a decimal. For example,
> I enter 10 it is put in as .1 500 is entered as a 5
> Thank you
...Open a Form at a Specific Time
I would like to open a form at a specific time of the day, everyday.
Message posted via http://www.accessmonster.com
Scheduled Tasks should do what you want.
1. Open Control Panel
2. Look for Scheduled Tasks and double click it.
3. Click Add Scheduled Task then follow the wizard
hope that helps
>I would like to open a form at a specific time of the day, everyday.
spread the WORD
Message posted via AccessMonster.com
I'm sor...Emails Receiving time in Inbox Differs
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Hi, <br><br>I wonder if anyone can help me with this. I realised that my incoming mails received in the in the Inbox, the time received is different from actual time received. Meaning, the timing in the inbox shows the time that I download the emails. IS there a way to resolve this?
...Service time billing
Can MSCRM be adapted to a service organization that primarily bills for time
on an as-provided basis? When resolving a case, I see that the billable time
is shown as the total of all activity time. Is this information only used
when applied against a contract, or can I invoice for time or export a list
of billable time with descriptions for use in Quickbooks?
Also, can information, such as usernames and passwords be stored in the
account record but secured from users that don't have sufficient privileges?
The actual time is only automatically decremented from th...Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing
wrong.....Here is the summary of my problem.
I have a form named 'frm_EfficiencyStats' and a subform within the
form named 'qry_Total hours subform' (the subform is based on a
query). The form contains a text box (for date) which is bound to a
I would like to be able to enter a date in the text box on my form,
and display the records in the subform based on the date I entered in
the text box. The subform will only pull records from my table based
on the date.
Here are th...how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
the output would look something like
In B1 enter =A1
In B2 enter =B1+A2
Copy down to B5
Gord Dibben MS Excel MVP
On Wed, 16 May 2007 06:34:13 +0300, "John" <email@example.com> wrote:
>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative...Excel Worksheet Change Event in a nick of time
1. Enter an Excel worksheet ; To Define Name > "TagNumber" > ReferTo :=
2. Intention ; After TagNumber is updated (in a Change Event), the
focus would move to the adjacent cell to the right, Offset(0,1).
3. And therefore, the event procedure is devised as follows ;-
Private Sub Worksheet_Change(ByVal Target As Range)
If ActiveCell.Address = Range("TagNumber").Address Then
4. However, at run-time ; As soon as Tagnumber is activated, the focus
shifts to the adjacent cell to the right alrea...calculating times
DOES ANYONE KNOW HOW TO SET A FORMULA TO CALCULATE THE
MINUTES FROM TWO TIME?
not really sure what you're looking for?
maybe the function MINUTE is working for you. e.g.
> DOES ANYONE KNOW HOW TO SET A FORMULA TO CALCULATE THE
> MINUTES FROM TWO TIME?
Posting in all upper case makes it more difficult to read especially
if your first language isn't the one used.
To calculate the minutes between times in A1 (earlier time) and B1
(later ti...Find folder within a folder which occurs multiple times in that folder
Hello! i have to find a folder named "Addon" in some folder named
"Installers" and store the path of "Addon" folder in a array.
but "Addon" folder may occur multiple times in "Installers"
I have to store all these path in a array how can i do that?
>Hello! i have to find a folder named "Addon" in some folder named
>"Installers" and store the path of "Addon" folder in a arra...Printing Multiple Receipts at a Time From Journal
Is there a way to print multiple journaled receipts at a time? Say all
receipts for a batch or by date or other criteria?
Not that I've seen.
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader
to see and download the file attachment. If you are not using a reader,
follow the link below to setup Outlook Express. Click on "Open with
under the MS Retail Management System on the right.
"Tom Bombadill" <Genius_pos...Browse file at run time in Integration manager
How can I set up the integration so that the system prompts the user for the
file at run time.
I do not want the users to edit the integration to point to the right file
every single time. Is there a way out?
You would need to write VBScript code in the Before Integration area.
The script would use the FSO (File System Object) to prompt the user for the
You would then need to copy the file to the location your source query
expects the file to be.
It would also need to be the same name as specified in the source query.
Be aware that using this method, you can on...Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
I have an ePM user asking why if he enters a project task in PWA does
it not check the resource max units allocation the same way as when he
enters a task in Project Professional.
You have a project where resource A is 50% allocated. When you create
a task in Project Professional for this resource, the resource
allocation is set to 50%.
Create a task under the same project in PWA, submit and approve the
Open project professional and view the task information for the task
entered in PWA, why is the resource allocation set to 100% instead of
50% set for th...Enter formula by code.
can anyone help. I cant seem to get this to work.
I keep getting run time error 1004
application or object defined error.
Public Sub TLIdentify()
finalrow = Worksheets("INV Bookings").Range("B65536").End(xlUp).Row
Worksheets("INV Bookings").Range("AV26:AV" & finalrow).FormulaR1C1 =
Regards and Thanks for any assistance.
Francis Brown...Make two or three times your cost on thousands of products
Make two or three times your cost on thousands of products. Gift items,Toys
Tools,Jewlery and more.Free info.
...Time and Date increment
I have a date and time field (which I have formatted as dd/mm/yy hh.mm)
I would like to add (incrementally) an hour on to the time each day, so the first few days will be:
I have tried right-clicking and using the "series" function, but when I go into the "series" option I am not sure what to do. I have chosen the options step value = 1 and "growth" but it only updates the Day (dd) by one day. I can't get it to update the Hour (hh) by one hour each day.
Any ideas anyone?
You need to ad...Update two workbooks at the same time, but not all the time.
I have set up 2 workbooks. One is for RMA's and the other is an evaluation
form for returned equipment. When I fill out the RMA form certain feilds are
filled out on the eval form at the same time, however I only need to do this
when equipment is being returned for evaluation. We get part returned for
various reasons, but not for eval. So I need to be able to turn these
functions on and off when necessary so I don't create an eval form for a
non-eval part. Can anyone help???
...Sum of all combinations
I have 7 categories, each category has 5 possible scores. I want to calculate
the sum of each possible combination. Is there a way to do this in Excel?
My grid looks like this:
JobKnowl 15 12 9 6 3
CallAcc 15 12 9 6 3
CallQual 15 12 9 6 3
JobAcc 5 4 3 2 1
IPSkill 10 8 6 4 2
Attend 20 16 12 8 4
Punct 20 16 12 8 4
> I have 7 categories, each category has 5 possible scores.
> I want to calculate the sum of each possible combination.
> Is there a way to do this in Excel?
I would write a VBA subroutine. But ....
> My grid looks like this:
> JobK...Entering a dollar amount w/out having to enter the decimal
What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?
It's one of the options you can specify. In Excel 2007, it's:
Excel Options...>Advanced>Automatically insert a decimal point
"Julieanne" <Julieanne@discussions.microsoft.com> wrote in message
> What is the formula to have Excel automatically enter the decimal so all I
> have to enter is the numbers?
...Open to Same Cell Each Time
Is there anyway of getting a workbook to open up to the same cell or
worksheet each time, regardless of where it was saved when it was last
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
In the workbook open event add code to activate a worksheet and cell. As an
Private Sub Workbook_Open()
This code should be put in the ThisWorkbook code...How do I stop dates from being entered everytime I enter a number
Everytime I enter data in a box (ex: ages 5-9) I then press enter to go to
the next cell and it automatically puts in may 9 . I have tried putting in
general in formatting cells and it still does it. can someone help before I
shoot this pc out the window? I am making a population pyramid with males
and females and their ages.
Kicking and Screaming
You can precede your entry with a single quote...
....or format your cells as 'Text'.
Hope this helps!
In article <64AE5219-035D-46E3-9488-5D01F6B012FA@microsoft.com>,
Kicking and Screaming <Kicking and...entering time #2
wondering if there is any way to do this...
I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a
colon, then the minutes.
Is it possilbe to simply enter a 4 digit number such as 1245 and have it
show up as 12:45 ??
thanks so much... I've found this group to be irreplaceable...
glen in orlando
Enter your times without colons in column A and put this formula in column B
and format column B for "Time" in the form you want it.
"Glen i...How much time has passed?
Using Excel 2003
I am using the following formula to calculate how much time has passed since
a particular event.
This returns the passage of time in full years. I am stumped trying to get
the result in years and months such as "3 years 6 months." Can anyone help?
Check out http://support.microsoft.com/kb/290190/en-us , particular event
being a birthday.
"BK" <firstname.lastname@example.org> schreef in bericht
> Using Excel 2003
> I am using the following formula to calc...