Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JeanW
  • Order by date
  1. JeanW

    CVS data from one cell into several

    Thanks. Works like a charm. Didn't even know that function exist. But then, I nearly never use Excel, only when forced to.... Tx
  2. JeanW

    CVS data from one cell into several

    Hi all, I have an Excel file with comma separated data in cel Ax, going down to 900+ rows. To have it easy to import the data into another program, I need each cvs part into separated cells. Parts can vary from 4 to 7 between commas. Ex. A1 has data xxx,yyyyy,zzzzz I need xxx in cel K1 yyyyy...
  3. JeanW

    Filemaker DBS not working as login items 10.6

    Seems to be a Mac problem then.... Sorry, only all other OS here (Win, Linux etc )
  4. JeanW

    Invoice calculation question

    The OP wants to know: 'TOTAL of each product ordered' not the price. You can use other functions to capture the total price through the relationship.
  5. JeanW

    Filemaker DBS not working as login items 10.6

    What is 10.6 ? Vague question with strange denomination....
  6. JeanW

    Invoice calculation question

    If you have a relationship between the products and your Sales campaign, use this to make a foundCount on each product. This calc will give you the total of a product based on each campaign.
  7. JeanW

    Portal of "Glossary" field with two columns, one "Spanish" a

    Like your modeling is now, it will never work. Basically you're talking about a many to many relationship. To solve this you need to transform this to two one to many relationship.
  8. JeanW

    Determining recent activity by date

    You have a date function Date(month; day ; year). Within this function you can play with + or - months, days or years. See if you can accomplish what you need with this function.
  9. JeanW

    What is maximum depth of calls to subscripts

    FileMAker Pro 2.5.... Are you sure it is 2.5 ?
  10. JeanW

    Data validation in FileMaker Pro

    Sorry. I missed this for while. Do you have a solution yet?
  11. JeanW

    Modifying ExBiz with Locations/bins and picking

    Starr Data had once a program like that on their site. I don't know if it is still available. Maybe if you contact the owner.... http://www.starrdata.com
  12. JeanW

    If statement to multiple fields

    What is your If() statement ?
  13. JeanW

    How do I create a time expired login

    Short and quick. >>I give them a database.... Put in that database a timelimit date, together with the current date, nearly hardcoded. Let your upstartscript check for the first launch of the DB by the client, store that value together with the systemdate, which must be greater than your...
  14. JeanW

    Strange behavior in Excel

    OK, after a few more questions to the other side: The data is an Excel file made on a Mac (don't know which OS)in MS Office for Mac 08 ( ? ) with data coming out of an Access file. I have no idea how they make the Excel file, just export or save the data as Excel, I don't know. And they can't...
  15. JeanW

    Strange behavior in Excel

    oops......silence.... Euh...no... But I did now, and can't find anything.... (will put that in my 'to look for...' file, thanks)
  16. JeanW

    Strange behavior in Excel

    I got an Excel file with text (customer names), made on a Mac, don't know which version. Open it in Excel (Office 2000 Pro on Win 2000 Pro). A weird thing seems to have happened. Every instance where the letter R preceded the letter T, the R is deleted and the letter C is inserted after the T...
  17. JeanW

    Reasonable Training Expectations

    Indeed a tough question and maybe one that doesn't make sense.... I have seen folks with little to no knowledge of databases getting along the FileMaker logic in no time. And folks with an CS degree, after months still do not get the basic into their fingers/head. The videos, although not...
  18. JeanW

    Why are YOU still running Windows 2000

    My Win2k machine is happely humming next to my 2003 server and my Sony with Vista. I do all my developing on the 2000, without any problem. I see no need to change yet. Sure, some programs will not run on the 2000, but they will on the 2003. And if not, I have the Vista. Or I bend and tweak...
  19. JeanW

    Problem Creating Script.. Don't know how create new/revision product

    Indeed a lot of info. But it's not enough. Let's go step by step. = which version of FM do you use. Possible techniques will be different. >> 3-Art director decides if a "New Product" has to be created How ? Is it a specific button, a given procedure? To build your sequence number/letter...
  20. JeanW

    Custom Serial Auto Enter Serial for New Records

    Or, going further on lebisol's idea, you can search for the 'missing serials' first and create a records using the missing numbers first, before adding 'new'.

Part and Inventory Search

Back
Top