Search results for query: *

Please explain...

I have left.asp, main.asp and right.asp I am having trouble having the right.asp appear on the right side of main.asp using <!--#include file="Right.asp"--> -------- ------- - L - - R - - E - Main.asp - I - - F -...

I am using a macro to import the csv file into my table... I do not have aunique key... when I try to move the data usinf distinct and into a new table I get a msg that this field is to small..... when using memo fields

Actually I do not have a unique... I am taking an extract from another system and the way there backend is created there is no unique key..... (!!!)

How can I delete records where the FName and LName are duplicate? Ex: LName FName Smith Joe Smith John Smith Joe Brown Dennis As you can see there is a duplicate for LName and FName. The final Outcome shoudl be: LName FName Smith...

Perfect thanks... RESOLVED

the result using your expression is: 0 0 4 Where is the 15 minutes? Should be: 4 0 15

I am trying to use the datediff fucntion to obtain the diff between two dates and to display it as Days Hrs and Minutes The results show as: 4 97 5775 When it should show as: 4 0 15 Here is my data being used in my Access query: Date1 = 2005/06/27 19:45:00 Date2 = 2005/07/01 20:00:00...

Hi I am new to java and would like to know what tool is the most common and best used for creating java gui (s)

I am using VBA in my xls spreadsheet. I opening a third party app using the shell command. The app opens and I use sendkeys to tab 3 times on the app. This works great... the problem is when I try to send sendkeys "^c" the field which is highlighted on the app is not being copied using the...

Awesome Resolved!! Thanks

I want to be able to prevent the end user from opening the same web site more than once. How can I do this using javascript?

This is great! My actual listbox passes all selected items to another listbox. Is there a way to delete all the items in the second listbox??? Other than that the code or your sample is perfect!

Is there a way to add the selected items (could be multiple) from alistbox to a text box sperated by ;?

Instead of ISBN lets say field PagesCnt as for the expression I entered it into the statement. I just wanted to add two fields to the query you posted.. SELECT Inventory.BookName, Max(Reservation.DateOut) AS Closest_To_Today, IIf([dateout]=Date(),"available","Reserved") AS Expr...

I used your query but used a LEFT JOIN... Quick question bslintx... Lets say I want to add two more fields from the Inventory table? I loose the distinct grouping? Lets say we want to add Inventory.ISBN and an Expression... How can I incorporate this into the query... Again I tried but the...

RESOLVED - I changed the realtionship to 2.... with your query worked like a charm... Thank you

It actually resolves the issue with the same book multiple times, but if there is no reservation for a book it should still show up in the query..

In this case if I use max it would display Tom Sawyer 04/12/2005

This is the query I originally started off with... only problem is it will display all the Books and all the reservations.. If one book has three reservations, BookName DateOut Under Sea 04/06/2005 Tom Sawyer 04/12/2005 Rogers Ltd 04/07/2005 Tom Sawyer 04/01/2005 Tom Sawyer...