Search results for query: *

Hi all, I've created a macro via VBA that does the "Ctrl-End" keystrokes, i.e takes me to the Last Cell in a worksheet: Sub MacroLastCell() ' Perform the Ctrl-End x = ActiveSheet.UsedRange.Rows.Count ActiveCell.SpecialCells(xlLastCell).Select End Sub My question: How can I have it...

Hi all, I have 2 fields in a report that total the length of all songs in a database as in the following format: =Sum([LengthMin]): =Sum([LengthSec]) A sample result output is 350:7500 which means: The total length of all songs is 350 minutes and 7500 seconds. I wanted the output to show a...

I've replied today to an article regarding of how to use a page break in this forum. Howcome I don't see it? -Tivoli0

Hi all, I have this code which loads "resume.htm". When I "x" out the window I want to load "homepage.htm" that brings me back to the main page. I think I should be using the "onUnload" event but I don't know how to write the code and where to put it...

Hi all friends, Why do I get only one record return with these &quot;Like&quot; clause? I know I have more than one record of that one author or body. In fact, the query pulls only the most recent one. <% if request.form(&quot;keywordBody&quot;) <> &quot;&quot; then SQL =...

Hi all, I have a very simple code that for the life of me doesn't let me do a simple a href: -------------- snip ----------------- <%Do while not RS.EOF%> <tr BGCOLOR=&quot;#CCFFCC&quot;> <td ALIGN=&quot;left&quot; valign=&quot;top&quot;><%= RS(&quot;title&quot;)%></td> <td...

Hi all, I have a script with a function that causes a line of text to scroll my screen from left to right, something like &quot;Welcome to my web site&quot;. How can I have that line scroll from right to left? Thanks for any help! -Tivoli0

Hi all, I have a var dateField = new Date(); that produce a date and time with seconds. How can I omit the seconds so it'll show: Sat May 31 6:55 AM Thanks! -Tivoli0

Hi all, I am generating a dinamical listing of all files in a directory using the FileSystemObject. The fields I'm producing are filename, date created, size and file type. The file type column shows an icon of the relevent file type, ie if it's an *.asp file then there is an asp.gif icon...

Hi all I have a form that collects input from the user and by clicking the &quot;submit&quot; button the data is saved in a database. I would like to modify that form to do the following: Upon pressing the &quot;submit&quot; button, the data will be saved in the database AND a confirmation...

Hi all I have a form that collects input from the user and by clicking the &quot;submit&quot; button the data is saved in a database. I would like to modify that form to do the following: Upon pressing the &quot;submit&quot; button, the data will be saved in the database AND a confirmation...

Hi all, I need to insert this code within <% vbscript %> tags: <input type=&quot;button&quot; style=&quot;background-color:red;color:yellow&quot; value=&quot;Back To Main&quot; onClick=&quot;parent.location='http://localhost/ProjectA/html/homepage.htm'&quot;> Thanks for any help!

Hi All, I'm using Access97 & Win95 I have a report that is based on a crosstab query that returns a row for each OBJECTIVE and a column for each GOAL. The intercept is the counted number of OBJECTIVES in that GOAL. Here is the code: SELECT DISTINCT [To Do].Objective, Count([To Do].Objective)...

Hello great group, I'm using Access97 & Win95 I have a report that is based on a crosstab query. I have no problem to get the report with ALL records. However, I'm trying to get a date range so the report will print from/to specific dates and that's where I'm having problems. The SQL in the...