Why oh why doesn't this work? 
Author Message
 Why oh why doesn't this work?

nochannels = DLookup("[FTAChannels]", "FTATypes", "[FTAType] = " &

Why doesn't this work?

FTAChannels = Field name
FTATypes = Table name
FTAType = FieldName

It gives the error message:

The expression you entered as a query parameter produced this error. The
object doesn't contain the Automation object 'FTA.''

What does that mean?

All I'm trying to do is let 'nochannels' equal 'FTAChannels' from the
'FTATypes' table.

Please help, anybody.

Nick Rowlands

Mon, 05 Mar 2001 03:00:00 GMT  
 Why oh why doesn't this work?
What is the value of Forms!FTANumber!FTAType? If it is a number, then this
is probably not the problem and you can ignore me, but if it is text you
might try the following:
nochannels = DLookup("[FTAChannels]", "FTATypes", "[FTAType] = ' " &
Forms!FTANumbers!FTAType & " ' ")

(Note:extra spaces added around the single quotes for readability). Even if
the control or property value of Forms!FTANumbers!FTAType is text, you will
need to enclose that text in single quotes to use it as criteria.

Hope this helps.


Mon, 05 Mar 2001 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. VB6 ListView: Why oh why oh why...

2. VB6 ListView: Why oh why oh why...

3. Why LoadPicture() works on local pathes and doesn't work on the URLS

4. Why -- Oh Why !!!!!!!!

5. DELPHI - why oh why Pascal?

6. Code doesn't work, why?

7. Why doesn't this MAPISendMail work?

8. Why doesn't this button work?

9. SQL in VB doesn't work - why?

10. Why doesn't this work?

11. Why doesn't this work???

12. Why doesn't this work?!!


Powered by phpBB® Forum Software