Access Forms-cannot enter data

jalmar

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.

maxamis4

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.

jalmar

Quote:

Originally Posted by maxamis4

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?

maxamis4

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?

jalmar

Quote:

Originally Posted by maxamis4

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?

jalmar

Quote:

Originally Posted by jalmar

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.

maxamis4

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.

jalmar

Quote:

Originally Posted by maxamis4

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.

AccessIdiot

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)

msquared

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

maxamis4

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.

jalmar

Thank you all so much, I will take a look at that and let you know. This stuff is great.

NeoPa

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).

jalmar

Quote:

Originally Posted by NeoPa

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

NeoPa

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?

jalmar

Quote:

Originally Posted by NeoPa

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.

jalmar

Quote:

Originally Posted by jalmar

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?

NeoPa

Quote:

Originally Posted by jalmar

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

jalmar

Quote:

Originally Posted by NeoPa

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?

NeoPa

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.

Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

re: Access Forms-cannot enter data

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about