Search results for query: *

Halleluya! Got it finally with thanks to Mordja and John Winterbottom... We ended up doing the query from the web page instead of making a seperate query in Access. Here's the web page code that does the magic. Hope this saves anyone else from the 3 days of agony we suffered trying to solve...

Hey Mordja, Sorry... I sent a reply and it didn't get posted so here it is again; "What did I have a go" Well, I tried your suggestions as well as variation on the string and a few other things. No luck I'm afraid... I tested the querystring a couple of days ago to make sure it was sending...

Hi again Mordja, Well, gave it a go but I get a "Invalid Variable" error message. Not sure what to do now :( Thanks again, Jude

Hi Mordja, Never actually used a module. We get the list of unassigned products for this group using this statement in the web page; <% Dim Recordset1__MMColParam Recordset1__MMColParam = "1" If (Request.QueryString("PriceGroupID") <> "") Then Recordset1__MMColParam =...

Hi Mordja, The variable [MMColParam] is sent in an URL querystring (i.e. webpage.asp?PriceGroupID=2) to the browser... and then we make MMColParam = Request.QueryString("PriceGroupID") so we can use it in the query. Hope that sheds some more light. Thanks heaps for responding. I'm getting quite...

Here's the problem; We need to return a query that shows the products that aren't associated with a specific PriceGroupID.(PriceGroupID is the specific group that will see these prices) We've got a Product table ProductID | ProductName | ------------------------- 1 | Product01 |...