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: *

  • Users: rewdee
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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 =...
  12. 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
  13. 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...
  14. 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...
  15. rewdee

    running total in a query

    If I have a table like: ID SomeField 1 5 2 1 3 2 etc. How would I write (if possible) a query that keeps a running total as: ID SomeField Calculated_Running_Total 1 5 5 2 1 6 3 2 8 etc. Any help would...
  16. rewdee

    works on my computer but not my Clients

    I have a append query that includes the Str function that works on my computer but not on my clients: The query is: INSERT INTO tblPhoenix ( Location, ItemNumber, Description, SerialNumber, Lot, ExpirationDate, Selected ) SELECT [Inventory].[Location], [Inventory].[ItemNumber] AS [Item...
  17. rewdee

    SP that involves inserting new identity into another table

    I want to create a SP that inserts into one table and then makes another insert into another table with an autoincrement ID into a second table. Something Like: CREATE PROCEDURE AddMotor( @serialNumber varchar(50), @Location varchar(40), @MotorDesc varchar(100), @Manufacturer varchar(50)...
  18. rewdee

    Getting the name of the column constraint

    I would like to change the data type of a column from money to char(1). Through experimenting I found that the best way to do this (and correct me if I'm wrong) is to drop the column (I don't care about the data in the column) and add a column with the same name. However, there's a constraint...
  19. rewdee

    alter a constraint to add Delete Cascade

    I have a foreign key constraint on a table that references another. I want to add Delete Cascade & Update Cascade. How do I do that? Do I drop the constraint and add a new one with ON DELETE Cascade or is there some way to alter table alter column blah blah? Thanks, Rewdee
  20. rewdee

    Should I use Lookups? How?

    I have a DTS package with two connections. We are updating one SQL Server Database into a blank database. There is one table (call Table1) in the previous database that has a field (call Field1) is just straight text. In the new database, Table1, the Field1 is a lookup field from another...

Part and Inventory Search

Back
Top