Tab control question about updates

Searched but couldn't see this discussed.

I have a form with 5 tabs.

Data can be loaded three ways, manually entered, imported from a text file,
and imported from a Word template.

On one of the tabs (the second) when the user enters information such as a
social sec. number (SSN) that matches a file already in the system, a flag
goes off and alerts the user.  Works fine.

On the import functions, the data is loaded and appears correctly, but when
the user moves to the second tab where the SSN number appears, it does not
set off the flag when the page opens.

I can make it happen with a couple of mouse clicks here and there but I
would like it to happen when the tabbed page is opened.

Using Access '97 at this time on this project.

Thanks,

Doug Sanders





0
Doug
10/21/2007 2:24:42 AM
access.forms 6864 articles. 2 followers. Follow

2 Replies
670 Views

Similar Articles

[PageSpeed] 7

Make sure you aren't using the tab page, or tab control's CLICK event.  It 
won't work right.  Make sure you are using the tab control's On Change event 
to test which page has been selected and run the code accordingly.
-- 
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista


"Doug Sanders" wrote:

> Searched but couldn't see this discussed.
> 
> I have a form with 5 tabs.
> 
> Data can be loaded three ways, manually entered, imported from a text file,
> and imported from a Word template.
> 
> On one of the tabs (the second) when the user enters information such as a
> social sec. number (SSN) that matches a file already in the system, a flag
> goes off and alerts the user.  Works fine.
> 
> On the import functions, the data is loaded and appears correctly, but when
> the user moves to the second tab where the SSN number appears, it does not
> set off the flag when the page opens.
> 
> I can make it happen with a couple of mouse clicks here and there but I
> would like it to happen when the tabbed page is opened.
> 
> Using Access '97 at this time on this project.
> 
> Thanks,
> 
> Doug Sanders
> 
> 
> 
> 
> 
> 
0
Utf
10/21/2007 7:54:02 AM
I'll give it a try.

Thanks,
Doug

"boblarson" <boblarson@discussions.microsoft.com> wrote in message
news:DE9DAA0F-AF36-443E-99EF-7CFF296BA573@microsoft.com...
> Make sure you aren't using the tab page, or tab control's CLICK event.  It
> won't work right.  Make sure you are using the tab control's On Change
event
> to test which page has been selected and run the code accordingly.
> -- 
> Bob Larson
> Access World Forums Super Moderator
> ____________________________________
> Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
> WinXP, Vista
>
>
> "Doug Sanders" wrote:
>
> > Searched but couldn't see this discussed.
> >
> > I have a form with 5 tabs.
> >
> > Data can be loaded three ways, manually entered, imported from a text
file,
> > and imported from a Word template.
> >
> > On one of the tabs (the second) when the user enters information such as
a
> > social sec. number (SSN) that matches a file already in the system, a
flag
> > goes off and alerts the user.  Works fine.
> >
> > On the import functions, the data is loaded and appears correctly, but
when
> > the user moves to the second tab where the SSN number appears, it does
not
> > set off the flag when the page opens.
> >
> > I can make it happen with a couple of mouse clicks here and there but I
> > would like it to happen when the tabbed page is opened.
> >
> > Using Access '97 at this time on this project.
> >
> > Thanks,
> >
> > Doug Sanders
> >
> >
> >
> >
> >
> >


0
Doug
10/21/2007 11:03:49 PM
Reply:

Similar Artilces:

Do MFC ActiveX Controls have dual interfaces?
Do MFC ActiveX Controls have dual interfaces? Kurt ...

Update Record Performance
I currently have C++ code that processes a raw data file containing multiple types of records. The code creates records in multiple tables in an Access database depending on the record type. The records are created one at a time as the data is read. I don't think this is very efficient. But I can't change this part of the processing. There are hunderes of thousands of records in raw data and the tables. I now need to update fields in created records from data contained in other tables in the database. The options I've come up with are: 1. In the C++ code, read t...

