Search results for query: *

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

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

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

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

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

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

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

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

Hello, I created a shortcut to a word document that contains hyperlinks. When I opened the document using the shortcut on my desktop the hyperlinks do not work. I receive the edit: "Cannot open specified file". When I place the mouse over each hyperlink the system displays the...

Hello, I am trying to use the advanced filter to only display unique records in a column. What are the correct steps to use an advanced filter to select only unique records?

Hello, How do you set up a table of contents in word? How do you define and create the page bookmarks? I went to the Insert Menu Selected a format: Classic template and I receive the following error: Error! No table of contents entries found. I have the following table of contents text...

Hello, I want use a command button in Word to execute a FoxPro program with parameters. What would be the correct syntax? In dos the parameter is: s:\datadi~1\DEV>datadictionary+sainfo.dbf

How do you execute a program with parameters from a MS Word hyperlink (i.e. MYPRG.EXE P1 P2)? Thanks

Hello, I would like to sort a spreadsheet to display only unique records by a particular column. In column A, this spreadsheet contains program names. There are multiple occurrences of the same names: Eg: Program1 Program1 Program1 Program2 Program2 How can sort this spreadsheet so that...

Hello, The code below uses a commandbutton to open a protected worksheet, unprotect it, and then uses the autofilter to remove blank lines. How can I adjust this code so that the protection can be automatically turned back on after the autofilter is invoked? Private Sub...

How do I set an autofilter to automatically select only "nonblank" cells in a range of columns. For example for Columns A1:A1000- Z1:z1000. Thanks