Recent content by pullingteeth

I have a univarchar column which cannot be indexed due to the length of the field. On my dev database, I can apply the index if I change the column to be a varchar. Does anybody know if it is possible to convert a univarchar field to a varchar one on a production database without losing the...

I recently converted my database from 97 to XP (not horrendous, but not as straightforward as it should have been.) I had been using several msgboxes which had bolded titles, using syntax like: MsgBox "hi " & Constants.NL & " @this is the body@ " These don't work in XP; the @ signs show up...

OK, I finally gotcha. I assumed (incorrectly) that that would only compile one form. Thanks for your persistence! :)

Hi Hap, we're talking at cross purposes, I guess. There are 100s of forms in this application, and it wouldn't make sense timewise to compile each individually every time we make a new MDE. Access97 used to give the form or module name that wasn't compiling, when it failed to make an MDE. So, I...

Hi Hap, yes I worked it out through the method I described. However, is there a way to make the error message more descriptive, i.e. to pinpoint the form or module that is not compiling (i.e. to restore the behaviour that Access 97 had)? Because it really sucks to have to delete them all and...

Hello, I'm using Access XP. When trying to compile an MDE and failing, it gives a really uninformative error message ("Could not make MDE file") with no option to see details. As I remember, Access 97 pinpointed at least the module or form which was giving problems; right now my "solution" is to...

I'm just getting back into Java so my guess would probably be as good as yours, given that you seem to have covered the essentials. However, to catch the memory leak, you might want to attach a profiler to the application; if you understand where the memory leak is coming from, you may find the...

I don't know if this will work or not, but you can move the mouse cursor using a user32 API call (setCursorPos). See the MSDN reference, or the abbreviated summary here: http://custom.programming-in.net/articles/art9-1.asp?f=SetCursorPos

I got it working by (strangely) setting the title of the window before sending keys. Any idea what side effect this is having? y = setWindowText(tdbid, "You are very happy") sendkeys "{f5}", true y = setWindowText(tdbid, "Tracking")

Hello, the following code (written in a macro language which can call out to the win32 API) switches from the user's window to an Access window ("tracking"), and activates a form with the "f5" key. In theory. It all works apart from the "f5" key, which doesn't seem to be accepted by the Access...

OK, got it to the stage where the window switching is working. The above code was missing a call to UpdateWindow. My new code is below. However, the window I'm switching too for some reason isn't taking keyboard input (the F5), although if I press F5 myself it works fine. Any idea what's...

Hello, I had a vba script which switched windows between two applications. The code below used to work in Windows 95, but doesn't in Windows XP. I determined using the debugger that it is the closewindow statement which doesn't work. Any idea what's going on here? Thanks dim ntsid as long dim...

I second Sedj's opinion. A native DB is going to be far superior performance wise.

I don't really have time to do that, but here's a simplified explanation. Assume your textboxes are named Text1 ... Text9. You will need to define an AfterUpdate event for each textbox (right click, properties, events, after update, choose [event procedure]); your code in each sub should be...

Here's a code snippet which you should be able to adapt. Here I keep running totals for each "row" and "column", and then a grand unified running total which is consistency checked. Private Sub Text28_AfterUpdate() total End Sub Private Sub Text29_AfterUpdate() total End Sub Private...