Macro Question Again
I'v never had any dealings w/ macro before, so this is all new to me. I have a windows 98 computer that is running office 2000 and there is an excel macro on this pc that was created by someone years ago. I have to get this 98 machine of the network and replace it w/ a 2000/XP platform also running either office 2000/xp. So far i'v copied the macro and am able to run it, but its not gathering the correct info. It is collecting the correct info on the 98 machine, just not the one im replacing it w/. It looks like some of the fields are supposed to be populated w/ info in a text d...

Master/content pages: prob with passing a control to JS
Hi, my code: .... <script type="text/javascript"> var myfilter = myJSfunction(document.myform.ListBox1); </script> </form> When compiling the web page, because of the master/content, the Listbox1 control gets a different name/id apparantly. So how can I pass my listbox on as an argument of my JS procedure? thx for helping, J "Jokke" <Jokke007007@hotmail.com> wrote in message news:7839C9C3-037F-4550-B5BC-E6BA75D93A99@microsoft.com... > When compiling the web page, because of the master/content, the L...

Question on Returns to Vendor without PO & Receipt number
Our company switched to Great Plains Dynamics from Simply Accounting 3 months ago. We currently need to return some of the inventory items to our vendors. However, when we try to enter a transaction entry in Purchasing/Returns Transaction Entry, in the detail lines we are asked for the PO number or the receipt number. We are not allowed to go further or save without the PO number or receipt number. When we converted from Simply Accounting, all we entered was the beginning balance of the vendors and only the PO's which we expect to receive. The older PO's were not carried over. W...

