Search results for query: *

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...

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

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...

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...

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...

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...

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.

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...