Duane, is there any sample code or databases on this Group site, or links that you can provide that will help me understand more about "Splash Screens" and "Sandbox Databases" etc.? In my Access 101 class we didn't cover much about startup options and user interface. I need to learn more about that. Thanks.
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> 2) Please explain Duane's suggestion: "Actually the anwer in 3. hould be minu one."
> Gina had an extra "s" in her line of code so I took out the "s" as well as removing all "s" from my explanation and my signature.
>
> If added back in, it would be:
>
> Actually the anSwer in 3. Should be minuS one S. The code line was correct.
>
> 1) I generally create a "splash" form that opens prior to my main menu. This form will check the connection to the back end, set some properties, display the application information, and contain a single command button to "Continue".
>
> 3) You can hold down the shift key while opening an Access database to avoid running any code that might hide the menues or other do other stuff.
>
> 4) Open a sandbox database and add a bunch of command buttons using the wizard while exploring the various options available. If you can do something through the ribbon, it can typically be done in code.
>
> 5) I always use forms. Some of my subforms might be datasheet view of forms.
>
>
> Duane Hookom
> MS AcceSS MVP
>
>
>
>
> To: MS_Access_Professionals@yahoogroups.com
> From: bradgriffis@...
> Date: Tue, 19 Jul 2011 06:45:45 +0000
> Subject: [MS_AccessPros] Re: Multiple User Issues
>
>
>
>
>
>
> Gina, the link has a lot of good information. I'm still working through it.
>
> I have a few more questions:
>
> 1) It looks like I need to insert a line of code somewhere to hide the ribbon. I'm a beginner with VBA and am a little confused about what to do. I did some research on the web and got myself even more confused. Where do I put your line of code?
>
> 2) Please explain Duane's suggestion: "Actually the anwer in 3. hould be minu one."
>
> 3) After hiding all the menus and toolbars, is there an easy way to make them "unhidden" if I need to make changes to the database?
>
> 4) I discovered that I can create a button to delete a record. That is something that I previously thought could only be done on the ribbon. I'm going to add a "Delete Record" button to my main data entry form. Since I like your idea of getting rid of all menus and toolbars, what are some other buttons I should create to make a good user interface? It sounds like you might have a standard way to set up your forms with some basic command buttons.
>
> 5) As you can see on my sample database, I have a "View Datasheet" button that allows users to view and change their records in datasheet view. Do you think that is a good idea, or is it best to have users do everything in form view?
>
> Thanks,
>
> Brad
>
> --- In MS_Access_Professionals@yahoogroups.com, "Gina Whipp" <classon@> wrote:
> >
> > Thanks Duane!
> >
> > Thanks,
> > Gina Whipp
> > 2010 - 2011 Microsoft MVP (Access)
> >
> > www.regina-whipp.com
> >
> > From: Duane Hookom
> > Sent: Monday, July 18, 2011 10:05 AM
> > To: Access Professionals Yahoo Group
> > Subject: RE: [MS_AccessPros] Re: Multiple User Issues
> >
> >
> > Actually the anwer in 3. hould be minu one
> >
> > Docmd.ShowToolBar "Ribbon", acToolBarNo
> >
> > Duane Hookom
> > M Acce MVP
> >
> >
> >
> >
> > To: MS_Access_Professionals@yahoogroups.com
> > From: classon@
> > Date: Mon, 18 Jul 2011 09:53:31 -0400
> > Subject: Re: [MS_AccessPros] Re: Multiple User Issues
> >
> >
> >
> >
> >
> >
> > Brad,
> >
> > Yep, Albert's link has been updated but I have not updated all of mine. Here you go...
> >
> > http://www.kallal.ca/Articles/split/index.htm
> >
> > 1. No need to worry about *Shared* because each database FE belongs to that person, at least it's never been a problem for me. However, for your peace of mind you may set the Default Open to *Shared*.
> >
> > 2. They don't have to have the FE on their desktop but it must be on their local or you still take a chance of corruption with multiple Users sharing the same file.
> >
> > 3. To hide the ribbon...
> >
> > Docmd.ShowToolBars "Ribbon",acToolBarNo
> >
> > 4. I do not give my Users a chance to use any of the menus or toolbars. They are stuck with the button I give them. In your case, I would check to see what they would like to do and see if that is an option I want then to do and then add it to the appropriate form.
> >
> > Thanks,
> > Gina Whipp
> > 2010 - 2011 Microsoft MVP (Access)
> >
> > www.regina-whipp.com
> >
> > From: Bradley
> > Sent: Monday, July 18, 2011 4:39 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Multiple User Issues
> >
> > Gina, thanks for your help! I studied your suggestions and links and have a few more questions.
> >
> > Please check your Albert Kallal link. It sounds like it will answer a lot of my questions, but it appears to be broken. Please re-send.
> >
> > My questions are pretty elementary, but bear with me. Currently, everyone in my department has Access 2007 installed on their PC's. I ran the splitter wizard at home on a test file to see how it works. It's easier than I thought. My questions are:
> >
> > 1) Does simply splitting the file and putting a copy of the front end on everyone's PC allow everyone to use the database at the same time, or is there something else I need to do to put it into "Shared Mode"?
> >
> > 2) Is it necessary for each user to copy the front end to their PC, or could they also create a desktop shortcut to the main front end file?
> >
> > 3) How do I get rid of the ribbon in 2007? I didn't know I could do that.
> >
> > 4) What are your suggestions and tips for setting the startup options and creating the best user interface? I also like users to work off the buttons on my forms as much as possible, but is there a place for limited menu/ribbon options?
> >
> > Thanks,
> >
> > Brad
> >
> > --- In mailto:MS_Access_Professionals%40yahoogroups.com, "Gina Whipp" <classon@> wrote:
> > >
> > > Brad,
> > >
> > > Let’s see how many of these I can knock off...
> > >
> > > 1. & 2.
> > > -Yes, the database should be split with the backend on the Server and the front ends on everyone's local. For more information see...
> > > Does everyone have their own front end? Are their front ends installed on their drive and the back-end on a shared drive? Is the database opening in shared mode? Perhaps the below will help...
> > >
> > > http://www.members.shaw.ca/AlbertKallal/Articles/split/
> > >
> > > http://allenbrowne.com/ser-01.html
> > >
> > >
> > > You may also want to take a look at MVP Tom Wickerath's article...
> > > http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm
> > >
> > >
> > > To handle the update of multiple front ends see...
> > > http://www.autofeupdater.com/
> > >
> > >
> > > If each user needs Access you can install the Runtime…
> > >
> > > Access 2007
> > > http://www.microsoft.com/downloads/details.aspx?familyid=d9ae78d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en
> > >
> > > Access 2010
> > > http://www.microsoft.com/downloads/en/details.aspx?FamilyID=57a350cd-5250-4df6-bfd1-6ced700a6715&displaylang=en
> > >
> > > 3. Ribbon not my area as I don’t load the ribbon. Users have to work off the buttons on my forms and that way I control what they can do.
> > >
> > > 4. The backend would be backed up by whatever you are using to back up the Server. I usually keep a copy of the front end in a subfolder of the backend folder on the Server just in case someone manages to crash their machine. I can either go in and load a new front end for them or tell them how to navigate to it and copy it to their local drive.
> > >
> > > Thanks,
> > > Gina Whipp
> > > 2010 - 2011 Microsoft MVP (Access)
> > >
> > > www.regina-whipp.com
> > >
> > > From: Bradley
> > > Sent: Saturday, July 16, 2011 2:51 PM
> > > To: mailto:MS_Access_Professionals%40yahoogroups.com
> > > Subject: [MS_AccessPros] Multiple User Issues
> > >
> > >
> > > Hello, I am creating a simple time tracking database for my department at work. It will be used by about ten people. I don't know anything about multiple user and security issues and have a few questions. Any advice you can give me will be helpful. I am using Access 2007 and my experience level is beginner. A zip file of the database (still in progress) is in the "PTS Time Tool" folder as "TimeTool_3."
> > >
> > > 1) How do I make the database available to multiple users at the same time? Currently, it can only be used by one person at a time.
> > > 2) Do I need to split the database? If so, how do I do that, and what do I need to know about making future changes to tables and objects?
> > > 3) A mid-level security arrangement is appropriate for my database. Currently, I have a simple "login form" password system, which is fine for now. How do I limit what users can do with the ribbon, and how do I keep them from making changes to tables and objects?
> > > 4) What is the best way to backup the database?
> > >
> > > Thanks,
> > >
> > > Brad
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar