How can I switch the keyboard to English (or to any other) from Access ?
Thanks in advance
I am trying to edit the X, Z, and ZZ reports and am having troubles.
Here is what I have added:
Section: Sales Calculations
<ROW> "Sales Calculations" </ROW>
<Row> "Net Sales|" Report.Department.Sales </ROW>
<CONDITION> HideZeroTaxes </CONDITION>
<FOR each = "ReportTax">
<CONDITION> Report.Tax.Total <> 0 </CONDITION>
&...HotKey registry Edit
The memory errors that I was finding were caused by the
registry. The KB files: 907651 recommends this edit.. but
I can't make the change. I would sure appreciate some
The issue is that my registry does not have the \PST in this Hotkey
2. Click Start, click Run, type regedit in the Open box, and then
3. Locate and then click the following registry subkey:
4. On the Edit menu, point to New, and then click DWORD Value.
5. Type UseLegacyCacheSize, and then press ENTER.
6. Rig...Excel to Word : Paste special>Paste Link> Excel Chart Obj doesn't
When I copy a chart from an Excell 2007 file and
paste it as: Paste Special > Paste link > Microsoft Office Excel Chart Object
I get a blank white picture (with gridlines in middle and a red (x) in the
top left corner). It does not show correctly. However, the link is working
I noticed that if I paste the same chart with 2700 rows of data the chart
shows properly. But when I go above the 2700 rows of data the chart does not
when I pasted the chart with the original 47000 rows of data it was not
diplaying proper...How to calculate the text length in an edit box?
Hi to all,
How can I detect if the text in an edit box control exceeds the edit box's
what I did without success:
// Get the width of the edit box
TRACE("Rect Size : Width=%d; Height=%d\n", rect.Width(), rect.Height());
// Calculate the width of the text
pDC = m_myEditBox.GetDC();
size = pDC->GetTextExtent(sString);
TRACE("textSize (Logical): cx=%d; cy=%d\n", size.cx, size.cy);
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???
&...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...Database name added to link tables!
I am a very new Access database user.
I am using the Microsoft Access function called “Get External Data” to
create link tables to an Oracle 11 G R2 database. My problem is that Access
is adding the database name to the names of all the link tables instead of
just creating link tables with the original Oracle database name. Eg a table
on the Oracle database is called “com_user” but is created by Access as a
link table called “databasename_com_user”
Unfortunately all my automated test scripts that use the Access link tables
fail because they do not recognize the link table n...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...Office 11.4.3 update breaks entourage
Is anyone else having problems with the latest office update? I updated and
now Entourage crashes on exit and I have to use force quit. I've deleted the
preferences but that didn't help.
Yes, there are sporadic oddnesses for a tiny fraction of users who update to
the latest update.
Download the latest Combo Updater for Mac OS X and re-apply that. It seems
to cure a variety of these ills :-)
It won't hurt to Rebuild the Entourage Database also, as described in the
On 11/3/07 5:00 PM, in article C21A1042.email@example.com,
"Jason Mc...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...How do I integrate RMS with a Web Store 2nd edition
I want to automate web orders into RMS and RMS inventory pricing into a web
I would appreciate any advice, that you are willing to share!
my partner is not verry helpfull like most of the parners
First please dont group all partners in the same catorgory. Just like all
store owners are cheep and will stab you in the back for price and then
whine about it not working.
Talk to store front nice package but pricey.
"jack@hosiery" <firstname.lastname@example.org> wrote in message
news:6708FB33-BEF5-40FA-9A53-A0C6AF609416@micr...finding all link, hyperlinks in a workbook
ile:///\\animal\shared\Accounting\DEBBIE '05-'06\ADESOGAN.xls - '61'!A1
this is an example of one of my links inside one of my workbook. it leads to
another page in the same workbook. i have about 26 workbook with about 31
worksheets in each. each workbook is independent of each other, there should
be not link leading out of the workbook itself. i think i may have some links
leading out and i can't locate them. there are so many links in each
workbook. i tried the suggestion of downloading the FINDLINK.xla but it
found no links anywhere in the workbook...lol. just t...Update Data
I need to upload data from PeopleSoft 8.9 on a regular basis to an Access
Database. As this is employee data and changes regularly I need to be able
to update the records with new information for employees already in the
system. I would like to link the two databases directly but our ISD will not
allow me to do so, which means I am stuck running a query every week and then
uploading the data.
Is there anything I can do that will allow me to update the old info with
the new? I don't want to simply write over the table every week because I
would lose my relationships in numerous...FWD: Watch these corrective update from M$ Corporation
Content-Type: multipart/related; boundary="sjrajwyoigtwrop";
Content-Type: multipart/alternative; boundary="cfrfxggybtixigoyx"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
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...Edited an attached file to a msg, saved the file. Edits are gone
I opened an file attached to an email msg, made edits, and clicked on save on
the file itself. I closed the email message, and edits are gone. I thought
Outlook would save the file in a temporary folder, but I cannot find the file
anymore. where does it save the file?
What if you open the e-mail message and re-open the attachment in it. Do you
see your edits there?
Ben M. Schorr, MVP
> I opened an file attached to an email msg, made edits, and clicked on save on
> the file itself. I closed the e...How can I make a linked table read-only
I have an XL file linked as a table to my Access file. I want to make
the table read-only, but can't figure out how to do it. Can anyone
advise me on this?
I can not make the XL file itself read-only in the file system.
Others may want to make changes to it. I don't want to import the
data -- I want to keep it as a link. I am really wanting to make sure
no one makes any changes to the data from within the Access file.
- Paul Schrum
I've never been able to change data in a linked spreadsheet.
On Jun 13, 3:08 pm, Paul Schrum <paul.sch...@gmail.com> ...EasyFilter Add-in update
Together with Norman Harker and the late Frank Kabel I have create EasyFilter 2.0.
This version have a special Date tab with a lot of Date filter options.
I hope it is useful for a lot of Excel users.
This Version of EasyFilter is dedicated to the memory of Excel MVP Frank Kabel.
We will miss him very much.
You can download it here
Please read the Superb User Guide made by Norman Harker
If you have problems or suggestions please let me know.
Ron de Bruin
Regards Ron de Bruin
...Access 2007: Cannot edit and save access 2000 reports with wherecondition
Just upgraded from office XP to 2007.
When trying to edit a ms access 2000 database report including
"whereconditions", access asks for saving changes, but the report is still
open and nothing is saved. The only viable option is to exit without saving.
A "standard" reports without filtering works without any problems.
"DoCmd.OpenReport stDocName, acPreview, , "[tblNonConfLog]![DateOccurred] >=
" & OrderDate"
Anybody else experienced this - or has a suggestion for a solution ?
Thanks in advance,
FYI: Solved this issue by delet...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
...Powerpoint 2007 links change from drive letters to UNC paths
We recently upgraded to Office 2007. Whenever we save a Powerpoint
2007 that has excel links to files on our network, all the links
change from f:\filesystem to \\ca.domain.com\filesystem. After we try
to update the links that have changed to UNC paths, we get the
following error: "The linked file was unavailable and can't be
updated". I have been unable to find a fix or workaround for this
other than to take the hour to update all of the links in the affected
presentation. Has anybody else seen this issue and more importantly,
is there a fix or workaround for this.
...Mappings link error
When clicking on mappings for any entity, I am receiving this error:
Exception of type 'System.OutOfMemoryException' was thrown
The task manager shows a memory Commit Charge: 4203M/5970M.
Any help on this would be appreciated.
Second quick points, I'd check the amount of availible disk space, and also
look in the Event Log to see if this provides any further informatioin.
If your still having trouble with the issue - post the entry from the Event
Log onto the board and we should be able to determine what is causing the
Kind Regards, Paul Mc...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...Edit Data with a Data Access Page
Hoe do I set a Data Access Page to allow data edits and entry?
Common reasons why a DAP doesn't allow editing of the data:
You must define the Unique Recordset property for the page's section that
has the data.
You must have an element bound to the table's primary key field. It can be
hidden, but it needs to be on the Data Access Page if you wish to edit data.
You must use an updatable query for the recordset (note: Data Access Pages
are more picky in what's updatable and what's
not -- a query that works in a form may not work in a page).