JSRunnels

Here goes: 3 macs - one host & two clients. Port 5003 open on all three. Connection used to work just fine... Now Mac Two can connect to the file - but only through File -> Open Recent -> File, but will not find the host in File -> Open Remote. Mac Three cannot open the file either way. Any thoughts?

Thank you. I knew it would be easy. I just spent an hour trying to figure it out!!! I love FMForums.

I know this must have a very easy answer, but I can't seem to get it to work... I want a calculation field to show two decimal places -- even if they are zeros. The field sums two number fields. If the sum is "7", I want it to return "7.00". This is a simple, simple invoice. I have tried Round, Truncate and SetPrecision. It always returns "7". I know there must be an easy way to do this, but somehow I am missing it.... I have searched FMForums for decimals, cents, steprecision. No luck.... Please help!

comment, It is very, very cool. May I use it in my database? Jessica

It will take me a while to sort through this, but I can tell you one thing for sure -- I wish you had posted this 13 days ago! This will be a great file for those struggling to understand the various relationships. I am working on a very similar database and was wondering if there was a way to show committee positions without duplicating the info. I will probably try to incorporate some of this into my database. Thanks for posting it!

I have been pouring over the file you uploaded. I noticed that on the Delete Family Mark Y script, the first command is "Commit Records/Requests [No dialog]. I am wondering what the rational is behind that. Is that a step that I should be adding to the beginning of a lot of my scripts?

Okay, so, while you did all that, I was proud of myself for fixing my little label printing problem (it was only printing 9 labels per column instead of 10). That would illustrate the difference between "beginner" and "advanced" users! I will definately go with putting my data/changes into your database! It is going to take a while for me to sort through and understand everything that you have done. I will probably tweek the delete family/mark yahrzeit script as there is at least one other thing I want it to check (if there is a "location," we will keep it.) I also think I figured out a more elegant way to move a child from one family to another for when they grow up and become their own member. - make new family record, change Fid of Indiv. record through a custom dialog box, change status. (Right now, I make the user go through this whole rigamaroll involving TextEdit.) I will also try to add the hebrew date calculator that -Queue- and comment have been working on so furiously. I guess you won't hear from me for a while, as I sort through all of this, but don't think that I am not working on it! Thank you, thank you, thank you. Jessica

Shouldn't this thread be in the Printing forum? I had trouble finding it....

Worked for me. The default header was 17 px. I dragged it to 11 px and my tenth label shows up now. Related side question: There must be an easy way to specify the EXACT height of the header/footer/etc., I just can't seem to find it. I have to eyeball it every time.... I have the little Size palette come up whenever I am in layout mode and if you click on the divider line, it returns the stats on the part, but as soon as you let go, they disappear...

I am not sure I want sliding, because the whole idea is that (at this point) A LOT of the fields will be blank. I am trying to print "forms" for members to update their information. By definition, a lot of the fields are currently empty -- for data we have yet to collect. I could just print a blank form I suppose, but my plan is to send each family a form with the information we DO have, so they can double check it. I will look at the form and see if there is something hiding there, but it seems to print a family of six (2 full pages) just fine. One member - fine. Two members - followed by a blank page. Wierd. If it ends up being to difficult to track down, I will probably go the lazy route and just pull out the pages. After all, I hope only to need to print these ONCE. It is just my nature to ask why? when something isn't working as expected.

I do not, in fact, have developer. I have found myself lurking on "my" own thread, because I seem to have nothing useful to add. You two have confirmed that I posted to the right area! I certainly understand if you take your discussion offline and I won't even pretend to follow most of what you are actually saying/doing, but I do care...

Coming right up. I added a record or two for you this time. I just got my computer back. I am capable, but sometimes you just have to let the man be manly. For him, upgrading computers is a man job. What can I say... I have to go to work (real work - where they actually pay me) this morning. I am going to take my computer with me and try to get satrted on this, so I eagerly await your response. SynDB.fp7.zip

My husband is kicking me off of my computer to transfer all the data to my new Powerbook. (He does not trust me to do this operation by myself. - He is not willing to risk that I might lose this database and then he would lose me for another 2 weeks.) I may go through withdrawl. I am eager to get working on the Adar problem. I will let you know when (realistic) I run into problems. It is still fuzzy. And now I have to look up the Case function! Thanks. BTW, they are really blowing me away on the Hebrew calendar. (In Brain Food.) I feel like I have an army of experts helping me out. This really is a great place. Can I move in?

The following years are leap years: 05, 08, 11, 14, 16, 19, 22, 24. (I looked it up using Hebcal.com) If I remember correctly it is a 13 year cycle with 7 leap years. (What can I say...) Leap years have the Adar I/II. Regular years just have Adar. There are entire books written on the Jewish Calendar...

That sounds like way more than I want to bite off. If it was easy, (I thought I might be missing something basic) I would want to add it. but basically, you might end up at the Individuals List from a variety of ways. They will just have to click around. This is still SO much better than what they currently have in place. Ultimately, this will run on a small group of networked Macs (3-4). I currently have the on close script set to run only when the User is Office (the main computer where the file will reside.) It simply prompts a Save As dialog. I may try to add in the Applescript, but I know even less about Applescript than I do about Filemaker. Me, personally, I don't know. But it could easily be looked up for the next 20 years or so. This makes a lot of sense. I have to think through how I would get it to do that. Something like: If _gMonth = Adar If get (current year) = Adar only set _gMonth = Adar Else set _gMonth (what here? ==AdarI?) (how to I get it to add the Adar yahrzeits here? - expand find ==Adar?) do all script stuff set _gMonth, Adar II do all script stuff End If End If I am assuming a put another little table in to check if it is an Adar only or Adar I/II (Leap) kind of year?