Search results for query: *

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 -...

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...

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...

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?

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

My table shows as: Book Author DateBought Tom Sawyer C Dickens 01/01/01 Spiderman S Smith 04/04/05 Tom Sawyer C Dickens 02/02/02 Spiderman S Smith 04/05/05 As you can see the Book and Authors are the same but not the...

How can I write the following statement? PSEUDOCODE: Look in the database and see if this book was reserved between Date1 and Date2. If the book was not reserved between Date1 and Date2 then INSERT the variables (Book Name, Author and Company) into that table. Is it possible to add SELECT and...

When I use my query in the Access database the results are correct. When I run the query in my asp code the results are not correct. varDate1 = #03/04/05# varDate2 = #03/04/05# Here is the query in the Access database: SELECT [Table1].[SerialNo], [Table1].[date1], [Table1].[date2]...

I have been working on this for two weeks now and I am very frustrated!!! Here is what I am trying to do: A person wants to reserve a monitor. In my database I have Date_Out and Date_Return fields. The user selects the dates he wants to reserve the monitor (Date1 = the date he would like to...

I have one table called Equipment and a second table called Reserve. The relationship between the two tables is TicketNo. Here is my query: SELECT DISTINCT [Reserve].[TicketNo], [Equipment].[TicketNo], [Reserve].[Date1], [Reserve].[Date2] FROM Equipment LEFT JOIN Reserve ON...

When I run my report if there is no data, the text box returns #Error. If there is no data is there a way to display 0 intsead?

Can I use code in vba in Access 2000 to retrieve fields from a table in SC?

I have a number field in my Access table, field1. Field1 shows data as seconds. Field1 3600 I want to convert this to hrs and second so it shows as 1 hr How can I do this?

For some odd reason I keep getting the following err msg: Error Type: MSAccess (0x800A1EBA) Microsoft Access can't open the database because it is missing, or opened exclusively by another user. On line 57 which is: objAccess.OpenCurrentDatabase strDbName I have strDBName set as strDbName =...

With my code below I am exporting a report to snp format onto my c: drive. ONLY problem is I keep getting the Enter Parameter Value box. How can I pass a variable (varName) to this parameter and then export the report to snp. Again the export works fine but I keep getting the Enter Parameter...