Recent content by VonFranzken

Hey Cheech thanks Is there a way to attach the javascript to the end of the image link I currently have which is simply the recordset value? <%=(Recordset1.Fields.Item("image1").Value)%>

I have a page which calls a recordset image. When you click the image the link is set to <%=(Recordset1.Fields.Item("image1").Value)%> so it opens up in a new window bigger. I want to know if there is way to attach to the link a java script which will add a close window behavior? Thanks. Steve

Hi and thanks in advance. I have a query, the works, and it basically shows the order information from a typical e-commerce database. Now when I run this query, and for this example lets say I am the customer and I order 3 distinct items in various quantity. Now when I run the query it shows all...

Ok your right OrderReferenceID is text and DetailOrderID is number so now how would I need to write this: SELECT DISTINCT DetailOrderID, OrderReferenceID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders o...

Not sure I understand in what capacity?

Getting closer, but now when I test this I get type mismatch in expression??? SELECT DISTINCT DetailOrderID, OrderReferenceID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders o, OrderDetails d, Users u WHERE...

I want this query to show the unique orders per persons firstname, which in this case happens to be the full name I have 3 tables Users, Orders, OrderDetails. SELECT DISTINCT DetailOrderID, UserID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal...

You guessed right Jerry, and now shows the top row of the query but no data? Under OrderID it says AutoNumber??? Hmmm. Thanks for your help with this.

I dont get an error but when I switch to preview the query it doesnt display any data and there are records and relationships. Steve

What am I missing here? SELECT OrderID, DetailOrderID, OrderUserID, DetailProductName, DetailQuantity, DetailPrice, OrderShipping, OrderTotal, OrderDate, Firstname FROM Orders AS o, OrderDetails AS d, Users AS u where o.OrderID = d.DetailOrderID and o.OrderUserID = u.UserID

I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be? It is a web server so read permissions are off for the database so New Web Query will not work unless there is something I missed...

Thanks Skip I tried that but when I try to map to the database throught the url I get access forbidden read access turned off. Steve

I have an online web database IIS server, with and access e-commerece db. I wanted to know if I could connect to this database via excel to extract data as need be? thanks for any help with this. Steve

by why = 10?

Can the where criteria be where the order id lets say = order detials id? Thanks. Steve