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

    Using time calculations in Excel

    Hello, I am trying to use the run time in a the following formula: SUM(D2*2)+C2 Where Column d2 equal run time and Column c2 equals start time How do I make the run time values remain in a hh:mm:ss format?
  2. tuccokeith

    Using time calculations in Excel

    Hello, I am trying to enter a program run time into a column in Excel. What time format can I use that will allow me to just enter the run time without excel trying to convert it to am/pm time. For example if I enter 00:00:10 (run time of 10 seconds) Excel indicates in the formula window...
  3. tuccokeith

    How do you create a mechanical compare in Excel

    ...only that the cells that contains data, use a formula like the following: =IF(MAX(COUNTIF(INDIRECT(&quot;A2:A&quot;&(MAX((A2:A500<>&quot;&quot;)*ROW(A2:A500)))),INDIRECT(&quot;A2:A&quot;&(MAX((A2:A500<>&quot;&quot;)*ROW(A2:A500))))))>1,&quot;Duplicates&quot;,&quot;No Duplicates&quot;) This...
  4. tuccokeith

    How do you create a mechanical compare in Excel

    Hello, I want to create a macro that creates a compare routine that will do the following: Compare two Excel worksheets Create a third worksheet that highlights the rows and columns or cells that did not compare in worksheets 1 and 2. Thanks
  5. tuccokeith

    create a history table

    Hello, I want to create a history table that stores records that have been changed in table &quot;Project List&quot; On table Project list I want to use a Change Indicator that is set to &quot;yes&quot; when a command button &quot;Change&quot; is pressed and any record on the Project List is...
  6. tuccokeith

    Revise field on form when a table field is changed

    Hello, Can you automatically revise a field on a form when the field is changed on its source table? For example. A text box is field - Business Sponsor is changed to a lookup field on the table - &quot;Requestor&quot; To update the Requestor form do I have to use the wizard or can I perform...
  7. tuccokeith

    Using color on an Access report

    Hello, I am using the following code and it the color is not printing on the report: Private Sub Report_Open(Cancel As Integer) For Each ctrl In Me.Controls If TypeName(ctrl) = &quot;textbox&quot; Then If ctrl.Text = &quot;red&quot; Then ctrl.BackColor = 3 Else End...
  8. tuccokeith

    Using color on an Access report

    Hello, What is the VBA syntax for a textbox change event to set the background color? text box name = Status If text box value = red Make background color red
  9. tuccokeith

    Using color on an Access report

    Can you designate a color to be associated with a field value on a report, so that the field prints on the report with a color embedded in it? Field Priority 1 = Red Field Priority 2 = Yellow Field Priority 3 = Green
  10. tuccokeith

    Create a macro that appends every record in a column

    Hello, I want to create a macro that adds the &quot;'&quot; character to every numeric value in a column b1:b1000. For example b1 = 2000(as a numeric value) I want the macro to change the cell value to b1 = &quot;'2000&quot; How can this be done? Thanks
  11. tuccokeith

    Sharing field values from one table to another

    Hello, How can I save the results of the form copying the two fields from Table 1 to Table 2 into a revised Table2. Is there an update table function in VBA that I can use to update the table2 (Change)
  12. tuccokeith

    Sharing field values from one table to another

    I have two tables: Table 1 (Project) contains Project ID, Project Name, Project Description, Start Date, End Date, Change Indicator, Requestor Table 2 (Change) contains Change ID,Project ID, Project Name, Change Reason, Change Date, Change Requestor. I have a form that opens when The Change...
  13. tuccokeith

    microsoft access question

    Hello, I have a question regarding whether or not I should use a query or a table. I want the Change table to contain the following fields from a the Project table: Project ID Project Name How do I link the tables so that these fields are only filled when the Change indicator is set to...
  14. tuccokeith

    microsoft access question

    Hello, in the code me.name.visible = false should name equal my table table name? I am receiving an invalid qualifier error
  15. tuccokeith

    microsoft access question

    Hello, I have three tables. A Project table that contains project id, purpose, status, change indicator, and requestor name. The second table is Change Project Table. This table is contains the Project Id, change date, and Change reason. The third table is a Requestor name table. I use...
  16. tuccokeith

    VBScript to JavaScript in Adboe

    I need to convert existing Vbscript to a link driven Adobe JavaScript Private Sub CommandButton71_Click() Shell (&quot;s:\datadictionary\dev\datadictionary.exe T DATEINFO.DBF&quot;) End Sub
  17. tuccokeith

    retaining Microsoft word doc hyperlinks

    Is there anyway to retain Microsoft word hyperlinks when you import a word documetn into Pagemaker 7.0? I want to be able to use hyperlinks that are pointing to files on a server. For example: The hyperlink location in word is s:\document\totals.xls
  18. tuccokeith

    Performing a compare in Excel

    Hello, I want to run a compare in Excel. I have two lists. The main list - Pricing contains master records The second list - Offshore contains some of the master records plus additional records. I want to run a report/compare that pulls out the unique records from the second list Offshore...
  19. tuccokeith

    Shortcut icons corrupted after computer locked up

    Only the short cut icons are corrupted. They still function. How can I reset my desktop? I have Windows ME. Thanks
  20. tuccokeith

    Shortcut icons corrupted after computer locked up

    Hello, All my shortcut icons from my startup menu are now fuzzy (though they still work) after my computer locked up when using my cd-rom drive to load some entertainment software. I tried to restore my compute by using Adaptec to go to a safe point but after I restored the system the...

Part and Inventory Search

Back
Top