473,325 Members | 2,828 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,325 software developers and data experts.

Urgent - non-editable fields in form

Hi,

I created two forms using forms wizard. One was for a master table
that has just an ID and Description column. Another was for a
transaction table that has foreign keys from the master table and its
own description fields.

In the master form, I can create and edit records succesfully.
In the second one, when I create a new record, the form doesn't let me
edit the description fields. I can edit the foreign key fields. I have
to first save the half-baked record with only the foreign key fields
in it and then come back and edit the description fields.

Any pointers as to what could be the problem? Both the forms have the
properties set same. I have Allow additions = Yes and DataEntry =No.
For the controls, I have enabled = Yes and Locked=No.

I am a newbie with forms and i don't know VB. Any pointers would be
helpful.

Thanks,
YS
Nov 12 '05 #1
3 2244
Do you have two separate forms? If so, drag the second form (transaction
table) from the
database window onto the primary form (opened in design view) for the master
table - thus creating a subform. Access should recognize the
primary/foreign key relationship and set up the appropriate relationship
between the forms and their respective tables.

HTH

"Young Seeker" <cu*******************@yahoo.com> wrote in message
news:84**************************@posting.google.c om...
Hi,

I created two forms using forms wizard. One was for a master table
that has just an ID and Description column. Another was for a
transaction table that has foreign keys from the master table and its
own description fields.

In the master form, I can create and edit records succesfully.
In the second one, when I create a new record, the form doesn't let me
edit the description fields. I can edit the foreign key fields. I have
to first save the half-baked record with only the foreign key fields
in it and then come back and edit the description fields.

Any pointers as to what could be the problem? Both the forms have the
properties set same. I have Allow additions = Yes and DataEntry =No.
For the controls, I have enabled = Yes and Locked=No.

I am a newbie with forms and i don't know VB. Any pointers would be
helpful.

Thanks,
YS

Nov 12 '05 #2
Hi,

Thanks for the reply.

But I don't think that's what I am looking for.

I have a the following tables:
Contact(ContactID, FirstName, LastName)
TaskList(Date, ContactID, Description)

I want to make a data entry form for TaskList. For this I went to the
wizard and pulled Contact.FirstName, Contact.LastName and
TaskList.Date, TaskList.Description. I have no problem with the
foreign key. But my form doesn't allow me to edit the Description
field, which is not a foreign field. I checked the properties and the
field is enabled and it is bound to the right field in the table.

Regards,
Young Seeker

"Squirrel" <wi*****@covad.net> wrote in message news:<18**************************@msgid.meganewss ervers.com>...
Do you have two separate forms? If so, drag the second form (transaction
table) from the
database window onto the primary form (opened in design view) for the master
table - thus creating a subform. Access should recognize the
primary/foreign key relationship and set up the appropriate relationship
between the forms and their respective tables.

HTH

"Young Seeker" <cu*******************@yahoo.com> wrote in message
news:84**************************@posting.google.c om...
Hi,

I created two forms using forms wizard. One was for a master table
that has just an ID and Description column. Another was for a
transaction table that has foreign keys from the master table and its
own description fields.

In the master form, I can create and edit records succesfully.
In the second one, when I create a new record, the form doesn't let me
edit the description fields. I can edit the foreign key fields. I have
to first save the half-baked record with only the foreign key fields
in it and then come back and edit the description fields.

Any pointers as to what could be the problem? Both the forms have the
properties set same. I have Allow additions = Yes and DataEntry =No.
For the controls, I have enabled = Yes and Locked=No.

I am a newbie with forms and i don't know VB. Any pointers would be
helpful.

Thanks,
YS

Nov 12 '05 #3
YS,
did you create the relationship between the two tables before trying
to add records? TaskList.ContactID should be a long integer. If you
do that, the data entry should work fine.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Anurag Saxena | last post by:
If someone can solve this problem,I am using ASP3.0 and IIS on windows 2000 server The complete Error is '''''''''''''''''''''''''''''''''' Server object error 'ASP 0177 : 800401f3' ...
2
by: js | last post by:
Hi all, I currently encounter a problem and it is urgent to me. After calling the MsgBox.Show(), the message box is shown with non-modal mode, what is the possible reason??? This only happen...
0
by: Michael Dyson | last post by:
M. Michael DYSON DIRECTEUR-ADJOINT SOCIÉTÉ DE SÉCURITÉ SARL. TEL.00229 20 21 80 Cotonou République du Bénin Email:michaeldyson2005@latinmail.com Bonjour . Je sais que mon message sera d’une...
4
by: Vittorio Pavesi | last post by:
Hello, I'm using CDO in my VB Application. Does anybody know how to set the Mail priority (Urgent, Medium, Low) ?? Thanks Vittorio...
7
by: zeyais | last post by:
Here is my HTML: <style> ..leftcolumn{float:left;width:300px;border: 1px solid #ccc} ..rtcolumn{float:left;width:600px;border: 1px solid #ccc} </style> <body> <div class="leftcolumn"...
3
by: N. Spiker | last post by:
I am attempting to receive a single TCP packet with some text ending with carriage return and line feed characters. When the text is send and the packet has the urgent flag set, the text read from...
4
by: Adrian Parker | last post by:
We've suddenly started getting a problem with a call to clear the contents of a DataTable. This is on a live customer site that's been working fine until yesterday. As far as we know they've not...
5
by: igotyourdotnet | last post by:
I'm creating a web service this is going to return an arraylist of items. When I try and run it Im' getting the following error message: System.InvalidOperationException: There was an error...
77
by: Hans Schneider | last post by:
1. in the prg bellow what vars are stored on stack, heap, data segment? int i; void main() { int j; int *k = (void *)malloc(1); }
1
by: kurrachaitanya | last post by:
Lecture Saying that: I am generally expecting most of you to work n java.If you prefer to use c/c++ version of the programs,you may,but the assistance in the lab sessions will be very much geared...
0
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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.