Search results for query: *

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...

An actual answer: Build a "network neighborhood" alternative which allows you to browse networks using a "hyperbolic tree" (see http://ucjeps.berkeley.edu/map2.html for example). Alternatives to "network neighborhood" - file tree browser; web site spider viewer; etc.

Access is great for rapid development of WIN32 desktop database systems. Outside that domain, it is relatively useless, and will be a headache in the long term. Doesn't DB2 only run on AS400s? If you have an AS400 to host your data, then by *all means* use DB2. If it'll be on a win or 'nix box...

First, are you using BufferedReaders? If so, the non-COM threads should be able to process without you losing any data from the COM channels. Second, if you have a tight loop (while data { }) within your COM threads, make sure to put a Thread.yield() or Thread.sleep(x) statement somewhere in...

You can run it through the query window if you like.

I forget where I got this from. It ain't pretty but it works. Put this in a class module, then call winCheckMultipleInstances from the AutoExec module (i.e. at startup). '******************** Code Start ******************** ' Module mdlCheckMultipleInstances ' © Graham Mandeno, Alpha...