Function isn't available.......error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 97 which contains some local tables and links to 3 SQL
tables. This database has been in use for years and now I’m getting an unual
error message: Function isn't available in expressions in query expression
'KeywordCat = 'VM Sub-Category' AND Left(Keyword, 2) = '3.".

There are 2 combo boxes that use a local table to populate. The first has a
select statement as it’s row source. It has an after update event which
populates the second combo box (row source is blank). Here is the procedure:

Dim strCat As String
Dim strAddEdit As String

strCat = NullString(Me![CATEGORY])
strAddEdit = NullString(Me![txtAddEdit])
If strCat <> "" And strAddEdit <> "0" Then
Me.SUBCATEGORY.RowSource = "SELECT Keyword FROM tblKeyword WHERE
KeywordCat = 'VM Sub-Category' AND " _
& "Left(Keyword, 2) = '" & Left(strCat, 2) & "' ORDER BY Keyword"
End If

Any ideas why this would happen now? I did reboot the SQL Server thinking
it might be a connectivity issue but since only a local table is involved, it
shouldn't matter. Also, I check the references and they look ok.

Thanks
LeAnn
 
Well, it seemed that the problems was a reference issue. The DAO 3.51
reference was checked so I unchecked it and checked 3.6. That solved the
problem. Course now the question is..............why would the reference
change?

Could someone who was on Windows 98 and just started using the database
cause the change?

Thanks
 
One more bit of information I have learned. There are several Access 97
databases that are being used through a Citrix server. Some of these use DAO
3.5, some use 3.51 and some 3.6. Is it possible that when users are using 2
different databases (which require different libraries) that the first one
opened changes the reference in the subsequent database? This is the only
thing I can think of that would cause the change. If this is possible, is
there anything that can be done to prevent it?

Thanks
LeAnn



LeAnn said:
Well, it seemed that the problems was a reference issue. The DAO 3.51
reference was checked so I unchecked it and checked 3.6. That solved the
problem. Course now the question is..............why would the reference
change?

Could someone who was on Windows 98 and just started using the database
cause the change?

Thanks

LeAnn said:
I have an Access 97 which contains some local tables and links to 3 SQL
tables. This database has been in use for years and now I’m getting an unual
error message: Function isn't available in expressions in query expression
'KeywordCat = 'VM Sub-Category' AND Left(Keyword, 2) = '3.".

There are 2 combo boxes that use a local table to populate. The first has a
select statement as it’s row source. It has an after update event which
populates the second combo box (row source is blank). Here is the procedure:

Dim strCat As String
Dim strAddEdit As String

strCat = NullString(Me![CATEGORY])
strAddEdit = NullString(Me![txtAddEdit])
If strCat <> "" And strAddEdit <> "0" Then
Me.SUBCATEGORY.RowSource = "SELECT Keyword FROM tblKeyword WHERE
KeywordCat = 'VM Sub-Category' AND " _
& "Left(Keyword, 2) = '" & Left(strCat, 2) & "' ORDER BY Keyword"
End If

Any ideas why this would happen now? I did reboot the SQL Server thinking
it might be a connectivity issue but since only a local table is involved, it
shouldn't matter. Also, I check the references and they look ok.

Thanks
LeAnn
Click to expand...
Click to expand...
 
Back
Top