How can I switch the keyboard to English (or to any other) from Access ?
Thanks in advance
...Visio 2007: macros are disabled
i have Visio 2007 pro.
i m trying to add a macro: tools > macro > macros...
but then the "create" button is disabled.
also the: tools > macro > record new macro... is disabled
possibly tools => trust center => macro settings...
"shemesh" <firstname.lastname@example.org> wrote in message
> i have Visio 2007 pro.
> i m trying to add a macro: tools > macro > macros...
> but then the "create" button is disabled.
> also the: tools > macro > r...send object macro
I am trying to send a report or form from access via.email in an excel format
so it can be edited and saved by another user. I am able to accomplish this
except that the excel sheet is not formatted the way the person wants is
there a better way of doing this or a different way that would have some kind
> except that the excel sheet is not formatted the way the person wants
What format is this person expecting?
It is a fancy thing that looks better than it works it has some colors and
and some drop downs. It wor...Keyboard
I need to catch the keyboard key`s ctrl+alt+e in my MFC application
how can I catch the combination of those three key`s???
How can I catch the F5 key???
For a normal key`s I use appwizard OnChar function or KeyDown.
hi, I guess you can try GetKeyState(VK_MENU) and GetKeyState(VK_CONTROL)
when you response the OnChar or KeyDown message.
> I need to catch the keyboard key`s ctrl+alt+e in my MFC application
> how can I catch the combination of those three key`s???
> How can I catch the F5 key???
&...Macro "stop recording" button
While I was recording a series of macros, I must have
inadvertently chosen to make the "stop recording" button
disappear from view. I could obviously stop the
recordings from Tools>Macros, but it would save me a
couple of clicks if I had the button back. I looked at
all the obvious Option screens, without success. Any
Answer from Tom Ogilvy on this problem
Start recording a macro, then right click on a blank area of a toolbar and
select the stop recording toolbar.
(or use View=>Toolbars from the menu)
then click the stop button.
Now when you record, the b...hook keyboard and send as other keyvalue
i have a problem to deal with global keyboard hooking .
my application has to deal with a special keyboard, whitch asking that when
press Shilft + A, it actually come out "#", Shift + B , it comes out "&"..
and when shift is not pressed, the A is still A.
i can not come out with the functionality no matter what..
i have to use global keyboard hooking since it is for the whole application
LRESULT CALLBACK keyProc(int nCode,WPARAM wParam,LPARAM lParam)
PKBDLLHOOKSTRUCT hook = (PKBDLLHOOKSTRUCT)lParam;
return CallNextHookEx(gHook, nCode, wPa...A List of Macro's
How can I create a List of Macro's with VBA.
Search the archives:
using the term "list of macros" and you'll find several ways, depending
on what you want to do with the list.
In article <uszbIwT#DHA.3292@TK2MSFTNGP11.phx.gbl>,
"Luc.Heyndrickx" <lucDitVerwijderenheyndrickx@skynet.be> wrote:
> How can I create a List of Macro's with VBA.
Here's the solution:
http://www.cpearson...Create an exel 2007 shortcut key
How do I create an excel shortcut key? For instance, I want to create a
shortcut key for Moving or Copying a worksheet. I added it to the quick
access toolboar, but cannot figure out to create a shortcut key for that
command. Thank you for your help.
Not sure why you need a shortcut key, when a button is already handy, but
here are the instructions from the Excel help file. You'll need to put the
command in a macro, then:
"To assign a CTRL combination shortcut key to run the macro, in the Shortcut
key box [click View Macros - select macro - click Options], type any
lowerc...KEYBOARD NOT WORKING
I know some people may help better if I give more
specific details to my problem.. So here goes:
My keyboard works correctly with any other application,
such as MSN, ICQ, Wordpad.. etc. However, when I open an
Office application such as Word or Excel, it doesn't seem
to type for me. I cannot type in the help section, can I
type in the document or in those toolbars at the top for
Fonts, etc. But if I specifically go to "Format >>
Font", then yes, I can type in it.
I have tried reinstalling Office already, that doesn't
work. The hardware is fine, I can still...I need help on a Macro
i really need to know how if i enter into cell F12 35 how can i get a
message box to appear with say "You need to restock" written on it and
the to buttons Yes and No?
Can anybody help me????????????????????????
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$F$12" And Target.Value = 35 Then
MsgBox "You need to restock", vbYesNo
Application.EnableEvents = True
'This is worksheet event code, which means that it needs...Outlook and XP Keyboard Access
I just had Windows XP installed on my machine and I am
having problems with keyboard access in Outlook 2002. I do
not use a mouse and I have my inbox set up with the
preview pane. Prior to XP I could get to my inbox with
CTRL+Shift+i and then tab around the panes (mail list,
preview pane and folders). With XP I can not get a
selection in any pane without turning off the preview pane
and then turning it on again. Which I then have to repeat
every time I use the shortcut to get back to the inbox.
This is making me very frustrated. Does anyone have a
Thanks in advance!
It m...Desktop shortcut
I know there have been several posts about this but can't seem to figure
out some of the answers.
I have lost, for some reason, the Create a Desktop Short cut from my
right click context menu.
I tried one thing and all I got was the Desktop icon on my Desktop. I
did more searching but can NOT find: "the file *Desktop (create
shortcut)* from the Default user folder."
I went to my User folder and there is no such item. Am I looking in the
And while I'm at it, what could I have done to remove it in the first
place. Don't want to do that aga...Startup from keyboard
Hi to you all
I have been using m/s XP for the last 5 years with computer set to start at
the touch of any key on the keyboard .
I recently got a new computer with Vista installed but can not remember how
I set computer up to do this. Can anyone jog my memory.
Thanks in anticipation.
This is the wrong newsgroup. Try the Windows Vista newsgroup. BTW,
what does Great Plains or GP or Dynamics have to do with waking a
computer up from sleep? ;-)
Microsoft SBF Specialist
6/19/2007 11:39:30 AM
> Hi to you all
...Macro Code ... Next Sheet
I have many many files where I want to change the name of
the Tab Sheets from whatever they are now to a new
name ... simply "Page 1", "Page 2", "Page 3" etc ... I
would like to do this with a Macro ... but need code ...
Select 1st sheet regardless of name ... rename to "Page 1"
Select 2nd sheet regardless of name ... rename to "Page 2"
Select 3rd sheet regardless of name ... rename to "Page 3"
The number of tab sheets vary so I assume Macro will
simply abend when it reaches the end ... Unless of course
you highly respected Wiz...HTML in a macro
Im using a Macro to create a new cell then add a little bit of HTML
code but for some reason excel doesnt like the code how do i get round
this , can someone help please
As ALWAYS, post your macro for assistance
Microsoft MVP Excel
"lennymos123" <email@example.com> wrote in message
> Im using a Macro to create a new cell then add a little bit of HTML
> code but for some reason excel doesnt like the code how do i get round
> th...How do I stop the control wizrd from creating embedded macros?
I want the control wizard to create VBA code, not embedded macros. I checked
the "Always use event procedures" box in the Access Options - Object
Designers, but the wizard still creates embedded macros instead of VBA code
(tried several combo boxes and command buttons on different forms). What am
What version of Access?
I've never seen the wizard create a macro, although I haven't used the
wizard in Access 2007.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"David Semon" <DavidSemon@discussions.microsoft...Shortcut Key or Macro for (Insert -> Entire Row)
Is there a shortcut key or macro I could do that would automatically
insert a new row? I'm getting tired of Right Click -> Insert -> Entire
Press these keys in succession:
[alt] I R
That's the [alt] key (which activates the menu)
then the letter I (which is the underlined letter in Insert)
then the letter R (which is the underlined letter in Row_
Does that help?
> Is there a shortcut key or macro I could do that would automatically
> insert a new row? I'm getting tired of Right...macro idea..
ok, i want to tidy up the way we discount items that we sell. i retail
plants, and when they are not looking their best i might take money off, e.g
2 pounds off a plant at 5.99. What we had been doing is creating another
product and calling it **reduced plant 3.99** and then sticking that label
over the original one. For obvious reasons that is not a good idea, stock
control, lack of knowing what plant has sold etc.
what i want to do is...
Make labels which say 2.00 off this plant, and when the till operater sees
the label they know to discount the item by 2.00. Is it possible for ...Touchscreen Keyboard
I am having to replace a machine with a new one. When I restore the database
I don't see the touchscreen keyboard that was created. Where is the file
located or how do I activate on new system?
In POS, Crtl-F6 "Screen"
You need to adjust the window sizes on both the Transaction Screen and
the Touch Screen so that the windows don't over lap.
The screen settings are one of the few things that are stored locally
rather than in the DB, so you have to reset them after installing to a
new machine. Slso, make sure that you reset the EDC settings in SO
Is there any lists of keyboard shortcuts, specifically a shortcut to clear
transaction in my checkbook.
Tim in Portland
A search for "keyboard shortcuts" in Money help yielded the following list.
But the quick answer to your question is "ctrl-M" will mark a transaction as
cleared in the advanced register. "ctrl-shift-M" will mark it reconciled.
Keyboard shortcuts allow you to quickly access and use features without
using a mouse.
Copy text CTRL+C
Insert today's date in the Date field CTRL+D
...Is there a keyboard shortcut for "paste values"?
or can I define one ?
I'm really using a lot of paste values, and it's pain in the *** to use
right click menu every time
( My real mail address: arvi.laanemets<at>tarkon.ee )
"Sirritys" <firstname.lastname@example.org> wrote in message
> or can I define one ?
> I'm really using a lot of paste values, and it's pain in the *** to use
> right click menu every time
It is quite easy to define a...Create new spreadsheet based on template from macro in Word
I am trying to put my Excel templates on a menu in Word along with my Word
templates, hoping that I can create a new spreadsheet based on my Excel
template. I have these two macros which I have tried with no luck:
Dim xlApp As Object
Dim xlWB As Object
Dim xlWS As Object
Dim cRows As Long
Dim i As Long
Set xlApp = CreateObject("Excel.Application")
Set xlWB = xlApp.Workbooks.Add("C:\Program Files\Microsoft
Set xlWS = xlWB.Worksheets(1)
Dim xlWB As Object
D...Lock keyboard and mouse #2
I want to lock the keyboard and mouse input for a specific
application, if the application is not used for a desired time. All
other application running on the same PC should be not affected. The
unlock process should work by putting in a password.
Have you thought about just popping up a modal dialog that asks for the
password. That will keep the application locked.
"Martin" <email@example.com> wrote in message
> I want to lock the keyboard and mouse input for a specific
> applica...Need Macro to manipulate the selected object on double clik.
I need this bad but can't take the time to learn visual basic etc.
I need to take a double-clicked object (or keyboard short cut) and:
1. Flip it vertically
2. Rotate 180 degrees
3. If I am now seeing the backside, then apply a cross-hatch without
changing the color or other properties.
4. Otherwise I am seeing the back side, (which is cross hatched), so remove
the cross hatch.
The selected object may be a group.
Thanks in advance.
...shortcut for WLM
Is any shortcut key for showing the main plan of WLM?
> Money is no problem
> The problem is no money
The main plan ?
"Find" <firstname.lastname@example.org> wrote in message news:3B123876-8FA9-4210-9678-34E0FE7C8425@microsoft.com...
> Is any shortcut key for showing the main plan of WLM?
>> Money is no problem
>> The problem is no money
a shortcut to show up the WLM's windows when is was min...