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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rewdee

    Active Directory and RDN attributes???

    Any help on this would be greatly appreciated!!! I want to rename the cn attribute something like billn to williamn =========================================== private void RenameMember() { DirectoryEntry objUser; if (String.Compare(NewUserName,User,true) != 0)...
  2. rewdee

    Duplicates in Pivot Query

    Thanks Duane -- I owe you one. Rewdee
  3. rewdee

    Duplicates in Pivot Query

    I have a table that has an autoID, ForeignKey, ShiftID,EmpID,StartTime,EndTime and HrsWrked as shown below: I have an initial query to make the pivot query simpler as: SELECT (Employees.FirstName+' '+Employees.LastName) AS FullName, tempBatch.ShiftDate, (Format(tempBatch.StartTime,"h:n...
  4. rewdee

    VBScript inside Javascript???

    I have some Javascript that creates a nice monthly calendar. I want to format specific dates. However, I can't get the dates that I want to format unless I write some VBScript to get the specified dates from the Database. The premise of the code should look like this: if...
  5. rewdee

    How come I get a border when border="0"

    I tried a simple html that merges two images into one as shown below: <html> <head> </head> <body> <table height="658" width="801" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="277"><img border="0" src="Images/Left_First.JPG" width="277" height="658"></td> <td...
  6. rewdee

    Caching Problem

    Thanks for the quick responses again. The problem with this solution though, even if I have a random string at the end of the url, when a user clicks the back button, the browser has cached the last page (no matter what the random string is). This is deemed a security risk because someone...
  7. rewdee

    Caching Problem

    I'm still having the caching problem as described in previous thread. DotNetGnat mentioned "the best way to fix this is to attach a random string to the end of the URL." I'm unclear how to implement this solution. Won't the string itself be cached too? Does anyone know of a site or some...
  8. rewdee

    Firefox caches original cookie value after I've made it null

    Thanks for the prompt responses. I've tried the Session variable too and as DotNetGnat pointed out the value is cached too so you are able to navigate backwards. I should point outh that the user cannot browse through secured pages after using the back button because when the user clicks a...
  9. rewdee

    Firefox caches original cookie value after I've made it null

    On my website an authenticated user will have a cookie value that I check as shown below: sSessionUserLogin = trim(cstr(Request.Cookies(COOKIE_USER_LOGIN))) If Len(sSessionUserLogin) > 0 AND sSessionUserLogin <> vbEmpty Then ///Do Stuff/// ELSE Response.clear...
  10. rewdee

    How to check if the browser was closed

    How do I use a session cookie? Currently I have some cookie that checks to see if the user has logged in (if not send to login page) but they're set for 30 minutes. I could use those cookies plus another one but would I set it to 2 minutes? Any help would be appreciated? Thanks, Rewdee
  11. rewdee

    How to check if the browser was closed

    Good Afternoon All, This will be for the dhtml gurus or someone with lots of Internet savvy. I have an asp website that authenticates user's and adds a cookie to validated user's. However, when a user closes the browser the cookie is still valid for 30 minutes (length of cookie). I want to...
  12. rewdee

    Looking for a Vertical Cascading Menu script

    I would like to add a vertical cascading menu. I have found this one at http://javascript.internet.com/navigation/cascading-menu.html but I don't want the absolote position on the top. Does anyone know a free script or how to edit the above so that I could place the menu in a table? Thanks...
  13. rewdee

    Difficult SQL Statement

    Travis, I don't know where you work or how much you get paid but I would go to your boss and ask for greater renumeration for you. Brilliant work. I just modified it a bit since I needed to add a few more fields and the count was returning all records in the timesheet not just between...
  14. rewdee

    Difficult SQL Statement

    I have a table called TimeSheet that has EmpID, Date, ShiftID,HoursWorked as fields. I would like to Sum the HoursWorked for each employee between 2 dates say June 20th to June 26th like: SELECT TimeSheet.EmployeeID, Sum(TimeSheet.HrsWorked) AS SumOfHrsWorked, Count(EmployeeID) AS ShiftNum...
  15. rewdee

    The command or action 'SaveRecord' isn't available now

    I'm using some simple code but I'm getting this error: The command or action 'SaveRecord' isn't available now The code is below is called a Command button just before opening another form: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Anyone know why this might be...
  16. rewdee

    Using Scripting.FileSystemObject

    Thanks Tony for the response. It works great except: 1)Writes to server where I want to write to the users machine not the server. 2)Maybe because it's on the server and the server has restrictions but when I ran the script the second time I got this message: Microsoft VBScript runtime error...
  17. rewdee

    Using Scripting.FileSystemObject

    I want to first check to see if the specified file is created, if so delete it and then put the contents of my string (simple xml document built using string manipulations into a text file and save as an xml extension. If tried this code: dim fso, TextFile set fso =...
  18. rewdee

    Update table in diff db

    I have to write an update trigger that updates records in another table in another database (same SQL Server though). Do I create another connection (if so, how? Or do I write something like : USE PUBS Update Customer blah blah Any help would be appreciated. Thanks, Rewdee
  19. rewdee

    Parametized Query

    I have this parametized query: PARAMETERS paramSling Short, paramLand Short, paramTSN IEEEDouble paramCraftID Text ( 7 ); INSERT INTO tblLogs ( Sling, Land, ENG_TSN, CraftID ) VALUES ([paramSling], [paramLand], [paramTSN], [paramCraftID]); and I'm using this code to fill in the parameters...
  20. rewdee

    Modal form with cancel

    I use to know how to do this but I've forgotten. ================================================= Say I create a bound modal form and I call the form like this: DoCmd.OpenForm "myform", acNormal, , , acFormAdd, acDialog However, what if the user wants to cancel there entry (eg. say the form...

Part and Inventory Search

Back
Top