Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-05-2012, 02:41 PM   #16
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,817 Times in 1,575 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: runtime error 2105

Clients is a table or a query? Which one?

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-05-2012, 02:44 PM   #17
gizmogeek
Newly Registered User
 
Join Date: Oct 2007
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
gizmogeek is on a distinguished road
Re: runtime error 2105

It's a table.
gizmogeek is offline   Reply With Quote
Old 11-05-2012, 02:47 PM   #18
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,817 Times in 1,575 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: runtime error 2105

Quote:
Originally Posted by gizmogeek View Post
It's a table.
So the only thing I can think of is that the Attachments field is causing you the problem. What happens if you take that out of your record source? Does the form update/add records then?

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-05-2012, 02:52 PM   #19
gizmogeek
Newly Registered User
 
Join Date: Oct 2007
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
gizmogeek is on a distinguished road
Re: runtime error 2105

Do I take out just the word Attachments or the whole select statement?
gizmogeek is offline   Reply With Quote
Old 11-05-2012, 02:54 PM   #20
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,817 Times in 1,575 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: runtime error 2105

Quote:
Originally Posted by gizmogeek View Post
Do I take out just the word Attachments or the whole select statement?
Change to this:

SELECT Clients.* FROM Clients;
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-05-2012, 03:05 PM   #21
gizmogeek
Newly Registered User
 
Join Date: Oct 2007
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
gizmogeek is on a distinguished road
Re: runtime error 2105

Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.
gizmogeek is offline   Reply With Quote
Old 11-05-2012, 03:06 PM   #22
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,817 Times in 1,575 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: runtime error 2105

Quote:
Originally Posted by gizmogeek View Post
Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.
Yep, and that is because you have more than one attachment for some records. The * will include the attachment field properly so that you can add/delete, etc. from that field. The only time you want to use Attachment.FileName is when you have a query for a Report or some other query which you do not need to have it be updateable.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-05-2012, 03:15 PM   #23
gizmogeek
Newly Registered User
 
Join Date: Oct 2007
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
gizmogeek is on a distinguished road
Re: runtime error 2105

Thanks so much Bob!! Now I can get back to my regular project.

gizmogeek is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 2105 -1, , New doddy88 Forms 4 08-14-2012 07:03 PM
Runtime 2105 on subform olly Forms 4 09-09-2007 10:40 AM
Why I get Error 2105? Chipcom General 1 08-04-2007 04:05 AM
RunTime Error 2105 Chipcom General 1 06-15-2007 05:35 AM
error no 2105 TurboDieselOne Forms 0 06-24-2004 10:25 AM




All times are GMT -8. The time now is 05:59 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World