Search results for query: *

Can VBA be used to assign a macro to run after a Windows Key Combo is pressed. I can't seem to find a reference to this anywhere.

Never mind, I fixed my own problem. Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False For Each cell In Target Range(cell.Address).Offset(1, 0).Value = Range(cell.Address).Value + 1 Next cell Application.EnableEvents = True End Sub I just...

...Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Range(Target.Address).Offset(1, 0).Value = Range (Target.Address).Value * 2 Application.EnableEvents = True End Sub This works great when the user changes one cell at a time. However the data in the sheet is a...

In Excel if you create a pivot chart and add custom formatting to one of the series, Excel resets it back to default each time you change a data selection. This is troublesome, especially with data that you wish to display using two axes. Microsoft states that this is a known issue and...

i have a XP Pro machine that I want users to be able to run scheduled tasks on. The admin account can add, run and delete the tasks and the standard users could create tasks in the past. The standard user tasks run as scheduled but the users can no longer modify them or run them by selecting...

...With rst1 .ActiveConnection = CurrentProject.Connection .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open "select * From tbl_LIMS_Cleaned" End With With rst2 .ActiveConnection = CurrentProject.Connection .CursorType = adOpenKeyset .LockType =...

I was given a dataset today that looks like this... Field Value Part# 97510 TID 100000000 Doc_Type TCP Stage 5P Panels 9108B0003,9108D0003,9108L0003,9108M0003 Materials 05695,07212,1980B,1980C,1980D Revision 10 As you can see the Panels and Materials fields...

Never mind I found a work around. The Connections button does not seem to work in windows Xp with PP 6.6 but the remote addresses can be added to the registry. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Cognos\cer1\PowerPlay Data Server\Servers]...

I have Impromptu and Powerplay installed and I want to add a remote server named addada0391. here is the ini file contents. Can you tell me where and how to add it? [ServicesL] COGNLSTAB=C:\Program Files\Cognos\cer1\bin\coglang.tab SRVCMSGS=C:\Program Files\Cognos\cer1\bin\SRVCMSGS.MSG...

My IT department just brought me my new laptop with PowerPlay Desktop client 6.6 pre-nstalled. connecting to a local cube works great but when I swith to the "choose a Remote Cube" dialog box the connection list is empty and the "Connection" button to create a new connection is gone. can I...

Forget the above post. The crystal reports installed on my PC was originally the "bad" version and was upgraded to a higher version. Once the CR registry fix was applied by the system as a schduled task it fixed the whole problem. Sorry about the silly question.

My VBA for Office 2003 Pro is producing the following every time I try to check references. "Error Accessing the System Registry" I found the article on the Microsoft Support site that speaks to crystal reports messing up the registry. I do have Crystal but not the version they are speaking...

I think I have solved my own problem....but could someone verify it? I have session variables that are set prior to switching authentication and are used after switching authentication. Would these variables be destroyed?

I have one page (Page A) with a simple form that collects order information using a few text fields and some combo boxes linked to an Access database to drive the dropdown lists. This page submits a post to another ASP page (Page B) that appends the info to the database and displays any errors...

<td width="10" valign="top">&nbsp;</td> <td width="315" valign="top" colspan="2"> <span class="fieldname2">Due Date <a class="tooltips2" href="#" onMouseOver="stm(Text[15],Style[3])" onMouseOut="htm()">[?]</a> </span><br> <script>...

Thanks for pointing out the variable thing but it still does not work. I tried both forms of the function without the If...then statement and they work but once inside the if...then statement it is just blank.

I am very new to Javascript and I am having trouble getting a javascript function to work inside of an If...then statement. I downloaded a Javascript function called "DateInput" that produces a datepicker and it uses four variables ( Name, Required, Format, Default Date). I am using it on an...

Most of that code drives the drop down box...I only included it to be complete. This is the only line that creates the tool.... <a class="tooltips2" href="#" onMouseOver="stm(Text[11],Style[2])" onMouseOut="htm()">[?]</a> These line populate the tip and add style.... Text[11]=["Key...

...<span class="fieldname2">Key Product <a class="tooltips2" href="#" onMouseOver="stm(Text[11],Style[2])" onMouseOut="htm()">[?]</a> *</span><br> <!--webbot bot="Validation" b-value-required="TRUE" b-disallow-first-item="TRUE" --><select tabindex=9 name="Key_Product">...

Thanks for the information. The single quotes didn't work exactly but they got me on the correct path. yourjsvar = "<%=Due_Date%>"; DateInput('Field', true, 'MM/DD/YYYY', yourjsvar);