469,266 Members | 1,880 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,266 developers. It's quick & easy.

Access Forms-cannot enter data

21
My question is related to Access forms. I have set up an Access form using 4 different tables~I am pulling 2 different numbers and the name of Trusts out of one table, I am pulling custodian name and acct number from 2nd table, 2 different numbers from Investment manager table and then 3 empty fields (at this time-needs to be populated by form) out of the 4th table. Can you tell me why I am not able to enter data into the 3 empty fields while in form view. All the tables I am using for the forms are updatable. Hope this is clear. Thanks in advance for your help.
Feb 22 '07 #1
19 24793
maxamis4
295 Expert 100+
Its the query your form is based on. For some reason it locks the record due to the criteria that you have setup. If you have relationships that are dependent on one another this could account for it.

Play with the query you are using to bind your form. Try two then add the third, then try a combination of the three to figure out where the problem is.
Feb 22 '07 #2
jalmar
21
Its the query your form is based on. For some reason it locks the record due to the criteria that you have setup. If you have relationships that are dependent on one another this could account for it.

Play with the query you are using to bind your form. Try two then add the third, then try a combination of the three to figure out where the problem is.


I am using tables to set up the form-no queries-there are queries ran off the tables in the database but I am not utilizing them for the form-will that still make a difference?
Feb 22 '07 #3
maxamis4
295 Expert 100+
but i take you are using the control source to select multiple locations right? if so that is also a query, if not how are you binding the tables to the forms?
Feb 22 '07 #4
jalmar
21
but i take you are using the control source to select multiple locations right? if so that is also a query, if not how are you binding the tables to the forms?

I use the wizard and choose the tables in the beginning. So that is then a query?
Feb 22 '07 #5
jalmar
21
I use the wizard and choose the tables in the beginning. So that is then a query?
OK-I will go back and try as you say to break it down and find which table is causing the lock. I will get back with you-thanks for your time.
Feb 22 '07 #6
maxamis4
295 Expert 100+
It sounds like it did one. Look at the form and click on the button with the three little dots and see what the control source is.
Feb 22 '07 #7
jalmar
21
It sounds like it did one. Look at the form and click on the button with the three little dots and see what the control source is.
I don't see three buttons to click on, on the actual form. I did go back and check and 2 of the tables aren't allowing to input, two of them are. I need to go back and check the 2 tables that aren't allowing, there are some changes I need to make to those. They were imported directly from Access and I just let Access set them up.
Feb 22 '07 #8
AccessIdiot
493 256MB
I think maxamis4 means that when you have the form open click on Design to look at it in Design view. Then on the last tab labeled "Data" the top one is the Record Source. That is the query that pulls the fields from the tables that you want on your form. Something in there might be causing the problem?

I am having the same problem with a form of mine and am trying to figure out why I can't type into a textbox.

Cheers,
melissa (the Access Idiot)
Feb 23 '07 #9
MMcCarthy
14,534 Expert Mod 8TB
Hi Jalmar

You cannot base a form on a non-updatable query. A query is non updatable for a number of reasons but in your case I can make a guess at the cause.

You have based the form on 4 tables but this will only work if there is a one to one relationship between all those tables. That is there is one and only one record in each table corresponding to the record in another table.

For any tables that can hold many records relating to one record in another table you will have to set up a subform. Test out your form query separately in the quey window and you will see you can't add to it there either. This has nothing to do with the forms operation.

Mary
Feb 23 '07 #10
maxamis4
295 Expert 100+
You got it right, thats what I meant, and the explaintion that the other guy just gave is perfect.

Let me know how the trouble shooting goes.
Feb 23 '07 #11
jalmar
21
Thank you all so much, I will take a look at that and let you know. This stuff is great.
Feb 23 '07 #12
NeoPa
32,171 Expert Mod 16PB
You haven't actually said this anywhere, but would I be right to think that this form you are talking about actually manages the four different tables using multiple sub-forms based on the main form?
Let us know what the Record Sources are of your form(s).
Feb 26 '07 #13
jalmar
21
You haven't actually said this anywhere, but would I be right to think that this form you are talking about actually manages the four different tables using multiple sub-forms based on the main form?
Let us know what the Record Sources are of your form(s).
OK-I actually kept working with the information you guys have given and I have finally figured it out. I created a query and used one table and now have my subform working correctly to enter the data. Thanks for your help on this.

I still haven't figured out the problem with my Excel spreadsheet though. I linked the spreadsheet to Access, had it pulling the data in and updating correctly but when I run the query I get far too many duplicated records. Even when I import the data into Access and run the queries there are too many duplicated records. I believe Juan is working on this with me but haven't heard back from him today. Any help would be appreciated
Feb 26 '07 #14
NeoPa
32,171 Expert Mod 16PB
Let's have a look at the SQL you're using then. Perhaps we can see where you're making any mistake.
BTW Who's Juan?
Feb 26 '07 #15
jalmar
21
Let's have a look at the SQL you're using then. Perhaps we can see where you're making any mistake.
BTW Who's Juan?

Juan is the person who was helping me before-he started the answers on this forum.
Feb 26 '07 #16
jalmar
21
Juan is the person who was helping me before-he started the answers on this forum.

How do you want to view my SQL? Should I copy and post it on here?
Feb 26 '07 #17
NeoPa
32,171 Expert Mod 16PB
How do you want to view my SQL? Should I copy and post it on here?
That sounds good - yes.
I suppose Maxamis4 must be Juan then right?
He's doing a good job :)
Feb 26 '07 #18
jalmar
21
That sounds good - yes.
I suppose Maxamis4 must be Juan then right?
He's doing a good job :)
It's not working that way.......

Yes, Juan is Maximas and he is doing a great job.

Is there an email address I can send this sample doc to you so you can take a look at it....I'd really like to find out why the queries aren't working correctly. Are there normally problems with linking data from Excel to Access and then running queries?
Feb 27 '07 #19
NeoPa
32,171 Expert Mod 16PB
I'm not happy to work via e-mail. Sorry.
We can help you post the SQL on here though if you tell me what problems you're having when you try to do that.
Feb 27 '07 #20

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by mamatha | last post: by
2 posts views Thread by Kim Skytte | last post: by
reply views Thread by rodchar | last post: by
2 posts views Thread by =?Utf-8?B?UGV0ZQ==?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.