f



Names of textboxes on tab-pages within a tab control?

I have a tab control named TabCtl210. It has 3 tabs.
named Page211, Page212 and Page213. Each of
those 3 tab-pages has a textbox control named
Page1HomeSpot, Page2HomeSpot and Page3HomeSpot
respectively.

I got an error #2109: "There is no field named Page1HomeSpot
in the current record"

There's only one line of code in the entire form module that
references the control:

Private Sub Page1()
DoCmd.GoToControl ("Page1HomeSpot")
End Sub

Under what circumstances would Access give em this error?
0
CRCI (2317)
8/25/2006 1:14:33 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
583 Views

Similar Articles

[PageSpeed] 55

Try:
    Me.Page1HomeSpot.SetFocus

If that still fails, and you are certain you have a text box with that name 
on your form, it sounds like Access is confused about the names. Try this 
sequence:
1. Uncheck the boxes under:
    Tools | Options | General | Name AutoCorrect
Explanation of why:
    http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
    Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by 
entering something like this at the command prompt while Access is not 
running. It is all one line, and include the quotes:
    "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
        "c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code), 
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
    http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors 
are gone, the indexes are repaired, inconsistencies between the text- and 
compiled-versions of the code are fixed, reference ambiguities are resolved, 
and the code syntax is compilable.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CRCI@NorthState.net> wrote in message
news:o7qse2hul5u61jl4d3uqj8ke7gj64al5cl@4ax.com...
>I have a tab control named TabCtl210. It has 3 tabs.
> named Page211, Page212 and Page213. Each of
> those 3 tab-pages has a textbox control named
> Page1HomeSpot, Page2HomeSpot and Page3HomeSpot
> respectively.
>
> I got an error #2109: "There is no field named Page1HomeSpot
> in the current record"
>
> There's only one line of code in the entire form module that
> references the control:
>
> Private Sub Page1()
> DoCmd.GoToControl ("Page1HomeSpot")
> End Sub
>
> Under what circumstances would Access give em this error? 


0
AllenBrowne (3681)
8/25/2006 1:25:18 PM
Thank-you, Allen. I'll give that a try.

It doesn't happen all the time. But it
did happen once and it was fairly
alarming.
0
CRCI (2317)
8/26/2006 7:45:18 PM
Reply:

Similar Artilces:

Tab control within another tab control
I am creating a form with a tab control containing 10 tabs. and what I want to do is on only on of the tabs, I want a sub section of tabs. So what it ends up being is one main tab control with another tab control embedded into only one of the tab pages. The problem I am getting is when I insert the sub section tab control into one of the tabs from the main tab control, the sub section tab control appears in every tab in the main tab control. Can anyone help? What do I need to do so it only appears in one tab, not all. Thanks As you found, you cannot place a tab control on one of the pages...

