Hi, Matthew.
[color=blue]
> I know that most people who
> try to answer others' questions look for unanswered questions (That's what[/color]
I[color=blue]
> do).[/color]
Me, too.
[color=blue]
> So when that person responded essentially with "use autokeys" when I
> already said I tried that made my question looked like it was answered[/color]
when[color=blue]
> it was not.[/color]
Hans-Joerg thought he knew the answer and jumped at the opportunity to help
someone in need. (Don't we all? And occasionally we miss the target.) His
news reader is in German, so please realize that he may have mistranslated
part of your post.
[color=blue]
> It eseentially wasted my post.[/color]
Well, realize the beaucoup bucks you are saving by not hiring an expert
consultant to be "on call" every time you need a little help, then swallow
your chagrin and repost the question with a comment that you've tried the
previous solution, but it's not working in your situation. Most of us have
experienced this "trial and error" phase, but in the end a suitable solution
is found -- sometimes many solutions. And when you do find that solution,
pat yourself on the back for being smart enough to know where to find the
quick, reliable answers -- for free.
[color=blue]
> I do thank you for your
> response.[/color]
You're welcome. An apology to Hans-Joerg would be appropriate, too.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Matthew Wells" <MWells@FirstByte.net> wrote in message
news:3YC8d.4590$Vm1.12@newsread3.news.atl.earthlin k.net...[color=blue]
> I appreciate all attempts to answer a question. I know that most people[/color]
who[color=blue]
> try to answer others' questions look for unanswered questions (That's what[/color]
I[color=blue]
> do). So when that person responded essentially with "use autokeys" when I
> already said I tried that made my question looked like it was answered[/color]
when[color=blue]
> it was not. It eseentially wasted my post. I do thank you for your
> response.
>
> Matthew Wells
>
MWells@FirstByte.net
>
>
> "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SP AM> wrote[/color]
in[color=blue]
> message news:jdB8d.8538$1g5.3855@trnddc07...[color=green][color=darkred]
> > > I'm reposting because an idiot replied without reading the whole[/color][/color]
> message.[color=green]
> >
> > Hi, Matthew -- who can't even spell his own name correctly, to wit:
> >[color=darkred]
> > > Matthewh Wells
> > >
MWells@FirstByte.net[/color]
> >
> > First, no one is required to answer questions in this News Group. Any
> > answer received is freely given and the recipient can be grateful for[/color][/color]
the[color=blue][color=green]
> > efforts made, but this isn't required, either. Any answer given can be[/color]
> from[color=green]
> > an expert or a complete novice, or someone who falls somewhere in[/color][/color]
between.[color=blue][color=green]
> > Some answers are mind-bogglingly brilliant and some answers are wild
> > guesses. Unless one is paying for the expertise, the expertise is not
> > guaranteed. All readers of every post need to keep this in mind.
> >
> > Second, your attitude is likely to prevent others from bothering to[/color][/color]
answer[color=blue][color=green]
> > this post and possibly any future posts of yours, as well.
> >[color=darkred]
> > > While in form view, how do you prevent someone from using Ctrl+, (ctl[/color][/color][/color]
+[color=blue][color=green][color=darkred]
> > > comma) or Ctl + . (Ctl +period) to get to design view.[/color]
> > <SNIP>[color=darkred]
> > > I tried using AutoKeys to remap it, but I keep
> > > getting "Invalid Syntax" or "Invalid keystroke combination". Most of[/color]
> > these[color=darkred]
> > > new hotkeys are really for developers and we should be able to stop[/color][/color][/color]
end[color=blue][color=green][color=darkred]
> > > users from using them.[/color]
> >
> > Access doesn't provide for every possible key combination for AutoKeys,
> > including the <CTRL><,> and <CTRL><.> combinations, as you've[/color][/color]
discovered.[color=blue][color=green]
> > These key combinations aren't intended to be mapped for anything but the
> > switch to Design View and switch back to Form View.
> >[color=darkred]
> > > I really don't want to go to every form and write
> > > code for the KeyPress event. What is the best way to stop this key
> > > combination?[/color]
> >
> > The best way to prevent the users from switching the form to Design View[/color]
> and[color=green]
> > back is to convert the *.MDB database file into an *.MDE database file
> > before distributing the database front end to the users. The[/color][/color]
second-best[color=blue][color=green]
> > way is to apply user-level security and remove design permissions to[/color][/color]
these[color=blue][color=green]
> > forms for the users and the groups that these users belong to.
> >
> > HTH.
> >
> > Gunny
> >
> > See
http://www.QBuilt.com for all your database needs.
> > See
http://www.Access.QBuilt.com for Microsoft Access tips.
> >
> > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> > will be forwarded to me.)
> >
> >
> > "Matthew Wells" <MWells@FirstByte.net> wrote in message
> > news:j8z8d.4463$Vm1.2033@newsread3.news.atl.earthl ink.net...[color=darkred]
> > > I'm reposting because an idiot replied without reading the whole[/color][/color]
> message.[color=green][color=darkred]
> > > I've tried autokeys and it isn't working for this combination.
> > >
> > > Please read on.
> > >
> > > While in form view, how do you prevent someone from using Ctrl+, (ctl[/color][/color][/color]
+[color=blue][color=green][color=darkred]
> > > comma) or Ctl + . (Ctl +period) to get to design view. I have all the
> > > normal properites turned off (Access special keys, F11, etc) but[/color][/color][/color]
nothing[color=blue][color=green][color=darkred]
> > > seems to stop that one. I tried using AutoKeys to remap it, but I[/color][/color][/color]
keep[color=blue][color=green][color=darkred]
> > > getting "Invalid Syntax" or "Invalid keystroke combination". Most of[/color]
> > these[color=darkred]
> > > new hotkeys are really for developers and we should be able to stop[/color][/color][/color]
end[color=blue][color=green][color=darkred]
> > > users from using them. I really don't want to go to every form and[/color][/color]
> write[color=green][color=darkred]
> > > code for the KeyPress event. What is the best way to stop this key
> > > combination?
> > >
> > > Thanks.
> > >
> > > Matthewh Wells
> > >
MWells@FirstByte.net
> > >
> > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
