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!

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

Recent content by Paul_W

  1. Paul_W

    MS Access - Export query to network failing

    Hi, I have suddenly lost the ability to export a query (and other objects) from one database to another in the case where the full network path is specified. (or to browse via desktop folder shortcuts) It works OK on a mapped drive but not where I address by \\server\folder\folder...\file.mdb...
  2. Paul_W

    Access query calculated fields not exporting to excel

    Hi Duane, Yes! I found a bad data row where the table had been modified directly without the error checking in the form. Problem solved. Thank you very much for your help Paul
  3. Paul_W

    Access query calculated fields not exporting to excel

    Thanks for your comments. Yes, it is a bit untidy! The table structure is based on a hierarchy of data (and its history) built up from individuals into households hence the columns - it saves a lot of cross tabbing. The query works fine in Access but it fails when importing to Excel - and this...
  4. Paul_W

    Access query calculated fields not exporting to excel

    Thanks , yes ... the fields I had to remove are NoOfCriteria and Ward2 SELECT tblHouseholds.SFID, tblCurrentData.CaptureDate, tblCurrentData.CaptureType, tblCurrentData.Offending, tblCurrentData.Education, tblCurrentData.ChildHelp, tblCurrentData.OutOfWork, tblCurrentData.DV_DA...
  5. Paul_W

    Access query calculated fields not exporting to excel

    Hi, I have an Excel (2010) spreadsheet which loads an Access (XP) query. Set up using the Excell Data Access button. It has worked fine for 2 years and suddenly won't connect to the database for this particular query. By a process of elimination I have found that it has stopped because of 2...
  6. Paul_W

    No File name nor File Type in dialogue box

    Hi I'm using Office 2007 with Windows 10 When using Save As dialogue, the boxes for FileType and FileName have gone missing in all Office applications so for example I can't open a csv file in excel and do SaveAs xlsx . etc. etc. I have tried repairing Windows 10 and Office 2007. I am...
  7. Paul_W

    Microsoft Access can't complete the output operation

    Thanks for your suggestion. I have actually found that recreating my Windows User Profile solved the problem so I guess it was related to a corrupt profile somehow.
  8. Paul_W

    Microsoft Access can't complete the output operation

    Hi I'm using Acccess XP (2002 SP3) with the rest of Office 2010 in a Windows 7 Professional environment (Corporate policy !) My Access databases have recently started giving the error: "Microsoft Access can't complete the output operation The Visual Basic code you entered contains a syntax...
See more

Part and Inventory Search

Back
Top