Rearrange data in a column, Access 2003
I have a column that is for Page Numbers, and this particular table contains
a letter in addition to the page number. Here are examples:
I would like to do 2 things: I would like to move the letter to the front
formatted as "A- " and I would like to make one-digit numbers 2-digits so
they will sort in the proper order. These letters are meaningful to the
users. I would like to end up with:
Can I do this? I've tried a few things that I found in other questions, but
have not been able to get it to work. I assume I would use ...Too many fields
I have a table and I think it is normalized based on other postings I
There are about 500 object<->value pairs, that needs to be tracked for
500 different objects on every single day of the year. And, all 500
objects should have a value for that day. Object 1-30 is about one
topic, Object 31-60 is about another topic, etc.
tblObjects, I have 500 records like this
(pk) fldObjectID - autonum
fldObjectName - Text 50
(pk) fldDate - Date/Time
(pk) fldObjectID - (fk) to tblObjects
fldObjectValue - integer
Now, I want to show the 500 records of tblObjects ...Outlook 2003 purchase
I operate on Windows XP Home Edition.
I am considering the purchase of Outlook 2003 as a stand-alone program. I
now have MS Office Pro 2000 installed on my computer.
Are there any compatability problems between Outlook 2003 and the other MS
Office Pro 2000 programs, such as Word, Excel, etc?
If not, can I have Outlook 2003 use my existing .PST file correctly or are
there some technical matters that have to be dealt with first?
If I were to install Outlook 2003, do I need to uninstall Outlook 2000? When
I go to Control Panel>Add/Remove Programs, it appears I can only uninstall
all ...What Exchange 2003 post SP1 fixes should I install?
Is there a good way to monitor when these become available?
Also, should both front end and back end servs be updated?
...trouble receiving e-mails
I recently had my motherboard replaced and am up and running but my windows
mail is acting up. In order to receive e-mails, I have to exit out and go
back in, then all of the e-mails I've received in that time appear (I think).
When the program is open I hear the chime signaling new mail, but the number
of new messages doesn't correspond to the number of chimes I've heard.
I followed the help suggestions with no change.
The chime will also sound for messages delivered to the Junk E-mail
folder, so have you looked there?
Which antivirus are you running? Some of...Quick question about Outlook 2003 Process not stopping
I know I just gave a big compliment about the great Junk filter. But I do
have one minor problem totally unrelated.
Ocassionaly, when I close Outlook 2003. The 'Outlook' process continues to
run until I go into Task Manager and stop it manually. Then it's fine for
several days, and then it does it again. No set pattern, just once in a
while. No big deal really, but I would like to fix it all the same.
Any ideas why this is happeneing, and what I can do to prevent it? Thanks.
Look for 3rd party tools that sync/utilize Outlook data. For example,
Outlook will stay resident with ...Trying to import from Outlook
When trying to import from Outlook I get the error
message "Microsoft Outlook can not be started. Verify
Outlook is installed on this computer"
I did find a support question on this site from 8/4/2003
that stated all I needed to do was enable Active X
But this did not resolve the issue. Do I have to have
outlook sales loaded also?
>When trying to import from Outlook I get the error
>message "Microsoft Outlook ca...Powerpoint Screen tip linking
Currently screen tips are keyed text only. Can that be upgraded to be linked
to an Excel sheet? Example: I support a fire department that has images of
fire hydrants on various slides. The images use screen tips to provide
hydrant info. If the info could be linked, then if hydrant info changes are
made to the sheet, the ppt file could update without the hassle of locating
and changing every screen tip affected.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the &quo...Public Folders have disappeared in Outlook 2003
Running Outlook 2003 in an Exchange 2000 organization. I upgraded my
Outlook 2002 to version 2003. Now Public Folders have disappeared. What
happened to them? Everyone with Outlook 2002 still has them.
Have you clicked on the Folders icon in the Navigation Bar?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, Spin asked:
| Running Outlook 2003 in an Exchange 2000 organization. I upgraded ...Import my Comcast email contacts into Outlook
I use Comcast as my email provider and just started using Outlook. However,
my email contacts do not show up in my Outlook so when I want to send an
email I have to use my Comcast and can't send from Outlook. How can I import
my Comcast email contacts into Outlook?
A google search using the term "comcast.net export contacts" will provide
As a reference, this may also provide some insight to the question posed
How do I import from ??? in Outlook
________________________________________________________...2003 on NT
Is it possible to run Exchange 2003 on an NT 4 Domain or does it require AD.
Requires an Active Directory domain.
"Gary Hindson" <firstname.lastname@example.org> wrote in message
> Is it possible to run Exchange 2003 on an NT 4 Domain or does it require
Not only that, but Exchange 2003 requires the server OS to be Windows 2000
SP3 or Windows 2003.
"neo [mvp outlook]" <email@example.com> wrote in message
news:%...Looking for XML Schema Validator
ANyone know any free powerful xml schema validator ?
Can You?You Can.
You can code one up very quickly using .net 1.1 and .net 2.0 beta2. I can
give you the code if needed.
"BillyLiu007" <firstname.lastname@example.org> wrote in message
> Hi guys:
> ANyone know any free powerful xml schema validator ?
> Can You?You Can.
but the framework's validatorReader doesn't fuifil my need.For eg, it only
tell that the datatype not correct, but not tell what type it supposed ...msmoney 2003: Strange Capital Gains Behavior in 2003
My version of money from 2003 is showing strange capital gains behavior in
the tax reporting. I recently ran the report and it stated that my capital
gains for the year was over 2,500,000.
However, if I run a report with the individual buys and sells and do the
calculations manually, the capital gains are significantly lower. Since I
do not have the 2,500,000 in my account, I am going to assume that I am
correct and that money has an error.
I have narrowed down the problem to just one account. However, this account
as thousands of transactions this year alone.
Any help would be...OWA trouble #3
i am having trouble opening PDF attachments on a server that is running SBS
i can open the same attachments if they are on a regular Exchange 2003
if i use IE7 or the latest Firefox against the SBS server i can open the PDF
i have been through all the security settings in IE, have re-installed
Acrobat Reader till the cows come home,
does anyone have an idea of where to look? should i install OWAAdmin on the
SBS server? why would IE7 or Firefox open the attachment when IE6 cannot?
thank you for your time
ok i have found a work around that will allow me...How to setup policy for Exchange/Outlook 2003
I'm looking for a way to have all messages in Outlook 2003 Sent Items folder
auto delete after 30 days. I know a policy can be applied via mail retention
policy for the entire information store, I'm just looking for a way to delete
items after 30 days in Sent Items.
Take a look at http://www.msexchange.org/tutorials/MF012.html for a tutorial
for Exchange 2000. It's the same for E2K3.
Jeff Guillet, MCSE
> I'm looking for a way to have all messages in Outlook 2003 Sent Items folder
> auto delete after 30 days. I know a policy c...Forwarding Rule Exchange 2003 / Outlook 2003
I have set up a rule for one of the owners of our company in Outlook 2003.
When he receives mail from his yahoo email account, there are 2 Outlook Rules.
One that sends those emails to a folder that I created for him. The second to
forward those emails to an external email address.
I have both rules looking at the same info in the header.
The folder rule is working.
The forward rule does not seem to be forwarding to the external email address.
I looked at message tracking on the Exchange server and it looks like it sends
the message as far as "Message Submitted to Categorizer",...Outlook 2003 upgrade from 2002 dial-up issues
I recently upgraded from Outlook 2002 to Outlook 2003. I
used to be able to dial up to my office Exchange 5.5
server and get my email. Now when I dial up, I connect
successfully, but am unable to retrieve my email. I get
the following error:
Task 'Microsoft Exchange Server - Sending and Receiving'
reported error (0x8004011D) : 'The server is not
available. Contact your administrator if this condition
Like I said, this used to work, but now after the upgrade
it does not. I called Microsoft and because it is
connecting to Exchange Server they wanted $245...If, then trouble
Trying to create if/then formula which will look at a cell and make th
=if(A8>1.5=100, .71<A8<1.49=75, .41<A8<.7=50, A8<.4=25)
A8 is a result of another formula, so could I be drawing on more than
Message posted from http://www.ExcelForum.com
"peterdanton >" <<email@example.com> wrote in message
news:firstname.lastname@example.org...Control with Dlookup source not showing data
I have a forn with a textbox whose control source is dlookup...
When I open the form the control does not show any data. However, when I
click on the control the data is displayed.
Any ideas on how to make the data display when the form opens?
If the DLookup() expression depends on other controls on the form, chances
are that those values are not present early enough.
Use ReCalc to force the calculated expressions to update.
Either that, or get the data for the expression from somewhere independent
of the form.
Allen Browne - Microsoft MVP. Perth, We...Outlook 2003 Import and Export Wizard is empty
Im using a Office2003 installationpoint and everyone who installs the
package gets this same error:
When they choose "File" -> "Import and Export" then the menu that
appears is completely empty.
Nothing in there at all.
The installation type is a complete install with EVERYTHING selected
so I guess its not because the lack some components.
If I do a repair from "add remove programs" the list gets populated
but thats not exactly the solution im looking for.
Its a standard MST unattended installation.
Thanks in advance.
...Trouble opening Outlook data file
Hi. I archived all my emails and saved the .pst file before reformatting my
hard drive. Now that I have everything installed again, I try to open the
archive.pst in outlook, and it tells me that I do not have permission to
access the file. Does anyone know how I can get all my emails back from the
Never mind. I didn't have permission because I was trying to open it from
the cd I placed it on. I guess you need write access to open the thing.
Once I placed it on my hard drive, I was able to access it and extract my
"Silmarillion" <evan.dickso...After Installing Exchange 2003 SP1
Was there a security change in how Exchange 2003 SP1 receives a message?
Before, I used an SMTP client that sent test messages to my companies email
server (I am the Exchange server Admin), and I would use something like
email@example.com - from home or work. Now, when I use a none real valid
domain as far as origination (FROM field), I never receive the message. I
am thinking that there is some DNS to address lookup/verification taking
place and failing thus not being received by Exchange 2003 SP1.
Can someone tell me if this is true or clarify it and tell me where that
how can you programatically move hyperlinks keeping the relative references,
so that the hyperlink is recreated when it is moved.
I have tried using the copy and paste hyperlink but this doesn't alter the
link for the change in location when the workbook is in a different directory
to the intial workbook that it is copied from.
Does this mean you want to point at the new workbook?
If yes, then I'd use the =hyperlink() worksheet function:
David McRitchie posted this and it might help you:
=H...SelectNodes() having trouble...
I have the following xml doc...
I'm tryin...Printing inconsistencies in Excel 2003
I'm getting a lot of grief from trying to get a printout in Excel 2003 that used to work perfectly in Excel XP.
I have a one page spreadsheet that I print on a regular basis. I set the scaling to fit 1 page wide by 1 page tall and center the page horizontally and vertically. The printout fits beautifully in Excel XP until I migrated to Excel 2003.
In Excel 2003, the printout is noticeably smaller with an annoying gap/margin on the left and bottom of the page.
I've ensured that all the settings remain consistent with my Excel XP settings. In fact, on the preview page, Excel 2003 show...