Ms Access Error 3315
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Run-time error '3315': Field ...can not be a zero-lenght string Want to Advertise Here? Solved Run-time error '3315': Field ...can not be a zero-lenght string Posted on 2003-04-14 MS Access 1 Verified Solution 11 Comments 2,867 Views Last Modified: 2008-01-16 I am getting this error (Run-time error '3315': Filed ...can not be a zero-lenght string) when I execute a sub procedure in Access 2000. My code sets a recordset to a SQL string which pulls a single record in my clients table. It then attempts to edit that record using a value in a textbox on my form. I am getting the error EVEN THOUGH MY CODE CHECKS FOR AN EMPTY CONTROL. The 'Description' field (below example) that which this edit is updating does not have the required property set to YES. Nor is the control on the form have any restrictions of the like. It actually used to work fine...now it doesn't...weird. Here is the sample of code is giving me trouble: ..... Client = Me.Client_listClient strSQL = "SELECT Clients.ClientID, Clients.Date, Clients.Company, Clients.Description," strSQL = strSQL & " Clients.StreetAddress, Clients.City, Clients.State, Clients.Zip, Clients.Contact," strSQL = strSQL & " Clients.OfficePhone, Clients.Ext, Clients.MblPhone, Clients.OfficeFax, Clients.OfficeEmail," strSQL = strSQL & " Clients.RevDate, Clients.Ini, Clients.Notes" strSQL = strSQL & " FROM Clients" strSQL = strSQL & " WHERE (((Clients.ClientID)=" & Client & "));" Set rs = db.OpenRecordset(strSQL) rs.Edit If Not IsNull(Me.Client_ctlDescription) Then 'Not required rs.Fields!Description = Me.Client_ctlDescription Else rs.Fields!Description = Null End If .....(more of the same above for differ
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below https://www.experts-exchange.com/questions/20585173/Run-time-error-'3315'-Field-can-not-be-a-zero-lenght-string.html into your site. Microsoft: Access Other topics Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Other topics Forum Run-time error '3315' thread181-119722 Forum Search FAQs Links MVPs Run-time error '3315' Run-time error '3315' thirty4d (MIS) (OP) 13 Aug 01 11:04 Hello!I have a form where I have to extract different values to create an assembly.I have extracted 3 records so far and everything seemed to be working fine. I have followed the same steps http://www.tek-tips.com/viewthread.cfm?qid=119722 through out. When I came to the 4th record something went hay wire because I keep getting this error: Run-time error '3315'Field 'Form.Fieldname' can't be a zero-length string.Thanks if you can help me RE: Run-time error '3315' Databaseguy (MIS) 13 Aug 01 11:18 You'll have to add error handling to check for a null value. Use the vbNull constant to check for it. If you find it, out something, anything, into the 'Form.Fieldname' so you don't get the error. RE: Run-time error '3315' thirty4d (MIS) (OP) 13 Aug 01 11:46 Databaseguy,Thank You! fixed the error Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Click Here to join Tek-Tips and talk with other members! Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Registration on or use of this site constitutes acceptance of our Privacy Policy. Close Box Join Tek-Tips Today! Join your peers on
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine https://msdn.microsoft.com/en-us/library/bb178230(v=office.12).aspx Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. MSDN Library MSDN Library MSDN Library MSDN Library Design Tools Development Tools and Languages Mobile and Embedded Development .NET Development Office development Online Services Open ms access Specifications patterns & practices Servers and Enterprise Development Speech Technologies Web Development Windows Desktop App Development TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. Field