C / C++ / MFC

FirstPrevNext

Re: ado and excel User 98856-Jul-01 12:07 User 9885 6-Jul-01 12:07  Instead of using the ODBC driver for ADO, you can also use the - Microsoft.Jet.OLEDB.4.0 provider and use Engine Type as "Excel 8.0". There are examples in MSDN that does that, but they are mostly VB examples. But, with ODBC driver, your code will be much easier as you can use "DSN=DataSource;" as the connect string for the ADO Recordset open. Note: I have never used Excel through the Jet ADO driver. So I am not sure of the syntax. Personally, I prefer using OLEDB over ADO in VC++. I use the OLEDB consumer templates. If you want to check this out you can look in MSDN for CDataSource CSession CDynamicAccessor classes. -- Thomas modified 29-Aug-18 21:01pm. Re: ado and excel 5-Jul-01 7:23 5-Jul-01 7:23  try this: http://support.microsoft.com/support/kb/articles/Q278/9/73.ASP Header notifications? 5-Jul-01 4:53 5-Jul-01 4:53  Hi All, I have a CMyListCtrl (derived from) CListCtrl on a CMyPropertyPage (derived from CPropertyPage). In CMyListCtrl I try to handle several header control notifications: ON_NOTIFY(HDN_BEGINTRACK, 0, OnHeaderBeginTrack) ON_NOTIFY(HDN_ENDTRACK, 0, OnHeaderEndTrack) ON_NOTIFY(HDN_BEGINDRAG, 0, OnHeaderBeginDrag) ON_NOTIFY(HDN_ENDDRAG, 0, OnHeaderEndDrag) ON_NOTIFY(HDN_DIVIDERDBLCLK, 0, OnHeaderDividerDoubleClick) ON_NOTIFY(HDN_ITEMCHANGING, 0, OnHeaderItemChanging) ON_NOTIFY(HDN_ITEMCLICK, 0, OnHeaderItemClick) The problem is I get some of the notifications, but not others. I get the BEGIN/END TRACK/DRAG notifications, but I do NOT get the DIVIDERDBLCLK, ITEMCHANGING, or ITEMCLICK notifications? I can use ON_NOTIFY_REFLECT(LVN_COLUMNCLICK, OnListColumnClick) in place of the HDN_ITEMCLICK notification, but I don't understand why I'm not getting the header notifications. If I handle the HDN_DIVIDERDBLCLICK notification in CMyPropertyPage, I do get the notification, so it looks like the header control sends some of its notifications to the CListCtrl, and others to the CPropertyPage? It also seems like by the time the HDN_DIVIDERDBLCLICK notification is received, the header (or listctrl) has already done the default resizing of the header columns, but that's what I wanted to customize. Any ideas or suggestions? Thanks - Sean McKinnon mailto:sean.mckinnon@kvs.com Re: Header notifications? Tomasz Sowinski5-Jul-01 5:15 Tomasz Sowinski 5-Jul-01 5:15  I've checked this with Spy++ on Win2000. My app wasn't UNICODE, but when I clicked on header, list control received HDN_ITEMCLICKW (not HDN_ITEMCLICKA mapped via #define to HDN_ITEMCLICK). It seems that this is the case with other notifications as well. Tomasz Sowinski -- http://www.shooltz.com Re: Header notifications? 9-Jul-01 5:03 9-Jul-01 5:03  Yes! That was it, thank you! - Sean How can I hide a list control item? 5-Jul-01 2:50 5-Jul-01 2:50  Is it possible to hide a list control item with CListCtrl::SetItemState as described in the MSDN Library: "An application might change other state bits to disable or hide the item, or to specify an overlay image or state image." Re: How can I hide a list control item? Tomasz Sowinski5-Jul-01 4:06 Tomasz Sowinski 5-Jul-01 4:06  It looks like bug in the documentation. They only list the following item styles: LVIS_CUT, LVIS_DROPHILITED, LVIS_FOCUSED and LVIS_SELECTED. The closest thing to item hiding would be setting the state to LVIS_CUT - Windows shell uses this style to display file icon after 'Cut' command. Tomasz Sowinski -- http://www.shooltz.com How to Print data in MSFlexgrid control in an VC++/MFC Application? Aky5-Jul-01 2:43 Aky 5-Jul-01 2:43  Hi Ive a MSFLexgrid control which fetches data from a database.how do i print the data's from the control. Im using VC++/MFC Framework for developing this application? Your help will be appreciated. ado Gérald Mercet4-Jul-01 22:23 Gérald Mercet 4-Jul-01 22:23  i have a little problem in an application where i use ado method to catch value from excel. So, i have created an dialog box with a button which could getting data from a selected called database. the first aim of this application is to read all the first field of the database and find the same value that the value given in the dialog box by the user. When i try to run the application, I could push my button but I have the message box which appears with this message:"Database Error cannot update Database or object is read-only" So, anybody could explain me what happen? thanks gerald How to change File Icon Muhammad Abid4-Jul-01 22:18 Muhammad Abid 4-Jul-01 22:18  Hi all, I want to create files of my own defined extension and also want to have icon for them of my choice(that will i made in VC++ resouce editor). How can i assign my own made icon to file. Plz tell me as early as possible if anyone know solution. Regards Abid Request for Application skeleton code N.Bharadwaj4-Jul-01 18:58 N.Bharadwaj 4-Jul-01 18:58  can i get a skeleton code for an application developed on Win CE. This is basically to test the bluetooth device working. N.BHARADWAJ Software Engineer MICROCON INTERNATIONAL LIMITED BANGALORE. Spec reqd for driver development N.Bharadwaj4-Jul-01 18:46 N.Bharadwaj 4-Jul-01 18:46  I need the specification given to software developer to write driver for any device. Like memory, I/O, IRQ, Registry and so.on. kindly reply N.BHARADWAJ Software Engineer MICROCON INTERNATIONAL LIMITED BANGALORE. Catching Access Violations Nick Blumhardt4-Jul-01 16:27 Nick Blumhardt 4-Jul-01 16:27  Hi All, I've just discovered I can handle the various kernel exceptiions, like 0xc0000005 : Access Violation by using: catch (...) { } Is it common knowledge that this can be done? Why doesn't everyone handle GPFs etc like this (nicely)... By the way, does the caught exception have a type? nb Re: Catching Access Violations Nick Blumhardt4-Jul-01 17:42 Nick Blumhardt 4-Jul-01 17:42  Answered my own question- you can only catch them with the ellipsis if anyone's interested in this, check out _set_se_translator() in the MSDN cheers \ nb ActiveX controls in Internet Explorer Derek Waters4-Jul-01 16:21 Derek Waters 4-Jul-01 16:21  Hi, I'm creating an ActiveX control to be embedded into a web page. This control contains a child dialog with a number of controls in it. The problem is that certain key presses are not received by this child dialog, specifically, TAB, cursor keys and (importantly) Backspace. I understand that certain key presses such as TAB and cursor keys require PreTranslateMessage to be overridden in the COleControl derived class. I have done this. I also know that I should be calling LockInPlaceActive on the control when it is activated so that I can capture these WM_KEYDOWN messages, but when I debug this control when it is embedded into a web page (and viewed in Internet Explorer), LockInPlaceActive always returns FALSE. Does Internet Explorer disallow in place active? Is there any way that pressing Backspace in a child Edit control of the ActiveX control will actually edit the text rather than returning to the previous web page? Thanks in advance. Derek Waters Re: ActiveX controls in Internet Explorer Michael Dunn4-Jul-01 16:26 Michael Dunn 4-Jul-01 16:26  You need to implement IInputObject to receive those keystrokes. Search for IInputObject in MSDN - I know I've come across at least one article that describes how to do what you want. --Mike-- http://home.inreach.com/mdunn/ "Holding the away team at bay with a non-functioning phaser was an act of unmitigated gall. I admire gall."   -- Lt. Cmdr. Worf Re: ActiveX controls in Internet Explorer Derek Waters5-Jul-01 14:52 Derek Waters 5-Jul-01 14:52  Thanks Michael, I actually found that Knowledge Base article "Q168777 - PRB: MFC ActiveX Control in IE Doesn't Detect Keystrokes" helped (with a bit of fiddling). Derek. ClassWizard "new Class from type lib" help 4-Jul-01 14:01 4-Jul-01 14:01  Hello All I use ClassWizard to generate a class derived from COleDispatchDriver to warp around a COM object, but the method that get generated say "method 'SessionOpened' not emitted because of invalid return type or parameter type" anyone has any idea why?? psksvp/ ======================== class INoteAcceptorEvents : public COleDispatchDriver { public: INoteAcceptorEvents() {} // Calls COleDispatchDriver default constructor INoteAcceptorEvents(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {} INoteAcceptorEvents(const INoteAcceptorEvents& dispatchSrc) : COleDispatchDriver(dispatchSrc) {} // Attributes public: // Operations public: // method 'SessionOpened' not emitted because of invalid return type or parameter type // method 'SessionClosed' not emitted because of invalid return type or parameter type // method 'UnableToOpenSession' not emitted because of invalid return type or parameter type // method 'LockGranted' not emitted because of invalid return type or parameter type // method 'LockTimeOut' not emitted because of invalid return type or parameter type // method 'LockReleased' not emitted because of invalid return type or parameter type // method 'AvailabilityChanged' not emitted because of invalid return type or parameter type // method 'XFSErrorEvent' not emitted because of invalid return type or parameter type // method 'BanknotesEncashed' not emitted because of invalid return type or parameter type // method 'BanknoteProcessingComplete' not emitted because of invalid return type or parameter type // method 'BanknotesRefunded' not emitted because of invalid return type or parameter type // method 'BankNotesInRefundSlotError' not emitted because of invalid return type or parameter type // method 'BanknotesRejected' not emitted because of invalid return type or parameter type // method 'BanknotesTaken' not emitted because of invalid return type or parameter type // method 'Enabled' not emitted because of invalid return type or parameter type // method 'EscrowFull' not emitted because of invalid return type or parameter type // method 'NoBanknotesEntered' not emitted because of invalid return type or parameter type // method 'UnableToEnable' not emitted because of invalid return type or parameter type // method 'UnableToEncash' not emitted because of invalid return type or parameter type // method 'UnableToRefund' not emitted because of invalid return type or parameter type // method 'BanknotesInserted' not emitted because of invalid return type or parameter type // method 'UnableToClear' not emitted because of invalid return type or parameter type // method 'Cleared' not emitted because of invalid return type or parameter type // method 'BanknotesWithdrawn' not emitted because of invalid return type or parameter type // method 'BNAExceptionEvent' not emitted because of invalid return type or parameter type }; Re: ClassWizard Nick Van den Abbeele4-Jul-01 21:14 Nick Van den Abbeele 4-Jul-01 21:14  Are the intefaces of the COM object using oleautomation compatible types ? It could be that you are trying to make a wrapper object for a COM object with a custom (c++) interface by using COleDispatchDriver. -Nick- DAO FindFirst otvac4-Jul-01 13:58 otvac 4-Jul-01 13:58  I'm VERY new to vc++. I am attempting to use DAO's findfirst function. All works OK unless there is an apostophe in the query string (for example "Joe's Place"). Code sample: m_pMySet->FindFirst("[Favorite Bars] = 'Joe's Place'"); Will not work, but m_pMySet->FindFirst("[Favorite Bars] = 'Joes Place'"); will. Any help appreciated Richard Re: DAO FindFirst Nick Blumhardt4-Jul-01 18:10 Nick Blumhardt 4-Jul-01 18:10  Hi! Try doubling up on apostrophes within the string you're looking for... e.g.: m_pMySet->FindFirst ("[Favourite Bars] = 'Joe''s Place'"); this is how SQL Server treats them, anyway nb Re: DAO FindFirst 5-Jul-01 1:23 5-Jul-01 1:23  Thans Nick, I'll give it a try! Richard Re: DAO FindFirst Hadi Rezaee5-Jul-01 9:47 Hadi Rezaee 5-Jul-01 9:47  Hi, In this example Favorite Bars is field name ? My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie Re: DAO FindFirst otvac5-Jul-01 14:26 otvac 5-Jul-01 14:26  Hi, Yes Favourite Bars is a field name. FindFirst works OK until a key is passed that contains an apostrophe (Joe's Place, for example). I've tried everything I know to work around this (which isn't much). All ideas appreciated! Richard type cast a CString to a LPTSTR Jose Cruz4-Jul-01 10:29 Jose Cruz 4-Jul-01 10:29  How can I type cast a CString to a LPTSTR to avoid this error: 'type cast' : cannot convert from 'char *(__thiscall CString::*)(int)' to 'char *'

Last Visit: 31-Dec-99 18:00     Last Update: 11-Jun-24 9:43 Refresh ᐊ Prev1...18213182141821518216182171821818219182201822118222 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.