use of access-issues

Does anyone know how to set up a "log page" (I'm using Issue database template)
so that anyone in my network can see a filled out template but only a few of 
those should have access to edit them. without being forced to change the 
"read only" in properties.

Problem: someone is calling in with a problem - I open a issue template, 
filling in all the information. Later someone else that has edit access to 
this issue template want to update with an answer- He do that. Now the person 
that called in with this problem should be able to read/see this answer 
without having access to edit this document. 

Hope this explains what I try to do....
-- 
Kenny
0
Utf
11/16/2007 8:22:00 AM
access 16762 articles. 3 followers. Follow

2 Replies
560 Views

Similar Articles

[PageSpeed] 32

Not sure exactly what you're trying to do:

Try using three forms - all identical but one property?

Take your current form then copy/paste it, so you have to, give it a name of 
FrmEdit or something appropriate.

Then change the "allow additions" property to false.

Do the same again, using "FrmViewOnly", ensuring "allow edits" and "allow 
additions" properties are set to false. - This ensures the user can only view 
and not edit the data within the system.

Hope this helps, if not what you need, let me know!
-- 
Dan Walters


"KenCo" wrote:

> Does anyone know how to set up a "log page" (I'm using Issue database template)
> so that anyone in my network can see a filled out template but only a few of 
> those should have access to edit them. without being forced to change the 
> "read only" in properties.
> 
> Problem: someone is calling in with a problem - I open a issue template, 
> filling in all the information. Later someone else that has edit access to 
> this issue template want to update with an answer- He do that. Now the person 
> that called in with this problem should be able to read/see this answer 
> without having access to edit this document. 
> 
> Hope this explains what I try to do....
> -- 
> Kenny
0
Utf
11/16/2007 12:55:01 PM
Create a table of user IDs and the roles you want them to have on your form.

Then on form load toggle the enabled, visible, locked properties as needed.

"KenCo" wrote:

> Does anyone know how to set up a "log page" (I'm using Issue database template)
> so that anyone in my network can see a filled out template but only a few of 
> those should have access to edit them. without being forced to change the 
> "read only" in properties.
> 
> Problem: someone is calling in with a problem - I open a issue template, 
> filling in all the information. Later someone else that has edit access to 
> this issue template want to update with an answer- He do that. Now the person 
> that called in with this problem should be able to read/see this answer 
> without having access to edit this document. 
> 
> Hope this explains what I try to do....
> -- 
> Kenny
0
Utf
11/16/2007 3:11:02 PM
Reply:

Similar Artilces:

Access 97 can't resize database window
My database window with the listings of forms tables etc was adjusted to a smaller width, but resizing it is completely disabled and renders Access 2007 utterly useless for me. Is there anyway to 'reset' the window? ...

How to link with an Access DB
Hi, I have an Acces DB with many tables. I need to choose the name of a customer in a cell of Excel. For example, in acces I have this tables: Table1 Id Name Last Name City I need to choose the last name from a drop down menu in a spreadsheet and then in other cell I need to put all the data regarding the last name that I choose. I hope to be exaustive, and sorry for my english. :-) Many Thanks Stefano ...

*major* functional issue with MOSS/WSS?
We are looking to move a big site over to using MOSS in a big as an alternative to shared network drives (ugh). One of the biggest issues is sending docs as attachments via email for others to edit. We'd like to get everyone to use the 'send a link' functionality from thew Sharepoint DL BUT when the user receives the email and clinks on the embedded link the doc opens read only. They then cant edit and save their changes. Seems a big an counter intuitive functional flaw. Are we missing something here? Is there any easy (for the end user) way to send those links to a doc ...

[Access 2007] How to edit custom menubar created in Access2003?
Hello, This is my first post to this server, Hello everyone. We're working on a database created by my collegue in MS Access 2003. Since some time we've moved to MS Access 2007. Now we find problems editing the menubar. Each time we want to remove/add/alter a menu item my collegue goes to his MS Access 2003 and changes a menu. In 2007 the full menubar is visible under Add-Ins ribbon menu. Normally there should be a system table USysRibbon, but it is not there. There are only MSys* objects. How can we change the menubar directly in MS Access 2007? Is that possible at al...

Access 2003 resets form variables during debugging while the form is open
Hello, I am using MS Access 2003. (FWIW, this is about an ADP project, not MDB.) A form has a variable that is initialized (by some function call) in Form_Load() and then stays unchanged for the form's entire lifetime. (In a language more advanced than VBA, it would be a constant, not a variable; unfortunately, in VBA I cannot initialize a constant by non- constant expression). Specifically, in my case it looks like this: Private sTempFileName as String ... Private Sub Form_Load() ... sTempFileName = GenerateTempFileName(...) ... End Sub Priv...

Can SUMPRODUCT be used for entire column?
This formula results in a numeric result: =SUMPRODUCT((A1:A20)*(B1:B20="b")) but this formula results in a #NUM! result: =SUMPRODUCT((A:A)*(B:B="b")) Which means I need to specify the length of the columns, which may grow over time. Any way to do this for the entire column, without having to specify the length of the column? XL07 removed the limitation on array formulas (which SUMPRODUCT is, even though it doesn't require CTRL-SHIFT-ENTER) and entire columns. For pre-XL07, one can use =SUMPRODUCT(A1:A65535, --(B1:B65536="b")) to get all but on...

users with restricted access
We have some users that we have directed to only get their information from a report that has been set up. Because of that, I set up a parameter query to make the information more easy to see. The parameter query prompts for last name or broker #, is there a way, when the last name is entered to include Jr's & Sr's? Or should this be another field in the table to make the last name field more accurate? ...

Using scanner in Word97
I want to scan a picture into word97 using my HP 4370 ScanJet. Could not find option of "From Scanner" under "Insert" --> "Picture". Apparently I must need some sort of Word97 Add-On. What and where is the add-on? Is it on the Office97 CD? Same applys to Excel97. Also, does microsoft sponsor a Word97 / Office97 discussion group? If so, would appreciate a link. "PSRumbagh" <PSRumbagh@discussions.microsoft.com> said this in news item news:39100DC1-A7EE-4679-881D-526BAA386620@microsoft.com... > I want to scan a picture ...

Access 97/2000/2003 comparisons
I have a rather large application that uses an access 97 database (DAO). We also have a version that works with access 2000, Oracle, msde, and SQLServer (ADO). We would like to retire the DAO version of the product, but there are places where the ADO version is much slower compared to where we run DAO seeks (very noticeable when looping). So, I have a few questions. 1. Are there any tips/tricks to speed up ADO queries to compare with DAO seeks? 2. Would there be any benifit in using access 2003 over previous versions of the software besides the added features (xml support, etc). 3...

Using later version of microsoft access
Hi, I've got access 2000 on my computer. When I go to open a database someone sent me I get an error message : this database is in an unrecognized format. The database may have been created with a later version of microsoft access. Is there any way I can open and use this file (short of upgrading to later version of access)? If you do not have Access 2002 or 2003, ask the person to save it in Access 2000 format for you. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at m...

no access to send internet email
Hi, Exchange 2003. Can a mail enabled user be restricted to send internal email only and not internet email? Nich Hello, > Exchange 2003. Can a mail enabled user be restricted to send internal email > only and not internet email? yes, that is possible. There are multiple ways to archive this goal. Depents on your infrastructure,too. If you have mailing to external over an SMTP Connector, try this: First look into your SMTP Connector, you will find Delivery Restrictions there. It is self explaining. If you have trouble with that or you won't find it, then i will need additi...

Using Company Wide Mail Templates.
Hi, I do not know if i am at the right spot here, or if it is evne possible, but i got the following question. My boss would like me to make sure that every outgoing mail has the same looks. It starts by adding a signature that is the same for everyone, except with ofcourse personalized information. This was easily done by giving everyone a signature. The next question is however, to put the head of our website, also above our mail. This means that every user that sends a mail, the mail will have a nice header, underneath that header, the mail is typed, and then its ended with the si...

Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a range based on a number provided in another cell. For example; if the number 10 is in cell A1, then cells A20:A30 would be selected when I run the macro. If the number 6 is provided, then cells A20:A26 would be selected. Not sure where to start, so any help is appreciated. this may do what you want range("A20").Resize(range("A1").Value+1).select -- Gary Keramidas Excel 2003 "TEK" <TEK@discussions.microsoft.com> wrote in message news:DA9FFF99-FC28-...

how create Quota filter in WIndows 2003 R2 using Script
Hi all I need create quota filter in Server 2003 R2 using vbscript. quota filter should be applied to directories and not by users. I searched information about it on google without success. thank's in advance Daniel Hi Daniel. First you need open your FSRM (File Server Resource Manager), then you create a quota template, you must specify if your quota is "software" (just monitoring, but never deny the user) or "hardaware" (deny users when they use 100% of the quota), you must specify if you want send e-mail to user when this user use...

GP SP#2 hangs with sa and Collections Issue
I just installed 8.0 SP#2 (ran the script that it says to run cuz we had upgraded from previous version to remove dups in smartlist tables) and when I log into GP as sa, it hangs and CPU sits at 100%. When I was able to log in previously to SP#2, I constantly received errors about the CN_Collector_MAIN table with invalid column names etc. I've deleted the table, then re-ran the create tables, but it keeps coming back with this error. I've even gone into file > maintenance > sql and deleted and recreated the table, but then get "number of results doesn't match ...

Word 2004 and kyocera printer issue
Hi, I am running a fully patched MAC OSX.4 machine with Office 2004 fully patched. I have installed the latest Kyocera OS X English 10.2 drivers from the kyocera website, for KM7530 model. The driver installs a job accounting feature in the printing presets for that particular printer. The function will work fine for every program other than word, word will not allow you the option to enter a pin code. all the features seem to be greyed out. If i reinstall and go immediately to anotherr program such as Eudora or Firefox or even Excel I can enter and lock the pin number in and it will print...

Using Publisher 200 with Publisher 2003
How do I covert PUB2000 documents to Pub2003 documents and vice versa? Pub 2003 can open anything, no conversion necessary. Going backward is a bit trickier. File - Save As and chance the file type to a Pub 2000 file. Possible problems can arise if you've used a feature that was not available in the 2000 version and your file size will grew immensely. -- JoAnn Paules MVP Microsoft [Publisher] "nasuco" <nasuco@discussions.microsoft.com> wrote in message news:500C7A7A-4026-434C-8CC2-2DFDB69D81C4@microsoft.com... > How do I covert PUB2000 documents to Pub2003 do...

Migrating Exchange servers
We are in the process of migrating to a new exchange server. The issue we are having is transfering the user's outlook (xp, 2k) address book/contact list to the new server without manually having to log into everyone's computer and pointing their address books to the new server. Is there a way to do this authomatically server-side? You're moving the mailboxes, right? The user's "address book" is the Contacts folder in the mailbox. So, there's nothing extra to move. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for ...

Security Role Issue 03-16-05
Anyone know why a User assigned to only 1 custom Security Role that has restricted access for all Core records set to the "User" level?, e.g. the user is assigned the "User Read Lead" privilege, they should only be able to read Leads that they own or share. However, it doesn't seem to be working, as if this user selects the "All Leads" View, the not only can read other users' Leads, but can also modify them! Again this User is only assigned to this 1 Role. Thank you, BryanK Bryan, This is a common problem. How long ago was this role created? Someti...

upgrading from Access 97 to Access 2007
I designed a database (forms, reports, et al) several years ago in Access 97 and it continues to work well. I've just received a MS Office Professional 2007 and wonder if it is time to migrate my data into the new program. I've attempted two or three times to do this in Access 2002 and I keep getting error messages along the line of "...corrupted file..cannot be opened by Access 2002 (or some such message)..." The help radio button opens up a box which suggests I do some programming in Virtual Basic to perform my transfer task. The easy way out, of course, is to sti...

Excel and Access
Hi All, I admit I am a complete novice on this aspect of using Excel. My requirement is as follows. I have an Access Database called nt1.mdb on drive D: in which there is one table (Table1) of data, indexed on column1 I wish to connect to this database and search the contents of Table1 for a value in column1 that has been entered into an Excel userform. The values of the other columns in Table1 should be returned if the value is found. How do I connect to the mdb, do the search and read the resulting values from the table? Any help gratefully received. Cheers There's sample ...

How to use different return email addresses
I use outlook 98. I have a mailbox with three aliases. People sending me emails can use any of the three email aliases and the email will arrive in the same mailbox. Accessing the mailbox once will retrieve all messages regardless of which alias was used. If I reply to these emails though, I want the recipient to think that the email has come from the alias that they originally used. What outlook always seems to do is use the email address of the service that is listed first in Tools->Services->Delivery. Is there any way Outlook can be set up so when I reply to a given email, my email ...

Change default export to Excel location
Hi, Does anyone know how I might be able to change the default location for exporting tables, queries, etc. from Access to Excel? It defaults to My Documents, which I can't stand because it forces me to drill down to find the spreadsheet. I'd rather that I could set it to go to my desktop. I've looked in the Access settings and registry, but could not find where to make the change. Any help is appreciated. Tony, Look at the TransferSpreadsheet method (in Help)... using that you can put any path you wish. -- Gina Whipp 2010 Microsoft MVP (Access)...

Security/ Access Levels
Hi, Can someone please help me with this MS CRM security/ access level question before I go completely mad trying to figure it out? I want to be able to restrict who can access certain account records (e.g. account records for our customers). For example, I don&#8217;t want telesales people to be able to access our customers account records. But I do want to give them access to other account records. I&#8217;ve tried restricting access at a user level and at a business unit level but cannot get either to work. If I set a particular users role to only access account records that they...

Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the workbook. Upon returning to work on this project, when selecting the chart menu to work with my source data, the source data is grey and not accessible. What might be causing this and can I correct it? It's a pivot chart. As soon as it's created, it's linked permanently to the pivot table, and you cannot change the source data. you cannot add more data that's not in the pivot table to the chart, nor can you remove data that is in the pivot table from the chart. - Jon ------- Jon Peltier, Microsoft...