If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
No fields listed on my form in form view
I have my database set up. I have four tables in it. I
created a form using the fields from the four tables. The fields appear in the design view of the form but when I go to the view form there are no fields listed just a blank form. Now if I use just one table with the fields from it to design form and view the form the fields are there. What am I doing wrong? |
#2
|
|||
|
|||
The detail section of your form goes completely blank if both:
a) there are no records to display, and b) no new records can be added. Examples of causes of a): - Your form's DataEntry property is Yes. - The RecordSource of the form is a table or query that has no records. - You opened the form with a WhereCondition or applied a filter that has no matches. - You are filtering on a calculated field, unbound control, or undeclared parameter, and Access misunderstands the data type. Details: http://members.iinet.net.au/~allenbrowne/ser-45.html Example of causes of b): - Your form's AllowAdditions property is Yes. - The form is based on a read-only query, or a query where you can't add new records either. - The database is opened read-only, or is from a read-only drive/network share. - Access security permissions do not allow adding new records. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Nick" wrote in message ... I have my database set up. I have four tables in it. I created a form using the fields from the four tables. The fields appear in the design view of the form but when I go to the view form there are no fields listed just a blank form. Now if I use just one table with the fields from it to design form and view the form the fields are there. What am I doing wrong? |
#3
|
|||
|
|||
The detail section of your form goes completely blank if both:
a) there are no records to display, and b) no new records can be added. Examples of causes of a): - Your form's DataEntry property is Yes. - The RecordSource of the form is a table or query that has no records. - You opened the form with a WhereCondition or applied a filter that has no matches. - You are filtering on a calculated field, unbound control, or undeclared parameter, and Access misunderstands the data type. Details: http://members.iinet.net.au/~allenbrowne/ser-45.html Example of causes of b): - Your form's AllowAdditions property is Yes. - The form is based on a read-only query, or a query where you can't add new records either. - The database is opened read-only, or is from a read-only drive/network share. - Access security permissions do not allow adding new records. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Nick" wrote in message ... I have my database set up. I have four tables in it. I created a form using the fields from the four tables. The fields appear in the design view of the form but when I go to the view form there are no fields listed just a blank form. Now if I use just one table with the fields from it to design form and view the form the fields are there. What am I doing wrong? |
#4
|
|||
|
|||
Thanks for the help Allen I now have by fields listed on
my form. But I don't seem to be able to enter any data into the form fields. I am using a query in my record source for my form. How do I set things up to enter data? -----Original Message----- The detail section of your form goes completely blank if both: a) there are no records to display, and b) no new records can be added. Examples of causes of a): - Your form's DataEntry property is Yes. - The RecordSource of the form is a table or query that has no records. - You opened the form with a WhereCondition or applied a filter that has no matches. - You are filtering on a calculated field, unbound control, or undeclared parameter, and Access misunderstands the data type. Details: http://members.iinet.net.au/~allenbrowne/ser- 45.html Example of causes of b): - Your form's AllowAdditions property is Yes. - The form is based on a read-only query, or a query where you can't add new records either. - The database is opened read-only, or is from a read- only drive/network share. - Access security permissions do not allow adding new records. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Nick" wrote in message ... I have my database set up. I have four tables in it. I created a form using the fields from the four tables. The fields appear in the design view of the form but when I go to the view form there are no fields listed just a blank form. Now if I use just one table with the fields from it to design form and view the form the fields are there. What am I doing wrong? . |
#5
|
|||
|
|||
Can you enter data into the query? If not, you won't be able to enter it in
the form either, so work on the query. To start with, only include the fields from one table in your query. Use subforms to enter related records into further tables. Use combo boxes to get/display the values from lookup tables. (Once you become familiar with that approach, you can sometimes get away with using multiple tables in the source query.) Also, don't perform any aggregation in the query. For example, it will be read-only if it: - is a Totals query (has GROUP BY clause), - is a crosstab query (TRANSFORM clause), - asks for Unique Value (DISTINCT predicate). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Nick" wrote in message ... Thanks for the help Allen I now have by fields listed on my form. But I don't seem to be able to enter any data into the form fields. I am using a query in my record source for my form. How do I set things up to enter data? -----Original Message----- The detail section of your form goes completely blank if both: a) there are no records to display, and b) no new records can be added. Examples of causes of a): - Your form's DataEntry property is Yes. - The RecordSource of the form is a table or query that has no records. - You opened the form with a WhereCondition or applied a filter that has no matches. - You are filtering on a calculated field, unbound control, or undeclared parameter, and Access misunderstands the data type. Details: http://members.iinet.net.au/~allenbrowne/ser-45.html Example of causes of b): - Your form's AllowAdditions property is Yes. - The form is based on a read-only query, or a query where you can't add new records either. - The database is opened read-only, or is from a read- only drive/network share. - Access security permissions do not allow adding new records. "Nick" wrote in message ... I have my database set up. I have four tables in it. I created a form using the fields from the four tables. The fields appear in the design view of the form but when I go to the view form there are no fields listed just a blank form. Now if I use just one table with the fields from it to design form and view the form the fields are there. What am I doing wrong? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form set to open in Datasheet view but does not | PE | General Discussion | 2 | September 14th, 2004 05:09 PM |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |
Form does not display fields in detail area | Bob F | Using Forms | 1 | June 16th, 2004 12:19 AM |
how to start a form in datasheet view from the switchboard | William Wenjie Wang | New Users | 3 | June 1st, 2004 04:30 AM |