Hi Rebecca
Me again. I just checked on the available properties
for Queries and found that the you can set the
RecordsetType to Snapshot. I have never used it but
it will do exactly what you asked for.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> 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