Postings for Windows 7
Why is there no Windows 7 spot to post. Is there a different forum to post
for Win 7?
I think because of "Troll" control
Microsoft is trying to eliminate Posting without logging in
So here is the Win7 Group
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
SBS2003 SBS2008 Support - www.SBITS.Biz
Question or Second Opinion - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com
&qu...Can't open Documents
When I try and open documents on my Office 2004 for Mac I get an error
message, saying that the file can't be opened because it is already
opened or some other program is trying to open it.
I know that it is not open anywhere else and I have the same problem
with Excel, Word, and Powerpoint documents that I received from co-
workers in Entourage. The files I received where all created on PC
OK, we need to do a little differential diagnosis here because this one is
going to be complex.
First, please work your way patiently through the trouble-shooting tips
her...Posting to vs. posting through
What is the system behavior and impact controlled by the following system
Post to General Ledger
Post Through General Ledger Files
Post To means that when you post a batch from the subledgers the resulting
GL journal transaction is created in General Ledger but not posted. The
transaction will remain in a batch in GL until it is posted.
Post Through means that when a batch is posted in a subledger, the resulting
GL journal entry will be posted in General Ledger, thereby updating GL
account balances and transaction history.
Note that if you post a transaction in a ...query help 04-14-10
using sql server 2005 sp3 32 bit
i have a table that looks like this (pseudo coded)
create table test (id int, parentid int, path varchar(200))
insert into test select 1, null, '/1/'
insert into test select 2, 1, '/1/2/'
insert into test select 3, 2, '/1/2/3/'
insert into test select 4, null, '/4/'
insert into test select 5, 4, '/4/5/'
insert into test select 6, 5, '/4/5/6/'
I need to produce a table that is flattened
4 ...Opening saved Excel files
When I open any saved Excel file the program will open a blank 'Book 1' and
then open my pre-existing spreadsheet in a new window - how can I stop Excel
opening a blank Book 1? I am using Office Pro 2003 and file share on my PC
and wirelessly networked laptop - Excel opens files on both the PC where I
save my docs and on the laptop in the same way.
If you are first opening Excel and then opening the desired workbook,
creating Book1.xls is normal. If you're opening the workbook by using
Windows Explorer and finding the .xls file and double-clicking to open it
direct...Open in acDialog mode
From a button in form X, I open form Y in acDialog mode. Reason for this is
that I want the code in the button to wait till form Y has been closed. I
find that the pageup and pagedown buttons and the arrow keys don't work
anymore in form Y. When I open it without acDialog they do work. How can I
solve this problem or is there another way to let the code wait for form Y
> From a button in form X, I open form Y in acDialog mode. Reason for
> this is that I want the code in the button to wait till form Y has
> been closed. I find that the...Initialize Second Dialog
I have a dialog application that I've created, and I can initialize a combo
box on this dialog box before it is shown. I also have a menu in this
dialog. A selection from this menu opens another dialog box...
However, when I try to initialize a combo box in the otherDiag through the
constructor, it doesn't work. I can add a button in otherDiag and once the
user clicks it, it will populate the combo box, but the constructor doesn't
do it. Any ideas?
"Saul775" <Saul775@discussions.microsof...multiple pages when opening
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
When I click to open on the Entourage logo to open Entourage, Entourage opens about a dozen pages instead of only the opening page. <br><br>Why does this multiple page opening occur, and what can I do to open Entourage only with one page.?
On 3/13/10 11:14 AM, Norman_Zalfa@officeformac.com wrote:
> When I click to open on the Entourage logo to open Entourage, Entourage
> opens about a dozen pages instead of only the opening page.
> Why does this multiple page opening occur, and ...any special trick to opening up corrupt XLS files
I have Excel 2007 SP2 on XP SP3 and I get clients that have corrupt xls files
quite a bit. I tried the open "fix and repair" function and opening up xls
in safe mode but I am not able to open the file.
Is there a trick I am missing? OH and I scanned for viruses and nothing.
These are uncomplicated XLS files with no formulas - just data.
Please and thanks
Can anyone shed some light on this? Please and thanks
> I have Excel 2007 SP2 on XP SP3 and I get clients that have corrupt xls files
> quite a bit. I tried the ...open relay #11
I have Exchange 2000 in my local network. I pick up all of incoming emails
from my ISP by POP3 connector. I'm sending emails using DNS from my local
network. Some of my users need to have access from home and don't want to
use OWA (generaly all of them are company management so i can't forbid
them:(). I add an aditional network card to my EX2K and asign an public IP
adres to that card. After that i have configured IMAP protocol to use SSL.
Everything is working just fine. At my home i installed Relay Test PRO and
make some tests. Results was like 20 messages from 47 tests was accep...Posting Journals causing locks (?)
It appears that posting journals to the GL in Great Plains v7.5 is putting
table or record locks on SQL Server that subsequently block other users. It
seems to be an intermttent problem, but we've seen the spid listed in
Enterprise Manager as blocking 4 or more users. The system grinds to a halt
when this occurs.
Also, posting even a simple journal with 2 entries takes an inordinately
long time - 5 min or more. We think perhaps that's the problem, where a
normally brief lock is being held too long.
Posting is slow even if there are no other users on the system.
So I have 2 ...Insert Documents (Word/PDF) and open them
For reporting purposes, I would like to create an Excel file containing
Candidates assessments with their CV's.
For that, I would like to have a Sheet containing all Candidates'
assessments. On the other hand, I would like to insert their CV's into the
Excel workbook (another sheet or one sheet for each CV). These are Word
and/or PDF docs.
What I wold like to have is links between the Assessment sheet and the CV's,
so I can click a button or a link in the Assessment sheet and open the
Is that possible?
I cannot create hyperlinks to ...second axis
How can I use bar graphs for three different products with two axes becuase
of two different sets of info for each product and get the graphs to stop
plotting on top of each other? Please help!!
Jon Peltier has instructions for a column chart on two axes:
carrie in pa wrote:
> How can I use bar graphs for three different products with two axes becuase
> of two different sets of info for each product and get the graphs to stop
> plotting on top of each other? Please help!!
Excel FAQ, Tips &...convert number of seconds to date
I have an integer 1060128571 which is the number of seconds since
1/1/1970. The number evaluates to
So my question is given the start date is always 1970 how do I
calculate the end date e.g 6/08/2003 10:09:30.
if I divide 1060128571/60/60/24 I can get the number of days etc.
If anyone has an easy solutions,please send it on
Message posted from http://www.ExcelForum.com/
1/1/1970 12:00 AM equates to 25569. Divide the number of
seconds by 86400 (number of seconds in a day). Subtract
that from 25569 and format the cell as
m/d/yyyy h:mm:ss AM/PM.
Ba...opening readable format for excel
I recently purchased a used Toshiba with Vista. The system works fine other
than when downloading or opening an excel file either via e-mail or off a web
page. Word will down load just fine. I use excel a lot and it works fine from
scratch when I build a spread sheet. Any help in this matter would be greatly
On 23 Mar 2010, =?Utf-8?B?SmltIEg=?= <Jim
H@discussions.microsoft.com> wrote in
> I recently purchased a used Toshiba with Vista. The system works
> fine other than when downloading or opening an excel...opening a Works 3.0 database spreadsheet saved on disk into excel 97
How can I convert or open a Works 3.0 database spreadsheet (from an older computer which is saved on a floppy disk) and save it into Excel 97 on a different computer?
...How do I add a second y-axis in an xy(Scatter) chart?
I would like to create a xy-scatter chart for a dataset with two different
I have one set of data, but I need to plot it against two axis,
"concentration" and "dilution factor". The dilution (and therefore the
concentration) is not linear, so a line chart will display the data
"distorted" or "skewed".
I tried the tip from bj (9/9/2005 4:44 AM PST, to the question "Line chart
or scatter chart??")
> there can be two x axis in a scatter chart.
> first select one of the data series and <axis> select secondary
> next i...css templates
I am using Frontpage 2002 and working with a css template. I need help on
how to remove the backround off all webpages except the index page.
"lgg" <email@example.com> wrote in message
> I am using Frontpage 2002 and working with a css template. I need help on
> how to remove the backround off all webpages except the index page.
> Thank you!
Can we see the template? Is it a free one or a bought one? If yours is not
online can we see the orginal?
There ar...Cant get my mail to open the right pst file
My outlook finds but will not accept the location of my pst folders.
No matter what I do
View or change existing email accounts
New Outlook Data File
Office Outlook Personal Folders File (.pst)
I cannot change the default path from the usual C:\Documents and
Settings\local user local settings\ application data etc.
My mail and all my documents are on a separate hard drive so I can access
them when my computer is in the shop.
What are the registry edit settings (I know what my path is) but don't know
which key to edit.
I have already tried fix and rep...bell curve charts
I'd like to know how to make a bell curve chart, which when given a single
monetry amount and a time line, can disperse the amount over the specified
time line in a bell curve.
Any help would be much appreciated. :)
A wrote on Tue, 1 Sep 2009 19:15:01 -0700:
> I'd like to know how to make a bell curve chart, which when
> given a single monetry amount and a time line, can disperse
> the amount over the specified time line in a bell curve.
I don't think you are providing sufficient information or perhaps you
should try again to say what you want. A nor...converting Minutes & Seconds into seconds
When my time is 10 minutes and 50 seconds how can I convert the time into
Depends upon how the 10 mins 50 secs is entered.
I have 00:10:50 in A1
In B1 enter =A1*86400
I have 10:50:00 in A1
In B1 I enter =A1*1440
Format as General.........returns 650
Gord Dibben MS Excel MVP
On Fri, 11 Dec 2009 10:46:01 -0800, Joe <Joe@discussions.microsoft.com>
>When my time is 10 minutes and 50 seconds how can I convert the time into
...How can I display hundreths of seconds?
I'm trying to design a speadsheet to display lap times such as 1:26:329 (1
min, 26 secs etc) however I cannot sort the data in order from highest to
lowest. I've been inputing the data as 1.26239. This s OK to sort frm
Highest to Lowest but when you graph it there is a massiv gap beween 1.59960
(1.59.960) and 2.00765 (2.00.765) and there shouldn't be. I need Excel to
recognize hundreths of seconds
The way you're entering the data, you don't have seconds or fractions of
seconds at all. You have minutes and (decimal) fractions of minutes.
1.59960, ...attachment help
1) How do I unblock attchments in outlook 2003? I think
its aregistry setting somewhere. I would like to add a
few file formats to the list of safe files.
2) I have a lot of folders and subfolders where I
organise my email in outlook. I would like to stop
outlook opening these folders every time I have a new
message in them? Any ideas would help.
Stop posting the same message around all the newsgroups over and over again.
This is not a chat!
Also posting to all the newsgroups one by one is not a nice thing to do.
Simply address you posting to more then one news...Button Caption help
Hi to all I require help for what maybe a simple problem. I have a form
frmPettyCash and on the form are 3 buttons Cmd1, Cmd2 and Cmd3 which open the
spending reports for 3 employees. There is a table tblEmployees with fields
EmployeeID and EmployeeName with the 3 employee names. What I would like to
do is link the EmployeeNames to the button caption ie Employee 1 to
Cmd1.Caption, Employee2 to Cmd2.Caption etc. so that in the future if I
change an employee name in the employee table the caption on the
corresponding button will change also. Any help greatly appreciated.
Than...Mails opening behind main window
I have Office 2003. I use Outlook to access my GMail account. Whenever I
open an email, new or read, it opens then pops behind the main Outlook
screen in a split second. Any ideas why? Do I need to re-install Office?
Or am I just missing a setting?
I don't use O2003 but many people mention this problem. Search for
existing answers, if any.
Neil Barras <firstname.lastname@example.org> wrote:
> I have Office 2003. I use Outlook to access my GMail account. Whenever I
> open an email, new or read, it opens then pops behind the
> main Outlook screen...