vinnymac

As a followup—I have tried unsuccessfully for three weeks to solve this problem. I have come to accept that the file is corrupted beyond repair and all data is lost. For those interested in a word of advice: no matter how rock solid FM is 99.99% of the time, there is always a chance something bad can happen—we should all back up everyday. Happy databasing!

I tried that a few (dozen) times. Nothing I try works.

I have a critical problem and looking for help. I went to load in a database I use almost everyday (project management) and today it asks me for a password. I have never set a password, at least not consciously. Thinking perhaps that I might have been sleep working, I tried every password I have ever used. I opened other databases and they use "Admin" and blank. I tried that. No worky. I tried logging on as a guest. Even tried "Please Open!" I'm assuming the file got corrupted somehow, which is possible I guess. So I tried to recover the data. It crashes FM but leaves a "recovered" file. That one says its damaged and can't be opened, use recover, etc. So I tried to recover the recovered and it says the "access privileges in this file have been damaged or possibly tampered with." Duh! Nobody uses this computer but me, all alone in my home office, so I can rule out the tampering business. Okay, that's a long story. But any idea how I can: (1) open the file (2) recover the data, or (3) accept the fact that all my hard work is gone. (I do have a back up about a month old, but I sure would not to lose a month's worth of work.) Thanks! FM7 running on MacOX Tiger. Never a problem until today.

Something simple would be: Enter Find Mode [ ] {leave all options off} Set Field [ **calculation goes here** ] Perform Find [ ] ** your calculation would be something like: [TableName::field1, TableName::field 2]

I appreciate the help with the better calculations. I have already done some tests with the paperclip idea and it works great! I downloaded the trial version of FM7 and the "new window" command is exactly what I envisioned. However, I noticed some strange behavior with FM7 on my Mac OSX and some annoying things in my layouts. So I may wait until those bugs are worked out before I migrate. In the meantime, I am using the Custom Dialog that you suggested (since it was the fastest to set up). And actually, I really like it. I still think I will probably build a separate DB with the related notes (when I get a spare minute) for greater flexibility. Thanks again! It's nice to know there are bigger brains out there who are willing to share some insight.

Thanks for your feedback Tom! You have given me some great ideas, thanks for your help. I'm sure an upgrade to FM7 will happen in time, so that might be the easiest option. I like all your ideas and will definitely try them out. I really like the idea to flag with an icon if a note is there or not. That would be a slick feature. I can envision something really cool here. I see is an empty paperclip icon/button (for no note) then click on it to a popup enter the text in the note field, close the popup, and the icon/button changes to a paperclip with a piece of paper in it. Would that be something like (I'm just guessing here): Case(Note = "", gIcon_off, gIcon_on) Assuming I make two global container icons one paperclip w/o paper (gIcon_off) and the other with the paperclip with paper (gIcon_on)? Then I would make that icon a button somehow and run a script to launch a popup window (dialog box or layout or other DB or FM7, etc.) Am I on the right path here?

Been a dabbler for years, but still a novice. I've got this simple project tracking/invoicing app I've built. One of my layouts contains a list of active projects with various data (dates, client name, the usual). But once in a while I need to make a lengthy note to one of my projects. Right now I've made a second line on my layout. But it clutters up the list view, or leaves a blank line when nothing is there. Is there a simple way to click a button and bring up a popup window so I can load in the detailed notes then close it again when I'm done? Kinda like a web page popup. Is that possible with FM6? Any thoughts would be appreciated.

Thanks Ernst! It makes perfect sense to use the line item database for the summaries. It seemed I was trying to do too much from the main database. During my trial-and-errors, I did briefly wander down that path but couldn't figure out why I couldn't see the summaries. With your example I realized that I have to be in preview mode to see it all and not browse. Now everything is coming together. Thanks again for your help and your example! .. V

I am a new user to FileMaker Pro, so please forgive the novice-type question. But I could use help from bigger brains than mine. I'll try to give plenty of details (maybe too much). Background: I built a project tracking database. It relates to "Project Line Items" db which I have placed in a portal window. Since I work on multiple projects each day I move from record to record inputting the time spent on each task for each project. I look up the task description and the hourly rate charges from another database called "Inventory". I probably have 30 or so task items there. Overall everything works great. The Challenge: When a project is completed I need to make an invoice. But I don't want a laundry list of all the task details, only the total for each task. For example, I work on Task A for 2 hours on Monday and Task B for 3 hours. On Tuesday I work 1 hour on Task C, 2 hours on Task A, one hour on Task B and so forth. I want my invoice to summarize each task and only to say "Task A --- total dollars. Next line "Task B--total dollars". Next line "Task C--total dollars", etc. Plus I need the flexibility to add an item to the invoice that I didn't have on my project record (like if I had to purchase something for a client). I created another portal in my invoice layout called "Invoice Line Items" which gives me great flexibility but then I have to manually input the totals for each task. That works OK too, but since this is a computer you'd think it can do the work for me? Is there a way to capture the data from the Project Line Items portal, calculate the summaries for each task, and imbed that data into the Inventory Line Items portal? Or am I barking up the wrong tree here? Hopefully I'm not overloading this description. I would appreciate any help. Thanks in advance, .. V