Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


MikeKD last won the day on January 11 2015

MikeKD had the most liked content!

Community Reputation

7 Neutral

About MikeKD

  • Rank
  • Birthday 10/08/1967

Profile Information

  • Gender
  • Location
    Kent, UK

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

6,042 profile views
  1. Looking closer now! In a bit of a rush now - try putting the time taken box below a blank box with both set to slide up & select the "objects above" option. Unless, there's another object out of sight that's not set to slide up" Sorry - I'm not an expert at this - tends to be a bit trial & error for me too! (I take it the last screen shot is from a preview btw?) Good luck!
  2. In your screenshot - there is no up arrow to indicate that you've set the fields to slide up. That option is in the inspector under Sliding and Invisibility. - Did you try it and find it didn't work? Also, they are all currently aligned top rather than bottom. To get the format you want, my first call would be to: 1. Set Activity, time_taken and Charge text boxes to all slide up. (probably also ticking the options for all items above and also resize part.) 2. Bottom align time_taken. Good luck!
  3. I don't do these often, so you'll hopefully get better ideas, but I'd make the Units and Unit boxes the same height as the activity box, align bottom and set them both to slide up (which looks to be the trick you've missed out). But - it would look messy if the units boxes stayed blue... Cheers, Mike
  4. Adding info after Importing New Records

    That's ace - so I don't have to bother working out how to find the recently imported records - for once things are easier than I expected! Thanks guys
  5. HI folks, I've got an import new records script I'm working on. After I've created new records (based on Excel rows) are they always left in the found set? As far as I can tell that's the case, but don't want to rely on it! After the import I'd like to then set a couple of fields based on variables, and can't see another way to find the records that have just been imported to do that. Cheers, Mike
  6. Filtered Portal

    Well this works, pretty much I think.. If anyone can see some improvements, I'd be glad to hear them! Case ( not IsEmpty (Resources::PickWork) ; Resources::PickWork = Piece_forResourcesMenu::WorkID ; IsEmpty (Resources::PickWork) ; ( (IsEmpty ( Resources::gSearchPieceTitle ) or PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle )) and (IsEmpty ( Resources::gSearchPieceComposer ) or PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect )) ) )
  7. Filtered Portal

    Ah, I think I've got it - I'll use Case, testing for PickWork being empty or not. Will have a go when I get the chance... Cheers! Mike
  8. Filtered Portal

    Hi Folks, I can't quite get my head around this one.. I have a portal that contains basic info about pieces of music. Each piece is either a work or a movement. (pieces are either self contained or consist of movements). I'm using 2 globals and 1 local field to filter down the list of pieces: 1. Composer 2. Title 3. Work ID This works almost as I'd like: ( ( IsEmpty ( Resources::gSearchPieceTitle ) or PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle ) ) and ( IsEmpty ( Resources::gSearchPieceComposer ) or PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect ) ) ) OR Resources::PickWork = Piece_forResourcesMenu::pkPieceID The issue is that, if the last field (Resources::PickWork) finds matches, I don't want to see any of the others. I suspect that it's possible, but can't work out how to do it... Best wishes, Mike
  9. I've just had a quick google of it. I think it needs rather more than a quick google! I think I probably need to learn how to use one tool at a time at the moment!!
  10. mmm, *******, good point! I'm showing my incompetence again.. My guess is that I should be looking at a calculation (or summary?) field listing either found or related records? Once we've got the files text content correct, are there different methods for windows and Mac to set the filetype to .doc? Or is that part of the text content? As always - huge thanks for the help you give to those of us learning the ropes comment :-)
  11. Hi Charled, Please take this answer with a HUGE pinch of salt! I'm only a couple of baby steps beyond being a beginner.... I /think/ what I'd do here is create some kind of text string (one that's not likely to come up anywhere else) in word that I could then do a search / replace on, e.g: ////..Title..//// ////..Date..//// ////..Content..//// Oh boy - I've just seen comment's answer and I'm right!! Yay! So then, you use substitute in FM to replace each of the text strings you've put in your template. This is potentially /so/ useful!!!... Thanks both :-)
  12. File location in Mac OS (iCloud)

    Thanks; that's what I thought - so I"ll be best creating a new folder outside docs and desktop for FM files. I guess backups can be stored in docs as long as they're not opened from there.... Cheers! Mike
  13. HI Folks, I've just bought a new MacBook and am using it as an excuse to force me to organise my HD! In Mac OS Sierra, documents and desktop are synced (optionally) with iCloud. This feature is obviously handy as it provides an easy way to access files without carrying memory sticks etc around. My questions are: 1. Is there a danger of a FM file being corrupted if it is on a disk that is being synced with iCloud? (I believe that this is the case with DropBox etc?) 2. Is that danger only present when the file is actually open in FM, or does it apply to backup files / files that aren't open too? Cheers folks! Mike
  14. Filepath

    Hi comment, All sorted now and your suggestion worked a treat. I can envisage that being a really useful technique when moving databases to different computers. Huge thanks yet again! Mike

Important Information

By using this site, you agree to our Terms of Use.