check register by date, not alpha
I did something, and it changed to alpha listings.
I previously had it by date, and prefer this way.
How do I get back?
In microsoft.public.money, randy wrote:
>I did something, and it changed to alpha listings.
>I previously had it by date, and prefer this way.
>How do I get back?
At the top of the register,
...Free Mentoring Los Angeles Area
I am offering Free Mentoring to someone in the Los Angeles San
Fernando Valley Area.
On Nov 19, 3:28 pm, xmanzig <bheif...@gmail.com> wrote:
> I am offering Free Mentoring to someone in the Los Angeles San
> Fernando Valley Area.
Me too. But only to attractive blondes with huge paychecks and a
sideline interest in Access.
...Reboot on printing checks in 7.0
I have someone at my company that on random occasions when he is printing
checks to an HP LaserJet 4050, he gets the blue screen of death, followed by
a reboot. I have set the computer to not reboot after blue screen, but it
continues to do so anyways. This does not happen EVERY time, but it has
NEVER happened at any other point except precisely when he hits the 'print
checks' button. Any idea? I can provide additional info if needed.
Great Plains eEnterprise 7.00g12
Great Plains Dexterity 7.10m012
Great Plains SmartL...Employee name change
One of the employees at a client of mine just got married and her last
name has changed.
The site is using SBS 2003 R2.
The primary mail system is the POP3/SMTP corporate web hosted by a third
party, while the Exchange server deals with in house mail and shared
folders; calendars primarily.
What is the best, easiest, etc., way to deal with this.
Thanks for any help
Fist I'd configure it on the Third party.
make sure both OLD and NEW names can receive email.
(this way she won't lose email)
Then change it on the SBS and Make her primary her ...SMTP Server Name -- DNS
We are about to migrate to Exchange 2003 from Exchange 5.5 (late we
We are testing out the SMTP to the internet and things are working
well, execpt for those sites that are doing REVERSE lookups on the
We have setup reverse lookup for our outbound severs as or normal name
space, but it seems when the messages are delivered, they are looking
up the active directory domain name (which naturally isnt on the
outside of our network), instead of the public name space name for the
AD Server Name: SERVER1.DS.DOMAIN.COM
External Name Space: SERVER1.DOMAIN.CO...Change Acct Name in Money 2004
I've change the name of an investment account in Money
2004 using change account details, but when I try to
transfer funds between accounts, it still shows the old
account name, not the new one. Is there a different way
to maintain the account name the works?
Did you change both the investment account name and its associated cash
"Steve" <firstname.lastname@example.org> wrote in message
> I've change the name of an investment account in Money
> 2004 using change account details, but when I tr...outlook webaccess does not show contact names #2
I have just installed exchange 2003 and do not see any names in the contact list while using outlook web access.
Using regular outlook I have many many names in my contact list but it is not showing when I use OWA.
Normally i create new mail, click "To" button and my list of contacts appear. Is there anything on the server end I need to set for thit to work in OWA?
...SQL Change Column name
I am using VB6 as a front end to an Access97 database. My computer has
Access2003 and won't let me edit the columns, tables, etc. I can add/change
data, but not the underlying structure of the database.
I have found & modified a VB front end that will allow me to add/drop
tables, add/drop columns, etc. But it doesn't have an option to change a
column name. I've done a bunch of googling on it, and know that using ALTER
TABLE and CHANGE is supposed to do it, but it's not, so I'm wondering if
CHANGE is not compatible with Access97.
The SQL statement I'm usi...Check if cell is an email address
I have a sheet contains names, adresses and email addresses. Which are
filled in by several people.
Is there a possibility to make an pop up if the email address not
filled in correctly, so without an "@" and an "." (row N and Q)
I tried to do this with the validation function.
Hope some specialist can help me with this.
This formula should do it
(there's no email, no snail mail, but somewhere should be gmail in my addy)
<email@example.com>...Two differently named folders for IDE Hard Disk Drives?
on our CEPC device, two CF cards can be mounted as IDE HDDs.
In storage manager registry settings, I can only define one name for the
If a 2nd card is detected, it gets a number concatenated (e.g. "Flashdisk:"
Is it possible to give the second store of the same type a different name
(e.g. "Flashdisk" and "Storage card")?
Thanks in advance.
Then change the profile name the IDE key refers to. You should have
something like this in your reginit.ini:
[HKEY_LOCAL_MACHINE\Drive...Use of ADMIN as user/account name
We have been using an email address with "admin" as the user/account
name for customers to send general documents to. (in other words the
full email address looked something lke this "firstname.lastname@example.org") We will
be moving to an MS Exchange email system and were told that you cannot
use "admin" as a user/account name on an MS Exchange system because it
will cause a variety of problems. Is this true? If so, what problems
On 20 Mar 2007 08:09:17 -0700, "Lanranger"
>We have been using an email addr...Naming shapes
Is there a workaround/explanation for the way Excel
Open a new workbook and draw a rectangle onto a sheet.
Excel will name it "Rectangle 1"
First question - Can I rename it?
Delete "Rectangle 1".
Draw another rectangle onto the same sheet.
Excel will name it "Rectangle 2".
How can I control the naming of Shapes?
Or at least have a sequential/logical/simple(!!) way of
referencing/controlling/manipulating what could be a large
number of similar/dissimilar Shape objects.
>>First question - Can I rename ...Check for duplicate entries???
Sorry in advance for the newbie type question :)
I'm going to be making a long list of items and prices. I will be getting to
the point I will come across the same item again and want to make sure I
don't have duplicate entries.
Is there a way in Excel to check and see if that entry has already been
entered in the workbook?
I assume there are a couple ways, but how would you set things up to check
to prevent duplicate entries?
(I'm using Excel 2002)
You may want to look at Chip Pearson's site. He has lots of techniques to work
http://www.cp...Count Check Marks
I have a report that counts yes/no. I am using a between date range on it.
When I use the following control;
when printing the report I get multiple pages. Could someone assist? If I
can format the report to show the Month and year and the totals, that would
> I have a report that counts yes/no. I am using a between date range on it.
> When I use the following control;
Why don't you count it in the record source (the query behind your report)?
> when printing the report I get multipl...Free Antivirus Download
Antivirus recognized a free download to your computer,
who knows Microsoft recommends at:
Content Site Links:
http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/ant...Checking cells are filled in.
From what I've seen being asked on these forums this question sound
like n00bish. But is it possible to check that certan cells are fille
in and if they are not an error message pops up. I am planning to use
macro if its possible and put this into a print sheet button, so firs
it checks to see that the cells are filled in and then if they ar
filled in prints the sheet. This is coursework and for some reason w
aren't given marks for anything acheived using VB scripting so I'd lik
to use a macro. But if it isnt possible then VB would be fine.
Thanks alot in advance :
Message po...Check for empty fields
I have a form for service calls.
My users are not filling out all the required fields.
If I make a field required in the table it does not save the record and I
want to do it another way, anyway.
What I really want is a test for particular fields when the close button I
built is clicked, before it closes I want it to see if the fields "Date",
"Generated", "PO" and "Emails" are null, if they are, a message box pops up
and says to go back and fill in empty fields, click that closed and it goes
back to the incomplete form. When all required fi...Excel Drop Down box or check box data to Excel Database
I desperately need help with this! I have an Excel form which I have
included check boxes, drop down boxes and Yes no. How do I incorporate the
data into the Excel database?
Maybe you could use some of the techniques that Debra Dalgleish shows at:
> I desperately need help with this! I have an Excel form which I have
> included check boxes, drop down boxes and Yes no. How do I incorporate the
> data into the Excel database?
You can send me the workbook and I may be able to assist.
...Parse out a name
How can I parse out a Name, ex: John J Jones, into First,
Middle Initial, Last Name.
Thanks in Advance!
Try using Data/Text to Columns. Following the wizard is straightforward.
"Brenda" <Brenda_Hankes@NCCI.com> wrote in message
> How can I parse out a Name, ex: John J Jones, into First,
> Middle Initial, Last Name.
> Thanks in Advance!
If it's spaces between, just go to Data>Text To Columns and use space as the
delimiter. It will automatically move to separate columns then.
...Outlook won't store my Yahoo password, so mail checking fails?
I have just started using Outlook 2000, and followed the steps to add my
Yahoo mail account.
When I click send/receive I am prompted to enter my password (despite saving
the password in the account settings) and sending fails after a timeout.
I am able to receive mail however?
Jonwalker67 <Jonwalker67@discussions.microsoft.com> wrote:
> I have just started using Outlook 2000, and followed the steps to add
> my Yahoo mail account.
Is this a paid Yahoo! account? Yahoo.com cannot be used with Outlook unless
it's a paid Yahoo! account.
Hi ...What does the #Name? message mean?
I have a report in which I have a text box which reads: ="As part of your
GALEX GI Cycle " & [Cycle] & " Program " & [NUM] & ", data was recently
delivered to the Multimission Archive at Space Telescope (MAST). GI data
is proprietary for 6 months from this notification."
I had this exact same construct in a 2003 report, but not I get this error
all the time.
The query which is the record source looks fine to me and the fields are the
ones in the record source.
Make sure that your don't have a control on the report named ...Determining if path name exist
How do I find out if a Path Name exist.
I have a CString that contain a Path Name (no file name associated
with this path name). All I want to do is determine if this path name
exist and if it doesn't, prompt the user that the path name does not
exist and if the path name should be created.
On Wed, 28 Jan 2004 09:17:10 -0800, John <email@example.com>
>How do I find out if a Path Name exist.
>I have a CString that contain a Path Name (no file name associated
>with this path name). All I want to do is determine if this path name
>exist...Macro to select all and name range
I have a workbook with some macros that work on another workbook
("Data.xls"). One thing I want the macro to do, is to select everything in
a worksheet named Survey and name the range "Database". This would be
equivalent to go to the Data workbook and Survey worksheet, hitting
Ctrl+Shift+End and enter Database in the name box. I can't record this
action because the code specifies the cells included in the current version
of Data.xls, and the number of rows will change.
What code can I use to accomplish this?
With Workbooks("D...Display names puzzle, can you help?
Here's my situation: We've acuquired a company, and now we're adding
those users onto our mail system. I can deal with all the issues
related to DNS, etc, but one real thorn in our side is the display
names. This company used only "firstname.lastname@example.org" for an e-mail
address, AND the real clincher is that they only use "firstname" as a
Our corporate standard as the aquiring company is to use
email@example.com. However, this little company we
bought has gone ahead and put employee pictures on the web (with only
fi...Named range row/column reference
I am using named ranges in a VBA macro
StudentNbr is A26:A45
TestWeek is E25:X25
TestScores is E26:X45
As you can see this is a grid of data with student numbers down th
left side, test week numbers across the top and the grid containin
I would like to update the cells in TestScores based on the positio
of the values in the StudentNbr and TestWeek named ranges using:
Range("TestScores") (vStudentNbr,vTestWeek).value = vTestScore
*Is there a way to get vStudentNbr and vTestWeek as relative reference
to the beginning of their respective named ranges? *...