Automation Word 97 & Word 2000
I have been using the following code to open up and exiting file that
has been working OK when the user has Word 2000 on his computer. One
user is using Word 97 and although the code starts up Word 97 it comes
up with a blank gray screen and does not load the file. Is there a
different way to call Word 97 to open an existing file??
Thanks for any help.
Tony
BINGO = M.C_FILE_NUM+'.DOC' ** Name of file to open is in this
field
CD REPORTS
GOODAPP = .T.
ON ERROR GOODAPP = .F.
oWORD = GetObject("&BINGO")
IF GOODAPP = .T.
WITH oWORD
.WindowState = 1
.APPLICATION.VISIBLE = .T.
ENDWITH
ELSE
WAIT 'COULD NOT OPEN YOUR WORD APPLICATION' WINDOW
ENDIF
CD .. Tag: Exception: c0000006 Tag: 182649
Easy Question about variables
Hello, I am returning to Foxpro after a 3 year hiatus(and
even before that I only used it part of the time). Anyway
I have a question that should be really simple to answer,
I just can't figure it out.
How do I declare a variable that will stay in scope
through out the life of a form(ie I want to set it in the
init procedure and check it in other procedures like on a
button click and in the release procedure.
Please help! Using VFP7.0
Thanks
Brian Tag: Exception: c0000006 Tag: 182640
InstallShield Express (2)
I am creating the setup with InstallShield Express.
In "Configure the Target System\Registry" I didn't select
any of HKEY values.
The problem is :
1. when the user is logged-on as administrator the
installation
finished correctly and he can work with application as
administrator, BUT NOT as ordinary user. The Win2000 or
WinNT report a message :
"Cannot locate the Microsoft Visual FoxPro support
library"
2. if the user is logged-on as user, the installation
crashes
with message that setup could not write to registry
Q: what action in ISE have I done that the user run setup
as
administrator and all other folks will work with
application
TIA
Mitja Tag: Exception: c0000006 Tag: 182638
MSCal.ocx problem with XP
Is anyone else out there having problems with the MSCal.ocx control with
VFP6.0 (SP5), if you run a form with this control I get a "OLE exception
error: Exception code c0000005. OLE object may be corrupt..." at the point
where we try and set the year property.
Just in the GUI, right click on this control, calendar properties, get a OLE
error and booted out of VFP. Sounds like it really is corrupt, how do I get
a clean copy installed.
Thanks in advance Grant Tag: Exception: c0000006 Tag: 182629
Import from Excel
I need to import a file from excel (office 2000) to fpw26. Yes I know get
with the program and upgrade. However the user is unable to do so at this
time. The excel file is in a day; time; name format with day being Tuesday,
October 7 and time being 24 hour clock and name being last, first. Append
from type xls results in time as .833 not 20:00
Any suggestions would be appreciated as usual. Thanks! Tag: Exception: c0000006 Tag: 182627
Fatal Error: Exception Code=C0000005
My worry about the compatability VFP7 and NTSC Windows are raised now. My client runs the
application in Chinese Windows XP and in a certain time this Fatal Error dialog box
appears.
This Fatal Error makes me so headache for many years and I don't know why it often
appears in Windows NT or XP. I don't know whether it can be appeared in Chinese version
of Windows.
However, it has no such problem in Windows 95 and Windows 98. Can anyone help me how to
solve it? Tag: Exception: c0000006 Tag: 182625
Text field justification in FRX report
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C38E95.3B7E9A90
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
All,
Is there a way to "justify" a text field? I.e., justified left and =
right margins? The basic properties are left, right and center, but =
nothing for full justification.
Thanks
John.
------=_NextPart_000_0010_01C38E95.3B7E9A90
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>All,</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Is there a way to "justify" a text =
field? =20
I.e., justified left and right margins? The basic properties are =
left,=20
right and center, but nothing for full justification.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Thanks</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>John.</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0010_01C38E95.3B7E9A90-- Tag: Exception: c0000006 Tag: 182622
XP Search tool
Anybody having problems getting accurate searches with XP
when searching for text in *.prg, *.sct files?
Windows 2000 was very accurate - XP is lousy at same
searches of the same network folders. XP SP1 supposedly
fixed a couple of problems in the search tool, but I
already have SP1. Tag: Exception: c0000006 Tag: 182607
Max index key length
Hi,
I'm trying to map the contents of the Windows registry to a table, which
isn't a problem in itself thanks to Rick Strahl and his registry class. The
problem I get is looking up a value in the table, which contains the full
registry key and value, e.g.
HKLM\SYSTEM\CurrentControlSet\Services\Dhcp\ImagePath. If I read the VFP
help correctly, these values can go a long way over the max index key length
of 240 bytes. Is there a good way to optimise a seek here without too much
linear search overhead?
My aim is to map the registry, make a change within Device Manager, then map
again and compare the two tables, so I know what's changed and can switch
states programatically from then on.
Alternately, does anyone know how to enable/disable all the USB ports on a
(remote) computer programatically?
Thanks
---
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 Tag: Exception: c0000006 Tag: 182606
VFP8 and .NET? What is a good resource for bringing myself up to speed?
I've been using foxpro for years, but I'm very unclear on what .NET can do
for me. Does anyone know of good books, websites, or articles that would be
helpful?
Thx,
Dan Tallent Tag: Exception: c0000006 Tag: 182604
GMT offset DateTime calculation
I have an imported VFP table of event start times where
the DateTime field is stored as GMT, including the offset
for Central Daylight Time or Central Standard Time.
What I need to do is to reconvert the DateTime back to
local time, including the offset for daylight savings time.
Any idea of a function that will automate this calculation
so that the return value will be correct for CDT or CST?
Here are a couple examples:
Input (GMT) Output Desired Zone Offset
10/15/2003 12:30 AM 10/14/2003 07:30 PM CDT -5 hr
11/05/2003 02:15 AM 11/04/2003 08:15 PM CST -6 hr
The trick lies in automatically calculating if the date
falls within Central Daylight Time (offset is -5 hours) or
Central Standard Time (offset is -6 hours). Dates will be
calculated on start times in multiple years - through 2006
right now.
Thanks! Tag: Exception: c0000006 Tag: 182601
VFP8 grid problems
I just applied SP1 and have noticed a problem - not sure if it existed
before SP1 however since I saw this immediately , I would assume this
problem is new.
I have a table that contains just under 9 million records , when i BROWSE
this table or bind it to a grid and drag the thumb down it gets to a point
where the thumb disappears. this seems to happen somewhere around the 5
millionth record. moving the invisible thumb back up a little brings it
back. This should not be an issue for production as I can't see ever
wanting to display this amount of data , but in the IDE I can see this being
a major hassle.
The problem of grids using the actual record count rather than the visible
record count ( ie. when a filter is a applied ) to determine the scroll bar
thumb position is still there and still as confusing / annoying / stupid
looking as ever. Tag: Exception: c0000006 Tag: 182599
VFP8 Connection Designer bug
FYI - the connection string field in the connection designer truncates
connection strings longer than 254 characters. I used the builder button
next to the connection string field, went through the DSN creation dialogs,
came back to the connection designer with what looked like a proper
connection string, clicked on the "verify connection" button and got
"connection succeeded".
But every time I tried to use the connection in a remote view, I kept
getting the following error:
==============
Program Error
Connectivity error: [Informix][Informix ODBC Driver][Informix]A syntax error
has occurred.
==============
Took me all morning to determine that my connection string was being
truncated - there are no errors thrown by the connection designer, the "test
connection" succeeds and the connection can even be saved.
Ugh.
--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
"While the complexity of this project is
several orders of magnitude less than
modeling heat flux in a fossil-fuel fired
electric utility plant using the Hottel Zone
technique, the context of each project
evolves in a remarkably similar fashion."
- Author Unknown Tag: Exception: c0000006 Tag: 182598
Report Field Q.
When writing report I have used a single field that I concatenate the
address on so it removes the blank lines and separates the line returns as
semi-colons, example:
c_Name;
c_address;
c_city+c_state+c_zip
My questions is why when seperating the same way with a combination of IIF
statements, why does that give you a syntax error and is there a way to over
come this? Do you use one long IIF and embed the semi-colons in the IIF
statement?
IIF(dr_apduelist.l_pmsign,'PM Signed Off '+DTOC(dr_apduelist.d_pmsign),'');
IIF(dr_apduelist.l_acsign,'AC Signed Off
'+DTOC(dr_apduelist.d_acsign),'ACCOUNTING MUST Sign Off Before Paid')
Jonathan Morningstar
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Exception: c0000006 Tag: 182584
VFP8 and Combo boxes, drop down problem
We are currently using VFP6. One of our users is
experimenting with VFP8. We have a form with a drop down
box with name (60ch), address (30ch), city (25ch), state
(2ch). In VFP6, it runs fine when the user drops down the
combo box, resizes the column to fit on the screen.
In VFP8, it cuts off the first column so only the right-
most characters are displayed. It's running on a Win2k
machine. We tried changing fonts, recreating it, but it
still cuts it off.
Here are URLs to the screen shots:
Good VFP6: http://www.bittar.org/vfoxpro/VFP6CBO.jpg
Bad VFP8: http://www.bittar.org/vfoxpro/VFP8CBO.jpg
Not sure if we want to move to VFP8 yet, not sure what
else might be affected. Thanks for the help. Tag: Exception: c0000006 Tag: 182575
Application written in Vfp6.0sp5 when prints to a net printer hungs the Windows...
Application written in Vfp6.0sp5 when prints to any shared printer hangs the
Windows...(Only RESET to restart!!)
This happens in two different LANs and with different printers.
One LAN Peer-to-Peer with 3PCs under Win98SE and HPprintserver with HP g95
printer.
The other LAN Peer-to-Peer with 3PCs under WinME and HP3325 shared printer
connected locally to one station
No problem when the stations print from the same Vfp Aplication on local
printers!!
No problem when the stations print from other Applications (i.e. Word) on
shared printers!!
Any idea?
TIA
Nick Pofiris,
ErmisPliroforiki
Athens-Greece
www.ermis-pliroforiki.com.gr Tag: Exception: c0000006 Tag: 182574
VFPOLEDB and updateable recordset
I'm not able to create an updateable recordset using the VFPOLEDB provider.
If I use OLEDB for ODBC the recordset is updateable.
What am I doing wrong?
My code is like this:
oConn=CREATEOBJECT("ADODB.Connection")
oConn.ConnectionString = 'Provider=VFPOLEDB.1;Data
Source=M:\rml50\RML.DBC;Mode=ReadWrite;Password="";Collating
Sequence=NORDAN'
oConn.Mode = 3
oConn.Open
oRs = CREATEOBJECT("adodb.recordset")
oRs.CursorType = 3
oRs.LockType = 3
oRs.CursorLocation = 2
oRs.Open("select * from lager.dbf" , oConn ) Tag: Exception: c0000006 Tag: 182570
ıs there any tool for developping and usın VFP6 on Windows Pocket Pc 2000
I am developping programs in VFP 6.00 and I am using
Windows 98, Windows 2000 , Windows XP. Now I want to
develop programs to use on WINDOWS POCKET PC 2000. Is
there any tool pack for this. Or do you have any
suggestions.
I have found that there is tool packs for Vissual Basic
but I couldnt find any news abaout Vissual FoxPro.
Thank you. Tag: Exception: c0000006 Tag: 182566
[Urgent] - VFP7R.DLL is invalid or damaged... and other problem
Sorry for repost this title. Although last time some experts suggested some good way to
solve the problem, I had tried before they suggested.
May I re-posting the problem:
I use InstallShield which is packed with VFP7 to build the distributed application. But
some clients reported that they encountered the error, "VFP7R.DLL is invalid or damaged".
Mostly the problem is existed in Windows 95. I would like to know on which situation this
error will be generated? Besides releasing the client that FoxPro Library files, which
measures I should take to avoid this error again?
I don't know whether the main problem is and it makes me so headache.
Additional infomation: My distributed application has the previous version but is
developed in VFP3. I don't know if the two set of library files (VFP3 and VFP7) are
violated. Some clients can run the application, but every time there is the message box
appeared at start up: "Covert 3.0 database to 6.0 format?". The answer becomes not make
sense. Tag: Exception: c0000006 Tag: 182551
Misc Win dll's etc
Is there a good place to find information regarding misc Win dll's and other
components? (i.e. ABC32.dll contains functions X, Y, Z. Here is how to use
them and the results you will get back.)
I have done some searches but rarely get a full reference. I am not a very
good searcher though.
The main reason I want this, is that I know some things that I do in many
lines of code have already been written and I just don't know where or how
to use them. (i.e. I wrote an entire "Getfile()" function in VB before I
learned there was a common dialog component that I could plug into my app.)
Hope this makes sense.
Thanks,
Scott Tag: Exception: c0000006 Tag: 182537