Forms With no Fields

[bradleyhorn]

Hello All,

I have several Tables I just brought into SQL-Server from Access. When I open up the Access forms that report to the new tables, they have labels/headers but no active form fields. What are the possible issues here? Is it something about the database? Or the Form?

Bradley

 

[GingerR]

is your Access db linking to the SQL server tables properly? what is the recordsource of the form? when you open the recordsource directly, does it appear ok? or are they all unbound controls?

 

[bradleyhorn]

Ginger,

The recordsource of the form is a query. When I run the query there is no data as it is an empty table. There is no white space under the query fields when it is run. I am not sure if there is a problem with the query or if it is just because there is no data in the table.

The fields are all bound to the results of the query.

Bradley

 

[PHV]

What is the value of the AllowAdditions property of the form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GingerR]

then your answer is that there is either no data in the table or the query is written incorrectly. Check the table and see if there is data. If there is, and you can manually see that there should be records returned from the query but there are not, paste you query here so we can see what the trouble is.

 

[bradleyhorn]

I think I will just rebuild the forms on the new SQL-Server tables. Deadlines have me by the nose/neck. I know I can re-build what was lost in the coversion in half a day. So sad.

Thanks for your help,
Bradley