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!

  • Congratulations TouchToneTommy 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: *

  1. acantho

    Unable to import a folder of files into a container field

    Are you trying to import the folder OR the files in the folder? Not that it would make any difference but you know how picky computers can be. And again, it might be able to take *any* type of file but maybe not multiple copies of them. I'll look into it and if I find out anything I'll let you...
  2. acantho

    Count of certain characters in a field

    Unfortunately it needs to be hard coded as it's part of a calculation field that is, believe it or not, based on static values brought over through a lookup. I've been using a weird calculation so far but this will make it easier for the end user to modify rather then having me come in and...
  3. acantho

    Unable to import a folder of files into a container field

    I'm not sure if this is the answer or not but I know in the version I'm using containers can only contain -graphics, movies, photos, bitmaps, sounds -multimedia file types supported by QuickTime 3.0 or later -OLE objects (Windows only) Now those might fall under OLE objects but I'm not sure...
  4. acantho

    Count of certain characters in a field

    Okay, I knew about that function but wasn't too sure about spaces. So in 1 1 1 1 1 2 11 If I wanted to find the amount of times the number "1" showed up ignoring any spaces it would be PatternCount( yourTextField; "1") This would return 7? and if I wanted to find the amount of time the...
  5. acantho

    Determine Value of a field of currentrecord from another db

    Thanks again Jean. I think I've possibly found a solution to my problem. First I had to determine that there is no automatic way to show Current Active Record :( So I have to rely on a script which is alright Status(CurrentRecordID) and a global field allow me to determine the current record...
  6. acantho

    Count of certain characters in a field

    Is there a way to count the number of times a certain character, series of characters, or number show up in a field on the same record? example field1 = 1234 123 4321 anna 1324 1234 1 2 3 4 is there a way to determine the following how many times 1234 shows up not ignoring spaces should...
  7. acantho

    Multi Layered cross referencing databases

    Yeah... I wish I had 7 or better :( I believe we're working with 5.5 here. I may eventually import it into 7 or better but it has to work with 5.5 first.
  8. acantho

    Determine Value of a field of currentrecord from another db

    Thanks for the answer Jean. The example was just for the purpose of showing what I was talking about. And yes I realize in the example there are better ways of doing things... that's why it was just an example. The actual project consist of several databases all pulling information based off...
  9. acantho

    Determine Value of a field of currentrecord from another db

    Is there any way to determine the contents of a field of the current record from a separate db? Not looking for another way to solve the problem below since I'm just creating a simple example of what I'm thinking of. example. db1 fields name age sex response lookup_calc db2 response...
  10. acantho

    Multi Layered cross referencing databases

    Ok, I'm trying to wrap my head around building some databases that cross reference each other but I'm trying to minimize the fields as much as possible etc. Since it's hard to explain what I'm doing I'll try and create a simple example here. Database #1 - Final Solution db lets call it an...

Part and Inventory Search

Back
Top