Using expression builder object

Hi,

I'm developing a wizzard in Access which builds import templates for various 
data sources to a fixed set of tables.  In step 3 the users must be able to 
build an expression ; for instance Left([Fieldx],20) .  Now I would like to 
have a command button on my form which calls the Access expression builder to 
allow the users to use this to build the expression. This expression will 
then be stored in a text box linked to the templates table.
Anybody know how to call and use this object from VBA code?
-- 
Kind regards
Noëlla
0
Utf
4/1/2010 5:10:01 PM
access.modulesdaovba 1670 articles. 0 followers. Follow

2 Replies
880 Views

Similar Articles

[PageSpeed] 40

DoCmd.RunCommand acCmdInvokeBuilder

I think there may be another argument, but try using the above.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"NG" <NG@forum.microsoft.com> wrote in message 
news:35A2A3E5-2171-44AD-A91A-E3D60C2CFAEA@microsoft.com...
> Hi,
>
> I'm developing a wizzard in Access which builds import templates for 
> various
> data sources to a fixed set of tables.  In step 3 the users must be able 
> to
> build an expression ; for instance Left([Fieldx],20) .  Now I would like 
> to
> have a command button on my form which calls the Access expression builder 
> to
> allow the users to use this to build the expression. This expression will
> then be stored in a text box linked to the templates table.
> Anybody know how to call and use this object from VBA code?
> -- 
> Kind regards
> No�lla 


0
Arvin
4/1/2010 6:36:59 PM
thx for your reply, but the problem is the InvokeBuilder command isn't 
available when running the form (error 2046), so I'll probably have to write 
my own function builder...
-- 
Kind regards
Noëlla


"Arvin Meyer [MVP]" wrote:

> DoCmd.RunCommand acCmdInvokeBuilder
> 
> I think there may be another argument, but try using the above.
> -- 
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
> 
> 

0
Utf
4/2/2010 3:37:01 PM
Reply:

Similar Artilces:

CRM Mobile and Mobile Express
My client has simple mobile needs - access to Accounts, Contacts, Activities and Opportunities when using Mobile Windows (Motorola Q). Which one is better (in terms of stabillity, installation, support, user experience) to go with - CRM Mobile or CRM Mobile Express. Any feedback? Thanks in advance! It sounds like CRM Mobile will meet your client needs. If so, then I would go that route. Mobile Express is not supported and only provides online functionality. -- Matt Parks MVP - Microsoft CRM "Shikhar" <Shikhar@discussions.microsoft.com> wrote in message news:099E9...

Outlook Express Versions
Where can I find what the different version numbers are for Outlook Express. This is needed to determine Outlook Express version for distribtion of KB837009. For example 5.50.4807.1700 is version 5.5 SP2? This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office family for Windows PCs. For Outlook Express (OE) support try posting in one of these newsgroups: microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x http://support.microsoft.com/newsgroups/default.aspx?ICP=GSS3&NewsGroup=microsof...

using third party defragmenting software
Good evening, I wanted to ask a simple question: when using a third-party defragmenting utility (such as DiskKeeper from Executive) on a Domain Controller that also runs Exchange (do not shoot me! I inherited this situation) it is a wise and prudent move to make sure that both the folder that contains ntds.dit (stored in the default location) as well as the folder that contains both priv1.edb and priv1.stm (not stored in the default location) are excluded from this utility's 'sight'. In fact, the argument could very easily be made that this utility should not be installed...

Using VLOOKUP to Sum values from multiple columns
I am trying to use VLOOKUP to sum multiple values from different columns. I need this because the value is given by name of machine, and in the column directly right of that the cost is given. The table looks like this. 2010 2011 A B C D M086-1 7000 M105 10000 M105 5000 F120 9200 F120 2500 M086-1 7600 F102 1500 F102 5500 It goes on like this for a list of over 100 machines, and there are about 10 columns. So i need to sum the values for each machine over these columns. Say for instance i want to get the total...

Using Excel to input survey Information- How do I put checks against myself?
I need to make certain cells accept only "x" and nothing else. I have no idea why this is becoming such a difficulty. Also, I have data sets in there own colum. I need to mark an "x" under yes, no, or not sure. However, if I move too fast, I might put an "x" under yes and not sure. Is there any way to check for that? This sheet is going to get quite large, and manual rechecking will be a huge pain. Anyone have any idea's? Oh! I'm running Excel 2002. -- kinjour ------------------------------------------------------------------------ kinjour's Prof...

how to disable/enable command button (ActiveX) using a macro
I have tried to create a macro using recorder to disable/enable command button (ActiveX) with the following code being created ActiveSheet.Shapes("CommandButton1").Select This only results in the command button being selected - with the procedure of enabling/disabling being "lost". So i tried the following code ActiveSheet.CommandButton1.Select CommandButton1.Enabled = False This presents runtime error message "object required" What is the "simplest" way to create this macro? (first time user) Any help much appreciated you can tr...

