Jump to content

drags

Members
  • Posts

    18
  • Joined

  • Last visited

Everything posted by drags

  1. I did not think of that. Good Idea. Thank You Kevin
  2. No I can't because user 1 needs to be able to change that field. Kevin
  3. I have 2 related databases. Database 1, with a name field that is shown in a portal related to database 2. The user of database 1 can edit both. I want the user of database 2 not to be able to change anything in database 1. I've tried to set a password on on both databases with groups and this works except on the field with the portal. This is the field I need to have restricted. Thank you Kevin
  4. Thank You Jason!!!!! You Guided Me In The Right Direction Kevin
  5. Ive written a database that keeps track of all the TV shows we are editing and mixing. Each Record is the TV show in house and the editor assigned to cut each reel of Dialog and Effects. Here is an example: Show JAG 121 Act1 DIA Dave Act1 EFX Mike Act2 DIA Joe Act2 EFX Mike Act3 DIA Dave Act3 EFX Steve Act4 DIA Sue Act4 EFX Steve I want to be able to search by editor to see how many Acts they are assigned each week. How can I set up a relationship so if I search Steve it would display: Jag 121 Act3 EFX Jag 121 Act4 EFX These fields were set up as repeating fields, but I would change them to make searching easier. Thank you Kevin
  6. Thank you guys for trying to help, Yes Jason that is what I want to do. I'll try to explain it better in the following example: StartDate (12/5/02) EndDate (12/9/02) Sat(Checkbox) Sun(Checkbox) What I want to happen is the user enters the StartDate and the EndDate and if the checkboxes are empty it would do the following: Into a repeating field the StartDate is entered, and because the checkboxes are empty the Friday Date is entered as an Endate, then another startDate of monday is entered. I guess the main question is: If I have a given Startdate, how do I find the date for the upcomming Friday? Thank You All Very Much Kevin
  7. I hope someone can help me with this one. So here it goes. I have three field values StartDate, EndDate, ShowTitle. These three fields I am exporting from FM as a dBase file, so I can import it into Outlook just so I can print a Calendar, all of this is working great except for one thing. In FM the SatrtDate is Thurs, Dec 5 2002 and the EndDate is Tues Dec 10 2002. What I want to happen is to have two checkboxes one for saturday and one for sunday, so if the boxes are left empty then it would make the StartDate Thurs, Dec 5 2002 and the endDate Fri, Dec 6 2002 and duplicate the record and set the new record StartDate Mon Dec 9 2002 and the EndDate to Tues Dec 10 2002. If the either checkbox is valid it would take this into account. Please help, I'm going crazy I've tried every thing I can think of. I have downloaded a couple of sample files in the download section and I can't get them to work. Thank you Kevin
  8. I was wondering if there is a way to have my solution exit or request a password if it has been sitting idle for ten minutes? I want this to prevent lower level users from changing anything. Thank you Kevin
  9. No, I'm just testing this on my C drive. What am I missing? Thanks Kevin
  10. I can't get it to work in Runtime. When I run db2 as a filemaker file everything works fine, but when I try to run it as a Runtime Solution I get the following error: "Update-1.fp5" could not be created on this disk. Use a different name, make more room on the disk, remove the write-protection or use a different disk. Anybody have any clue as to why this is happening? Thank you Kevin I'm using Developer 5.5 on Win98 SE
  11. Thank You Kurt I try that now Kevin
  12. Hello everyone! I have been reading various topics on this forum but I can't seem to find the solution I'm looking for, so I'm hoping someone can help. I have a runtime solution the opens with a certain password that does not allow importing and exporting of records, lets call this db1. It has over 124,000 records in it. I would like to have the users download an update called db2 which may have only 1800 new records that need to be imported into db1. What I would like to happen is the user opens db2, clicks a button that runs a script that opens db1 (with a password that allows importing and exporting) then runs an external script within db1 to import the new records. I want to do this automatically because I don't want the user to mess it up by not matching the correct fields. The tests I have tried are not working because db2 always has to be the same name because the script in db1 is looking for a certain file. Is there any way to from db2 "Export Records Into" a certain solution. This would be the most direct approach. The other problem I'm having is that I can't seem to open db1 from db2 with a special password. I may be going about this the wrong way, how does anyone update runtime solutions? Thank you Kevin
  13. Thanks Andy I'll try this tommorow because today I have to finish another non FM project. I kind of glad that I need to create another DB because this will make it easier for updated products. I'll let you know how it goes. Kevin
  14. Hello Everyone, I have a small problem which mabey someone can help me with. I have a database with 6 layouts. Layout 2 has over 100 pictures of different products, Each product has a value list of the different models of that product. Everything is working great except for one thing, the value lists. What the end result should be is that the person selects a product on layout 2, then it takes them to layout 3 with the correct value list for that product. I've tried using a calculation with ValueListItems. But when I try to select an item it says this field is not modifiable. Is there anyway I can do this without creating over 100 layouts? Thank You Kevin
  15. Thank You For your fast replies. Today I talked with Jamie he is the programmer who wrote Lockpoint. He told me that the company he wrote it for went out of business last June so he bought it back from them and will be releasing a new version by next Friday with new features. With that in mind I'm still very interested in this solution. I'm just wondering if anyone who uses it is happy with it. The 'CryptoToolBox' plugin sounds interesting but I am not a real programmer, I'm still very much a beginner and I don't think I have the Ability to write something that complex. The program I wrote was for me to make my life easier, but when others saw it, they thought it was very cool and now they now all want copies for themselves. Thank You All Very Much. This forum is a must have tool for information and resourses. Jamie /Lockpoint can be reached here: http://www.braddockstreet.com/contact.html
  16. Hello everyone, My solution is almost finished and I need to protect it from piracy and I was wondering if anyone is useing Lockpoint? I tried to call them and the number was disconnected. I'm open to any suggestions anyone might have to achieve my goal. Thank You Very Much!
  17. I Have created a button to go to the previous record, this works just fine, but I was wondering if the was a way to click and hold down the button to make it keep going to the next previous record. Thank You Drags
  18. I have a database with over 119,000 records I want to click a button to sent the contents of a merge field to WordPad. I used the sent message command to open the WordPad document and it works great. I then would like to delete all info on the wordpad the paste the contents of the merge field to wordpad, save it, then close it so it can be used by another program. I've tried to use DDE Execute for this part but I can't seem to find the topics or commands for this process. I went to the microsoft libraries and spent many hours reading help files but it was not any help to me. I've contacted the programmer of the application that needs to recieve the contents of the merged field and he is not familiar with Active X or DDE so I can't think of a way to send the info directly, so I want to send it to WordPad basically as a clipboard. I can then access it through a Macro from the other application. Is there a way to send the contents of a merge field over a network to a specific computer clipboard? I am a new member to this forum and have found lots of usefull information here. Thank You, Kevin
×
×
  • Create New...

Important Information

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