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

Thanks,John I wanted to draw 4 lines and join them because I am trying to render an architectural perspective/isometric from a listing of coordinates which represent the corner points of a building's walls and windows, and similarly for the roof sections. Every wall and roof section has...

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

lameid, Thanks for the response. A VBA module was my first choice, however, the creators of the database are also the users and they have no knowledge of VBA coding. 90% of our Access DB's were created by people who are insufficiently trained to do so and in this company there is categorically...

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

Ascii = 13 Here's a sample: 12815886397 A0000001009684 0220717381 8134805304 12816320455 A0000003428B6D 9999999999 NA A00000010171AC 000000001 5059777417 NA A0000001018694 000000001 8044566537 12805591940 NA 0520759191 4045566294 The apparent spaces between the values...

Thanks for the input Bong, Actually the file I received does not have an extension, so it isn't really a .txt. When I open it with UltraEdit, however, it appears as though there is some sort of line ending character at the end of each line. When I use the Line Input #1, it tries to read in...

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?

There is a SYSTEM.MDW file in the same folder as the DB, however there are also 2 other mdb files in the same folder which do not have any security. Would it be a good or bad assumption that that SYSTEM.MDW file is the right one?

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

Thanks lbass, I didn't know I could specify a sort order by group. Since my data already had a field with the 3-day abbreviation, I just had to make it the group field and specify an order.

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

Thanks lbass. That works great. Now why didn't I think of that.

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

As I'm sure you know, there are CSS tutorial websites out there which go into great detail regarding how CSS elements can be used in place of 'traditional' tables (look at http://www.brainjar.com/css/positioning/). A previous web site design of mine used tables extensively for things that were...

kaht, Thanks for the input. I have three thoughts on your comments. 1. Forget about the calendar. That was just an example from something I tried several months ago but gave up on and went back to tables because the divs and spans always had space between them. 2. My new project isn't...

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