Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Tivoli0
-
Excel Macro to go to first cell in last row?
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...- Tivoli0
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Converting Totals Minutes & Seconds to HH:MM:SS
Hi GingerR, Your point is well taken! For the sake of this thread here is the description of the 2 text boxes: Name: Text43 (should be txtSumSumOfLengthMin) Control Source: =Sum([SumOfLengthMin]) Name: Text45 (should be txtSumSumOfLengthSec) Control Source: =Sum([SumOfLengthSec]) Appreciate...- Tivoli0
- Post #6
- Forum: Microsoft: Access Reports
-
Converting Totals Minutes & Seconds to HH:MM:SS
Thanks for your help but still couldn't figure it out! So, after spending 3 hrs breaking each component I found(!) the solution and now posting it for anyone who may experience the same: The 2 fields, Sum([LengthMin]) and Sum([LengthSec]) are in the Report Footer as Text43 and Text45...- Tivoli0
- Post #4
- Forum: Microsoft: Access Reports
-
need code for VBA in access for a refresh button
Try this: Private Sub city_AfterUpdate() Me!city.Requery End Sub Private Sub city_Change() Me.Refresh End Sub Tivoli0- Tivoli0
- Post #3
- Forum: Microsoft: Access Forms
-
Calculating Sum of Calculated Values
Change the text field to numerical field. HTH- Tivoli0
- Post #2
- Forum: Microsoft: Access Reports
-
Converting Totals Minutes & Seconds to HH:MM:SS
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...- Tivoli0
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
-
Where is the thread about "Page Break" of today?
Rick, I did not try it with anything but IE5.5 Worked great though. -Tivoli0- Tivoli0
- Post #5
- Forum: HTML, XHTML & CSS
-
Where is the thread about "Page Break" of today?
oh, well, thanks RISTMO for *your reply. Since I believe you were on that thread, so let me just repeat what I stated in my reply: I was able to print out 50 pages on IE5.5 with the following setup: <head> <Style type="text/css"> H2 {page-break-before:always} </Style> </head>...- Tivoli0
- Post #3
- Forum: HTML, XHTML & CSS
-
Where is the thread about "Page Break" of today?
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- Tivoli0
- Thread
- Replies: 4
- Forum: HTML, XHTML & CSS
-
Files in Current directory
What if I want to get the listing of files in BOTH directories, c:\mydir1\ and c:\mydir1\mydir2? Do I have to run the line set f=fs.GetFolder()twice, ie set f=fs.GetFolder("c:\mydir1") and then set f=fs.GetFolder("c:\mydir1\mydir2") ?- Tivoli0
- Post #8
- Forum: Microsoft: ASP (Active Server Pages)
-
Web Page dsn less hook up to Access database
instead of: set cnn = server.createobject("ADODB.Connection") cnn.open "DRIVER={Microsoft Access Driver(*.mdb)};DBQ=c:\test\testDB.mdb" Do this: Set cnn = Server.CreateObject("ADODB.Connection") sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _...- Tivoli0
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
Opening a Word Document from ASP
Just my 2 cents... If you set the Word.doc document's properties to "Read Only" you shouldn't be afraid of modifying it by other users. That at least what I was doing and it worked just fine. -Tivoli0- Tivoli0
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Need to load a document upon exiting another one...
Hi bombboy , Thanks much for the tip! It works perfect. -Tivoli0- Tivoli0
- Post #3
- Forum: Javascript
-
Need to load a document upon exiting another one...
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...- Tivoli0
- Thread
- Replies: 2
- Forum: Javascript
-
Why SQL Return only one record with "Like"?
Thanks for the prompt reply! You were right, I had to loop thru the recordset... boy, shows you how banged up I am...! Thanx again! -Tivoli0- Tivoli0
- Post #4
- Forum: Microsoft: ASP (Active Server Pages)
