Can Excell create a running invoice NUMBER?
Lets say I was to create a form that will be used over and over, but
everytime I fill it out and print it I need it to generate a number
that changes 1 digit each time it is pulled up and printed.
Example, I have a blank invoice, then I fill in the fields as needed
and the invoice has a number on the top numbered 00001
so I print it and close the file. Then tomorrow I open it and do the
same thing except the invoice number now is set at 00002.
I am not sure if Excel can do this or not.
This would be pulling a rabbit out of a hat if this can be done :cool:
Message posted from http:...How can I not display an Exchange Email in GAL?
I know there's a way to prevent an Exchange 2000 account from being
displayed in the GAL. Could someone please tell me how to do this? Thanks.
Enable Advanced features within Active Directory Users and Computers
1. Open Active Directory Users and Computers
2. In the console tree, click the <your domain> node.
3. On the View menu, click Advanced Features.
Hide the mailbox
4. Navigate to Active Directory Users and Computers | <your domain> |
5. Right click on the user you wish to make hidden from the GAL and
select properties from the me...Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...Default properties for new folders
How does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...I used "save as" but now can't locate original file
I was using a file (November), changed the data, clicked "save as" (December.
Now, November is the same as December. Any possibility there's a temp file of
I believe you have not done as you describe.
If you had a previously saved November workbook open and made some changes
then File>Save As and named it December, November workbook will still be on
your computer in its previous state.
Unless you saved it as November with the changes.
From where did you open November workbook?
It will still be there.
Gord Dibben Excel MVP
On Thu, 1 Dec 2005 1...How can I strip the extensions from filenames in a query?
I have an Access 2003 table created by importing an Excel spreadsheet. One
field in this table contains the filenames of digital images in various
formats. These filenames are of varying lengths and have extensions such as
..jpg, .jpeg or .tif (other file extensions are also possible). For example,
A red car.jpg
A blue bus.tif
How can I write an query expression to strip off the extension, and which
will work regardless of the length of the extension? Essentially, I want to
drop the dot and everything that follows so that I end up with,
A red car
A blue bus
Mountain ...Can't import .pst file to reloaded Outlook
Can anyone help?
Windows XP crashed and I was forced to reinstall the
whole thing. Before doing so, I managed to export my
personal folders to a .pst file that I put on a cdRom.
When I reinstalled Outlook and tried to import that .pst
file from the cdRom, I got an error message saying that
access was denied to the file. I then saved it to my
hard drive and tried again. This time I was able to
import the file but all it did was put an empty folder in
my list. The information that was supposed to be there
does not seem to be.
Is there a solution to retrieve my e-mails? Please h...Need to Transfer Files Between Money and Quicken
I've got an interesting problem here. I need to transfer files between Money
2002 and Quicken Premium 2004. The first four attempts at having Quicken
read exported QIF files has been a disaster. Quicken is absolutely no help.
Their built-in help is referring me to webpages that don't exist. There is
supposed to be a tool to convert the file format, but the fine print says it
is for converting between previous versions of Quicken and Quicken 2004, but
it "may work" for converting Money files. A Quicken guru says I need to
export Money files to XML in order to bring the files i...New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <email@example.com> wrote in message
>I just installed Outlook 2007 on my n...Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
...Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
Contact us for detailed info and demo.
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...Can I Display Winodws File Folder Contents in Outlook?
I have found how to set a particular outlook folder to display a
website by seleting the home page tab under properties. Is there a
way to have this display the contents of a windows file folder instead
of an html file? I have tried something like c:\my documents, and
even file:\\c:\my documents, but this does not seem to work.
I've thought of perhaps making an html file with links to the contents
of the folder and displaying that html file. Looks pretty easy, but
if we add new files, etc., then the html file does not get
I know this is a stran...Style available all sheets new or old
I need a custom style that is available in all
spreadsheets, new or old. I can set style and save it in
book.xlt in xlstart, but that only works for new
workbooks, and doesn't work with old spreadsheets when I
call them up. I want to be able to select a group of
cells, or column or row and apply a setting for negative
numbers to have brackets. I am using Excel 2000.
I even tried saving the style in personal.xls, but that
doesn't work as it is hidden.
Do I have to use a macro? And if so what would it be?
Public Sub MergeStyles()
ActiveWorkbook....Can You Count This Way?
I have some cells with note type data:
Is there a way to count every item between the commas?
Timothy Wright wrote:
> I have some cells with note type data:
> For ex:
> Is there a way to count every item between the commas?
On Wed, 19 May 2004 20:13:53 +0200, "Frank Kabel"
>=LEN(A1)-LEN(SUBSTITUTE(A1,&q...Outlook & Outlook Express on same PC
I had both Outlook 2000 and Outlook Express on my PC with
Windows 98. Each was connected to different email
accounts and had different messages.
I want the same set up on my new PC with Windows XP Home
edition. But I could only find one pst file. It had the
data from Outlook. How can I find the data for the
Outlook Express folders?
Thank you in advance.
OE stores data in a different file structure to OL
"cp" <firstname.lastname@example.org> wrote in message
>...Sub Form Assigning New Values to Old Records
I am using a subform within a form to have users update certain fields in the
record where the rest remiain locked. On the Main form when the list box
(which is bound to a query) is used to select the record set to display in
the subform it sometimes takes an old record and assigns a new value to the
record. For example it changes the Period field from 9 to 10. Taking a
record created in period 9 and assigning a period ten to it which is the
selection I make in the list box. Addtionally, it looks like it is taking
the first record in the related table to assign this new value to. ...Which table will refresh by adding new Account / Contact
I am new to CRM and trying to update CRM Accounts and Contacts from our
Sales Management system. I am using Micorosft Bulk Import utility. I am in
preparation of CVS files but not sure what columns do I need in CVS file to
complete one Account/Contact record. Could anybody please help. I am .NET
expert developer, please let me guide If I could develop CRM by using .NET
Microsoft do provide CRM SDK for CRM enhancment using .net. You can download
from following url
http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...Money 2003 Deluxe Call Progress
When I attempt to update prices on line, Money appears to
get hung up. The call progress window says that it is
updating securities but it stays on screen and nothing is
downloaded. Even when I try to cancel the call, the
window will not close. The only way for me to stop the
call is for me to shut Money down using ctrl-alt-delete.
This happens about 75% of the time that I try to update
prices. I am connected through a cable modem.
You're not alone Bill. It happens to me frequently as well. Prior to 2003
version, the update was fast. Once I installed the 2003 version, it seem...Adding new pages
Any thing I do on new pages happens simultaneously on any previous page. Can someone help me please?
Can you be more specific? What stencils are you using and what are you
John... Visio MVP
Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm
Need VBA examples? http://www.mvps.org/visio/VBA.htm
Common Visio Questions http://www.mvps.org/visio/common_questions.htm
"Joanie" <email@example.com> wrote in message
> Any thing I do on new pages happens simultaneously on any previ...Can't open Outlook #11
Just bought a new computer & copied my PST file over to it. When I go to
open the file, it asks me for my password. Problem is: I don't have a
password on the file. Any help would be appreciated.
...tab does not move to adjacent cell in excel
When I enter data using the tab key in rows a-j, I end up in row k, not the
adjacent cell. Once I enter into K, I jump to U. I can't find an option to
change this and don't know how it happened. I am using excel 2003, and it
did not use to do this.
try <tools><options><transition> and uncheck "Transition navigation keys?
"Karen Boyd" wrote:
> When I enter data using the tab key in rows a-j, I end up in row k, not the
> adjacent cell. Once I enter into K, I jump to U. I can't find an option to
> change this and don't know ho...New messages comes up in Deleted folder
Sometimes when I receive new messages the go to the
Deleted folder instead of the Inbox. The messages are
from random people...not just one sender. What is the
Check your message rules/filters. "key word" in new mail
subject line of body is probably being tagged and
filtered to deleted items folder.
>Sometimes when I receive new messages the go to the
>Deleted folder instead of the Inbox. The messages are
>from random people...not just one sender. What is the