Search results for query: *

Hi All, A co-worker is having problems when he opens VFP 9. This situation just started out of the blue one day... When he double clicks on the icon to open VFP, it appears like the program opens up, the icon for VFP is showing in the task bar, but not showing on the desktop. He has to then...

Hi All, I have a couple of instances where we get data that has been concatenated into one field. We need to strip out certain info but unfortunately, the characters we need to gather out of the string are not located consistently in the same place. Here's an example of the data: 6-25 4.1L...

Hi all, I have a two part question. I spend hours each week in my data, with 8-10 tables open doing research. Do you have a font preference that you feel is easiest to read? I've been using MS San Seriff, set on (8)font size to fit everything on my monitors. I thought I would be able to change...

Hi all, How is the best way to capture the date and insert it into a character string? Basically, this is going to be a combination of the source of the data, and the date the my program was run on it. The result I need is this: "File Source 03/11/2015" Thanks for all your help!

Been battling an issue with an Excel 2010 VLOOKUP, decided to create the 2 tables in Fox Pro to see if I had any better luck... and I didn't. Saved Excel files as .CSV and imported them into Fox Pro 9. I have added a field, call it ABC, in each table and populated the ABC field in both tables...

I am having problems with a VLOOKUP between 2 different work books. The field I am linking on is a field that is made up of data from 5 columns that I have CONCATENATED together. The function is finding the data in the H column but not consistently. I have found places where #N/A is being...

Question, I have a program that opens multiple tables (15+ using browse last no wait) in a work area. The question I have is does anyone know why my thirteenth table opens up without its previous structure/form… all other tables open with their previous structure/form (they all open with same...

We are writing a program to automate some setup files we use often. We would like to be able to add a field(s) to the table through the command line and accomplish the following: Name the field Set the data type Set the field width. Been trying to do this with an alter table command but it's...

This is the first program I have ever written. I am writing this to open several tables that I work with on a daily basis. When I run the program table A is the only one visible until I click on the screen, table A disappears and then table B will open. if I click on the screen again both tables...

I really appreciate all folks that take the time to answer the posts here! Since finding this site it has been a big help to me. Frank

Datatbase Access 2000 Crystal 8.5 I need to change the Link Options from and equal join to left outer join to put together an inventory report. However, when I right-click on the link, select options, the join type is visible but not available for me to edit. What do I need to do to make it so...

Hi everyone, I have written a few Access DB's for others, reporting with Crystal 8.5. I have purchased version 9 and want to install it. Are there any known problems when upgrading from 8.5 to 9.0? Thanks,

Hello, I am writing a PM Schedule report in Crystal 8.5, using an Access 2000 database. I need to take a completion date from a Workorder table and project the next time this PM Workorder will come due. Example, PM W/O is completed on 4/19/2004 and will come due the next time in 90 days. How...