Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pullingteeth

    Preserve data while changing column data type

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

    msgbox title @body@ doesn't seem to be working

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

    More informative compilation errors?

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

    More informative compilation errors?

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

    More informative compilation errors?

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

    More informative compilation errors?

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

    Multithreaded application help

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

    Simulating mouse/keyboard activity to prevent screensaver kicking in

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

    Switched to window won't accept input

    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")
  10. pullingteeth

    Switched to window won't accept input

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

    User32: CloseWindow stopped working in XP

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

    User32: CloseWindow stopped working in XP

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

    db2 vs Access

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

    Total sum of Items

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

    Total sum of Items

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

    Project Idea

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

    db2 vs Access

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

    Multithreaded application help

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

    Searching for and writing data throughout the database

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

    App.Previnstance in Access?

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

Part and Inventory Search

Back
Top