Recent content by Vivitech

That's a neat idea - thanks indeed. I'll try it out ASAP. I can't imagine why you wouldn't want your modules in external files, though! IDE's like the VBA editor are shackles, IMHO. For example, how do you develop an application as a team? Have you never used programmers text editors such...

I need to be able to compare the code from two versions of my project, to highlight any differences. With any text-editor-based system, this would be SO easy with a tool like EXAMDIFF, but of course, we have to use the awful VBA code editor, don't we! I've tried printing the project to file...

I'm having an annoying problem with an Access 2000 MDE that runs fine in many locations on a variety of PC's and OS's, but on others it occasionally bombs with an "Access will be shut down" fault. There seems to be no pattern to where and when this happens, though I do suspect that it might be...

I have done this in the past by setting up a OnTimer event on the form, and simply call the form's .Refresh or .Requery method from within the Form_Timer() routine. However, I never have found a satisfactory way of preventing the screen from flickering each time the refresh occurs. It can...

Hi, I've written a custom error handler in A2K which I want to call from Form_Error(). This is to trap Access (not VBA) errors when somebody does something silly that Access/JET objects to. In these cases Err is NOT set, so the only way to get the error description, as I understand it, is to...

Good thinking, makes perfect sense! It's always nice to have an explanation of why faults appear to be intermittent. Cheers.

Found the culprit Well, I've found the line of code that causes it, so just in case anyone else experiences this: In my autoexec macro I was calling a Startup() subroutine with some code to run another application when my database is opened: Sub StartUp() Dim ret As Integer ret =...

Help! I have a pretty stable (or so I thought!) MDE application but I've just tried to run it on my client's Windows 98 machine and all I get is a message box saying "Overflow!" The client's PC has Access Runtime installed and this does run other MDE apps OK, so it must be something specific...

I have a typical "search and edit" form populated from a table of, say, 1000 items. On entry to the form I have an unbound combo field which, under certain circumstances, I would like to make "jump" to a certain point down the list, by matching, say, the first 3 characters of an "UnknownItem"...

Thanks ChrisO - now you've reminded me, I've actually used that Nz approach before in a report formula to overcome "invalid use of null". Cheers! Nice to get some prompt help at midnight from the other side of the world!

Sure enough - silly it was, but I think I've found it myself: The trap needs to be If Not IsNull(Rs("fld1").Value) Then ... Still a bit frustrating why the compiler lets the other "Ifs" through when they are bound to fail at runtime.

I know this is going to be a silly one, but...! I've got: Dim Rs As DAO.RecordSet Dim sStored As String ...(open record set etc.) sBatchIDStored = Rs("fld1").Value but if the field happens to be empty I get a "Invalid use of Null". So I try to trap this with: If RsProc(sFld).Value <>...

But that's exactly the point - it isn't MY Jet/Mdac that "might" need updating is it? It's those on the machines of every one of my customers. What's more, it isn't something I can supply them with. They have to get it from you-know-who. And what if they don't know how to do the update? Or...

It obviously is an ADO/WinXP issue! Well, well, well! I changed the code to use a DAO recordset and guess what - it's running happily into 5 figures of looping now. I guess the problem must lie in the dark recesses of ActiveX and it's tie-in with WinXP? Oh how I yearn for those good old days...

Not the ADO vs DAO issue again! But everywhere you look MS (and others) are saying ADO is the way to go! Surely you aren't suggesting that they would be pushing ADO without having fully tested it under their new "flagship" operating system? ;) If so, maybe they are interested in knowing...