help: need formulas, using quantitve/non-quantitve data consecutiv
i'm processing data into a chart, and i'm trying to create a formula that will allow me to add number quantities in one column that are based on the non-quantative codes in an adjacent column. there are multiple codes, i need to create formulas that will allow those quantitives, in a corresponding chart, to change- based on code-without having to create separate sheets for each individual code type. i.e. af 20,000 af 3,500 ce 40,000 ce 25,000 ce 276 ce 700 i want a formula which will add up the numbers for series 'ce' and 'af' based on the presense of the cod...

using html tags in Outlook 2000
I would like to use html formatting commands, such as bold, unordered list, links, etc when sending emails. I have word as my editor and send in html format. But when I use html tags to format, the email recipient sees those tags, and they don't function. The only way I can send true html is to create an html page and use "Send Page by Email." Anyone know how I can just type in the html tags and have them work? http://www.howto-outlook.com/howto/edithtml.htm -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Cre...

Getting an Authenication error when using CRM 3.0 laptop client
Server: Win2003 enterprise SP1 SQL Server 2005 SP2 CRM Server (w/KB922815) Client: WinXP TabletPC Edition 2005 version 2002 (SP2) Office 2003 (SP2) CRM Laptop client for Outlook Hotfix (KB925874) Rollup 1 (KB922815) We are getting an Authentication error when working in both Custom and System entities. No problems accessing or entering data initially, but if you stay connected for a short amount of time it will give you an error while you're working in it. This happens mostly when offline and connected with a sprint aircard throught the VPN. We've deployed all known pat...

How do I use Publisher 98 to write a book?
I have written a short book, in Word 97, (150 pages), and would like to use Publisher 98 to insert pictures and fromat it printing. Can anyone help? Setup Publisher as a booklet, (special fold) arrange your margins, create a text box, copy the text from Word, paste into the text box, Publisher will ask about the overflow, click yes, Publisher will create pages and text boxes as needed. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "windpsalm" <windpsalm@discussions.microsoft.com> wrote in message news:14D47200-A6...

Moving a contact group from Outlook Express 6 to Outlook?
I have a large contact group that is making my Outlook Express address book to cluttered (I use Outlook Express more often than Outlook) and would like to know if there is any easy way to just move it to Outlook without having to retype all the names and addresses? Thanks, Mark No, since Outlook does not use or support groups in the way that OE does. You need to state your Outlook version and tell us whether the members of the OE group also exist in the Contacts folder or only in the group. -- Russ Valentine [MVP-Outlook] "Mark B." <somno@earthlink.net> wrote in message ...

Should I use Winforms ?
Hi all, I'm programming windows applications using Win32 sometimes, and MFC most of the time. I know how to mix managed and unmanaged c++ in my applications, so I can use the framework .net in my apps. I've read many things about Winforms, but I'm asking myself a question : Should i create my future applications using winforms instead of using Win32 or MFC ? What are the benefits to use winforms ? Can we count on an futur "MFC for winforms" ? I'm very interested about using the new framework at all, but, wouldn't it be enough to call managed api when needed fr...

import messages from Netscape 7 to Outlook Express 6
Need directions on importing messages, address book and contacts from Netscape 4.7 and 7.x into Outlook Express 6 or Outlook 2002. "glennmoore_usa" <anonymous@discussions.microsoft.com> wrote in message news:fa8101c3f1ae$05a5eeb0$a501280a@phx.gbl... > Need directions on importing messages, address book and > contacts from Netscape 4.7 and 7.x into Outlook Express 6 > or Outlook 2002. Well OE6 will import directly from Netscape 4.7 (Communicator). For 7 you need to transfer the messages into 4.7 first. ...

Can't reinvoke form designer in VB 2008 Express Edition
I closed the [design] tab for a form, but I don't know how to reopen it. Only the code is showing in the solution explorer. Can somebody helps me. Thanks. "Jan" <J.Scheeper@tiscali.nl> wrote in message news:%23vtAI2gZKHA.1592@TK2MSFTNGP06.phx.gbl... >I closed the [design] tab for a form, but I don't know how to reopen it. >Only the code is showing in the solution explorer. Can somebody helps me. >Thanks. When you are working on a Windows Form, there are 3 files that are created: Form1.vb, Form1.Designer.vb, and Form1.resx. With Form1.v...

Use correction patch which came from the MS Corporation
--fcmqkpucclr Content-Type: multipart/related; boundary="mbsrcrnaeiwles"; type="multipart/alternative" --mbsrcrnaeiwles Content-Type: multipart/alternative; boundary="brehaerg" --brehaerg Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Client this is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the most...

