Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chriscrowhurst

    Office 2010 apps crashing when VBA is accessing VFP DLLs

    Hi Olaf, Genius! Your thoughts gave me an idea. I have recompiled my DLLs using VFP9 instead of VFP7 and now they are working fine under Office 2010. So the only thing I need to do now is update all our workstations to include the VFP9 runtime when we roll out Office 2010. Thank you for your...
  2. chriscrowhurst

    Office 2010 apps crashing when VBA is accessing VFP DLLs

    I have just tried installing Office 2010 and VFP7 on a clean install of Windows 10, creating a test DLL as in the above post, and calling it from VBA code in Office 2010 and I am getting the same program crash errors. Can someone confirm if they are able to successfully call a VFP DLL via...
  3. chriscrowhurst

    Office 2010 apps crashing when VBA is accessing VFP DLLs

    Hi Olaf, I have just tried another example in Word to trigger the error, so that I could check the event logs as per Dan's suggestion. I have also built a small test DLL that looks like this : Define Class emstest As Custom OlePublic Function TestMessage(tcMessage As String) As Boolean...
  4. chriscrowhurst

    Office 2010 apps crashing when VBA is accessing VFP DLLs

    As a side note these VBA apps where working perfectly fine in Office 2007.
  5. chriscrowhurst

    Office 2010 apps crashing when VBA is accessing VFP DLLs

    This is what is happening at the <----- CRASHES HERE stage, this is all I have to go on at the moment: "When the Office app crashes I get the standard "Microsoft Excel has stopped working" error, then it restarts again, but gives no indication of what has gone wrong." This is happening my dev...
  6. chriscrowhurst

    Office 2010 apps crashing when VBA is accessing VFP DLLs

    Hi, My organisation is upgrading to Office 2010 soon. I am currently testing out some of our customisations made in some VBA apps. Several of these VBA apps both Word and Excel are crashing whenever they are accessing some DLLs written in VFP. The CreateObject call works fine, but as soon as I...
  7. chriscrowhurst

    Help with optimising query

    It creates the table of results I am looking for, but I was wondering if there is a better way to do the last SELECT statement as it contains many sub-queries to get the results.
  8. chriscrowhurst

    Help with optimising query

    I have table which contains the status of tasks over a period of time. Each task can be Not Started, In Progress, Or Complete. Each time the status of task is updated it is added as a new record to the table : e.g. RecordID, TaskID, Status, DateModified 1,1, Not Started, 01/01/2015 2,1, In...
  9. chriscrowhurst

    Linked server : access to the remote server is denied because no login-mapping exists.

    Hi SQLBill, I tried this and it did not work. I am came across this post http://blogs.technet.com/b/mdegre/archive/2011/03/10/access-to-the-remote-server-is-denied-because-no-login-mapping-exists.aspx in my search for a solution. Adding the User ID of the remote user to the provider string...
  10. chriscrowhurst

    Linked server : access to the remote server is denied because no login-mapping exists.

    Thanks for your reply. Crystal2 does not have any permissions on ServerB which is why I am using the option "Connections will: Be made using this security context", to use a different user on the remote server. The remote login details have readonly access to ServerB, and I have tested this...
  11. chriscrowhurst

    Linked server : access to the remote server is denied because no login-mapping exists.

    I am having problem a getting a linked server to work. My problem is when I am running a query using a linked server to another server it is getting the following error for a particular user : access to the remote server is denied because no login-mapping exists. I have a user called...
  12. chriscrowhurst

    Error Loading form or the data environment : File access is denied THISFORM

    Hi Olaf, The Parent field was empty and the Methods field contained all the method code I expected for the form. Regards Chris
  13. chriscrowhurst

    Error Loading form or the data environment : File access is denied THISFORM

    Hi Olaf Thank you for your response. Below is some further information regarding record no 35 : Class = emsstdform Classloc = ..\..\ems\classes\ems.vcx Baseclass = form Objname = frmSiteVisitUpload Properties: DataSession = 2 Height = 42 Width = 397 ShowWindow = 0 DoCreate = .T. BufferMode =...
  14. chriscrowhurst

    Error Loading form or the data environment : File access is denied THISFORM

    Hi, In one of my VFP7 apps the company runs, I am occasionally getting the following error when a form loads : Error loading file - record number 35. frmSiteVisitUpload. Loading form or the data environment : File access is denied THISFORM The form is automatically launched from a timer and I...

Part and Inventory Search

Back
Top