Using FM7 relations to get a sort of omitted list???
-- I know this is SQL, but I really have a question
-- about Filemaker 7 and this is the best way I
-- can think of to express it. I've tried very hard
-- to implement it in FM7.
-- I have a list of states and a list of tasks (a Checklist - CL)
-- assigned to various states.
-- I can find the tasks assigned to a state using
-- Filemaker 7 relations.
-- But I cannot figure out how to get a lists of
-- the tasks that have NOT been assigned to a state.
-- And I would like such a list so that I can add
-- unused items to my list.
-- If this file is saved as tasklist.sql, it
-- can...US-TX-Austin: Access Developer, Access, SQL, VBA, ASP, queries, macros, modules; (45357414406)
US-TX-Austin: Access Developer, Access, SQL, VBA, ASP, queries, macros, modules; (45357414406)
Position: Access Developer
Location: Austin TX
Duration: 5-6 Months
Skills: Microsoft Access
Developing, debuging, testing and troubleshooting queries,
macros, and modules
Understanding of database design.
MCDBA certification a plus.
Active Server ...Connect to VBA Objects?
I wonder if Python can connect to the object models exposed by Excel or
Thanks in advance,
San Antonio, Texas
On Monday 22 September 2003 07:38 pm, Kenneth Hutson wrote:
> I wonder if Python can connect to the object models exposed by Excel or
> Thanks in advance,
> Ken Hutson
> San Antonio, Texas
Yep, assuming you have the win32all extensions installed:
from win32com.client import Dispatch
d = Dispatch('Word.Application')
d.Visible = 1
Content-Type: text/plain; x-avg-checked=avg-ok-EF3387E;...VBA and SDL Graphics (or similar)
I've asked this over the last couple of weeks in VB and VBA newsgroups
but no response, so i thought i'd ask the ever flexible c.p. crowd...
I have a project where I'd like to be able to use the SDL graphics
library from within VBA in an office environment to show a more fluid
graphical model. The 'graphics' available in Excel consist of
changing settings on charts - and it's possible to make it look
dynamic-ish, but not particularly good!
It wouldn't have to be SDL, anything that can handle the *entire*
windowing process by virtue of calls to the DLL, and also ...VBA or qry
When using forms are you best to use SQL or run VB code to load the
data from tables. Or is it just personal preference.
Anyone that can shed any light on this, would be appreciated.
I don't understand the question.
Bound forms will use a table, a query, or an SQL statement as their
RecordSource. Under some conditions, it is possible to open a recordset to
use as the RecordSource, but, in my experience, it is always just as easy to
use the table, query, or SQL directly as RecordSource that you'd use to open
the Recordset. The exception _may_ be the use of "disconne...A new approach to storing ordered hierarchical data in RDBs.
I've discovered a new approach to storing ordered hierarchical data in
RDBs. As far as I know there is no similar model out there and it
differs significantly from traditional models (such as adjacency list,
materialized path or the nested sets approach). A brief article
describing the model (with accompanying sql code) can be found at
> I've discovered a new approach to storing ordered hierarchical data in RDBs.
Looks interesting. Below is a similar example using dbd (no...MicriStation VBA Question
I'm new at programing
How would I select the text I want to change
Private Sub CommandButton1_Click()
ActiveSettings.TextStyle.Justification = msdTextJustificationLeftTop
...Re: Sort order change from Mainframe to Windows #2
On Fri, 30 Mar 2007 05:02:56 -0400, Narasimhaiah Devadula
>I am moving an application from the mainframe V8.2 to Windows . Mainframe
>sort displaying the output an ascending sort of numeric in the bottom.
>When i do the same sort in windows environment, the numeric values
>displaying in the first.
>But our client would like to see the reports in the same order which is
>already in Mainframe environment.
>Please have a look into the below same code. When i run the below code in
>Windows environment numeric value...Quick Sort
Can anyone let me know the Quick Sort algorithm?
Thanx in advance
On 7 Dec 2003 22:17:09 -0800, email@example.com (Linux Man) wrote
or quoted :
>Can anyone let me know the Quick Sort algorithm?
Canadian Mind Products, Roedy Green.
Coaching, problem solving, economical contract programming.
See http://mindprod.com/jgloss/jgloss.html for The Java Glossary.
"Linux Man" <firstname.lastname@example.org> wrote in message
> Can anyone let me know the Q...Linking to DLL from VBA
I need your help on linking to DLL from VBA. I wrote the DLL with the
DLL Wizard in VC++6 and I am able to link to it in another C++ program.
However, when I try to call the DLL exported function from Excel VBA by
typing the function fnTest2(), it gives a #VALUE! error message. The VBA
code is as follows:
Declare Function fnTest2 Lib "C:\user\ys\dlltest\Debug\test2.dll" ()
When I use the same syntax to call the WIN API DLLs(such as user32.dll),
it worked okay.
I greatly appreciate your help.
...Sort Date Field String
I am already using TreeMap to massage records in my export file such that
each record has a unique key combination ( LastName + FirstName + Member
Key) . Thus I am sorting the records by the unique key. I also have a Date
String Field in my record ( ie "30-Apr-2005" ). I want to create a unique
key combination of
( LastName + FirstName + Member Key + Date).
Can you please tell me what are the steps I need to do to sort the Date
String Field? Obviously, I can't treat the date as a string field because
it will sort the date alphabetically ( ie 30-Apr-2005 will ...Access 2007 VBA project error message
I've been busy converting an existing 2003 database into 2007 by dint
of creating a new accdb database and importing the objects into it.
Everything went smoothly and all the objects imported without a
problem. I then ran a compile, discovered a problem with
wdOpenFormatAuto not being recognised so added a couple of libraries.
I also added two locations to the Trust Centre. Whether related or
not, when I now try to open the database I get this error:
"The database cannot be opened because the VBA project contained in it
cannot be read. The database can be opened only if the VBA proje...Toward a generic Disk Sort for Java
I was thinking how you might go about writing a sort that could handle
more data than could fit in RAM. It handled the problem is Abundance
by checkpointing the app to disk to free up maximum RAM, then spawning
a copy of Opt-Tech sort. My records were roughly like DataOutputStream
would produce, so I could automatically generate the command script
sort the fields in any way I wanted.
I thought you might pull it off in Java this way.
1. You write a comparator as if you were going to sort Objects in an
2. the external sort has an add method that also takes collections.
I want to populate a table based on a checkmark being inserted on a form.
Example, if the check mark is present, i want the customer number (which
exists on the form) to be inserted in another table.
Not too competent in vba but am making progress. Not sure how to get the
information from the form [custno] to the new table [custno].
Thanx for your help
I'd suggest using an append query to do this rather than VBA code.
You can use the QBE (query) grid to create an append query, and type "True"
into the criteria row of your "Checkbox" field.
When finish...The default locale of sorted()
I'm not able to find the documentation on what locale is used for
sorted() when the 'cmp' argument is not specified. Could anybody let
me what the default is? If I always want LC_ALL=C, do I need to
explicitly set the locale? Or it is the default?
Content-Type: text/plain; charset=ISO-8859-1
On Mon, Dec 3, 2012 at 3:17 PM, Peng Yu <email@example.com> wrote:
> I'm not able to find the documentation on what locale is used for
> sorted() when the 'cmp' argument is not specifi...Crash while sorting a vector of pointers
I'm writing a program that needs to display the contents of a std::map
Webuser objects, where each Webuser contains an ID number and the last
date in the form of a string. I'm using the ID number as the key for
map entry, but when displaying the map entries I need to sort them by
login date. I tried doing that by creating a vector of pointers to
objects, filling that vector with the addresses to each Webuser in my
then sorting that vector based on the login date of the pointed-to
This is causing a crash during the sorting. I could find ano...Opening VBA hangs
I have several A2000 mdb files on a computer. I can edit the vba modules
with no problems.
When I transfer the mdb files to another computer and try to edit a module,
the vba editor won't open (I get an hourglass) and I have to kill the access
process or reboot.
The second computer runs the mdbs OK, just can't edit the modules.
Reparing Access didn't help.
"Karl" <firstname.lastname@example.org> wrote in message
> I have several A2000 mdb files on a computer. I can edit the vba modules
> with no prob...T-test data again... hopefully in better order
n mean std. dev
G1 ADULT 15 62.9710145 6.3971889
G1 TEEN 16 51.0869565 12.4059156
Variable Methode Variances
df t-Value Pr > |t|
correct Pooled Equal 29
correct Satterthwaite Unequal 22.8 3.38
For H 0: Variances are
Variable Methode df df ...VBA
This is a multi-part message in MIME format.
Where can you find a listing of VBA commands or code?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1&qu...Including in a report totals of records not shown or sorted
I am using FMP 5.5 and FileMaker server 5.5
I need to create a report that filters records based on criteria CR1,
but shows sobtotals and totals for the records of the report and the
total of records in the file.
I have no problem in generating a report that selects and shows only
the records that meet CR1. Then I also have no problems for creating
the summary by the sort order SO1 and the total of that summary for
all the records in the report. BUT, I need to get a total of the same
field for all the records in that file.
How do I achieve this?
What I mean is:
I have alrea...VBA?
Wondering if anyone can help me...
I have a created a table with a tick box field in it for a large number of
records. I have also created a form and in the form is a Text Box and a
Command button ( please see http://webmonky.myby.co.uk/despatch.jpg ).
What I need when the command button is executed is for the Tick Box field to
be ticked for the order # (primary key) that was typed/scanned. All are
unticked by default.
If anybody could help me out I would be very grateful Thank You
Sorry....and also for a confirmation that order #1234 has been marked as
dispatched in a labe...do not want to sort hash on key
My hash automatically sort the data on key. I do not want to sort data
I just want to store the data in the way I store it.Is there any way
> My hash automatically sort the data on key.
No it doesn't. If you observe this behavior, it's pure coincidence (and
it's probably a very small hash). Hashes are psuedo-random.
> I just want to store the data in the way I store it.Is there any way
Have you read the perl FAQ?
perldoc -q order
returns this relevant article:
How can I make my hash remember the order I put elements i...VBA adding values to a table
So I have a text box with a string in it, and I want to get the value
in that text box into a table using VBA but I have no idea how to do
that. Anyone offer any help? Thanks in advance!
> So I have a text box with a string in it, and I want to get the value
> in that text box into a table using VBA but I have no idea how to do
> that. Anyone offer any help? Thanks in advance!
Look at AddNew method in help. (some other topics include
OpenRecordset, Update, FindFirst, and later on Edit). Of course, you
could also use an Append or Update query. Since you specified ...Why does Oracle sort hashjoin output before parallel insert?
I've got the following statement (Oracle 8.1.7):
insert /*+ append */ into outtable
select [union all of 2 hash joins of 2 tables each]
(I'm actually performing a refresh of a materialized view: this is the
statement that is performed)
The select is done in parallel. Outtable is partitioned.
Oracle reads the first table of a hash join into hash memory and into
hash segments in temp. What happens next depends on parallel dml being
disabled or enabled.
If parallel dml is disabled:
as soon as Oracle starts reading the second table, records that can be
joined are written to outta...Difference between the "true" and the printed first-order optimality in fminunc?
When I choose the 'iter' or 'iter-detailed' display option for fminmunc, a quantity called First-order optimality is printed. Is this quantity different from the max absolute value of the gradient (or L-infinity norm of the gradient)?
Iteration Func-count f(x) Step-size optimality
0 2 15625 1.88e+004
1 4 409...