data input in text box

We have a form which the operator enters data in a text box. Currently we 
have a 'done' button on the form that the operator clicks to send the text 
box info to a vba program. How can we send the text box info to the vba 
program when the operator hits the enter key @ the end of the data entry for 
the text box? TIA

-- 
_______________________________
In Christ's matchless name
ted     &   colleen
n6trf        kc6rue 


0
ted
9/20/2007 10:50:41 AM
access.formscoding 7493 articles. 0 followers. Follow

2 Replies
763 Views

Similar Articles

[PageSpeed] 0

Use the control's AfterUpdate event.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"ted" <n6trf@arrl.net> wrote in message 
news:O%23t9VQ3%23HHA.396@TK2MSFTNGP06.phx.gbl...
> We have a form which the operator enters data in a text box. Currently we 
> have a 'done' button on the form that the operator clicks to send the text 
> box info to a vba program. How can we send the text box info to the vba 
> program when the operator hits the enter key @ the end of the data entry 
> for the text box? TIA
>
> -- 
> _______________________________
> In Christ's matchless name
> ted     &   colleen
> n6trf        kc6rue
> 


0
Douglas
9/20/2007 11:58:40 AM
Ok & thanks again. Now I have another problem. Have been using an option 
group but now find I would like to change the label on each option in real 
time via a vba program. What do you suggest? TIA

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
news:uK0RNk6%23HHA.4584@TK2MSFTNGP03.phx.gbl...
> While the form's open in Design view, select Tab Order from the View menu. 
> Arrange the controls in the order in which you want the cursor to travel.
>
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "ted" <n6trf@arrl.net> wrote in message 
> news:%23qom3T6%23HHA.4476@TK2MSFTNGP06.phx.gbl...
>> Ok that works & thanks. Another question on one of the forms the cursor 
>> starts out in the text box BUT in another form the cursor doesn't start 
>> out in the text box. How does one fix that. TIA
>>
>> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
>> news:%23fcgX23%23HHA.4752@TK2MSFTNGP04.phx.gbl...
>>> Use the control's AfterUpdate event.
>>>
>>> -- 
>>> Doug Steele, Microsoft Access MVP
>>> http://I.Am/DougSteele
>>> (no e-mails, please!)
>>>
>>>
>>> "ted" <n6trf@arrl.net> wrote in message 
>>> news:O%23t9VQ3%23HHA.396@TK2MSFTNGP06.phx.gbl...
>>>> We have a form which the operator enters data in a text box. Currently 
>>>> we have a 'done' button on the form that the operator clicks to send 
>>>> the text box info to a vba program. How can we send the text box info 
>>>> to the vba program when the operator hits the enter key @ the end of 
>>>> the data entry for the text box? TIA
>>>>
>>>> -- 
>>>> _______________________________
>>>> In Christ's matchless name
>>>> ted     &   colleen
>>>> n6trf        kc6rue
>>>>
>>>
>>>
>>
>>
>
> 


0
ted
9/20/2007 7:04:21 PM
Reply:

Similar Artilces:

continued: multiple selections in a list-box
There was a thread started on 9/15 about this (see below) where a list box with multiple selections would be dropped into a text field separated by by commas (or whatever you want). The corrolary to this then is: now that I've got a text / memo item filled with multiple values, how do I extract that back to the list-box if the form is opened up later to that record. Secondarily, is there a way to pull each of the values from the list box and have it populate a different table that has the record number and choice. For example, the main form (tbl_main) has you choose three or more...

Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...

How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...

Formatting Text in a Forwarded Email Message
Odd problem in Outlook on one of our pc's. We are using Outlook 2002 SP3. When attempting to forward a message, I sometimes change a few of the words in the body of the message. I place the cursor within the word I wish to change. As soon as I type one letter, any letter, the letter shows up two font sizes bigger (from 12 to 14), and with a space on each side of the inserted letter. What seems to make this more puzzling is that when I attempt the same task on our other pc, everything functions as it should; no change in font size and no extra spaces. Any help in eli...

Comparing text strings
I have two columns populated with names and I need to compare them for duplicates. Some duplicate names may contain middle initial or middle names and some don't. So they may not be EXACT. Please give me suggestions on formulas or funcions that would help me accomplish this task. Thanks. On Fri, 27 Nov 2009 11:12:01 -0800, Comparing columns with text <Comparing columns with text@discussions.microsoft.com> wrote: >I have two columns populated with names and I need to compare them for >duplicates. Some duplicate names may contain middle initial or middle names ...

Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...

Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > GP Ver 6.0. Recently I...

How do I expand the amount of text I can put in a cell?
I am entering text into a cell & can see it in the formula bar up top, but it's giving me the #### in the cell that states it's too big. How can I get it to show my text? Sarah - Put your cursor between the column you want to expand, and the column to the right. When you see a four sided arrow, click and drag it to the right. You may need to also Format, Cell, Alignment and click on Wrap Text. Hope this helps, Carole O "Sarah" wrote: > I am entering text into a cell & can see it in the formula bar up top, but > it's giving me the #### in the cell...

Change a text box to a combo box
Hi there I have created several forms in my database. I realized that I should have made them combo boxes instead of text boxes. Is there any easy way for me to change them into the format I need? Thank you in advance for your help. Right-click on the text box and select changeTo from the menu. -- Reggie "forest8" <forest8@discussions.microsoft.com> wrote in message news:FD867B89-38CC-4F20-A9AE-C177444DA9DA@microsoft.com...the > Hi there > > I have created several forms in my database. > > I realized that I should have made them combo ...

