Jump to content

wolfe

Members
  • Content Count

    35
  • Joined

  • Last visited

Community Reputation

0 Neutral

About wolfe

  • Rank
    member
  1. wolfe

    Multiple Attachements

    Bump...I'd like an answer to this one myself!
  2. Working on a work schedule. Using FM8A I've got this to work the way I want, but the cost in fields seems a bit much so I was hoping someone could look at what I have and see if there's an easier way. I've seen it time and time again so to avoid misunderstandings due to my ignorance, I'll just attach the file I'm working on so you can get your hands on the issue. You will notice all the fields used to count shift coverages. I'm wondering if the same result can be achieved using fewer fields. You will also notice the summary and calculation fields only work as intended when the last record in the set is active. I'm not that concerned about that because I plan on removing all menu commands and keeping the user on the last record once a new schedule is created. (Unless there's an easier way!) Feel free to "talk down" to me since I am not very experienced, ill trained, and a little slow on the pick up! Days.zip
  3. wolfe

    Template for network forum

    Not exactly what I wanted to hear, but thanks for the reply Ender.
  4. wolfe

    Template for network forum

    Hey FM addicts, I'm tossing around the idea of building a forum style solution for my work. Was wondering if anyone out there had an idea where I might find a good template? I've looked around the FM site and in here, but haven't seen anything. I'm wanting something to run from FM server 8 on a private business network with about 12 computers or so.
  5. Try this old file to get you started. I used a variation of this to create autoenter serials that begin anew at the beginning of each year. SerCat.zip
  6. Okay, I've spent several hours trying to figure this thing out. I don't get it. The "Jan1" field works fine, but I can't reproduce it. I even tried creating a new file and using the same field names, copy and paste didn't work and duplicating didn't work. I even tried to copy and paste from the layout and then rename the copied field....Nada!
  7. Hold the presses! Now it seems the only field to work is Jan1. It appears Jan2, Jan3, etc... do not work. All the options are identical, I've even tried duplication and copy n paste, but I can't reproduce the working field, any ideas???
  8. Well I guess I just had to step away from the tail pipe of my car for a while??? I think I've solved this by not even addressing the fact that the day fields, "Jan1", "Jan2" etc... fields are repeating fields. I tried this and the calc works with all the occurances in the repeating field; If ( Jan1 = GetRepetition ( Codes; 1); TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 2); TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 3); TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 3) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 4) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 5) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 6) ; TextColor ( Jan1; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 7) ; TextColor ( Jan1 ; RGB ( 0; 0; 0) ); If ( Jan1 = GetRepetition ( Codes; 8) ; TextColor ( Jan1; RGB ( 0; 0; 255) ); If ( Jan1 = GetRepetition ( Codes; 9) ; TextColor ( Jan1; RGB ( 0; 0; 255) ); TextColor ( Jan1; RGB ( 255; 0; 0) ))))))))))) I did look at the information posted and appreciate the responses you guys gave. Using the above calc will allow me to address my colored text for any number of repetitions. Ender, you had a very good point and since the above calc works (so far) seamlessly, I'm changing the repeating fields to 50 or so to allow for expansion. I will still only show 20, but this way if expansion is needed, it won't be a problem Thanks for the input!!!
  9. You guys always seem to come through when my brain starts to freeze up like my computer so here goes. I am working on a simple (?) work schedule for up to 20 employees. I have a file with 13 layouts, 1 admin and 12 months to show the calendar months. I've created 366 fields showing the day of the month, ( M, T, W, T, F, S, S ) which autopopulate after the first day of the year is chosen. I have a script to add Feb.29th for leap years and recalculate the days. So far so good. Next I want to create a display of work shifts for my 20 employees. What I had in mind is a repeating field named "Jan1" with 20 reps. This way I set this field below the "Day1of366" field on the layout and I can set different work shifts and off days for each of the twenty employees using the repeating field. Still so far so good. The problem is greed...I want to show schedule shortages by turning the text red when a person uses a sick day or takes overtime or for some unforseen reason takes off work. I also want the text to be blue when the person takes off for a scheduled event, like their regular off days or a scheduled vacation, so anything that is listed in the "codes" field will show either black or blue, any other entry will be red. What I have so far is on the admin layout I have a repeating field that stores the schedule "codes", like 1 for first shift, 2 for second P for a personal day and such and soforth. This is a repeating field My autoenter calc is a "get repetition" calculation which looks something like this, If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 1); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 2); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 3); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 4); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 5); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 6); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 7); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 0) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 8); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 255) ); If ( GetRepetition ( Jan1; 1) = GetRepetition ( Codes; 9); TextColor ( GetRepetition ( Jan1; 1); RGB ( 0; 0; 255) ); TextColor ( GetRepetition ( Jan1; 1); RGB ( 255; 0; 0)))))))))) This works fine for the first repetition, but how in the world do I address the remaining 19 reps?
  10. I maintain a rather large db for my police department. We run 12 machines all with XP w/sp2. Our server is a desktop some guy put a mirror drive into, I don't know much about computer hardware so all I can tell you about it is that it has a large hard drive and 2 Ghz of ram and the processor is a 2.4 Ghz. I'm not sure what kind of hard drive it has, but it seems I read something a while back on the forums about having the right hard drive??? (I looked but couldn't find the post) Our problem is that when FMServer 8 performs a scheduled backup, it slows the entire network down where users end up getting the dreded coffee cup icon. As I stated previously, this is a police database and we are open 24-7 so it's hard to pick a convinient time to do this. Oh, and all clients run FM Pro8 with updates! My question is, does anyone have any advise on hardware (server end) which would help speed up or lessen the effect on clients during back up times? Thanks!
  11. wolfe

    Networking stack cannot be initialized

    I was getting the same error, it was the firewall. Did you shut the wirewall off or go into the settings and allow the FM program? I've ran into firewall issues before and found that simply disabling the firewall does not always prevent the firewall from stopping connections through a network. If you haven't already tried it, go into the firewall settings and add FM to your application list.
  12. wolfe

    Printing an index

    Wow, now don't I feel like an idiot! I guess I haven't been using my brain enough lately. Gonna have to knock the dust off a little more often I think. lol Thanks guys!!!!
  13. wolfe

    Printing an index

    My thought was to keep my question short to avoid clouding what I thought was a simple question. Maybe I need to add a little more detail. It's been said I'm not always clear as glass. Here's my problem; I have a database which has a "location" field used to record the loction of an event. This is a regular edit box indexed text field. The problem I have is that we have about eight different people entering data into the field and if someone uses the "enter indexed value" (CTL + I) the index is full of the same locations spelled differently or abbreviated. To describe an intersection like "Main Street and Market Street" I see entries like "Main & Market" "Main St & Market St" and numerous other variations. Now what I want to do is create a drop down list with using the contents of the field. The problem with this is all the garbage and misspellings and different variations so I want to "clean" the index list up before I impliment the field as a drop down list. To do this, I was thinking I would need to either print the index list or be able to gather the list into a field where I can print it. Once printed, I can assign someone to modify the location field in all records so they have uniform descriptions for the locations listed.
  14. Maybe someone else has had a need for this before but I can't find it anywhere. I'm needing to either print an index list from an indexed field (or) be able to import the contents from the indexed field from all records into a global field. Any ideas?
  15. wolfe

    disappearing text

    Additional diagnosis....... It seems that four different fields were affected by whatever caused this. The first was a standard text field, the second was a time field, the third was a text field with a drop down list, and the forth was a calculation "audit" field. I'm thinking this may have been some type of power surge or electrical problem but the system affected is on a UPS. Does this help shed any light on the problem?: HEEEEEELP!
×

Important Information

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