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: *

  • Users: bkdobs
  • Order by date
  1. bkdobs

    Query Speed issue

    I posted a variation to this question in the SQL forum and the solution is to use a Crosstab ... TEK-TIPS rocks!
  2. bkdobs

    SQL Join frustrations

    Very interesting ... I had tried the IN function in the SQL statment but the two key details were that if trying to apply this in the design mode it must be done in the properties of that field and secondly the named fields must match the data from the crosstab table field and or as in my case...
  3. bkdobs

    SQL Join frustrations

    Hmmm just a slight twist ... I need all 10 columns to show up regardless ... with no where clause the crosstab is generating 9 of the 10 columns because the dev table is not completely full ... I could generate a dumby record with 0 in each type but because I have referential integrity enforced...
  4. bkdobs

    SQL Join frustrations

    Hmmm I would like to give you a 100 stars for this one ... I have been struggling with this for a few months now off and on ... now I know what the crosstab is for ... THANX A WHOOOOOOOOOOOOOOOOLLLLLLLLLLLLEEEEEEEEEEEE bunch!!!
  5. bkdobs

    SQL Join frustrations

    Several parts to this question ... given one table with up to 10 related records ... task create a query to join all related records in one record with 10 fields (may be 0 to 10 related records for any given primary key a)what is the maximum number of joins one would want to ever make on the...
  6. bkdobs

    Query Speed issue

    OK being a SQL newbie I tried to apply one of the examples above to another table but cannot get the SQL editor to save my code ... I currently am using an ADO object with a for next loop to resolve this record but thinking a query should work alot quicker? I have a table that has; Part as...
  7. bkdobs

    Choose() alternative(s)?

    I was looking for an answer to my previous posting relating to speed ... by rewording it I received one of the answers I was looking for ... I tried the split function in my speed tests and found the speed of looking up values in Arrays was slower then the if elseif approach for i = 1 to...
  8. bkdobs

    Globals and speed

    Anyone reading this may have wondered WHY I don't just define the variables GLOBAL or PUBLIC and access them directly ... two reasons ... one is that for whatever reason Queries do not appear to be able to resolve variables but they can resolve SUB{}'s ... second is that without knowing the...
  9. bkdobs

    Choose() alternative(s)?

    csv files are read by access in an import function what escapes me is how to do this in code ... Choose() is close but not exactly working the way I expected. given; strList = "a,b,c" ? NumElements(strList) ' number of elements in list for inI = 1 to NumElements(strList) ...
  10. bkdobs

    Globals and speed

    After reading the Access 2003 Bible I have been attempting to speed up a generic global set/get module. What is frustrating is that there appears to be no way to quickly do a get/set other than create a unique set/get function for each global. I have an application with 32 globals ... I think I...
  11. bkdobs

    How do I suppress the Image Load dialog

    using a linked image control ... when an image is loaded a dialog flashes on the screen that appears to be an image load dialog ... is there a way to suppress this dialog? Sub RequeryPicture() Dim chDir As String Dim chPic As String Call dbg("Requery Picture") chDir = DLookup("[ConfigParam]"...
  12. bkdobs

    KeyPress filter

    ...the Control. So setting KeyCode to 0 does terminate the message. A Key entry produces 3 window messages the Keydown, then KeyPress, then KeyUP ************** SNIP SNIP SNIP ****************** The windows message handler passes Key events to the parent Application in focus and on down to...
  13. bkdobs

    KeyPress filter

    Thanx Roy ... I had tried that ... I tried it again and it is still causing a Control Keypress event with KeyAScii = 0
  14. bkdobs

    KeyPress filter

    Roy Sorry ... I am looking for a solution in ACCESS for the Keypress/up/down event ... should one expect that the Visual Basic group would have an answer for this? I realize that VBA is a subset of Visual Basic but is it exactly the same in terms of how it deals with message handling? I will go...
  15. bkdobs

    KeyPress filter

    When programming in WinAPI a Keyboard filter can be installed that traps specific keys ... there is a way to stop the windows message handler from passing the key any further ... in VBA we can do a key preview at the form level but I can't figure out how to have the process stop at this point ie...
  16. bkdobs

    Access version Compatibility

    I have been programming for over 30 years on everything from micro code on Nova Data-Gen machines, Micro-controllers/Micros like Z80, Z8, Pics, 8080, 6502, to higer level languages like Fortran, Forth, Q|V|Basic, C++, ... Dbase, Foxpro, and now 4GL. I have never had to spend so much time working...
  17. bkdobs

    Access version Compatibility

    Thanx Roy ... it appears that the decompile feature did the trick ... I suspect moving the mdb file compiled with the 10.0 object file into a2k then recompiling with the 9.0 object file may have caused the problem as decribed in the decompile thread ... this will be a standard operation from...
  18. bkdobs

    Access version Compatibility

    The issue with the alleged bug is not what this thread is about ... this is old news ... was something that was an issue several months ago and am not going to rehash further ... I need a solution for the OS crash issue please.
  19. bkdobs

    Access version Compatibility

    Taking two mdb files created in Access 2K and merging them into a 3rd mdb file caused the modules to become corrupted ... forms would not load because the modules could not be read/accessed ... When I asked about this issue, someone on tek-tips said there is a known bug with Access 2k ... I...
  20. bkdobs

    Access version Compatibility

    I designed an application in Access 2k but found there was a bug in 2k that wouldn't let me copy/combine parts into a new mdb file ... I have now painfully taken and rebuilt all of my modules in Access 2k2 in 2k format ... The application works fine on XP Pro and Access 2k2 ... the moment I pull...

Part and Inventory Search

Back
Top