Can I change the calendar year beginning date?
Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
Create a query to use as the source for your report.
In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year...Date Formatting when Concantenating
I have a simple question. I have a cell that has date that looks lik
When I use the concantenate feature my date looks like this:
I tried to format the call every which way - but I cannot get it t
look the original.
Feeling really silly for even asking.. thanks all for your help
Message posted from http://www.ExcelForum.com
="Today is "&TEXT(TODAY(),"mm/dd/yyyy hh:mm")
Norman Harker MVP (Excel)
"bleu808 >" <<bleu808.189yij...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...Remove file Protection from an Excel workbook file from others
I have an older excel file created by someone who is no longer with my
company. I want to use that file as a starting point to created another
file. The file is set up as "read only". If I try to change any of the
cells, I get the message that the "cell or chart is protected and therefore
read only" and further tells me to unprotect before attempting the change.
When I got to tools/protection/Unprotect Sheet I get the request for a
password. I don't know the password as the file was created by another. I
have tried "save as", from tools making sur...first time linking worksheets need some info and help
I'm trying to link 4 cells with dates in them to be inputted into the second
sheet for calculation. BUT the info is in a cycle. So basically I need it to
link and stay. But when I do the next cycle, I need the info to change. I do
have a column that is counting the cycles. So can I make it so it'll link the
info until the cycle number changes? (a Formula???) if so how do i put a link
and formula together.
Also if this is figured out,can you possibly link a cell to two different
worksheets within a workbook?
Can you give an example as to what you are...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...Run Time error 1004
I am trying to programmatically copy the text contents of one cell
(including formatting) on one worksheet to a merged range on another.
I get the error in the title when I run the macro initially... then
strangely it works with no error after failing to run it a couple of times.
My code is as follows:
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Selecti...Time performance Chart
I need to develop a chart that graphically depicts an employees start
time and end time each day. This chart would be a bar chart. The bar
chart would have days of the month along the bottom, and the side
would start at 00:00 at the bottom and end at 24:00 at the top. I
need to be able to enter an employees start time and end time and have
it charted along the bar. So if the employee started at 07:00 and
ended work at 18:00, the chart would show a colored bar that
corresponds to the start time and the end time. Also, if an employee
came back to work the chart would refl...Forced Removal of Failed Exchange 5.5 Server
A failing Exchange 5.5 infrastructure prompted a rapid
migration to Exchange 2000. A mixed mode environment was
created and all security principals and data was moved to
the new servers before the old server failed. Exchange
2000 is functioning and about to be integrated into an
Exchange 2003 environment. However, there is still a
grayed-out reference to the now failed/non-existent
Exchange 5.5 computer. How can this be resolved?
You can delete the server object from ADSI Edit. ADSI edit comes with
windows 2000/2003 support tools.
Open ADSIEdit and navigate down to the servers lev...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <email@example.com> wrote in message
> How to get only the year in the date form...Changing Text Box Size and Location on a form, at run time with Access Xp
Is it possible to change the size of the text box (or any other control) on
a form at run time, by Drag and drop or resizing borders using the mouse
events. (Just like the design mode but the user will use it at run time on
Thanks in advance...
You should be able to resize in your code if necessary.
Me.control.Visible = True
Me.control.Height = 1000
Me.control.Width = 1000
Don't forget to set them back when you are done.
> Hello All,
> Is it possible to change the size of the text box (or any other control) on
> a ...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...How to remove black frame/background around the icon <firstname.lastname@example.org>
I have created a toolbar using Deskband in Visual Studio 6.0. I have added icons for the buttons but for every icon, I see a black background/frame. Even if I open the icon in MS Paint, I see that black frame. Its like all the icons are sqaure in shape and except for the actual picture everything else is black! I have never worked with icons before and I do not know how I can get rid of this. It makes my toolbar look very ugly. Please somebody help
EggHeadCafe - .NET Developer Portal of Choice
Normally, icons (.ico) files are actually two bitmaps, a mask bitm...Time Conversion
I need help in converting time. I am using data from a time clock which
currently formats time as 1.5. When I input this data into a cell how can I
have it formated to read 1 hour and 30 minutes (1:30)
What you could do in an adjacent row or column is format
them as Time and then using a formula, divide the input
time by 24(hours in a day).
>I need help in converting time. I am using data from a
time clock which
>currently formats time as 1.5. When I input this data
into a cell how can I
>have it formated to read 1 hour and 30 minut...removing predefined locked fileds
do someone know by a chance how to remove predefined locked fileds
from some forms (like address fileds in the Order form) ?
On Feb 4, 1:05 am, "eliran" <eliran...@gmail.com> wrote:
> do someone know by a chance how to remove predefined locked fields
> from some forms (like address fields in the Order form) ?
You can't remove, but can hide them using onLoad event script like
If there are a lot of fields, that you want to hide, you can p...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...Paid Sales Transaction Removal error message
When I try to do run a "Paid Sales Transaction Removal" against a specify
customer (Microsoft Dynamics GP menu >> Tools >> Routines >> Sales >> Paid
Transaction Removal) in Dynamics GP 10 with SQL 2005, I get the following
error: [Microsoft] [SQL Native Client] [SQL Server] Violation of PRIMARY KEY
constraint ‘PKRM30101’. Cannot insert duplicate key in object 'dbo.RM30101'.
I searched for the error message in Customer Source Knowledge base and found
Article ID : 861084, which I followed and it showed the duplicate document
I have four fields on a form to show time. I want a seprate "Total" field to
add the time between the first two fields and then add the time between the
second two fields. Like this:
In LunchOut LunchIn Out
6:00am 12:00pm 12:30pm 4:30pm
The first four fields are stored as medium times. Can someone let me know
how to do this?
Message posted via AccessMonster.com
"ladybug via AccessMonster.com&quo...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...Winmail takes 4 minutes to load at boot time
Running Windows Vista Home Premium on Lenovo Laptop 2 gig mem. After
logging in after rebooting, it takes 4 minutes to load Win mail. I used the
"event Viewer" to see what was happening. It showed ESENT with ID
102--start Win mail, then the next event is ESENT ID 103 4 minutes
later--terminate Win mail.
Anyone have a clue why it is taking Win mail so long to load? Win mail
works fine after computer loads.
> Running Windows Vista Home Premium on Lenovo Laptop 2 gig mem. After
> logging in after rebooting, it takes 4 minutes ...Taking a loooong time for new mailboxes to appear.
We have a tool which creates a batch of mailboxes, then logs into each
one via MAPI to migrate old messages.
Today we ran the tool and mailbox-enabled 300+ mailboxes in one go.
Although the Exchange tabs were present and the SMTP address was filled
out on each user in ADUC, the mailboxes didn't appear in ESM until
about an hour later. How is that possible?
Manually running RUS didn't help either. We've got one DC and a
separate E2k3 server.
Any RED errors in the event logs on that Exchange box during that time>
...Cannot publish or export in Deployment Manager
When I click on "Publish Customization" or "Export Customization" I get an
This application has requested the Runtime to terminate it in an unusual
way. Please contact the application's support team for more information.
Has anyone experienced a similar problem? What can be causing this, it was
Thanks in advance,