Tab control in one of the tabs of another tab control
One of my colleagues is working with a tab control. He has several tabs. He is trying to embed another tab control inside one of the tabs of the first tab control. He had placed the second tab control inside one of the tabs of the first tab control. But the problem is that the second tab control does not show up (unless one goes to the block diagram and double clicks the second tab control, only then does it shows up; when the vi is closed and reopened its again not there). I told him that I had never seen such functionality (a tab control inside another tab control) in any application but is it somehow possible. All this is required while the VI is not running and is being developed (of course it should work at run time, but this functionality must show while the VI is not running, i.e., this functionality should be non-programmatic. Is it possible. Thanks for your time. Hi rashid, yes it is possible. See the attached example. I see no problems with it.Hope it helps.Mike Untitled_LV71.vi: http://forums.ni.com/attachments/ni/170/323165/1/Untitled_LV71.vi Thanks <a href="../view_profile?user.id=88992" class="auth_text" style="font-weight: bold;" target="_blank"> MikeS81</a>! Yes you are absolutely right. Your VI is working perfectly. I wonder what has my friend done to get such behaviour as he is getting. Strange! Thanks for the help!Have a very nice day! Hi rashid, can you upload your vi, maybe someone found the proble...

Tab Events of Access Application ? (NOT Access Tab Control)
I'm trying to use the event when a person moves to a different form by clicking on the built in Access application tabs. Is there something I can reference or does it require some kind of subclassing/hook api calls? Thanks On Jul 21, 9:47=A0pm, "christianlo...@yahoo.com" <christianlo...@yahoo.com> wrote: > I'm trying to use the event when a person moves to a different form by > clicking on the built in Access application tabs. > > Is there something I can reference or does it require some kind of > subclassing/hook api calls? > > Thanks Hi Christian, You can use the OnDeactivate event. Imb. > You can use the OnDeactivate event. Hello Imb, Aha. Now I am forced to make an event for each form. Trying to automate what tab the ribbon moves to based on the access application tab. Okay, thanks. Access could use a rewrite of it's event system imho. There are no top level application events to tap into, no 'after delete' event, record saves w/ a 'dirty=true', it's all quite ridiculous. I was hoping the new table events would be the solution but they come up w/ this 'data macro' crap where there doesn't seem to be any way to call your own code on the event. Sometimes I wonder if the ms developers ever use Access. However, I love the report and form design improvements. <christianlott1@yahoo.com> wrote in message news:ba72c614-57c0-4045-9af0-3cd9734e923b@r18g2000vbs.googlegro...

How can I set the tab order of text box controls on each page of a tab control?
I need to be able to select the tabbing order of individual controls on a single page of a tabbed control. How?? In LV 6.1 an up you should be ablel to right click on the edge of the tab control when the tab-page in question is selected. The bttom selcetion in the pop-up is "Reoder controls in page..." selecting this option will switch editing modes to allow you to specify the ored, just like in a cluster. I seem to remeber in older versions you had to drag the tabable controls off the tab control, specify the tabbing oder and then drag them back on. The oldest version I have on ...

Tab control: How do I read the name of a selected tab??
Hello, &nbsp; I've got a tab control with 10 tabs and around 20 controls on each tab. I'm using an event structure but the amount of possible events (about 200) drives me crazy. &nbsp; Please tell me if the following is possible: &nbsp; I want to use a case structure to determine which tab was selected and start an event structure for that tab only. I'd only have 20 events now. When the tab control is pressed the event structure is killed (the while loop finishes), and the outer case structure determines what event structure&nbsp;to fire up now. Is this possible???...

Tab Tab
How can I direct the output from pressing tab tab to a file? Op 4 Aug 2004 12:39:13 -0700 schreef gnosis: > How can I direct the output from pressing tab tab to a file? gawk 'BEGIN {print "\t\t"}'</dev/null >file -- There's no place like 127.0.0.1 Gerard Wassink http://linux.family.filternet.nl http://freeware.family.filternet.nl Linux counter #360967, "In a world without fences, who needs gates?" gnosis wrote: > How can I direct the output from pressing tab tab to a file? I'm not sure I understand the question..... If you mean: 'put 2 TAB (0x09) characters into a text file from a command prompt', then echo -e '\t\t' >somefile or echo -e '\t\t' >>somefile If you mean: 'the output of the BASH 'TAB-TAB' "completion key combo", then no. The BASH TAB-TAB key combo is meant as input to BASH, so BASH interprets the TAB-TAB combo before you have a chance to supply any re-direct operators for the command. Regards, Larry -- Anti-spam address, change each 'X' to '.' to reply directly. ...

tab control inside another tab control
Hi. Is it possible to put a tab control inside another tab control. I tried it several times, but for some reason this doesn't seem to work. Can someone confirm this, or tell me what the trick is. Thanks. -- Georges The only way I know to do this is to put a subform on the first tab control. Then you can put your second tab control on the subform. If you do this repeatedly, however, you will find the form loading rather slowly. HTH - Turtle "Georges Heinesch" <news@geohei.lu> wrote in message news:3fe82fb8$1_2@news.vo.lu... > Hi. > > Is it possible to...

How can I lock a tab control untill fuction within tab is complete?
Hi &nbsp; I am a little stumpt.&nbsp; What I would like to do is to lock a Tab control until the fuction within the tab is complete (and have a dialogue box saying something like "fuction 1 must stop before you can run function 2"). &nbsp; I realise some event based programming would&nbsp;have been best&nbsp;but I wonder if there is a quicker fix as the code I produced is quite complex now.&nbsp; &nbsp; I attach an example (tab control and two case stuctures) to clarify what I need to do. &nbsp; I know there is probably a really simple answer so sorr...

tabbing order in tab controls
Hi How can I set the tabbing order of controls in a tab control on the front panel when having several other controls on the front panel. Right-click on the tab and select "Reorder controls In page" from the menu that pops up. This is not exactly what I meant. When I'm creating a local variable I can choose its destination (right-click - select item). Because there are so many I would like to reorder the tabbing order to choose the correct on the top. All this action are taken in the block diagramm. From the edit menu, select Set Tabbing order changing the tabbing order will also change the order the variables are listed when you want to list or select a local variable ...

Tab Indexing in a Tab Control
Anyone know why when I set my tabs index in my tab control (I have 3 tabs on the control) the numbering gets messed up when I save the form changes? I thought each tab on the control had an independent tab index, I guess not. Marcus ****** Just a suggestion, the Tab Index for a container (Tab Page) is different than the Page Index for a Tab Control. You might be thinking that the Tab Index is related to the Tab Pages. The order of the pages is Page Index. (Right Click Page Order) The order of the controls on a page, form or other container control is Tab Index. (Right Click Tab Order) T...

Hide a tab on a tab control
Dear All, I have a tab control with about 5 tabs on it. Depending on who logs on, I want to hide one particular tab. How do I do it? thanks John Fox Per John Fox: >Dear All, > >I have a tab control with about 5 tabs on it. > >Depending on who logs on, I want to hide one particular tab. > >How do I do it? Code below selects different tabs and makes some tabs invisible. 2160 With Me.tabMain 2161 If .Value = mTabMain_Page_Security Then 'If user walking a compressed list, don't want tb jumping back to sec if looking at docs 2162 If ..Pages(mTabMain_Page_CompanyGroupIssuer).Visible = True Then 2163 .Value = mTabMain_Page_CompanyGroupIssuer 2164 End If 2165 End If 2169 End With 2170 With Me.tabMain 2171 .Pages(mTabMain_Page_Security).Visible = False 2172 .Pages(mTabMain_Page_Allocations).Visible = False 2179 End With -- PeteCresswell Thank you - sorted! John (PeteCresswell) wrote: > Per John Fox: >> Dear All, >> >> I have a tab control with about 5 tabs on it. >> >> Depending on who logs on, I want to hide one particular tab. >> >> How do I do it? > > Code below selects different tabs and makes some tabs invisible. > > 2160 With Me.tabMain > 2161 If .Value = mTabMain_Page_Security Then 'If > user walking a compresse...

Vertical Tabs on Tab Control?
Hi Folks: I've used conventional horizontal tabs on one application. Now I'd like to have a row of tabs, representing each letter of the alphabet, running down the right side of a tab control. These are owner drawn tabs. I have questions. I want a single line of alphabet tabs. If the control shrinks to too small to show all of the tabs, I'd like them to display a ragged edge, and arrows in order to scroll them. Instead, multiple lines of tabs are drawn. The Resource Editor's "Tab Control Properties" window has "Multiline...

how can i print all the tab pages not just the first page (tab)
how can i print all the tab pages not just the first page (tab) You would need to do this programmatically. Here's one way: Example_VI_BD6.png: http://forums.ni.com/attachments/ni/170/326797/1/Example_VI_BD6.png ...

How to import a tab delimited text file into MS Access database
Hi, I have the following task to be done in VC++ 6.0. I have a tab delimited text file that needs to be imported into a MS Access table. The table is created and the table structure is defined using DAO methods. So now I have to fill this table with the data in the text files. For a few rows in the text file, the number of columns could be less than the number of columns in the table. Can anyone please post me the code to do this. Thanks a ton in advance. Pradeep wrote: > I have the following task to be done in VC++ 6.0. We'd be happy to give you the VBA code, but do you really want to throw away your C++ and use Microsoft Access for the job? If you want to keep C++, you can ask for C++ code in another newsgroup, because we'd just be guessing. -- Message posted via http://www.accessmonster.com ...

Getting XP look with tabbed dialog control and tab strip control
I know how to use a manifest file to get the XP look for the Windows Common Controls 6 group of controls but I also have both the tabbed dialog and tab strip controls in my app and I want those to take on the XP look as well. Does anyone know how? Also, while I am able to get the XP look through a manifest file in my app's folder I should be able to do this without the file having to be in the app's folder. I've read it has to do with compiling with a resource file but I don't know how to do that. Can anyone offer any assistance? Thanks! ...

Tab order on multirow tab control
Is there a way to stop the default action of a multirow tab control whereby the row with focus moves to the front of the tabs? I find this behaviour annoying and confusing to the user and am at a loss as to why MS has designed their tab controls like this. Wayne wrote: > Is there a way to stop the default action of a multirow tab control > whereby the row with focus moves to the front of the tabs? I find > this behaviour annoying and confusing to the user and am at a loss as > to why MS has designed their tab controls like this. ALL multi-row tabs act this way. How else can y...

Tab Control
Is there a way to lock all the items on a tab in a form without having to list each field and lock individually? I see a way to enable/ disable, but not lock. Thanks, Laura On Mar 10, 5:58=A0pm, musicloverlch <lho...@gmail.com> wrote: > Is there a way to lock all the items on a tab in a form without having > to list each field and lock individually? =A0I see a way to enable/ > disable, but not lock. > > Thanks, > Laura What I usually do is hide the tab. But if you want the user to see the data, you'll probably have to go through each control one by one and lock each. -- GL ...

Tab control tabs dissapear when clicked
I have yet another problem with the infamous tab control in my Access 97 database. I have a form with a tab control with 4 tabs on each tab is a sub form bound to a form. When the main form loads the vertical scroll bar moves the main form down just low enough to were one can't see the tabs on the tab control. Once you scroll back to the top of the main form and click on one of the four tabs the sub form on that tab becomes visible but the same scenario as above happens. The main form vertical scroll bar once again moves down just low enough to were you can't see the tabs until ...

Tab Control
Hi, all! &nbsp; I would like to customize Tabs on the Tab Control. More exactly - I would like to add bevels to the tabs as shown below: &nbsp; <img src="http://vi-lib.com/forForum/TabControlwithBevel.jpg"> &nbsp; Is it theoretically possible? May be&nbsp;some workarounds exists? &nbsp; with best regards, &nbsp; Andrey. Hi, TiTou, This requirement coming from corporate UI Guidelines, where shapes of Tabs strongly predefined. I can do required "skinning" for most controls which can be customezed, but unfortunately not for Tab Control... Andrey...

Re: tabbing order in tab controls
Is there a way to change the tabbing order without having the order on a list or local change also? I didn't take that into account when making the program, should have ordered all the control before wiring it all up :-/ Hi leachdor,When you change the tab order of a specific control in LabVIEW, it must then re-order the other controls in order to ensure that each tab order value is only applied to one control, and that there are only as many tab stops as there are controls.&nbsp; As such, there is no way to simply re-order a single control without modifying other controls. Hi and thanks for the response. I think I may have explained the behavior i'm seeing wrong.&nbsp; Changing the tab order, you have those two little boxes the first showing the changed order number, and the black background one that shows what it was previously.&nbsp; Each time you change one, yep you have to change the order of the rest otherwise you might tab and select two fields at once!The behavior I'm not sure about though, is when I change them to the proper order on the front page, it changes my block diagram.&nbsp; For example if I have a cluster with 3 items in it, and I change the tab order of the items inside that cluster.&nbsp; Then if I had previously used an "unbundle" function prior to the tab order change, and it was all wired up with item 1 at the top, item 2 in the middle output, and item 3 as the bottom output - AFTER the change, those controls...

Change values of Tabs on Tab Control
I have a LabVIEW application where it is possible to change the language on the front panel, in connection with this I want to change the names/labels of the Tabs on a Tab Control. Is this possible? Hi Labbie, yes it is possible. See the attachment. Mike Unbenannt 1_LV80.vi: http://forums.ni.com/attachments/ni/170/311358/1/Unbenannt 1_LV80.vi Awesome all... got what i needed. &nbsp; Peace, &nbsp; Pete ...

Tab control pages
I have a tab control. How can I check in an if statement which page in the tab control is currently open or visible? I tried using TabCtl.TabIndex, but that always returns 0 no matter which tab I'm on. Thanks Nevermind...I tried using TabPageName.Visible and it worked. "Enterprise" <someone@microsoft.com> wrote in message news:vNDCc.16153$Wr.2643@newsread1.news.pas.earthlink.net... > I have a tab control. How can I check in an if statement which page in the > tab control is currently open or visible? > I tried using TabCtl.TabIndex, but that always returns 0 no ...

Accessing 2 tables having same name but different databases ms-access
Hi, I have an application with MS-Access as backend and JSP/ tomcat as frontend/webserver. For getting better response time(as access is very slow compared to other RDBMS's), I have split the main DB into two DB's on different disks on my server for better performance.I have kept the table names same but changed the DB names. How do I access tables from both the DB's? This is what I have done; I made different connection to the respective DB's i.e. con and con2. When I want to access data, I am using 2 result sets for retriving data from the tables, but getting no result. Here is my code: rs2_1=stmt2_1.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' order by Req_No"); rs=stmt.executeQuery("select * from Requests where Status='Released' AND LoginName='"+login+"' AND Req_No> 5500 order by Req_No"); So, rs & stmt are for latest records and rs2_1 & stmt2_1 correspond the records from older DB. I think, I'm forgetting some small thing but cant get it. Please advice. What do you mean "no result"? Does "next()" return false for both rs2_1 an= d rs? If you're really trying to improve response time, you should probably be ru= nning the two queries in separate threads ... but as you acknowledge, Acces= s may not have as high performance as other RDBMSs. You would also see rel= iability adv...

attractive css, xp tab(page) control and grid control
This is a multi-part message in MIME format. ------=_NextPart_000_002E_01C57C0C.EE04A220 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, Any site I can download free css and xp tab/page/grid web script ? Regards Hoe ------=_NextPart_000_002E_01C57C0C.EE04A220 Content-Type: text/html; charset="windows-874" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>Any site I can download free css and xp = tab/page/grid web&nbsp;script ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_002E_01C57C0C.EE04A220-- ...

Web resources about - Names of textboxes on tab-pages within a tab control? - comp.databases.ms-access

Notes Plus on the App Store on iTunes
Get Notes Plus on the App Store. See screenshots and ratings, and read customer reviews.

Training - Algodoo
Navigation Home For Fun Algodoo Play Algodoo Physics Scenes Demo Buy For Education Algodoo for Education Lessons User stories Solutions Demo ...


Automated Test Design
... tests along with doing ET. Here's my take on a UI test for Alan's app: Open the page Check that text "Total" exists. Check that the 6 textboxes ...

Quick Answers - CodeProject
Questions - Free source code and tutorials for Software developers and Architects.; Updated: 11 Jul 2012

Cyprus By Bus Route Planner - Find your bus journey in Cyprus
Cyprus By Bus route planner for finding the best possible bus route between two bus stops in Cyprus. Based on origin bus stop, destination bus ...

Issues - gwen - GUI system aimed at games - Google Project Hosting
My favorites ▼ - Sign in gwen GUI system aimed at games Project Home Downloads Wiki Issues Source New issue Search Search within: All issues ...

ASP.NET Web Forms DynamicData FieldTemplates for DbGeography Spatial Types
... Those templates are simple. Here's the Edit example. You might say, hang on, this is just a text box! I thought we weren't using TextBoxes? ...

uCan Post WordPress Plugin Demo - Cartpauj & iComNow
This is a demo for the uCan Post WordPress plugin by cartpauj. This plugin lets users create posts and site content without having to access ...

Jennifer Semtner [ Web Designer / Developer ] » CSS
If you're using Grails and the Grails UI plugin's autocomplete feature, you may have noticed all of your textboxes have disappeared in Chrome ...

Resources last updated: 3/21/2016 2:22:26 AM