A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"no valid fields can be found"



 
 
Thread Tools Display Modes
  #1  
Old September 18th, 2006, 08:29 PM posted to microsoft.public.access.tablesdbdesign
prima854
external usenet poster
 
Posts: 3
Default "no valid fields can be found"

Kind of a strange problem, I'm trying to use the lookup wizard to create a
list box field on one of my tables and I'd like to base it off of another
table. When I choose the table I'd like to base the list off of, I get the
error "No valid fields can be found... please select a new source. There's
plenty of fields in the table to choose from so I'm not sure what could be
wrong.
Anyone have any suggestions? Thanks.
  #2  
Old September 18th, 2006, 08:35 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 2,251
Default "no valid fields can be found"

My suggestion is to not use lookup fields defined in tables
http://www.mvps.org/access/lookupfields.htm. Use combo boxes on forms.

Do you get similar issues with other tables/fields? Does the chosen lookup
table have a primary key, text fields, ....? Non-valid fields might be memo
or date fields.

--
Duane Hookom
MS Access MVP

"prima854" wrote in message
...
Kind of a strange problem, I'm trying to use the lookup wizard to create
a
list box field on one of my tables and I'd like to base it off of another
table. When I choose the table I'd like to base the list off of, I get
the
error "No valid fields can be found... please select a new source.
There's
plenty of fields in the table to choose from so I'm not sure what could be
wrong.
Anyone have any suggestions? Thanks.



  #3  
Old September 18th, 2006, 09:28 PM posted to microsoft.public.access.tablesdbdesign
prima854
external usenet poster
 
Posts: 3
Default "no valid fields can be found"

Thanks, Normally I would just not worry about it and use other methods of
using lists, but it almost seems like an indication of a larger problem with
my setup or something. When I go to use the forms wizard to create a form,
none of the tables I have set up list any fields to choose from. All the
tables are listed, but when I select a table, no fields show up to choose
from.
All the tables have primary keys and text fields along with other fields
like number, date etc. They are all really simple tables as I've just started
putting them together.

"Duane Hookom" wrote:

My suggestion is to not use lookup fields defined in tables
http://www.mvps.org/access/lookupfields.htm. Use combo boxes on forms.

Do you get similar issues with other tables/fields? Does the chosen lookup
table have a primary key, text fields, ....? Non-valid fields might be memo
or date fields.

--
Duane Hookom
MS Access MVP

"prima854" wrote in message
...
Kind of a strange problem, I'm trying to use the lookup wizard to create
a
list box field on one of my tables and I'd like to base it off of another
table. When I choose the table I'd like to base the list off of, I get
the
error "No valid fields can be found... please select a new source.
There's
plenty of fields in the table to choose from so I'm not sure what could be
wrong.
Anyone have any suggestions? Thanks.




  #4  
Old September 18th, 2006, 10:02 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 2,251
Default "no valid fields can be found"

You have some form of corruption that might require a re-install of Office
or possibly registering a DLL. This KB article might provide some additional
help http://support.microsoft.com/?id=303769.


--
Duane Hookom
MS Access MVP

"prima854" wrote in message
...
Thanks, Normally I would just not worry about it and use other methods of
using lists, but it almost seems like an indication of a larger problem
with
my setup or something. When I go to use the forms wizard to create a
form,
none of the tables I have set up list any fields to choose from. All the
tables are listed, but when I select a table, no fields show up to choose
from.
All the tables have primary keys and text fields along with other fields
like number, date etc. They are all really simple tables as I've just
started
putting them together.

"Duane Hookom" wrote:

My suggestion is to not use lookup fields defined in tables
http://www.mvps.org/access/lookupfields.htm. Use combo boxes on forms.

Do you get similar issues with other tables/fields? Does the chosen
lookup
table have a primary key, text fields, ....? Non-valid fields might be
memo
or date fields.

--
Duane Hookom
MS Access MVP

"prima854" wrote in message
...
Kind of a strange problem, I'm trying to use the lookup wizard to
create
a
list box field on one of my tables and I'd like to base it off of
another
table. When I choose the table I'd like to base the list off of, I get
the
error "No valid fields can be found... please select a new source.
There's
plenty of fields in the table to choose from so I'm not sure what could
be
wrong.
Anyone have any suggestions? Thanks.






  #5  
Old October 10th, 2006, 04:16 AM posted to microsoft.public.access.tablesdbdesign
prima854
external usenet poster
 
Posts: 3
Default "no valid fields can be found"

Thanks for your help. Tried a bunch of different things, including this KB
article as well as lots of time banging my head on the desk, until I finally
stumbled on the solution, my anti-virus (Kaspersky) was preventing the
wizards from working correctly. It was at recommended levels, but those
levels were apparently affecting me negatively, so as soon as I set it to
stop monitoring VBA macros, Access began working the way it's supposed to.
Looks like it was working a little to well!
Anyways, thanks again.

"Duane Hookom" wrote:

You have some form of corruption that might require a re-install of Office
or possibly registering a DLL. This KB article might provide some additional
help http://support.microsoft.com/?id=303769.

  #6  
Old October 10th, 2006, 04:57 AM posted to microsoft.public.access.tablesdbdesign
Duane Hookom
external usenet poster
 
Posts: 2,251
Default "no valid fields can be found"

Thanks for taking the time to reply back with the solution. It may help
someone in the future.

--
Duane Hookom
MS Access MVP

"prima854" wrote in message
...
Thanks for your help. Tried a bunch of different things, including this
KB
article as well as lots of time banging my head on the desk, until I
finally
stumbled on the solution, my anti-virus (Kaspersky) was preventing the
wizards from working correctly. It was at recommended levels, but those
levels were apparently affecting me negatively, so as soon as I set it to
stop monitoring VBA macros, Access began working the way it's supposed to.
Looks like it was working a little to well!
Anyways, thanks again.

"Duane Hookom" wrote:

You have some form of corruption that might require a re-install of
Office
or possibly registering a DLL. This KB article might provide some
additional
help http://support.microsoft.com/?id=303769.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.