From: "kingston via AccessMonster.com" <u27511@uwe>
Date: Wed, 28 Feb 2007 15:18:03 GMT
How are you plan to do this? I mean are you thinking of using VBA to set a
field value or do you simply want a reference value in a box as a default-
type setting? It sounds like you want the latter so this might work:
Create a query like the one you have without the aggregate function Max().
Then set the value of the textbox to =DMax("Expr1","NewQuery").
bijan wrote:
Hi ALL,
please help How can I capture result of this SQL in my Textbox(txt1.value):
SELECT Max([Seventh]+1) AS Expr1
FROM TBL7 INNER JOIN country ON TBL7.Country = country.[COUNTRY-NAME]
GROUP BY country.CCODE
HAVING (((country.CCODE) Like [Forms]![Frmchange7]![txt5]));
Re: Adding and Changing CustomDocumentProperties from VBA on oth ... In tools references, create a reference to it as shown in the article. ...Dim oSummProps As DSOFile.SummaryProperties ...Tom Ogilvy "VBA Dabbler" wrote in message ... > I've downloaded the DLL - it looks like you have to be in an application> development environment, like C++, VB, etc. I'm not sure how this can be> used in Visual Basic for Applications (VBA).... (microsoft.public.excel.programming)
Re: Clear Clipboard in VB ... In VBA, go to the Tools menu, choose ...reference to the MSForms type library. ... Microsoft MVP - Excel... Dim doFName As MSForms.DataObject (Compiler does not like the DataObject definition)>... (microsoft.public.excel.programming)
Re: Extracting $ Data from Alpha Field? ... The definitive reference document for the VBA functions is ... >*This says stop looking when you get to the comma?... These two are both part of a single expression that is the ... (microsoft.public.access.queries)
Re: Different VBA code behaviour in MDB and MDE ... By running the same program in MDE the VBA code in the form gives the ... 'wordt het vinkje in de tickbox van het reference form in VBA uitgezet. ...Dim refCurr As Reference ... (comp.databases.ms-access)
Re: Frustrated with VBA so-called help ... There is the old Excel VBA reference that microsoft published (last for xl97 ... > lack thereof) to good help for Office products,... (microsoft.public.excel.programming)
