Euro Display Not working in Form
I have an Access 2003 Client linked to a SQL Server DB (2005).
When I change a text box to format as Euro it never displays as Euro, only
the number. I've tried Currency Type in SQL Server, Decimal, Numeric, etc..
What Am I doing wrongly?
...How do I get a Data validation list to select another validation l
I am creating a data entry page in which I want to use data validation Lists
to select the product that I want to enter. How ever each cell may be
different from the one above. For example in (c4) I want to enter pipe data.
I have a sheet named pipe as the source for this entry. In (c5) I want to
enter valve data or maybe pipe data or ell data. How can I use Excel to
create a drop down list that lets me decide which source page I want to use
and then go to it for me to make my selection?
Look at this site:
"langston35&...Unable to open Outlook2003. Error: MAPI unable loading msncon.dll
I am trying to set up Outlook 2003 on home computer but keep getting the
following message when trying to open application.
MAPI was unable to load the information service msncon.dll.
Since I am not open to open, I cannot get to the help feature.
Have you downloaded the latest MSN Connector from their site? Or, if not
using it, have you uninstalled it? Try opening Outlook in Safe mode
(start->run->outlook.exe /safe) and go into the Advanced options and uncheck
it from add-in manager or COM add-ins.
Milly Staples [MVP - Outlook]
Post all replies to the group to ...Using Autocorrect to remove spaces
I am looking at how to remove extra spaces, and have been thinking
about using Autocorrect.
I have been reading another thread which suggested;
For Each cell In Selection
cell.Value = WorksheetFunction.Trim(cell.Text)
What I have been using is;
.AddReplacement "Want", "Replace"
Works well within a loop changing any "Replace" text with "Want".
Something I didn't get Substitute to do correctly within a loop.
What I can't get AutoCorrect to do though is work with spaces, so...Unable to Edit/Add records on Form in a New ADP
I just started playing around with rebuilding a MDB file as an ADP. I built
a form and subform from scratch, but I'm unable to edit or add records.
SELECT Id, LoadDate, TrailerDOTNumber, SealNumber, SealDate, SealId,
LoadLocation, LoadStatus, DispatchStatus, DispatchLocationId, DispatchUserId
FROM TrailerActivityHeaders ORDER BY LoadDate
Recordset Type: Updatable Snapshot
I'm getting the 'This recordset is not updatable'
Never mind... (Does anyone have a spare bandage btw? I cut my head banging
it on the wall due to my stupidity...)
"D...Unable to open calendar
Folks, i cannot open or view my calendar.
When I start Oultook a Pop Up appears saying "Could not read the Calendar"
On clicking Ok, the pop up vanishes and nothing happens.
If i then go over to my calendar, it says "Cannot display the folder"
I have run Oultook Diagnostics and nothing shows up as irregular. I ran the
repair function (off my setuo CD) and nothing happened. I also re-installed
Outlook and rebooted my comp and nada.
When staring in safe mode i also get he same errors.
I am using Off 2007, Win 7
"phamiltonsmith" <...using embedded .xsd vs file based .xsd
I am thinking of embedding my schemas as embedded resources instead of
reading it using URI at run-time.
I came across some snags while trying to do just that such as, previously
unknown to me, XmlValidatingReader.Schemas.Add was using
XmlValidatingReader.Resolver to resolve my schemas using the URI method.
Resolver property was never set, so the reader simply ignored any external
references even though one of the schema explicitly imports the other one.
I verified this by removing the referred schema from the schema collection,
and the code chugged along fine.
But when I changed the code to ...unable to download emails and unable to stop synchronization
I am going to try one more time to get this fixed. My Outlook 2003 has been
unable to download emails. While it is trying, a small box in the tray
section shows up and it states that it is trying to synchronize folders.
After a time out time Outlook gives me errors. This is the error message. It
has these numbers 0X800CCC15 , or 0X8004210A, or 0X8004210B, which these
error messages state that either I did not have enough timeout or look and
see if server name is wrong. All of you have given me these suggestions. no
joy. Thank you very much however.
I went ahead and finally found a sect...Run a Query using VBA without User Interface
I have a VBA Macro that Opens an Append Query (see below), which works great,
except for the end user has to answer the following MsAccess prompts:
1) You are about to run an append query that will modify data in your table.
(They have to click Yes)
2) You are about to append 1 row(s). (They have to click Yes)
I'd rather them not have to answer either question. Instead I'd like the
Append Query to run and do what it's asked without any human intervention.
Can this be done? Please help!
VBA Macro Code:
DoCmd.OpenQuery "tblTask_List Query", acViewNorm...Using "OR" in an IF statement
I am trying to use the command OR in an If statement and I am having no luck.
In Lotus 123 I could string commands by using #OR# to produce a common
result. For example: =IF(J3="INVEST" #OR# IF(K3 = "INVEST",1,"NO")) I can't
seem to make this work in Excel. Can anyone provide me with a correction?
=IF(OR(J3="Invest",K3="Invest"),"The true condition","the false condition")
If the true or false condition is numeric then drop the quotes
When competing hypotheses are other...Change of recipient/sender display name
Environment :- Windows 2003 x64 with exchange 2007 (All in one role)
Outlook client :- 2003, 2007
We have created a list of mail contacts (which under GAL) in exchange
2007, these mail contacts are associates with external email address,
each of contact has a naming standard for display name, for example,
display name is HD Finance Manager, external email address is
I want to configure outlook client to show the display name according
to mail contacts whenever the email address is match to mail contacts
list (GAL), for example, an email sent from the email a...unable to scroll the page
on microsoft office frontpage 2003 - when i up loaded my web pages to my web
site www.millertimeauction.com , there is no sroll bar for up & down of page -
it scrolls for me in IE8
scroll bar will only appear if it needs to
Microsoft MVP Expression Web
"FrontPage Error" <FrontPageError@discussions.microsoft.com> wrote in
> on microsoft office frontpage 2003 - when i up loaded my web pages to my
> s...Unable to start POP3, NNTP, IMAP4...
I'm evaluating to install Exchange 2003. After the installation I find the said protocol haven't been started. I tried to start
them in "Servers --> Server Name --> Protocols" but no help.
Please comment.... Thanks!!
Windows 2003, Exchange 2003, Active Directory DC with all roles of FSMO as it's the first DC in the forest. Thank you very much!!
Are you boring? Let's come to talk together... ^^
Those services are disabled by default in Exchange 2003. Go to
Administrative Tools, Services and enable...Display apostrophe in Combo Box
I have a combo box which displays the employee names from a table. Users
select an entry to "reassign" a unit of work to another individual. There are
several employees with apostrophies in their name. The name appears without
the apostrophe in the combo box, so when work is reassigned, it displays the
name differently than when updated from any other process. Example: Audit
trail updates show the individual as "O'Connor" but updates using the combo
box show "OConnor".
Is there any way, without using code to load the combox, to display the
correct name...Can not remove Public Folder Store in Front End Server
When trying to delete a PF Store in a new FE server you get the error: "...
Can't ...contains replicas ... move to another server ..."
Selecting 'move all replicas' and waiting a day doesn't help.
Dismounting the Store, and deleting the edb and stm files and remounting to
delete doesn't work.
No Mailbox Databases point to this PF Store, I changed the Mailbox Database
PF 'affinity' to another BE Server.
I've setup 5+ FE servers over the years, so not my first shot at this. But,
it is the first time I've done it since SP2 was out...Outlook doesn't close --> WMS Idle
From time to time in recent weeks, when I log out of
Windows XP Pro (SP1 with all updates) I get an "End
Program" error on "WMS Idle", with the system indicating
it can't shut down WMS Idle.
Whenever this occurs (it happens only intermitently),
Task Manager shows that the OUTLOOK.EXE process is still
running. However, the Outlook 2002 application (SP2 with
all updates) has been closed. There are no other system
symptoms or problems whatsoever and the only software
updates done for many months are Windows and McAfee
Is anyone aware of a Windows update...How do I stop text from automatically filling another text box?
When I type in one box, the same text appears in another box. How do I
Someone answered my questions but the link isn't working so I can't see the
response. Please answer again.
Edit, Undo Synchronize.
Mary Sauer MSFT MVP
"Chicago" <Chicago@discussions.microsoft.com> wrote in message
> When I type in one box, the same text appears in another box. How do I
> unlink them?
> Someone answered my...Condition is true in one cell, give me same condition in another
Have a problem. See below.
If a condition or value is true in one cell, I need the same conditio
or value to appear in another cell.
If cell A1 = "N", then give me a "N" in cell C1.
Problem is, I need to write the formula in cell D1 due t
specifications in workbook.
Message posted from http://www.ExcelForum.com
not possible with formulas. Formulas can only return a value but can't
change the values of other cells.
> Have a problem. See below.
> If a condition or value is true in one cel...Running Total in report using net of two columns in third column
I have a client time/fees database of over 22k records. I have a report
which provided a summary of all time booke and all fees charges to that
client. What I require is two additional columns the first which provides a
running total of time bookings and the second which provides a running total
of the net of the time booked field less the fees charged field, i.e. the net
of time bookings which have not been invoiced.
I can do this in excel but in access I appear to be getting data from other
clients which should not be included in the report.
What type of field are you usin...Lost Public Folders with Digital ID
I'm using Exchange 2003 with SP1 and a CA Server. I created my own Digital
ID that I installed on my Outlook 2003.
Somehow I lost my public folders after the installation.
How do I get this back? Please advise.
Digital ID is working fine except the above problem. And I got slow
response when the root is not offline and subordinate have CRLs to execute.
Does root need to be online when CRLs need to be executed?
Can you see these folders via another Outlook client? I have never seen a
certificate cause public folders to disappear.
When you say the root CA is...Unable to conect
I have set up my email account to work with aol using the guidlines for
outlook 2002 but it is still unable to connect. Any suggestions? Thanks.
John <John@discussions.microsoft.com> wrote:
> I have set up my email account to work with aol using the guidlines
> for outlook 2002 but it is still unable to connect. Any suggestions?
Since you pay AOL for their service, my suggestion is to ask AOL.
...Personal Folders #2
Hi, I really need some help...........
I made a personal folder and always put my emails in
seperate sub-folders after I read them. We have to keep
our inbox fairly small or the server statrts yelling at
PROBLEM! My personal folder is now just over 2gig in
size. Outlook 2000 won't let me access the file. It
says there is an error and to use the inbox scan to fix
it. I use SCANPST.EXE, but even it comes up with a error.
Is there a 3rd party program that will let me access this
file? Maybe I can go in and delete some things to get it
below the 2gig limit.
Please email m...Unable to click on charts & unable to create any new charts Excel
Just started using Microsoft Excel 2007 and I seem to have done something
that means the chart option is unavailable. The chart section is now grey
and all charts I have created are 'locked' I cannot click on them anywhere.
I'm working on a project and need it finished by Monday.
Do you mean that if you click on a chart it does not get a border to show it
is activated and there are no range-finder borders around the data that
makes the chart?
This is a bit odd.
Have you tried a new workbook to see if the problem is with just this one?
My advice with all odd things is...Using secondary email when distributing a Campaign Activity
I'm looking for a way to use the marketing list's member primary AND
secondary emails when send a email mass mailout from a campaign activity. I
believe we could do it using the sdk, but am not sure how (plug-in,
workflow?) Has anyone achieved this somehow?
Yes, our latest VEM (Vizola eMarketing Addin) module has this feature,
please checkout http://www.vizola.com/vem - you can download and try
the evaluation version - it also includes all the template usage +
tracking and bounce features you need. On the COMPOSE EMAIL screen you
are presented w...Public folder favorite disappears
Hi. We are using Outlook 2003 sp 3 and Exchange 2003 sp1. One of our users
adds subfolders of a public folder to her public folder favorites, but
after a short period (10minutes - 1 day) the folder disappears from her
public folder favorite list. When she adds it again, the same thing
happens. I am lost as to why this keeps happening. Does anyone have any
suggestions? Thanks in advance for any help.
I have not encountered this, however, the public folder favorites
are stored in the OST/PST file. Knowing this, I would guess that
the problem lies in the synchronization of the pub...