Jump to content

Moaa

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Moaa

  • Rank
    novice
  1. Thanks! Just wondering though: I have force quit a couple of times, there is no obvious file corruption would you still reccomend copying it over? Thanks again, Moaa
  2. Hi, I have a script that runs a splash screen with 'allow user abort' off. unfortunately i think ive got a bug in the script and it runs for infinity! Ive made a lot of changes to various scripts since i last backed it up and was wondering if there was a way of disabling scripts altogether or grab the scripts from the fp7 file? Any help would Really be appreciated, Thanks, Moaa
  3. Thanks guys your comments got me thinking in a different direction and it turns out that user is the user who's sending and i only allowed viewing for the reciver, thanks a lot! Moaa ???
  4. Privilege set for holiday request table: View - limited by User = Get ( AccountName ) Edit - No Create - Yes Delete - No Field access - all All things said, if this happens with new records only, then the most likely explanation is that UserField is NOT getting populated as intended. In such case user would be able to fill out a new record, and lose access upon committing it - exactly as you describe. that makes sense but user is auto entered with: creation - account name cant modify and the user has access to the records in list view Do you have the Accou
  5. OK, so it could be that i have to turn of automatically committing the record... Unfortunately its on my computer at work so i will have to wait till tomorrow (im in the uk). This part of my database is to request holiday leave so there is one layout in list with all the pending requests, and to make a new request you are taken to a new layout in form view - the one i am having these problems with. I know that the account name matches up to the User field as i have tested it with multiple users and they always get their own records and no one else's. I did set custom privileges
  6. Oops forgot to say, yes the User field is set to autoenter.. Thanks, Moaa
  7. hmm, im not sure im describing my problem very well.. i have the user settings in place so each user has their own set of records within the table and only their own are accessible by them. These are presented fine in list view. But, if the user goes into form view and clicks on the background - and therefore deselecting the record that is being viewed, my if statement in access and privileges fails to work. I believe this is because "if ( user = get ( AccountName ))" cannot get the active record and so cannot get the value of field "user" to compare to "get ( AccountName )"
  8. This is the kind of setup i have at the moment but.. users are limited to what records they can view with if ( User = get ( accountName )) My problem is that in form view, when a user clicks the background the fields fill with I am guessing that is because in my if statement there is no longer a record to access User Field and so it returns False? any ideas? any way of not allowing deselection of records or something like that, or script triggering on record deselct? Thanks, Moaa
  9. I have a table called holiday request with; Start Date, End Date, Comment, User. I am limiting the records in this table that the user can see - so they can only see their own (User is autoentered as account name). How do you mean two tables, as in one for each user? Thanks, Moaa
  10. Hi, I have a privilege set called Standard User, In this users are limited to what records they can view with if ( UserField = get ( accountName )) My problem is that in form view, when a user clicks the background the fields fill with I am guessing that is because in my if statement there is no longer a record to access UserField and so it returns False. I have had a good look and cant see a workaround.. if anyone has got a solution, or a better way of separating different users data, i would really appreciate it. ) Thanks, Moaa
  11. Oh, i knew a global variable is unique to each user i didn't realize a global field was also! Thanks! Moaa
  12. Hi, I have table x with fields; name, user, date, reason. I need to display a date (not the contents of the field date) but the date the user is currently using. I have a global variable date_looking_at (this is the date i need to display). How is the best way to display this at the top of the page? I did try copying it into a global field and using merge field accept this wont work as i need multiple records as multiple users will be viewing different dates.. Thanks for any help.. Moaa
×
×
  • Create New...

Important Information

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