scolesm

It is hosted, we have a different staff member that deals with the Server-side of things (I wish they'd let me). The file has closed unexpectedly a few times. Usually, this is involved in the printing. This doesn't make me happy at all, but thanks for the help. What steps can I take to clean things up?

Hey there, I'm running FileMaker Pro 8.0v1. I've got a database of products that I've been maintaining for some time now. Each product is linked from an Item Master (IM) layout to ingredients, qualities, display layouts, etc. by a primary key. Lately, with one item, the IM data has stopped appearing. When I search the IM layout for the primary key (or any other piece of data related to this item), the fields displayed on one record appear empty and cannot be edited. I can't even see data in the field that I searched to find the record. Looking at a field linked to this record from any other layout, it appears empty and cannot be edited. I've created a new record for this item and deleted what I could, but the IM record which seems to contain no information cannot be deleted. When I search for it and delete it, the found count goes to 0, but the total remains the same and the record remains. I'm sure I'm not the first to encounter this, but I cannot find a similar post. Can anybody help me either understand the problem or just get rid of the remaining record? Thank you very much, Michael

That sounds like the exact problem here. Thank you for pointing me in the right direction!

It seems the problem is that FileMaker no longer stores/cares about the page size each user picks after they hit the OK button in the Page Setup dialogue. I'm currently in preview mode, trying to change it and every page size I choose reverts to 8.5 x 11. Any help is still much appreciated.

No such luck, I guess it's time to re-build. Thanks for the idea though.

Hello, I have a database of tracked product history that I'm trying to make printable. For some reason, the printing of this specific file is not working properly. I'm printing on a Xerox printer with multiple paper sizes and such and despite the fact that I've done everything I can think of to ensure that I'm telling FileMaker to print on 8.55"x11" (checking that print setup contains the proper page size both before and after printing), it prints on a different page size, 11"x16", which I don't enjoy wasting. I was wondering if anybody has encountered this type of problem/knows what to do about it. As a note, this is a file that I've inherited from a previous administrator, so I'm unsure of which version of FileMaker it was made with (I don't even know if that's a part of the problem). I have three other working, printing databases that I've created in v8. If it would be remedied simply by recreating the file entirely in 8, I can, but I'd like to avoid that if possible.

Alright, I have a little better understanding of subsummaries, but I don't quite understand how to implement the printing from the related table will condense the number of pages I use. I'm working on a sample of this database so you can see my problem

I'm sorry to say that Sub-Summaries still baffle me. My FM freezes whenever I search the help So that's just a different problem. Would I put a subsummary after every category, and if so what do I sort it by? I'm gonna start looking into them more, but if it's simple and explainable, feel free to give me a hand. Thanks, Michael

Hi all, My problem now is as follows: I have a database up and running that is filled with products (so I can't post it due to privacy issues). My company needs to print out the Specifications of these products in order to send to customers. I just can't make a layout that I feel comfortable actually presenting to customers due to the amount of white space I'm creating. Each product has 9 categories, brought in through portals. Each of these categories contains between 8-15 fields. I need to make a layout that prints properly if every single field is filled (worst-case scenario), but that also prints if various amounts are. Some products also do not contain certain categories. Right now, for printing, I've separated the layout into three different pages and scripted a print of all of them. This works, but if page one only contains 2 categories with 3 records, it looks embarassingly blank. I'd like to be able to create one layout which prints straight across page boundaries, but I don't want the start of a category to be on the bottom of one page and then the rest of it to be on the next. Is there any possible solution out there to make a decently printable document? Thank you very much, Michael

Just out of curiosity, how many layouts do you have?

If you ever create more than 44 (not positive on the number) layouts, the drop-down menu for them adds gets scrolling arrows to the top and bottom

Yes, sorry Ender, I forgot to give thanks for your help, your solution was most useful to me.

Ender, Yeah, I realize that it's pretty vague what I'm doing here (I try not to be so vague, but the entire loop is quite lengthy and my question's just referring to my looping method, I'm content with it's contents). This is just a general loop that I've been using to make changes to fields in all found records. It generally just contains Set Fields. As a programmer, I was just interested to see if there's a more effective way to do this. And thanks for the Get hint. I always look over how many things that function can handle. Thanks! Edit: And yes, the two layouts are related, by Item Number. Layout2 simply has many occurences of Item Number differentiated by multiple Lot Numbers.

Hey all you FileMaker...ers Is there a more efficient way to loop through found records than the following: Go to Layout [Layout1(Layout1)] Set Variable [$ItemNum;Value:Layout1::Item Number] Go to Layout [Layout2(Layout2)] Enter Find Mode [] Set Field [Layout2::Item Number;$ItemNum] Go To Record [Last] Set Variable [$LastLot = Layout2::Lot Number] Loop . . . Exit Loop If [$LastLot; Value:Layout2::Lot Number] End Loop Either that or is there a way for the script to find out how many records were found? Thanks a lot, M

I'm still pretty new to this, so I'd hope comment comes back with something better, but Fields: ExpireDate - a calculation field (of type date) that evaluates to StartDate+183 (avg length of six months) CurrentDate - a date field, insert the current date in there (just to start out) DiffDate - a calculation field (of type date) that evaluates to CurrentDate - ExpireDate make a script Insert Current Date [CurrentDate] Enter Find Mode[] Set Field [DifDate; >121 <183] Perform Find[] This should find all records with a CurrentDate - ExpireDate value of between 122 and 183 days. (4-6 months) I do stress however that this isn't the most effective way, but it should give you a bump in the right direction, I hope. I imagine somebody will either correct my solution or offer a new one, as this doesn't really account for which day of the month it is. Good luck! Michael