Week Numbers for Tax Year
Can anyone post a reliable formula for calculating week numbers in Excel
that relate to the UK Tax year?
I guess week 1 would be the week with 6th April in it, or maybe week 1 is
the first full week after 5th April. Does anyone know?
-Please remove 'safetycatch' from email address before firing off your
Maybe check with the UK tax folks to find out the criteria?
> Can anyone post a reliable formula for calculating week numbers in Excel
> that relate to the UK Tax year?
> I guess week 1 would be the week wit...Report on Serialized items passing through a site
I want to run a report on the history of any serialized transfers to / from a specific site.
...A program is trying to automatically send e-mail on your behalf.
I tried posting this in microsoft.public.outlook.general, but no
Does anybody know how to turn the "A program is trying to
automatically send e-mail on your behalf." prompte off?
It pops when one of my MS Access apps is emailing one of it's reports
It happens on the Citrix server that one of my MS Apps is running on,
but it does not happen when the app is running on my own PC.
Consequently I'm hoping for some user-configurable setting that
controls...Last auto-generated replication-id
In an MS Access table I have a one-field primary key, that is an auto-
increment field of type Replication-id. After inserting a single
record using SQL INSERT, I want to obtain the key of the new record. I
have done this before with auto-increment fields of type Numeric and
then I can use "SELECT @@IDENTITY AS fieldname". But this doesn't work
for replication id's. So how do I find my new record?
Peter Laman <firstname.lastname@example.org> wrote in
> In an MS Access table I have a one-field primary key...view number of mbxes or logons in ESM 2003
IS it possible to display a status bar like in 5.5 exchange admin where you
click on mailboxes in a storage group and it displays the number of mailboxes
that are in that group..........or alternatively displays the number of
mailboxes logged on when you look at logons.
This is a real simple thing I would expect to have with 2003 like 5.5
had.......please don't re-direct me to scripts to do this.It should be made
available with a service pack or hotfix by MS if it's not currently possible.
...Reading XP generated publisher document
How would I go about open up a publisher doc that was sent
by someone using Publisher XP. I am currently running Pub
The Message I get when trying to open it is:
Can not read this version
You need to have the person who created the Publication
save the file as a Publisher 2000 file. Have them go to
File>Save As and change the file type to Publisher 2000.
Microsoft Publisher MVP
>How would I go about open up a publisher doc that was
>by someone using Publisher XP. I am current...Generate a random 6 character output
I am looking for a way to randomly generate a 6 character output of letters
and numbers like abc123 or 258qwe etc...
Can anyone show me how to do this or point me to some examples?
Thanks for any help.
Well I have built my own answer.
1 table with 2 fields. LTR and NUM.
LTR has 10 letters and NUM numbers the letters 0-9.
The following is the code I built from the help file.
Dim db As DAO.Database
Dim char1, char2, char3, char4, char5, char6
Dim ltr1 As Recordset, ltr2 As Recordset, ltr3 As Recordset
Set db = CurrentDb
Is there any way to create a template where a contact is
automatically CC in the email. So I dont forget to cc them
every time I send an email.
...Money 2006 constantly faults with automatic updates
Whenever I use the Internet automatic updates, money faults out and wants to
send a report to Microsoft. Also my account list shows most accounts with a
status of 'Update In Progress'
I've done a complete reinstall after removing it and power cycling my
machine. I thought it may have been something with removing 2004 and
installing 2006, but got same problem
Has anyone else been having this problem? I really just want to go back to
What's the error message?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq f...Automatic axis format
I'm need to make a automatic axis format within excel.
The number of rows is depending of a imported file.
No problem to get the max. number of rows.
But to put this number into the chart ( category axis) is more problematic.
I try VB but my knowledge is at dummy level !
Waiting for your reply.............
Have a look at Jon's examples of dynamic charts.
> I'm need to make a automatic axis format within excel.
> The number of rows is depending of a imported file.
> No problem to g...Auto Number Problem
I have a table with an autonumber and periodically I migrate lines in that
table to another table which saves the autonumber in a number formatted
I had to reinstate a row with its original autonumber and the table lost
count. It started counting from the reinstated number. Has anyone had this
For Example. I migrated lines 4000 - 4200 to another table. These lines no
longer existed in original table. When I reinstated line 4100, it allowed
the 4100 in the autonumber field.
That would be fine, but it continued to number the lines from 4100 instead
of 22000, which was ...How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
The = icon disappeared in newer versions of excel (xl2002???).
You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)
And drag it to your fav...My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with
the bright yellow fill. There is no conditional formatting on this workbook.
Check your VBA editor.
You might have an Event Macro which does what, usually, a CF does.
Try to Increase the Macro Security to its maximum level in order to
eliminate the Event Macro from running...
You may, also consider to "rem" all the Macro commands by adding a Preceding
apostrophe to each command.
> When I type text in a blank cell, the cell automatically is highlightes with
> the bright yello...Help regarding programatically generating CSR
I'm a newbie to certificates and I could not find a newgroup related to this
otherwise I would have posted this question there. If someone has worked on
it, please help or guide me to a newsgroup where this could be answered.
In IIS there's an option to manage web server certificates. The initial step
is to generate a CSR. I have to do this programatically using C#. Searching
on the net gave me hints to use XEnrol.dll (createPKCS10 method of
CEnrollClass) which I tried and it worked fine. There is just one confusion
that I cannot set the bit encryption in it. By de...I open the MDB, the form runs automatically
I have an MDB file with 20 files and 7 forms in it.
When I open it up, the form runs immediately an access goes into some
sort of protected mode. I can't view the tables, queries etc. I can
see the code by pressing Alt F11 but not the data.
I created a blank db and imported the mdb so I could see the tables.
But how do I open the original without it running the code?
When I look at the code. I don't see anything that sets properties or
invokes the code automatically.
There are no macros in this, just the forms and associated code with
...Automatic updates, automatically disabling itself
Automatic updates, automatically disabling itself.
2nd day now onecare popped up to tell me the updates turned themselves =
I'm thinking what malware would want to turn the updates off ?
Any idea what's going on here ? Did I AUTOMATICALLY install an update =
caused this ?
<email@example.com> wrote in message
> Automatic updates, automatically disabling itself.
> 2nd day now onecare popped up to tell me the updates turned themselves
Drop OneCare and install Microsoft Sec...Having numbers automatically appear bold
Had such great advise last time, thought I'd try again.
I have a large range of cells where I will be inputing sales figures i
the form of currency revenue. The range is about G-I and 1-400. Th
sales data will be a comparisson of YTD 2001 - 2004 revenue results.
What I hope to do is have any figure that is above $30,000 appea
automatically in bold so as to stand out as a good client. I gues
there is something in the IF function to do this but I'm stumped.
Thanks again in advance.
Message posted from http://www.ExcelForum.com
select the range you wa...Number with dash is importing as date
An Excel spreadsheet is being exported from a SQL database that I cannot
change, so I need to accomplish this in Excel.
Sometimes, some of the many numbers contain a dash which Excel then
interprets as a date. I can remove the dash programatically, but the number
is not correct afterwards.
For example, the number imported is 05-9078 which is displayed in Excel as
May-78, but is actually stored as 5/1/9078. Changing the cell format to
number or text gives me 2621833.
I need to be able to add to my macro something that will give me back the
original number so that I can remo...I'm missing a number only in the final version
I am missing one of my number in the final version. It shows up in the final
showing markup. Where the heck did it go? There is no markup indicated on
that line and the numbering continues as though it is there.
Note that in a document with Track Changes, numbering (paragraph/outline
numbering, footnotes, endnotes, field numbering) may be incorrect until you
have accepted all changes. There is nothing you can do about this.
Microsoft Word MVP
"Display name here" wrote:
> I am...Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows?
It seems like a simple thing to do but I can't find a function anywhere.
If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
"Richard Thorneycroft" <firstname.lastname@example.org> wrote in message
> Is it possible to automatically move data entered in columns into rows?
>...serial port communuication
I m communicating to a printer device through serial port.It
is failing to open the port,but when I disable and enable the com port
in device manager,it works fine(i.e)it communicates with the printer
and reads the configuration settings of the printer).
are u leaving the port opened when ur program terminates ........ what is
the frequency of u disabling/enabling port ....... after every run ......
some times works some times not ..... ?????
"hari" <email@example.com> wrote in message
How can I automatically forward messages received from a
specific sender to another's e-mail person?
...CE6: How to Disable SIP popup automatically
I know SIP popup can be disabled by the following registry setting in CE5:
But It doesn't work in CE6.
How to disable SIP auto-Popup in CE6?
The SIP Auto Deploy in CE is due to Windows Controls invoke SHSipPreference
(exported by AYGSHELL.DLL).
So the easiest way is to avoid including AGYSHELL (SYSGEN_AYGSHELL)
But if excluding AYGSHELL is not an option, you may need to modify the
SHSipPreference (PRIVATE\SHELL\SHELLPSL\HAVEAYGSHELL\shellpsl.cpp) to supress
SIP s...Automatic Database Backup
Is it possible to right code to automatically backup a database? And if so
how, or where, can I get information on this?
There are a few way to do this. I have windows scheuler doing this on all
my databases (at 1 min past midnight each day). Open Scheduled Tasks (it's
in the control panel). It's very simple and not likely to go wrong
> Is it possible to right code to automatically backup a database? And if so
> how, or where, can I get information on this?
So I take it that, there is no way t...Automatically format charts with range of dates
What I am trying to do is I have 4 charts that are linked with data from
another spreadsheet. They are basically week totals for my business and make
a chart compared to say last year.
What I want to do though is have an option on my report that I can enter in
a specific date or a range of dates and have the charts automatically filter
the new data in and change. Instead of having to go into the chart data and
changing what series of data I want to have a chart for I want to be able to
just enter eg. "April 12-April 18" and have the charts bring up that data to
reflect the ...