Hi Rebecca,
For question 3, do not let users direct access to the
Queries but create a form with the data source as a
Query, and set the Form's properties for display only.
That is,
Allow Edits = No
Allow Additions = No
Allow Deletions = No
Data Entry = No
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Hi Rebeca
>
> Nice of you to join us. I have no trouble understanding your English.
>
> A good place to start learning about ribbons is right in our Links folder. Go to Links> Access 2007 Links. Look for all the links that start with "Ribbon".
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Rebeca Muller <becaml@> wrote:
> >
> > Hi everyone !
> >
> > I'm a begginer brazilian user of Access 2007 and I just found that group that may be helpfull with some doubts.
> >
> > First of all, I'm sorry for my bad english. I hope its possible to understand what I write.
> >
> > I have 3 doubts to start my participation in this group:
> >
> > 1. How to hide the start tab?
> > I can easily define a custom menu bar. However, after creating my menu options, I see a standard Start tab. I dont't want to see in my menu bar tabs not created by me. So I ask you how to hide the Standard Start Tab which provides options to copy, paste data and other basic features.
> >
> > 2. How to create a customized tab?
> > In the attatched example, you can find two tabs: "Início", the standard "Start tab" and "Sumplementos", another standard tab which all my options are subordinated.
> > It works, but I would prefer to place my itens in another structure of menus. Something like:
> > Tab Search
> > Menu project
> > Item Add
> > Item remove
> > Menu task
> > Item Add
> > Item remove
> >
> > Tab report
> > Menu project
> > Item Weekly monitoring
> > Item Pending tasks
> >
> > In other words, I desire to create my own structure not subordinated to "Suplementos", the standard tad for customized itens.
> >
> > 3. How to show queries without allowing direct insertion in table?
> > I have created forms to deal with data insertion. Afterwards, I created queries to return selected data from table. Yes, as you can see in the attatched example, I was able to create queries. However, I expected users could only see data in query. The used mechanism allows also to insert new data.
> > So I ask how to create a query only to show data without allowing insertion?
> >
> > Thank you everybody for your atention !
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Tidak ada komentar:
Posting Komentar