473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 25760
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,556 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,556 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,556 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,556 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

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

Similar topics

1
by: mamatha | last post by:
Hi I have Access forms and i want to add our company's logo to that form.How can i add,if any one knows let me know.
2
by: Kim Skytte | last post by:
HI! I have a few questions about access . 1) Does anyone know if it is possible to apply skins to Access forms ?? 2) Is is possible to hide the main access windows, and just show the forms.
0
by: vlpkumar | last post by:
I saw a lot of resources for creating and linking to a PDF document from within Access all over the internet. I would like to know if it is possible to accomplish the inverse task of hyperlinking...
7
by: dtecmeister | last post by:
Looking to see how many people could use this kind of tool. I've got several large databases I've developed in Access with MySQL as the back-end. I've started using Linux instead of windows and...
0
by: rodchar | last post by:
hey all, you know how in ms access forms there's a record navigation buttons at the bottom to cycle thru the records, well does anyone know of any article references,webcasts,etc on doing this on...
7
by: mumbaimacro | last post by:
hi i am using Adobe pdf reader ActiveX in ms-access, I have given in form load() Private Sub Form_Load() Dim FILENAME As String FILENAME = "D:\SAMPLES\Test.pdf" AcroPDF5.LoadFile FILENAME
0
by: annivanova | last post by:
Hi, I saw posts in Dependent listboxes on access forms, which problem is very similar to my. I’m from Bulgaria and working over to create an MS Access application. I used in my project given code...
1
by: krishnasarma | last post by:
hi again i'm new to VB ... can any one tell me .....How to import access forms in Vb6?
2
by: =?Utf-8?B?UGV0ZQ==?= | last post by:
Happy New Year everyone. Quick question: does anyone know a good tool for converting Access forms into VB.Net form? Pete
2
by: sarah2855 | last post by:
How can I disable auto save function in access forms?Currently, If accidentally something is changed in forms, it gets saved automatically without being prompted. Thanks in advance
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.