User Profile

Collapse

Profile Sidebar

Collapse
fleece
fleece
Last Activity: Dec 29 '06, 03:39 PM
Joined: Nov 28 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • fleece
    started a topic Help on tricky permission
    in Access

    Help on tricky permission

    Hi, I need help on this tricky access permission issue:

    For my database, I want to allow users be able to edit his/her records, insert new ones and review other user's records but no edit. How to set up the permission? BTW, I do have users ID in my database.

    Thanks a lot for your help!
    See more | Go to post
    • fleece
      replied to Problem with report filter
      in Access
      Hi, Nico,
      Thanks for your reply. I tried to use IIF as you suggested. However, it won't show any criteria evenif there is some searching criteria. So I guess the Report.FilterOn is False. What's wrong? Very confused.
      Thanks again for your contribution....
      See more | Go to post

        Leave a comment:

      • fleece
        started a topic Problem with report filter
        in Access

        Problem with report filter

        I set up a form for searching criteria and pass the searching result to a report. On this report there is an unbound text box (=[Report].Filter) and shows the searching criteria. It works fine when searching criteria is NOT NULL. But when Seaching criteria is Null, it will show some incorrect default filter.

        I think the problem might be solved by using IIF( Report.filteron , Report.filter, Null). But I don't know how to set Report.filteron =True....
        See more | Go to post
        • fleece
          replied to Help on Conditional Format
          in Access
          Hi, Mary,

          Thank you very much for your reply. A further question: is it possible to set up one field which could either input text or insert hyperlink? Thank you very much for your opinion.

          Fleece...
          See more | Go to post

            Leave a comment:

          • fleece
            started a topic Help on Conditional Format
            in Access

            Help on Conditional Format

            Hi,
            In my database, one data's type is hyperlink but we could also enter text without hyperlink to anywhere else. Hence how could I set the cell's format conditioning on whether it is a real hyperlink or just plain text? In another words, if there is hyperlink in the cell, the color of of the letter would be blue, otherwise it would be black. I searched this website for my problem, but couldn't find the corresponding solution to it. Do you...
            See more | Go to post
            • fleece
              started a topic How to create a report based on a continuous form?
              in Access

              How to create a report based on a continuous form?

              I have a continuous form based on some selected criteria. Now I want to send the search results to a report. How could I do that? It's better if I could sort the results before export to report.
              Thanks for your suggestions.
              See more | Go to post
              • fleece
                replied to Link record beween forms
                in Access
                Thanks a lot for your reply. It works now....
                See more | Go to post

                  Leave a comment:

                • fleece
                  started a topic Link record beween forms
                  in Access

                  Link record beween forms

                  Hi,
                  I have two forms based on the underlying table. One is a data entry, and the other is a continuous form based on some searching criteria.

                  Now I want to add "edit" button to each record in the continuous form. This button could bring user to the appropriate record in the data entry form.

                  How could I do that?

                  Thanks.
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...