Licensing Question with Professional Suite
Hey, I've seen some licensing questions out there, but wanted to be clear. Microsoft Reps are giving me different information, but admit they do not know!? I think there needs to be a little more training with the CRM licensing. I need the CRM Professional Suite (sales and service). If I have 5 sales people (that don't really need to get into the Service Stuff), and I have 5 Service People (that don't need to do anything with Leads and other stuff), can I purchase 5 Sales Professional Users and 5 Service Professional Users? Or do I still need to purchase the Suite User...

Report of sales by month based on a cross tab query
Hi, I have a cross tab query that will provide sales by month for 2008. Right now it is sales for January08. As there are sales for future months, they will appear as well. I want to create a table that has all of the months listed out already. Right now, on the first day of the month, I go into the report and add the new month. I want it so that all month are listed which I have done. The problem is that when I run the report, I get an error that says "the Microsoft Jet does not recognize February as a valid field name. After today, there will be February data but no March ...

Questions about Migrating from Outlook Express to Outlook
I'm thinking about migrating from OE 6 to Outlook 2003 and was wondering if I will lose my folder structures, rules, and address book by doing so. I also use Yahoo POPs for importing my Yahoo e-mails into OE. Will I need to reconfigure the Yahoo POPs to work with Outlook after the migration? Thanks in advance for your help! Spudy Not sure about the YahooPOPs thing but using Outlook's File menu > Import & Export command should get most of the data. You can also try exporting from OE. "Spudy" <spudy@spamless.com> wrote in message news:th1hd1ddvnto8he4fsv9mluf...

exchange 2003 +recepient update services
Hi i have this issue for months now. I have win2k AD network with exchange 2003. My pdc went down, but before it went down i managed to transfer all the FSO roles to my secondary domain controller successful. All seemed well, but then when i access exchage system manager to create a mailbox for a new user it gets up to 60% on the task but then throws up an error message of : <?xml version="1.0" encoding="unicode" ?> - <taskWizardRun taskName="Create Mailbox" dcName="DC2" buildNumber="6944" runningAs="Administrator@domain....

Which Controls to Build a Parent/Child Web Form
Hi there, I'm quite new to asp.net, but know exactly how to do this using classic ASP, but would like some pointers for aspnet2. I've got data being returned from an SP which looks like this: HeaderItem ChildItem A A1 A A2 A A3 B B1 etc I want to display the data like this A - This is the header record A1 A2 A3 B - Header 2 B1 etc. In classic ASP I'd write out my header row html when HeaderItem changes value and then write the Child Rows. As I've on...

IF question...
I need a formula which will allow me to accept a number if it falls within a certain range. For instance, I want the cell to recognize the number in the cell if it falls between 1 and 10. Otherwise, I want the cell to return a 0 value. Anybody? =IF(AND(A1>=1,A1<=10),what?,0) On Mon, 25 Oct 2004 19:15:06 -0700, "mailrail" <mailrail@discussions.microsoft.com> wrote: >I need a formula which will allow me to accept a number if it falls within a >certain range. For instance, I want the cell to recognize the number in the >cell if it falls between 1 and 10....

Outlook macro question
I have two email accounts in Outlook 2003. I know about the Accounts drop list in new emails. But is it possible to create a few macros so that I end up with two buttons where each runs a macro that starts a new email using a specific account? One button would start a new email using account 1 and the other button would start a new email using account 2. If so, could someone please give me some pointers? Thanks. Outlook doesn't provide any direct way to change the account for an = outgoing message in versions before Outlook 2003. See=20 http://www.outlookcode.com/codedetail.aspx?id=3D88...

Event ID 9554/Unable to Update Mailbox SD
I am continuing to get the event below; I referenced Microsoft KB 555433 in which it details how to use ADFind Utility to locate the mailbox in question and update the permissions -- however, there is no account in my domain that matches that GUID. Any ideas? Event Type: Warning Event Source: MSExchangeIS Event Category: General Event ID: 9554 Date: 10/6/2005 Time: 8:59:59 AM User: N/A Computer: MY EXCHANGE SERVER Description: Unable to update Mailbox SD in the DS. Mailbox Guid: fe3913d5-a4e0-4c0e-b3b1-291f50d7fc4f. Error Code 0x8004010f For more information, click http://www.microsoft.c...

sales line detail window-after updating the request Ship Date-also
I am also using manufacturing, when you change the requested ship date, you get a window asking: You can update the In House due date, What is the name of this window in modifer? I would like to modify this form, so the No button is disables, I want to make sure they always click 'yes' How do I find this form in modifer? the form name is just 'Microsoft GP Dynamics' thanks -- Doug ...

Stack overflow question
Occassionally when on Facebookwith MSIE if I have 2 instance of Facebook open (Different pages) I will get an error message of "Stack Overflow at Line: 31". When I click OK the page finishes loading fine. Any suggestions as to what is going on? Running: <<< System Summary >>> > Manufacturer : eMachines Inc. > Mainboard : eMachines WMCP61M > Chipset : nVidia GeForce 6100V > Processor : AMD Athlon Neo MV 26 @ 1600 MHz > Physical Memory : 4096 MB (2 x 2048 DDR2-SDRAM ) > Video Card : NVIDIA GeForce 6150SE nForce 430 ...

Easy question on Excel...
Hello I have an Excel workbook open which has 5 worksheets. How do I toggle through them manually without using the mouse to click a sheet? I am sure I used to know how but now I forget! Regards Alex Try Ctrl + PageUp Ctrl + PageDown Regard -- Message posted from http://www.ExcelForum.com Well done. Thanks. >-----Original Message----- >Try > >Ctrl + PageUp > >Ctrl + PageDown > >Regards > > >--- >Message posted from http://www.ExcelForum.com/ > >. > Ctrl + Page Up or Page Dow -- Message posted from http://www.ExcelForum.com Hi I th...

Excel template and access questions
We are going to use the Excel purhase order templates. We need to save each order in order to refer back to it. Is there a way to do this without saving each individual file (order)? Can we save in some sort of easy to locate "batch"? Also, is there a way to transfer a template that we have done (and all the data realted to it) into a Acess database withouthaveing to so much tweaking? If you have Access, I would suggest creating your purchase order database in Access and then having a mail merge push this information into an Excel template as needed, rather than going the othe...

Runtime Control Addition
Hello everybody, I was searching the net for any resource that helps me on the subject of Adding Controls at runtime into a MFC application. I also wanted to handle the messages as well. Please help me on the subject with any tips or resources you know. Thank you so much. Shervin Hello Shervin, > Hello everybody, > > I was searching the net for any resource that helps me on the subject > of > Adding Controls at runtime into a MFC application. I also wanted to > handle > the messages as well. > Please help me on the subject with any tips or resources you know. >...

Update Problems
I have encountered repeated problems when I try to update my accounts online. Initially, the updates failed about a week ago. I have since "stopped using online services" and then re-started the online services (re-entering my information for each account) in the "Manage Online Services" window. When I do that, I have only been able to successfully update the accounts in Money that initial time. Every subsequent update fails. To make this even more strange, I noticed that my accounts in the Money.msn page update when I click "Update Now" in Money, but ...

Button Control Event: question
I have a small dialog that prints data it queries from a server to a listbox when a user presses a start button. What I'd like to do is to have the data continually print after the button is pressed until the user presses a stop button. So, I guess I would need to initiate some kind of continuous loop for the data querying/printing, but I'm unsure how to get the stop button to break the loop. If this even the best solution. Does anyone have any ideas of how I could accomplish this, or perhaps a better design idea? Thanks, Marcus Marcus wrote: > I have a small dialog that prints d...

How can i null out a field going through CRM Update object
I have a custom field that i want to set back to null. Any ideas how i can do this through the object.update function? thanks ...

TAB Order
Hello, i want to transfer focus from child window to parent window how can i do it ? or what message is sent to application when TAB is pressed i couldn't get it done with keydown Thanks. Danish. Danish, GetParent()->SetFocus(); will transfer the focus from this window to its parent. Johan Rosengren Abstrakt Mekanik AB "Sahil" <coder@topcoder.com> a �crit dans le message de news:%23h0o2TAOEHA.540@TK2MSFTNGP11.phx.gbl... > Hello, > i want to transfer focus from child window to parent window how can i do it > ? or what message is sent to application when T...

Simple question about text within a cell
I can't seem to find the option that prevents text from covering the adjacent cell. For example if I type the folling in cell A1: All I want for Christmas is my two front teeth. Obviously that will overflow over the cell B1 (if there is no data in B1). I don't want to resize my column, I only want the cell to show as much text in A1 as possible without covering cell B1. I believe I've seen the option to do what I'm looking for but I can't seem to find it and I can't figure out how to look it up in the HELP file. Thanks in advance. Rick My simple solution ha...

Some stupid questions about edit the aspx file
Hi, I'm quite newbie about asp.net & other web application. I've heared that we can put some code in the CRM aspx file. For example, we can make OnChange event to the textbox in CRM & put some code in it. I know it is unsupported by microsoft, but I need to know how to do it. I've been searching this newsgroup & microsoft.public.crm, but I couldn't found any sample. My question is pretty simple (or stupid, I guess): I've looked in inetpub\wwwroot\SFA\quotes\edit.aspx, but I don't know what to do. My friend telling me that the code behind, is under som...

Hyperlink in my Dialog control
I want my text in a dialog control to behave like a hyperlink in a web page. Is it possible and how(VC 6.0) Thanks I. Lesher http://www.codeproject.com/miscctrl/hyperlink.asp Here are some examples: http://www.codeguru.com/staticctrl/HyperlinkStatic.html http://www.codeproject.com/staticctrl/cmyhyperlink.asp http://msdn.microsoft.com/msdnmag/issues/01/01/c/default.aspx (look for CStaticLink) -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "Lesher" <Lesher@triplebit.com> wrote in message news:uRDIoju#DHA.808@TK2MSFTNGP12.phx.gbl... | I want my text in a dialog contr...