Why does it say no valid fields?

K

Kd05

When I create a combo box and when I get to the part of selecting a table, I
select it and click next, btu then it tells me that 'No valids fields can be
found on Table'

I've checked this problem in the ms office help and tried the solution but
still doesnt work.. I was wondering if anyone has another solution..

Thanks..
 
J

John Vinson

When I create a combo box and when I get to the part of selecting a table, I
select it and click next, btu then it tells me that 'No valids fields can be
found on Table'

I've checked this problem in the ms office help and tried the solution but
still doesnt work.. I was wondering if anyone has another solution..

Thanks..
Click to expand...

What fields exist in the table you're selecting, and what are their
datatypes? If you open that table in datasheet view, what do you see?


John W. Vinson[MVP]
 
K

Kd05

John Vinson said:
What fields exist in the table you're selecting, and what are their
datatypes? If you open that table in datasheet view, what do you see?


John W. Vinson[MVP]
Click to expand...

Hmm.. I've got lots of tables.. and all of them don't work one of them has
MovieID, MovieTitle, SeatsRemaining. All field types are text except for the
last one ie number.

When I open the table, i see the data dictionary, same as like any table
should look like in datasheet view.

I think its just my access. And also, when I create a form and it won't show
the entities of table.

How did I have a form in the first place to put a combo box in? I've done
this project at my school's computer.. so yeah.. just in case you're
wondering. =D
the table I want to put.
 
J

John Vinson

On Thu, 9 Jun 2005 04:40:04 -0700, "Kd05"

I'm sorry, KdO5. I really have no idea what you're talking about.
Hmm.. I've got lots of tables.. and all of them don't work one of them has
MovieID, MovieTitle, SeatsRemaining. All field types are text except for the
last one ie number.
Click to expand...

"all of them don't work one of them has".... do you mean that none of
your tables "work"? Specifically what do you mean by "not work"? What
actions are you taking?
When I open the table, i see the data dictionary, same as like any table
should look like in datasheet view.

I think its just my access. And also, when I create a form and it won't show
the entities of table.

How did I have a form in the first place to put a combo box in? I've done
this project at my school's computer.. so yeah.. just in case you're
wondering. =D
the table I want to put.
Click to expand...

I would suggest starting by opening the Table in design view, and
clicking the "Auto Form" button. Let Access create a default form for
you, and then you can modify it.

Alternatively, you can create a new Form using the Forms Wizard. It
should ask you what table you want.

Finally, you can create a new form without specifying a table, and
manually set its Recordsource property (on the Form's Properties
window, on the Data tab) to the name of the desired table.

John W. Vinson[MVP]
 
Top