You can also create a group with the needed privileges, then create one account for each person who needs the access, making them a member of the group.
Jim,
I guess my example was close but not close enough :)
The report still doesn't get the employee name. FYI, [Emp] is an unbound text box, which I assume is correct.
Howard
Jim,
Does that mean I have to code the report to start the form instead of the other way around? Or do I refer to the items I selected? Do I have to store them in a global variable & use that?
Ideally, I'd select employee in the form, click on a Preview or Print button & have my code dispaly...
Thanks Jim.
That's what I thought I would have to do.
I thought I'd try passing a parameter from the form to a test report first to make sure I could do it. I use the first employee selected & send it to the report (which I have open) using Forms![myformname]![textboxname] so the code looks like...
I've been asked to fix someone's form & report. The form lets users select a person or persons, then print a report for all selections. However, the report that's used is based on a query that prompts for the person's name. Can I pass the name (or names) as a paremeter so the prompt no longer...
Lonnie,
I think I've figured out how to do this but I'm sure I can learn from your method. Could you please send your sample database to me at shidlowsky@yahoo.com.
Thanks very much for the help.
Howard Shidlowsky
Unix Consultant
I want to let users select from a list whose source is a table. Do I have to use 2 listboxes for this, one showing the entries that haven't been selected & one with those that have?
Thanks.
HOward
I have a main report in Access 2000 with a number of subreports. I get the correct data in each of the subreports. The subreports are empty when there's no data to report; however, I would like to suppress (not display) the empty subreports. I tried setting "Can Shrink" to Yes where...
Online learning will replace the class room for people who are in remote areas or can't <br>get to a school/campus for some reason. These are the same people who turned to<br>distance education earlier (pre-Web) and made use of TV, radio and cassette based<br>courses. Online education will...
This is not a question for this forum but...<br><br>You want to create a linked list. Each object on the list describes a single block of<br>free memory. You will need to track the starting address of the memory block & its<br>size. You may need to store other information depending on your exact...
The attachment may be too large for the receiver.<br>
If possible, break the attachment into a number of smaller attachments,<br>
then try sending them in individual emails.<br>
<br>
Howard Shidlowksy
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.