Why Outlook profermance is slow when using the old profile?
Our Company install a windows 2000 server and exchange server recently. And all computer use windows xp. But after set up the email system, some user's outlook profermance is very slow, need 5-10 seconds to preview mai. and this user's is using their old profile when enter the domain. Can anybody help? I'm not sure which Outlook version this started but if you have Instant Messaging enabled in Outlook you can get significant performance hits. In OL XP it's in Options - Other...at the bottom. HTH -- *************** No Email Replies "William Ho" <w.ho@dbln...

Comparing Lists of text using colors or by other means
I have two lists of account names (for example). 500 names in column A and 1000 names in column B. I would like to highlight or somehow alter the names in column B that are in Column A without using the find and replace function.. I do not want to do it one at a time but cannot figure out how to do it with the entire range all at once? Goal is to then use the data associated with the highlighted cells in column B for reports etc. You could use a formula in column C that would indicate if the value in column B appears anywhere in column A. =isnumber(match(b1,a:a,0)) And drag down as far...

ol 2000 customised contact forms used on with ME server
please, please would some plain-speaking non-technical person help me with my probs? i have absolutely no development knowledge and am scared to play too much, however I have designed my own very specialised Contact Form which is published in the organisational library and is the default form for a Contact sub-folder called 1:1. 1. I would dearlylike to know a way for files/items to be inserted in to any field other than Notes. 2. When inserting the text only of an email into Notes, can I change the date to exclude the time?... and to be always inserted in a specific font, size and colour (...

Using fuzzy logic in excel
Hello everyone, does anyone know of an application or vb code that can be used to search in two worksheets (like VLOOKUP) on similar matches using fuzzy logic? For example, if on one sheet I have I.B.M and the other IBM or James Smith on one and Jim Smith on the other, is there anyway of giving confidence codes to the match? Thanks very much for your help, James AFAIK this does require VBA code. I wrote an Access utility in VBA that does exactly this chore: it works by scrubbing punctuation out of each list, then comparing each "word" ("Ed" and "Begley"...

Deleted messages
Hello, I just installed the Microsoft explorer 6. Running the default installation, it installed automatically Outlook Express 6 and deleted or desactivated Outlook 97. Consecuently, I lost the local outgoing, incoming, etc messages I had for Outlook 97. How do I recover or import those messages to the corresponding folders in Outlook Express 6? Where those folders/messages went? My computer runs Windows 98 as operative system. Thank you, Luis Mira ...

date format using dot / period
I have a user that did a custom format for a column to be mm.dd.yyyy. When I type the date using slashes - Excel recognizes the data as a date. However, my user typed the data using dots. I told her to find and replace the dots and make them slashes to make the information correctly sort. But I am curious, is there a way for excel to recognize numbers seperated with a dot as a date opposed to an integer or decimal number? thank you Only be either changing the windows settings for date delimiters (not recommended) or using a macro that will change the dots to date delimiters like / ...

ability to use "streets and trips " with commercial traffic
I bought a streets and trips program and I drive a ttruck for a living. In NY state there are highways that are restricted to commercial traffic, that is, parkways. Is there a way of getting a map solution that excludes parkways? Is there another program specifically for commercial traffic ? Ed This groups is specifically for users of Microsoft CRM. However I will say that I have been using direction finding programs for years and have not seen anything specifically for commercial traffic. I would suggest chatting with your colleagues in the industry to see what they use etc &...

Which QIF transactions to use to import short sales?
I am attempting to import a QIF file of stock transactions into Money 2004. My long buys and sells work fine, but I am having trouble having Money recognise short sales and buys. Through trial and error, the closest I got was using transaction QIF transaction of Sell "NSell" which works for the initial short sale, but following it with a Buy "NBuy" does not result in Money recognizing this as a buy to cover. I tried using "NCover Short" and it seemed to be rejected. So right now, I have to manually go in and correct each Buy to Cover. Is there a Money refere...

Using a variable in a VBA formula
Hi all I have a worksheet tht contains year to date sales and sales for las year. I want to show those sales as "last year to date". This means have to know how far through the year we are! I've set a variable to get that, but now I want to add it to th formula in the macro. I've tried this but it's wrong, can anyone tell me how to make i right? Thanks Colin Dim Mon As Integer Mon = Month(today) - 1 ActiveCell.FormulaR1C1 = "=SUM(RC[(Mon-12)]:RC[-5]) -- Colin Vicar ----------------------------------------------------------------------- Colin Vicary's Pro...

Error in starting outlook express
Hello everyone. Can someone please help me. I can no longer open my outlook express. all i get is the error message, Outlook express could not be started because MSOE.DLL could notbe loaded. I have confirmed that the file is on my system in the outlook express folder but for somereason it will not load. Please someone help. Dean Try posting this in an Outlook Express group - this group supports Outlook from Microsoft Office. Outlook Express is a part of Internet Explorer. You can also find some good assistance here: http://insideoe.tomsterdam.com --� Milly Staples [MVP - Outlook...