Search results for query: *

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

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

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

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

I have a Price table related to part number where each part could have prices from different vendors ... the price table was set up with an active flag, Vendor and buy and sell prices. I made a query which creates a distinct record of 2 buy and sell costs plus the minimum between them so it has...

Mercator version 6.5 exports the data maps in xml format and in this file it specifies a DOCTYPE MMS System as mms.dtd ... I can't seem to find this anywhere. Does anyone have a copy of this and or know where I can find it?

Is there a method to steal control of the right click mouse event so as to create my own support dialogs on form elements?

Is it possible to limit a find to 100 results? find $srcpath -xdev -type f exec mv {} $dstpath \; The issue is when too many files hit the srcpath a mv $srcpath\*.* $dstpath fails due to parameter list too large ... the dstpath processes will fail for the same reason if I execute the above find.

I have a data set in a backend database that will be used by multiple users across a 100Mb Intranet ... I am wondering if there would be any speed gains if I used multiple back end data sets as opposed to one big one? Understanding the OS has to manage open file buffers as well ... just thinking...

I have a VSS project that when run created a 185M mdb file by importing data files ... this file closed properly using the check in process ... When I try to open this file now it just locks up ... is there anyway to open it in read only mode so I can recover my source code? I have attempted to...