I've created a number of comments. When I position the comments where I
want them, they only reflect their positions on "Show" or "Edit"
comment. All the comments default to the same relationship to the cells
when you pass over them. This is a problem because I've also used data
vaildation (with lists) on these cells and you can't display the
comment with the list pulled down at the same time because the comments
are tool close to the validated cell.
Thanks in adavance.
The comment usually appears to the right of the cell, and should still
allow you to see t...Printing problem from Excel 2007
I am having an issue with printing from Excel 2007. Many users when
printing from Excel with get several pages of non-sensical "junk"
printed out on the pages. If it actually prints what is on the page,
none of the items are in the cells, but look like they are just
randomly thrown about the page. I have found that this most often is
related to the Calibri font somehow, because I instruct them to change
the font to Arial and all prints fine. That being said, if the user
converts the Excel sheet into a PDF and print, it prints perfect. This
is a great workaround, but kind ...Excel Mail Merger Problem
When merging excel with word for..my currrency field is
dropping off zeros to the right of decimal point..if
field has $ 56.03, it imports correctly, but if it is
$56.00, it comes in as $56, if it is $56.30, it comes in
as $56.3...this process is for invoices..any advice (I've
Debra Dalgleish has given the following reply in newsgroups
and has also identified the following MS KB articles in
such as : http://google.com/groups?threadm=3DFA8DA8.6000209%40contextures.com
304387 - WD: Date, Phone N...Cannot access by OWA
we�ve two ex2k servers. First in domain 1 with internet connection. Second
in subdomain, connected by a dedicated line. Both servers are in same org
and site. When I try to access the second server by owa I can�t access the
mailboxes there. That�s only possible on the first server (SSL security is
Do I�ve missed to configure something?
Thanks for any advice.
Sorry, found it myself. Just have to configure the server as a
"J. Kuenzel" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Hi the...Access attachments don't work anymore
Outlook 2000's security update makes it impossible to
receive MS Access .mdb or .mde files. But I need to do
this to earn a living as an Access developer! Other than
have the sender rename the file there must be a simpler
way to override the security patch. Outlook Express let's
you turn off this feature but OL 2000 has no such setting.
(The feature is basically worthless anyway - any hacker
would know you just rename the file, put your hacker code
in it and send it. Access will open ANY file, regardless
of what you name it!!)
See if the information on the following page help...Converting XLS file to QIF or to OFX
How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
> How do I safely and securely convert an excel file (xls) to a QIF or OFX file?
In Excel, save the file to CSV and ustilise iCreateOFX Basic from:
to convert the saved CSV file to OFX.
...synchronising problem with Sony NWZ-S545
Up until recently i could sync tracks/albums etc to my sony S545 MP3. now
when i try and drag tracks to the sync folder then click start sync the mp3
player just freezes, WMP states "processing" but nothing happens.
Have searched the web for a solution but nothing. done sysem restore etc
etc. I guess it must be a recent update but what one?
Its a pain in the backside and hope someone can help
> Up until recently i could sync tracks/albums etc to my sony S545 MP3. now
> when i try and drag tracks to the sync folder then click s...Problem hot synching Outlook 2002 with Palm Pilot
I recently had to reformat my c: drive and reinstall Windows XP and
Office XP, including Outlook 2002.
Since then, whenever I hot synch my Palm Pilot with Outlook, the hot
synch is interrupted with a dialog saying "This action cannot be
completed because the 'Inbox Microsoft Outlook' program is not
responding. Choose 'Switch to" and connect the problem." When I
press the 'Switch to" button, I get a second dialog, which says,
"Microsoft Outlook - A program is trying to access e-mail addresses
you have stored in Outlook. Do you want to allow this? ...Problems printing in Publisher 2003 with HP PSC 2410 #2
I am new to publisher 2003 and am having great difficulties printing anything
properly using an HP PSC 2410 all in one. As an example when trying to print
a half page side folded pre-designed greetings card all that prints is page 1
and part of page 4, minus any text. Pages 2 and 3 are missing altogether.
The print preview however displays everything correctly. I have reinstalled
Office 2003 and updated the printer drivers to the latest versions but the
problem remains. Any help is much appreciated.
this is a follow on to a previous thread (Copy Macro)
We are now successfully creating a new Workbook using the code below.
FName = .Path & "\code.txt"
ActiveWorkbook.SaveAs Filename:="c:\Week\testing" & strFileName &
Problem is when we open the new Workbook and run the macro the code defaults
ba...Convert Column to row with variable data
I'm using Excel 2k and I have a spreadsheet that looks
Fred 21 Blah St
Sue Tower 50
and need it to look like this
Name Address 1 Address2 Address3
Fred 21 Blah St London
Sue Tower 50 London EC2
I have a macro that can convert from column to row but
only for a set number of columns. Is there any way to
account for the variable amount of data for each address ?
Any help much appreciated
I suggest the following formulae - copied down as necessary:
C2: =IF(...frustrations with Access 2006
is anyone else frustrated with the number of time, when editing a
project..., Access 2006 crashes, leaving behind a corrupt, un-repairable
file (or somtimes just a corrupt form, never-the-less: frustrating)?
short of going back to an earlier version of the program, does any one have
thanks in advance...
"Mark Kubicki" <email@example.com> wrote in message
> is anyone else frustrated with the number of time, when editing a
> project..., Access 2007 crashes, leaving behind a corrupt, un-re...conversion lotus 123 files to excel -- problem
I am converting lotus123 files to excel2002. One problem is that in lotus, literals are ignored when found in a cell within a formula. Excel on the other hand is not doing this and therefore causing #value errors on all the formulas where this occurs. Is there a way to handle this in excel other than manually having to change all the formulas?
...Do you need Access to use an Access Database for data entry only?
We have an Access database completed. Now we will use it for reading as well
as for data entry. Do we need to install Access for every workstation
needing the database for data entry or reading?
No you don't necessarily need Access on every computer. You CAN use the
Access Runtime and if it is in Access 2007 you can use it for free. If you
are using another version then you would need to purchase the developer's
edition to be able to legally distribute the associated Access runtime.
If you do have 2007 and want to use the runtime, make sure your Full version
of Access doe...Access, average several fields in one row
I have several rows of data in a field, I need to average all the entries in
I have 12 fields for 12 months of data, I need the average of the sum of all
non blank entries.
For example 3 months completed, the solution in Excel is
I am looking for method to average the sum in Access
One way if you can't change your data is to use a VBA function. I've posted
one below. You would call it in a calculated field in a query. Assuming your
field names are the abbreviated month names the expression might look like the
Field: fRow...Access 2007 Reports
I'm using an Access 2000 mdb (split ends) in Access 2007. I cannot up-
convert because other terminals don't have Office 2007.
It works as a database just fine except:
When I try to change a (front end) report from the default printer to
another specific printer in design view, page setup, it all LOOKS good
except it does not save my changes upon return and goes back to the
I never had this problem with earlier versions of Access and the
specific printer in questions works fine with other apps and
Any ideas people? Many thanks.
This is a known prob...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...Is store procedure always fast than Access linked table via ODBC?
I was assigned to upgrade one program from Access(using ODBC to connect to
SQL 2000) to ASP.NET(using store procedure in SQL 2000).
Finally, I tested them and found that ASP.NET is slower than Access.
The mojority job of program is select some data from SQL 2000 tables, modify
and then insert into some tables.
Is store procedure always fast than Access linked table via ODBC?
Message posted via http://www.sqlmonster.com
Stored procedures don’t add any overhead and they can save compile time.
It's the code in the stored procedure and the underlying tables / indexes
that ...IE8 can't access Microsoft Office site when all other browsers can
When trying to access the Microsoft Office page using IE8 I keep getting the
"Internet Explorer cannot display the webpage" message. If I use any other
browser (Firefox, Opera, Safari, Chrome) I have no problem accessing the
page. This happens whether running in normal or No Add-on's mode. Despite how
many people keep complaining about all the problems with IE8, neither the
MVP's or Microsoft acknowledge that they exist.
Intel E8400 Core2Duo 3.0GHz
4 GB PC2-6400 DDR2
Windows 7 Ultimate (with all the latest updates installed)
NIS 2010 (all up to date)...Unable to open Access 95 mdb in Access 97
I am trying to open an old Access 95 mdb in Access 97...I
didn't create it but someone who knew the database way
back when said that a system.mda file was created for
that particular database because it had a lot of personal
info in it.
(I am not familiar with mda files...the database folder
also had a system.ldb file there as well...I deleted that
file...but am unsure why it wasn't closed out to begin
I was able to open Access 97 and repair it...but when I
go to open it in Access 97...I get an Automation
Error...Cannot find VEENLR3.hlp file.
Do you think it may ha...How to convert privatekey(string) to XML
I need to convert privatekey toXML format.
I read privatekey from file. Here is how:
Dim myStream As System.IO.StringWriter = New
Dim testfile As String = "c:\RSAprivate.txt"
Dim objStreamReader As System.IO.StreamReader
objStreamReader = System.IO.File.OpenText(testfile)
Dim readfile As String = objStreamReader.ReadToEnd()
TextBox1.Text = readfile
and the privatekey looks like this:
-----BEGIN RSA PRIV...Backup error Access Denied
I have been recieving the following error message for a while and can't
figure out how to fix it. It is only happening on one mailbox.
"Backup - \\MBMAIL\Microsoft Exchange Mailboxes Access denied to file Jhon
Doe [jdoe]Top of Information StoreSync IssuesServer FailuresMail
Delivery (failure firstname.lastname@example.org)." Help Please
Can you access the mailbox from a mail client? If so, you can use mdbvu
to look at the Top of the Information store folder, and delete the message
If you cannot access the mailbox, then I have seen it where some users think
they are ...save as problem
I cant save my excel file
The "save as" option is not eviable. Whats happening?
"From a prior post by Ron DeBruin,
You can reset your menubar to default.
Right click menubar. Customize > Toolbars Tab. Select worksheet
menubar. Click Reset button.
Using VBA Application :
CommandBars(""Worksheet menu bar"").Controls(""File"").Reset
Or the whole menubar
You lost the things you add to the menubar!!"
And one link that offers some sugges...Odd problem with worksheets when opening file
Okay, here's the odd problem that's come up.
When you double click on a excel file, excel opens up, but you can onl
see the toolbars. The grid area looks like a snapshot of whatever you
current background is before the file opened up. If you were showin
your desktop, after the excel file opened, you'd still see your deskto
in the datagrid area.
If you start up a new excel file, then do the File>Open>file name, th
file will open correctly.
This problem happens across users here. Everyone is currently runnin
Any ideas on what causes the problem and any...Problem OL 2002 Email
I am having a problem with OL 2002 email settings. I
have two computers which I am setting up. One computer
works perfectly. The second computer I have configured
exactly the same...incoming/outgoing servers and ports,
etc... are all setup the same. On the second computer
when I press test email settings, everything tests fine.
But when I try to do a Send/Receive, I run into problems.
First, the POP3 tries to connect to the POP3 server twice
at the same time. (I am able to see this on my POP3
server console.) Second, the SMTP sending mail never
connects to my SMTP server. (Ag...