By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Access Forms-cannot enter data

P: 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
Share this Question
Share on Google+
19 Replies


maxamis4
Expert 100+
P: 295
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

P: 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
Expert 100+
P: 295
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

P: 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

P: 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
Expert 100+
P: 295
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

P: 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
100+
P: 493
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
Expert Mod 10K+
P: 14,534
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
Expert 100+
P: 295
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

P: 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
Expert Mod 15k+
P: 31,186
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

P: 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
Expert Mod 15k+
P: 31,186
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

P: 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

P: 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
Expert Mod 15k+
P: 31,186
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

P: 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
Expert Mod 15k+
P: 31,186
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.