Show Access Print Dialog to Ask for a Printer
Using Access 2002
I used the command wizard to create a button on the form to print the form's
currently selected record. The record prints fine, but it does not allow
selecting of a printer. I want to let users select a printer, and then use
the code that the Toolbox Wizard created to print the selected record (code
Private Sub cmdPrint_Click()
On Error GoTo Err_cmdPrint_Click
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
...problem with resizing
I'm writing a MDI application. Child window is splitted in three panes. In
the one pane I've got a FormView with some buttons. How to do, that this
FormView was in the center of a pane (even during resizing )? And the second
problem, how to do, that during resizing, splitters dividing window were
always in the same places?
Please, help me. I would be appreciate.
...MSExchangeTransport EventID 929 #2
Every hour I get the same messages in the Application Event Log on our
Exchange server. The messages are as follows:
Failed in reading Connector's DS Info Process Id: 1280 Process
location: C:\WINDOWS\system32\inetsrv\inetinfo.exe ConnectorDN:
CN=Connector for Lotus cc:Mail (TLBEXCHANGE),CN=Connections,CN=First
Routing Group,CN=Routing Groups,CN=First Administrative
For more information, see Help and Support Center at
http://go.microsoft.com/fwli...data entry and saves it to sheet 2 #2
Basically I need a simpler data entry with submit button and saves it
on the sheet 2.
I have 2 sheets:
1st sheet would be entry fields that I would enter data on, such as:
Account Number, Company Name, Product, etc.
after entering those fields I would just hit 'submit' or 'enter' then
it says on Sheet 2.
I really would like to impress my boss... so your help is much
This would require VBA, but the actual code depends greatly on the layout of
your data. If you wish, send me direct via email a small file that clearly
shows the layout of sheet 2 (colum...Disabling Esc and Enter in a Modeless dialog box
I am having a dailog based application in which another dialog is embedded
as a child.The settings of this dialog are child with no border and visible.
The child dialog is created using the "Create" function of CDialog and hence
is modeless. On press of Esc or Enter the dialog gets destroyed. I want to
override this normal behaviour. How can this be done? !!!
Thanks & regards,
a couple possibilities.
1. change the accelerator key definitions to remove those key mappings
2. override the onok and oncancel member functions of cdialog and make yours
not call the cdialog ...How to fix keys t s h c v non-responsive only in Excel?
When I press keys t s h c and v in Excel 2003, nothing happens. If I use the
Shift key, then the keys work, but only as caps. The keys work fine in other
Office applications, and worked fine in Excel 2003 until this morning.
Interesting. Try the stuff at http://www.smokeylake.com/excel/vfaq.htm,
"Excel acts generally goofy."
"bareedy" <email@example.com> wrote in message
> When I press ke...SMALL function #2
Good Morning Eveyrone,
Using Excel XP. I would I write the formula =SMALL(A1:A100) that would find
the lowest numbers that are NOT zeros.
Thanks for you help,
Thanks...got it working..
"������" <firstname.lastname@example.org> wrote in message
I am using OpenGL in my MFC app. The problem is when I resize the
window from the left or top border the whole scene of my OpenGL moves
even before my OnPaint event handler is called and when my OnPaint is
called after this it repaints the scene so this produces a flicker. If,
however I resize the window from the right or bottom border this
problem doen't occur. Can anybody please tell me what is happening?
...Difference between 2 excel spreadsheet
Someone has given me two exported results from a query in
Is there any easy way in Excel to find out whether they
are exaactly the same (ie all rows and columns matched) ?
Here is one way (but, there's probably a better way):
Load both csv files into the same workbook either as seperate sheets o
on the same sheet. I would probably use seperate sheets so that I coul
reference any differences a little easier. (A1 on sheet 1 should = A
on sheet 2)
Then insert a "difference" sheet (SHEET3) and in A1 use this formula:
Then sel...Macros Disabled #2
I have a user running Excel 2000 on a Win 2000 sp3
machine. She has a file with several macros. The file is
a form with data fields for names, numbers, etc. As soon
as she enters any data and clicks the tab button to go to
the next field, she gets an error message that the Macros
have been disabled and the Tab key won't go to the next
She emailed me the file and when I open it on my machine
(same setup), I first get asked if I want to enable the
macros. I say Yes - and everything works fine. I emailed
the file back to the user, but it's still broken on her...Bitmap resize on same DC
I am a little be confused!
I have a custom control with a bitmap inside
I create the bitmap with this code
CClientDC dc(this) ;
if (m_dcGrid.GetSafeHdc() == NULL)
m_pbitmapOldGrid = m_dcGrid.SelectObject(&m_bitmapGrid) ;
and in OnPaint i have:
CPaintDC dc(this) ; // device context for painting
CDC memDC ;
CBit...Office 2003 outlook does not have newsgroups feature #2
Does anyone knows Office 2003 outlook have newsgroupgs feature. Outlook
Express has newsgroups feature but not Outlook.
Outlook has never had a newsgroup reader built in. It will launch a
news-only mode OE session when you use the menu items therein.
> Does anyone knows Office 2003 outlook have newsgroupgs feature.
> Outlook Express has newsgroups feature but not Outlook.
There's a third party product in beta called NewsLook in beta. Its not
ideal, yet, but functional.
The gr...CStatic derived dialog and auto-resize
I would like to add auto-resizing feature to my Cstatic derived control. I
mean when I load a bitmap I would like to adjust size
I tried to SendMessage WM_SIZE but it doesn't work.
>I would like to add auto-resizing feature to my Cstatic derived control. I
>mean when I load a bitmap I would like to adjust size
>I tried to SendMessage WM_SIZE but it doesn't work.
You can resize a window by using the SetWindowPos or MoveWindow APIs.
MVP VC++ FAQ: http://www.mvps.org/vcfaq
...portfolio views #2
hello, im using 2004 and have created portfolio's using the customized view
option in the Portfolio Menu. This way i can allocate my investments into
different portfolio's, but i cant see a way to delete or rename customized
views, anyone know how to?
In microsoft.public.money, Jex wrote:
>hello, im using 2004 and have created portfolio's using the customized view
>option in the Portfolio Menu. This way i can allocate my investments into
>different portfolio's, but i cant see a way to delete or rename customized
>views, anyone know how to?
I'm trying to determine if I have any corruption in some of my user's
mailbox's. Specificaly their inbox. Does anyone know any tools for
determing corruption with exchange and specificly a user's inbox/mailbox.
MVP - Exchange
NEW blog location:
"George Schneider" <email@example.com> wrote in message
What setting keeps users frombeing able to open anyone's mailbox? Is it
in Active Directory?
Store (mailbox) permissions.
MVP - Exchange
NEW blog location:
"nick" <firstname.lastname@example.org> wrote in message
> What setting keeps users frombeing able to open anyone's mailbox? Is it
> in Active Directory?
Well, they should not have this by default, so if they do, it's because of
some ...Who could tell me? #2
I know when the container is running,it want to
search the COM in register table and load them,I want
to know that the word,excel and ie where they need to
...3M SandBlaster 423-120 Flexible Sanding Pad, 3.7 x 9.25-Inch, 120-Grit, Rectangle, 2-Sheet
Best deal: http://discountadvisors.info/index.php?id=B000GLHW3Q
Sandblaster, 2 Pack, 120G 3.7" x 9" Large Flexible Abrasives Detailed Sandpaper, Lasts 10 Times Longer Than Normal Sandpaper, Extreme Durability, Ultimate Comfort, Sandpaper Can Also Be Used On Detailed Flexible Abrasives Tool True Value #630-485.
3M SandBlaster 423-180 Flexible Sanding Pad, 3.7 x 9.25-Inch, 180-Grit, Rectangle, 2-Sheet:http://discountadvisors.info/index.php?id=B000GLE1OO
3M SandBlaster 413-220 Flexib...SP2 Fix
I cannot install SP2 fix. I keep getting a
message, "Office hotfix Intaller incountered a problem.
Sorr for the inconvenience"
Does anyone know a fix for this or where I could get one?
...Dialog Box: Which control gains the focus?
extern CMyDialog* pDial;
Which control has the focus?
In a project developped with Visual Cpp version 5 & 6, it's the last control
having the focus when dialog was visible.
An other project developped with Visual Studio .Net, it's always the
first control (first in tabulation order) which has the focus.
With or without MFC, the behaviour is the same.
Who knows the reason why?
What is exactly behind pDial->S...Recurring Deposits #2
Is there a way to create recurring deposits in Money Essentials for Vista? I
can't seem to do this. I can create recurring bils without any problem though.
You would need to enable the 'advanced bills/deposits' area. I've not used
Money Essentials, so don't know whether that is an option in that particular
version of the product.
Glyn Simpson, Microsoft MVP - Money
See http://money.mvps.org/faq/default.aspx for tips and fixes for MS Money.
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx
I do not respond to any uns...CRM 1.2 Activitys
For some reason my companies CRM database has become corrupt and there are
some invalid Activities listed in the ActivityBase Database. I have been
able to locate the invalid entries and was considering just manually
deleting them from the database, since deleting from the CRM interface isn't
working. Will manually deleting them just cause more headaches for me? If I
do remove the activities are there other tables that will need to have rows
manually removed also? I can seem to find documentation on how activities
are related to the other tables?
Manually updating the database is...auto resize text without resizing cell in excel
format|cells|alignment tab|check "shrink to fit"
...2 Domains, 1 Exchange Server
We're trying to go with 2 seperate 2003 domains, but with only one
Exchange 2003 Server. What would be needed for the domain that the Exchange
server is not in to access e-mail? We've contemplated having those users use
OWA, but would really like them to be able to use Outlook 2003. We're a
school district and want to segregate the kids domain from the administration
domain, but only have funding for one Exchnage server. Any ideas\help will
be appreciated. TIA.
This should explain what it requires:
"tj woo...How to resize a CTreeCtl when the dialog window is resized
Is there any documentation on how to do this? Or does anyone have any
>Is there any documentation on how to do this? Or does
anyone have any
You can handle the message WM_SIZE of dialog to change
the size of CTreeCtrl. Use message mapping.
Then call the MoveWindow function to change the size:
CTreeCtrl::MoveWindow(x, y, width, height)
>Is there any documentation on how to do this? Or does