Recent content by D0N

I've gotten the gallery3 to work without changing their instructions, however, it doesn't work exactly the same as the sample. The pictures aren't randomly rotated as they're moved around and the caption contains the filename rather than all the information given in the sample. One CAN go in...

It sounds like some path in his autofill technique is now broken, doesn't it. The simplest thing to do is create an extremely simple database which does nothing more than uses his technique to autofill a couple of fields. Once convinced that you've gotten THAT to work, use it to find the...

This is a toughie. Any time you incorporate fields that can vary in vertical length, you make the task nearly impossible. Imagine, for instance, that you had to create a script which examined each record and calculated how many lines it was going to take. You'd then use that to calculate how...

I can't think of a way to do this without incorporating a simple front-end database. This front-end database does nothing but take care of processing you buttons and opening the 'real' database based on the button pushed. Of course when the 'real' database opens it will handle asking them for...

You should be able to do something like this: set a variable, say x, to a numberic calculation which is: (Today- start_date) / 365. Then, set the formating for x to be "format as decimal" and select "fixed number of decimal digits" and enter a 1 in the box.

Sounds tricky, since I believe the specific print options variables are outside of the reach of FileMaker, however you can save the print setup. There's a couple of ways to go about this. One is just to create a script which loops through a one-copy print. The loop variable would be based on...

Hi Hippyer, A sort of after-the-fact approach, but once you have your records ordered sequencially, have you looked into using the 'replace' command to resquence them?

If I read this right, the number you refer to doesn't sound like something you want to store permanently, as it'll change when new orders come in and you run the next batch. If that's the case, I'd just create a script that gathered the current list, then have the script loop through them and...

I suspect you've answered your own question. It's the relationship you've established that forces the related files to open.

It depends on how secure you want this to be, but you should be able to base record privileges on who's currently logged in. Save the login info within associated records. If I log in and attempt to edit a record that doesn't match my login info, I'll get rejected.

Like the guys above alluded, don't expect the value you assign a global field to be there the next time you open your database. Basically, they're a handy way to set up a temporary variable without increasing the size of your database.

Does it work if, when you print, you elect to send it to a file (that would isolate it to a network/printer problem)? Do other things print from this Mac OK (i.e., could you using the wrong printer definition)? If so, can you take that file you created, convert it to pdf and print it...

Oddly, since the last rash of security patches, we're unable to open new (or modified) files on our FileMaker Pro server. One gets this very informative message: "Unable to open file". Anyone else experiencing this?

The possibilities here are pretty wide without knowing how the database is set up. I'm guessing you probably use a script to do your update? Try following through your procedure by hand to make sure everything's working as it should, then put stops in your script and see what's happening (and...

The less messy way is to make your result a calculation which, using your example, is: Case ( C = a, b * .2, C = b, b * .4 ) Keep adding more of these as needed. You can (and should) have a default value at the end if C can ever have an upredictable/unchecked-for value.