Hello again, So nobody has any solutions or ideas for this problem? I have searched the net again now for any solutions, but still I can't find anything. As Bradley noted below there seem to be many people who have experienced this issue... / Erik "Erik" <Um3Erik@newsgroup.nospam> wrote in message news:39D43C15-7AB8-4D2C-8E1F-9E3507A44452@microsoft.com... Hi, I too have the

When I create a new record on a subform I get the following error message: (application name) can't find the object 'select *, sql_variant_property(value, 'basetype') aS type from ::fn_listextendedproperty(N'MS_WSSTemplateID', N'user',N'brad', N'table', N'StoreMaster',NULL,NULL)' Anyone have any clues? I cant figure it out! I'm logged in as user brad. But I also tried logging in as

Something in your suggested where doesn't work: WHERE Instr(Nz([ENTER STORE NUMBERS], StoreName), StoreName)>0 This where returns 0 records. If I replace it with: WHERE (((StoreMaster.storename)="H2345")) I'm able to get the records for H2345. This indicates the rest of the query is working, just not your suggested where above. Again, "StoreName" is a text field for store ID's. 12345,

As per a much earlier posting of mine in this thread, change the sql to: PARAMETERS [Enter Customer IDs] Text ( 255 ); TRANSFORM First(Orders.Freight) AS FirstOfFreight SELECT [Order Details].OrderID, [Order Details].ProductID FROM (Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID WHERE (((InStr

Using Northwind, the CrossTab SQL below is more what I'm dealing with: TRANSFORM First(Orders.Freight) AS FirstOfFreight SELECT [Order Details].OrderID, [Order Details].ProductID FROM Customers INNER JOIN (Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON Customers.CustomerID = Orders.CustomerID WHERE (((Customers.CustomerID)="DRACD" Or (Customers.CustomerID