Pivot Table Text Only, No calculations
:confused: I have a spreadsheet of data, text only. An address list. want to look at the table by city. Is there a way to do this withou calculation? For example, I want to have a city has the page field an look at all the addresses, including columns, within that city. Thanks -- rmm3 ----------------------------------------------------------------------- rmm30's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=835 View this thread: http://www.excelforum.com/showthread.php?threadid=26902 A pivot table is a good tool for summarizing data, but won't help...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

Message box error check box
I have built a databse, on a form i have a close button i want to do a few checks to see if certain text boxes have data in them. I would want message box and then i want it to set focus to that box ( and highty llight it in red if pos) I have about 10 checks to do on every form that the best way to do this "Simon" <S.Dickson@shos.co.uk> wrote in message news:f628c1d7-0598-4d75-bc3a-6c41df313870@m16g2000yqc.googlegroups.com... >I have built a databse, on a form i have a close button i want to do > a few checks to see if certain text boxes have data in the...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

Incorrect Field Names Appear in PivotTable Field Dialog Box
I have found that items deleted from my source, standard worksheet, are still appearing in the Pivot Table Drop down list. I have applied the sollution in MS202232 but it did not clearup the outdated data. I have refreashed the pivot table before and after runing the MACRO "Delete_Fields" Not sure what else can be done, I continue to search groups and MS. ******** This is the code for the MACRO based MS202232: Sub Delete_Fields() On Error Resume Next For Each pvtfield In Worksheets(PivotTables).PivotTables(PivotTable1).PivotFields For Each pvtitem In pvtfield.PivotItem...

Displaying Text
Hello, I have an MFC application, where I'm interested in displaying some text for the user in the client area. To do this, I create a device context, and use the .TextOut method to display CStrings. The problem begins when the window is resized, or when a menu that hides the text pops - once the menu is closed, or after the window has been resized, the text (or parts of it) are being erased. How can this be solved? I read that when the window is resized, OnPaint is called, and thus I tried displaying the text from there - hoping to re-display it "after" it has been erased. The...

Linking text to style for auto update
I want to auto update figure/table number in text to that in Figure/Table style numbers Use Insert > Cross Reference to put the numbers into the text; they don't update every time the numbering changes, but only when you tell them to (Ctrl-A, F9) or when you print or switch to Print Preview. On Dec 18, 4:05=A0pm, Taurus <Tau...@discussions.microsoft.com> wrote: > I want to auto update figure/table number in text to that in Figure/Table > style numbers ...

Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...

Advanced Filtering
Hello, I've got a worksheet with four columns, one of which is a user name. I would like to take all the user names that contain numbers (and their respective data) and put it into a separate worksheet. So far, I haven't had any luck doing this with any combination of wildcard operators. The format of the user names are two or three letters and then 4 numbers, or they are entirely text. So the list has data like abc1234, ab1234 and abcdef. I want all the abc1234 and ab1234 entries in a separate list. Any suggestions? Thanks in advance. Maybe you could use a helper column and filt...

Count invalid data entries
I am using the following macro to identify invalid data entries in cells with data validation applied. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub Is there a way to count the number of invalid data entries (red circles) and write the number to a particular ce...

Copying Formula Text
Is it possible to copy and paste just the text of a formula from on cell to another without going into the formula text window and usin Ctrl+c. Can this be done from multiple cells to multple cells. thanks -- jp ----------------------------------------------------------------------- jpx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=101 View this thread: http://www.excelforum.com/showthread.php?threadid=37716 edit/copy select new location edit/paste special, select Values. OR... Right-click the BORDER of the selection and drag to the new location. When you ...

In POwer POint 2003 can I gradually add text in the same slide?
I want to gradually add text in my presentation within the same slide. For ex: The beginning of an equation and click the mouse to complete the equation as I explain it. Read the instruction here: http://pptfaq.com/FAQ00581.htm -- James Bart: "According to creationism, there were no cavemen." Homer: "Well good riddance, their drawings sucked and they all looked like hippies!" "PP HELP" <PP HELP@discussions.microsoft.com> wrote in message news:6190E093-00D4-492A-AD1A-3F589B809E5D@microsoft.com... > I want to gradually add text in ...

Multiple combo boxes on a form
I have a form based on two tables. I would like a combo box for a field from each table that will fill in various fields from the relevant table. Does anyone have any suggestions? On Fri, 17 Aug 2007 23:58:37 GMT, "Malt" <u36720@uwe> wrote: >I have a form based on two tables. I would like a combo box for a field from >each table that will fill in various fields from the relevant table. Does >anyone have any suggestions? Why would you want to do that? It sounds like you're trying to store data from one table redundantly into a second table. This is essentially ...

forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view. All the tables, queries, and macros are there. When I open up the database to add data, all the forms are there and can be used. The data is stored. So, it seems that the forms are still there, but just cannot be seen in design view. The database, when I open it up in design view, says Access 2000 file object even though I am using Access 2003 - could that be the problem? Thanks! You cannot open an entire database in Design View. Try opening it normally, selecting a form, and choosing Design View from the V...

Text wrapping #4
Hi All I am just trying to create a document using publisher 2003. I have some pictures on the page and have text boxes containing the text I want. The problem is that it seems to be putting in the - in the text when it spreads it on to the next line. How can I stop it doing this and move the whole word on to the next line. Many thank Glenn Tools, language, hyphenation, clear the box. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Glenn Clark" <glenn.(NOSPAMclark@btinternet(NOSPAM).com> wrote in message ne...