Search results for query: *

Hi, I would like to know, how could I resolve the following problem: I am using ODBC API a MS JET 4.0 driver (MS Access database). In the database there is a simple table with two columns called "Counter" and "IDRow". "IDRow" serves as ID for selecting an unique row. I need to read and then...

I have very strange problem. I am working on ActiveX DLL. There is no UI (except MsgBox) in the DLL. Only code for access to DB and mathematical computations. The DLL is working for a few years without any problem. Yesterday I have add a few lines of code (only some for i... next i loops) and...

Hi, I am getting error 998 when spawning another application with createprocess API call. This problem arises only on Windows 2000. I have tested Win95, Win98, Windows NT 4.0 and Windows XP and there is everything OK. Can anybody help me? Thanks Ivo

Hi all, I use VBA code and MAPI functions for sending e-mails from my ACCESS application. In Windows NT MAPI32.DLL contains exports like BMAPISendMail, BMAPIResolveName etc. Unforunately there are only MAPISendMail, MAPIResolveName externals in MAPI32.DLL under Windows 98 A (ver. 4.01.2222) and...

Ok. But how get you know when application.quit command was issued (e.g. user press MSAccess close button)? The class Terminate method isn't called in that case.

Hi all, does anybody know the way how to intercept a class destroing that happens when method 'application.quit' is called or EXITcommand from File menu is issued? I have a class which executes some background tasks when Access application is running. I have to remember the state of the class...

Hi, does anybody any experience with using MAPI from VBA, especially with using MAPISendMail? MAPISendDocuments works fine but MAPISendMail fails with error code MAPI_E_INVALID_RECIPS or MAPI_E_ATTACHMENT_NOT_FOUND. I guess that something is wrong with passing MapiRecipDesc and MapiFileDesc...

Hi, thank you for your replies. The problem was in using Delete event without using BeforDelConfirm event. If I didn't set parameter Response to acDataErrContinue in BDC event, the Error event was called with error code 8519. But it happened only in ACCESS 97. The second problem (with...

Hi, try this: when your visitor leaves workshop (you should be notified somehow) use the following formula dim dtDiff as date dtDiff = datediff("m",Form![txtStartTime],Now) where txtStartTime is date and time when a customer entered workshop. Ivo

Hi, I have the following problem: In my Access 97 application I have a Form in datasheet view. Data source for the form is linked table. When I delete a record by pressing "delete" key or from a shortcut menu, I get undocumented Error 8519, but only when I am using form's Error event...

Resolved

Please help! Ivo

Thank you for your advice. It works. But instead of oncurrent event I had to use onchange event for the tab control where the Date picker resides. Thanks Ivo

Hi, I have a problem with MS Date/Time picker. I have it on a tab control. I have defined my custom format for displaying only month and year ("MMMM yyyy"). After first opening the form everything is OK. But whe I choose a different tab page and than return back to that with DT Picker...

Hi Jim, thank you for your response. I have resolved the problem. Ivo

Hi, I have ListBox control, which I fill by user-defined function (RowSourceType property is set to VB function). Everything works fine except an occasional ERROR 2118 message when I call ListBox.Requery method. Any ideas? Ivo

Hi Nick, try this function. I use it and it works. I do not use any password and I have also admnistrator rigths. The tables have to have an identical structure. Ivo Private Function refreshLinks(strFileName As String) As Boolean ' Refresh links to the supplied database. Return True if...

Hi Nick, I am trying to remeber some usefull information for later colling FindFirst method on RecordsetClone. Then I use Me.Bookmark = Me.RecordsetClone.Bokmark. But It doesn't seem to work correctly. Do you any other idea? Ivo

Hi, I have a continous form (like datasheet) and I want, after requerying underlying recordset which makes the first record to be viewed, to move the current view to the record which user have selected before. I use form property SelTop to move the specified record to the first viewed line. It...

Hi Jim, good idea. Thanks. Ivo