Recent content by bkdobs

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

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

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

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

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

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

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

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

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

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

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

Thanx Roy Sorry! LIGHTS ON NOBODY HOME .... after writing the blurb below it finally clicked!!! ... In order to trap the characters at the FORM level WE/I NEED TO USE the Form_KeyDown Event ... The KeyPress event interprets the Key after KeyDown which is allowing the KeyDown message to get...

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

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

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