Search results for query: *

I need a simple (I think) master file but I'm just stuck :( I have three fields: ID_ONE/A6 ID_TWO/A12 NAME/A40 I need to be able to join to either ID_ONE or ID_TWO and get the NAME, so ID_ONE and ID_TWO both need to be indexed. (ID_ONE is in legacy data, ID_TWO is in current data.) I'll...

I'm sure I'm missing something obvious but I need to buy a clue. Someone decided it would be nicer to have some data feeds in mixed case instead of upper case, so before we got e.g. SMITH,JOHN and now we are suddenly getting Smith,John Previously WHERE NAME LIKE 'SMITH%' or WHERE NAME EQ...

I need to change one field in a few records in a large .FOC table. Normally I would do that by creating a hold file with the corrected data, and then use a MODIFY to UPDATE the field in the .FOC. But this time it is an indexed field and I have run into the "A key field cannot be updated using a...

I'm having a problem with a Managed Reporting (web client) compound EXL2K format report that saves as a .XLS suffix file, but is really a "single file webpage" format file. This is transparent to later versions of Excel on the PC but causes problems on mac. I can fix it by opening it in Excel...

I'm interested to learn what programs folks are using when they need more sophisticated/flexible graphing than Excel can provide.

I need to redirect the url for one file e.g. http://www.mydomain.net/dir/thatfile.gif to a different file http://www.mydomain.net/dir/thisfile.php No wildcards/regex, just one defined URL to another defined URL. Could someone please show me the RewriteRule for that? Thanks!

Sorry for a 20th century PC question, but does anyone know how to set an HP E-PC C10 to boot without a keyboard? I find old reviews and specs for this machine showing this as a feature but can't figure out how to do it. This is a very tightly locked down little box with very few BIOS options.

I'm wondering if anyone is else having trouble with USE concatenated, indexed, .FOC files under Focus 7.6? We recently updated from 4.3.x to 7.6.x and our reporting is in now big trouble because we use USE to concatenate multiple .FOC files for different years to allow multi year reporting...

Is there a setting somewhere that determines what types of files the file search function will search for text? I'm suffering with an application that was moved from Server 2000 to a new Server 2003 machine. We have program routines in plain text files, but with a .fex suffix. On the old box I...

Hi folks, back for some more of your great help! A friend is asking me how to automatically page break a very many row Excel spreadsheet when the value in a column changes. e.g. In the following example page break after the last Cat, last Dog, Otter, Zebra. Cat Cat Cat Dog Dog Otter Zebra Is...

Here's a problem that I usually have to spend a lot of time to fix. I need to create a lookup between two big sets of data from different sources. The lookup column contains both pure numerics and mixed alphanumerics, e.g. 10021 10022 1002F V5364 Murphy's law usually dictates that the fields...

I can't get the DOWK subroutine to return a result. My input date is a YYMD and the code is: MYDAY/A4=DOWK(MYDATE,MYDAY); and it returns a blank for MYDAY. Do I need to convert my YYMD date to another format for this to work?

I'm transitioning to Access from something else and I'm sure I'm just missing the right Access term for this, but I'm having difficulty with doing the type of report that has a sort for the rows, and a sort for the columns. Suppose a data set has these fields (with example values)...

I'm trying to change an XP Home laptop from DHCP to fixed IP. I can enter the IP in TCP/IP properties, the system takes it and connects fine with that IP (see it in IPCONFIG/ALL), but when the system is rebooted the IP setting is lost and it's back to DHCP again. The DNS setting does stick...

This is a strange one. I always thought that a DEFINE persisted until the end of a .fex unless reset by something like a CLEAR or JOIN, so you could have all the DEFINE's at the start of the fex and then have multiple TABLE FILE reports off that file in the fex. Now I have run into a situation...

Hi, I never see all installed programs in Control Panel > Add or Remove Programs. With the default name sort the listing stops at "N". With the other sorts Size, Frequency, Date Last Used, I see a different subset of programs, but never all of them. This is XP Pro Sp2 Help!

XP Pro PC. The c:\windows\system32 folder opens on the desktop when it boots. I set folder options to default but that doesn't change anything (except hide the files). How can I stop this folder opening?

I have a .foc with 3 multiplier code fields. I need to link the multiplier codes to a multiplier code table which will return the actual multiplier. I'm stuck with this because I can't see how to get 3 values from the multipler table without cloning the table so that each multipler is linked to...

Could I get some suggestions how to do this? Suppose I have a set of data that looks like Employee Job Start Date/Time End Date/Time Joe Thingy 2005/06/01 13:00 2005/06/01 14:00 Joe Widget 2005/06/01 15:00 2005/06/01 16:30 Joe Stuff 2005/06/01 16:00 2005/06/01...

How can I generate a spreadsheet that summarizes data? For instance after subtotalling a large spreadsheet I might have >100 subtotal rows and they'll be on rows 451, 522, 1203 etc, and I would like to generate a simple spreadsheet with just the subtotals on rows 1,2,3 etc.