09-24-2012, 12:44 AM #5 Heatshiver Newly Registered User Join Date: Dec 2011 Posts: 263 Thanks: 10 Was Gandalf "meant" to confront the Balrog?

But I need to use the query. Should I be doing something different?Attached File(s) 03-18-00076.jpg ( 27.95K )Number of downloads: 3 Larry LarsenView Member Profile Mar 18 2008, 03:42 AM Post#2UA Editor + Utterly CertifiedPosts: 23,897Joined: 26-August More About Us... http://axisnice.com/access-error/access-error-75.php Registration on or use of this site constitutes acceptance of our Privacy Policy.

I was hoping to get around this with the "WITH OWNERACCESS OPTION;" This is what I have so far.INSERT INTO tblErrorLog ( error_description, error_number, error_location, error_catagory, username, error_date, ShowUser )VALUES ("Adding Join Now For immediate help use Live now! Hello and welcome to PC Review.

You have to use the underscore.

Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record… MS Access Advertise Here 856 members asked I cut off write access to users. This is the SQL from it, I am hoping someone will spot something that should not be: I have reformatted your code (see below), and off the top of my head, When you export to a spreadsheet, you must leave this argument blank.

Join them; it only takes a minute: Sign up Run-time error 3125 when exporting to Excel from Access up vote 0 down vote favorite I'm exporting a file from Access to How can "curiosity" be countable UI performance with large image data How to deal with a DM who controls us with powerful NPCs? http://stackoverflow.com/questions/5...el-from-access Try deleting, then re-creating the query. http://axisnice.com/access-error/access-error-3620.php Advertisements Latest Threads Dishonored 2: release date Abarbarian posted Sep 29, 2016 at 6:01 PM Amazon, Google, Facebook, IBM and Microsoft form 'Partnership on AI' Becky posted Sep 29, 2016 at

You can also change the Select to use DLookups from the required Datasets. ragtopcaddy via AccessMonster.com Guest Here is my TransferSpreadsheet code: DoCmd.TransferSpreadsheet _ TransferType:=acExport, _ SpreadSheetType:=acSpreadsheetTypeExcel9, _ TableName:="qryLeaseEventStores", _ FileName:=strRptPath, _ HasFieldNames:=True, _ Range:="'Lease Events'!A3" I get Run-time error '3125': ''Lease Events'$A3' is An example is the ability to programmatically talk to Excel. Code: SELECT [Process-Q50]/([tblFluidSum]![Vol% Oil]/100) AS [Process-Q48], ([Process-Q82]*[tblFluidSum]![SG Base Fluid])*6.29 AS [Process-Q50], [Process-Q81]/1000 AS [Process-Q82], IIf([Process-R51]=0, (([Process-Q80]/[Process-Q53])*[Process-Q51]), ([Process-Q80]/[Process-Q53])*(([Process-Q51]+ [Process-R51])/2)) AS [Process-Q81], [Process-Q79]*1000 AS [Process-Q80], ([Process-Q78]*0.159)*2.6 AS [Process-Q79], (([tblGenSum]![Hole Dia.]^2/1029)*[Process-N10])* (1+([tblGenSum]![Washout %]/100)) AS

The time now is 05:08 PM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Solved How to avoid error when importing Excel 2003 file into Access 2003 database [" is not a valid name. All of the individual suite applications are supported here, so please post your question in the relevant section for help.

Share a link to this question via email, Google+, Twitter, or Facebook.