Recent content by tuccokeith

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?

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

I want to use the following type of logic for testing duplicate entries, however the example below only works if the data is into 2 ranges on the same sheet. I want to be able compare two unique worksheets: Pearson Software Consulting, LLC Duplicate And Unique Items In Lists This page...

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

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

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 - "Requestor" To update the Requestor form do I have to use the wizard or can I perform...

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) = "textbox" Then If ctrl.Text = "red" Then ctrl.BackColor = 3 Else End...

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

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

Hello, I want to create a macro that adds the "'" 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 = "'2000" How can this be done? Thanks

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)

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

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

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

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