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.

I have a worksheet in Excel. A row represents a record and the row under it is a multiple of the record above it. (Qty x Cost). In the example below let's simplify it and assume that the cost is $2 for any item. If I use the Change Event I can capture the change and made the cell under the...

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

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

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

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

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

I have small markers that produce pop-up tooltips for each field on a page. They work great for text boxes but when I use them next to a Dropdown box they appear behind the box. Any ideas how to force them in front of the box? Here is the code for the label and box.... <td...

I have a pop-up date picker that is written in Javascript that will take one of it's parameters as a default date. I use it on two pages... On my Add a record page the default value is today but on my edit-record-page I need it to reflect the date already stored for that record. The “Add”...

I have a pop-up date picker that is written in Javascript that will take a parameter for default date. I use it on two pages... On my Add-a-record page the default value is today but on my edit-record-page I need it to reflect the date already stored for that record. The “Add” page work fine...

I am trying to install the Client for Oracle 9.2 on my PC. After I identify the jar file the progress meter makes it about half way and generates an error that says it could not load a library named Windows GenerslQueries. Any ideas?

I have a Date Field MM/DD/YYYY and a time value stored in a number field HH24MI that I want to convert to a single field but can't seem to figure it out. Just starting out simple I am trying to convert the number field to a time value. Select To_Date(JOB_ACTY_TM, 'HHMI') TIME_Field, From...

I have an table linked into my SQL Server 2000 database. The linked table contains manufacturing transactions from our mainframe. One field JOB_ACTY_DT is a date field and another field JOB_ACTY_TM is a vchar field that contains a time in 24 hour serial format. I want to create a view that...

I have a passthrough query from an Oracle 9 datasource that stores a 4 didit department number in a field that Access imports as a memo field. (I don't know why memo for 4 characters). I have a local tabe in my Access 2000 database that will provide a department mgr name for each department...

When I run the following query everything worls fine... SELECT qry_Queue_Closed.PCKG_NBR, qry_Queue_Closed.PCKG_INITIATION_DT, qry_Queue_Closed.PCKG_APPROVED_DT, qry_Queue_Closed.OP_TYP_DESC, [PCKG_INITIATION_DT]+30 AS [Due Date]...

I have a summary field that sums a calculated field called "30%". When I make a pie graph of the data the legend calls the data SUM @30%. I wnat to give it another name. Is there a way to change a formula to rename a field?

I have a database that is giving me an error stating that I don't have access to the MySysObjects table. Any idea why this type of thing happens? I hadn't been making any development changes, but I did access the MDB and security file from a different computer then I normally do....

I have a database that is giving me an error stating that I don't have access to the MySysObjects table. Any idea why this type of thing happens? I hadn't been making any development changes, but I did access the MDB and security file from a different computer then I normally do....