Search results for query: *

My Visio Controller Dimension objects display dimensions in feet, inches, and sixteenths of inches (e.g. 16'-2 7/16") when the Units in the Precision & Units dialog box is set to Feet-Inch (1'-0"), regardless of precision. I want to create a custom format so that dimensions will display as feet...

Long Time VBA user - new to VBA in Visio - still haven't figured out how to refer to shapes and their properties (or is that Cells ?) I have code that draws 4 lines on a page, then selects the 4 lines and joins them. After the join, I want to fill the joined shape with a color. I recorded a...

Is it possible to use a formula or the value of a text box on a form as the File Name argument of a TransferText action in a Macro. The user needs to export a number of similar files from a table with slightly different criteria. He wants the Transfer text to increment the output file each time...

I want to use VBA in Excel to open a .txt file in which length of each string of characters varies from record to record. The goal is to peel off either characters 1 to 11 if they are numeric, or some other other set of characters if they are not. What is the best way to read in each line if...

Is there a way to get all of the records in table X that do not have a corresponding record in table Y? Here's some details: Table X fields: POKEY EXTERNKEY MODEL QTY Table Y fields: POKEY EXTERNKEY MODEL QTY Table X contains all receipts for 1 week and can have many records (typically 8-10)...

Is there a way in Access 97 to open a database and determine what .mdw file the database is using for security settings?

Please understand that my knowledge of Access security is scant. There is an Access 97 database which was created (and used) by someone who is no longer an employee. An unknown level of security is applied to the database, which resides on a server at company headquarters. Users are at a...

My CR XI report is a 3D Bar chart showing the number of Help Desk calls by hour of day and day of week. The underlying data has the day of week as an integer: 1 for Sunday, 2 for Monday, etc., so the values that show in the axis on the chart are 1, 2, 3, 4, 5, 6 and 7. The data includes a...

Using CR XI, my report includes a chart which shows the Top N groups by percentage of results records. A parameter gives user the option to select the value of N. A chart in the report footer shows the Top N groups. I want the title of the chart to have the value of N in it (e.g. - if user...

When I try to use CSS divs and spans to create a series of table-less rows and columns, there's always space between adjacent cells. Here's code similar to what I'm using: <style> span.cal_hdr { text-align: left; vertical-align: center; width: 14.28%; background-color: #EEEEE3; border...

A database includes information about certain objects which are best viewed according to their spatial relationship (for example - an organization chart). Is it possible, assuming the data can support it, for CR to produce a report that is html output so that the org chart can be rendered based...

My report has a grouping that is for a date. When I added the group, CR being smart like it is, knew the field is a date so it added the option in the Change Group Options dialog which says "The section will be printed" and below it a drop down menu list with the choices for each day...

A text field in 'Details a' on my report has values which could be as few as 1 and as many as 40 lines. The field's Can Grow property is enabled and set to a maximum of 3 lines. If the complete value of the field would cause the feild to be more than 3 lines (if I didn't have it limited), I...

In CR XI, I plan to mimic the MS Project Gantt chart using a horizontal bar (text box perhaps) in the detail. The position and width of the horizontal bar will need to change with each record. Is that possible in CR? The record set has 1 record for each person who will work on a job - there...

How can I determine if a record is the last one that will be printed on a page (in a multipgae report). I want to have a line under each record but have it suppressed for all but the last record on each page.

My CR XI report data Group 1 is by a client name and Group 2 by a date field. The report parameters give the options to select/not select a client as well as the option to select/not select a date range for the date field. If users choose not to select by Client, then I would like the Group...

Looking for a way to force a new page when the value of [client_name] changes in the details. My CR11 report is run from within another application. The report needs to have the results grouped by [client_name] but have other sorting options as well. I don't want to create a group for...

Please forgive me for asking another 'How do I position my <div>' question.[sad] My page is a .php file that creates a monthly calendar (7 days across, 5 or 6 rows down) on the fly by pulling records from a mySQL database, and creating the table rows and cells and filling the cell with the...

A report I'm developing using CR 11 has 3 levels of grouping with GH and GF1, 2, and 3. In GF3 there is a vertical line and 2 fields that I want to show each time GF3 is printed, unless it is the last GF3 before a new GF2 prints, in which case only the fields show and NOT the line. Is it...

Using Excel 2000, my procedure adds a comment to various cells based on their content. When visible, the cells default to a position just above and to the right (of course), which, for my worksheet, is off the screen. I want them to show up to the left of the cell when the mouse is positioned...