f



Syntax of control on tab controls

I have a form "frmturnover" on which there is asubform "subfrmturnover"
which has three tabcontrols say Page1, Page2 and Page3. There is control
"control2" on Page2 that when its is entered I want to check if it is the
same value as a control "control1" on Page1 and then show a pop up box if
they don't match. I can work out the code for the message box but I'm
getting a little lost on the syntax for referring to the controls on the
pages of the tab control.
I also want to check the value of Control2 on page2 with the vale of
control3 on a page1 of a subform "subfrmmain" on another form "frmmain"
can anyone point me in the right direction?
TIA
Tony Williams


0
tw7705 (85)
12/2/2004 9:47:40 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

2 Replies
636 Views

Similar Articles

[PageSpeed] 13

"Tony Williams" <tw@tcpinvalid.com> wrote in message news:<coo2hr$285$1@sparta.btinternet.com>...
> I have a form "frmturnover" on which there is asubform "subfrmturnover"
> which has three tabcontrols say Page1, Page2 and Page3. There is control
> "control2" on Page2 that when its is entered I want to check if it is the
> same value as a control "control1" on Page1 and then show a pop up box if
> they don't match. I can work out the code for the message box but I'm
> getting a little lost on the syntax for referring to the controls on the
> pages of the tab control.
> I also want to check the value of Control2 on page2 with the vale of
> control3 on a page1 of a subform "subfrmmain" on another form "frmmain"
> can anyone point me in the right direction?
> TIA
> Tony Williams

Keri Hardwick wrote an article about this a while back.  It's on
Access Web in the forms section...
http://www.mvps.org/access/forms/frm0025.htm

if that doesn't do it, try this one.
http://www.mvps.org/access/forms/frm0031.htm
0
pietlinden (2926)
12/3/2004 4:46:24 AM
Thanks Peter that's just what I needed!
Tony
"Pieter Linden" <pietlinden@hotmail.com> wrote in message
news:bf31e41b.0412022046.3f012c24@posting.google.com...
> "Tony Williams" <tw@tcpinvalid.com> wrote in message
news:<coo2hr$285$1@sparta.btinternet.com>...
> > I have a form "frmturnover" on which there is asubform "subfrmturnover"
> > which has three tabcontrols say Page1, Page2 and Page3. There is control
> > "control2" on Page2 that when its is entered I want to check if it is
the
> > same value as a control "control1" on Page1 and then show a pop up box
if
> > they don't match. I can work out the code for the message box but I'm
> > getting a little lost on the syntax for referring to the controls on the
> > pages of the tab control.
> > I also want to check the value of Control2 on page2 with the vale of
> > control3 on a page1 of a subform "subfrmmain" on another form "frmmain"
> > can anyone point me in the right direction?
> > TIA
> > Tony Williams
>
> Keri Hardwick wrote an article about this a while back.  It's on
> Access Web in the forms section...
> http://www.mvps.org/access/forms/frm0025.htm
>
> if that doesn't do it, try this one.
> http://www.mvps.org/access/forms/frm0031.htm



0
tw7705 (85)
12/4/2004 7:17:05 PM
Reply:

Similar Artilces:

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...

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...

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...

Refs to controls on tab control
I'm really stumped. I have been able to get all of my references to all my controls with property nodes - even controls inside clusters for all of the controls on a vi front panel. However, when I move these very same controls onto a tab control&nbsp;I can't seem to figure out how to get these same&nbsp;references! I can only get the tab control ref. :smileyindifferent: &nbsp; &nbsp; <img src="http://forums.ni.com/attachments/ni/170/243049/1/Cotrols%20on%20pages.JPG"> BenMessage Edited by Ben on 04-20-2007 05:01 PM Cotrols on pages.JPG: http://forums.ni.com/attachments/ni/170/243049/1/Cotrols on pages.JPG ...

Can a Combo Box control a Tab Control, like an Enumerated Ring control can
Is there any way to have a Combo Box control a Tab Control.&nbsp; An Enumerated Ring control can if all the names match "Exactly", question is can a Combo Box do the same, especially within an Event Structure? I haven't been able to figure it out.&nbsp; Enclosed is a test VI that has an enumerated ring example, and a combo box with the same data.&nbsp; Thanks for your help... Test Tab Control [1].vi: http://forums.ni.com/attachments/ni/170/215375/1/Test Tab Control [1].vi A tab control can be treated like an enum, so your question comes down to: "Can I map a ...

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 Control and Rectangle Hiding Controls
I'm trying to change the back colour of a tab control in Access 2010 by using a rectangle. I've selected the tab control (not an individual page) and pasted the rectagle (solid with required colour). I then send the rectangle to the back and then the tab control to the back. The problem is that most (but not all controls remain hidden) on each tab. Subform and list boxes are visible, but labels and text boxes aren't. I've done this before in another application, but can't remember how I did it. Any ideas? -- Bob Darlington Brisbane On Thursday, June 20, 2013 1:57:59 AM UTC-5, Bob Darlington wrote: > I'm trying to change the back colour of a tab control in Access 2010 by > > using a rectangle. > > I've selected the tab control (not an individual page) and pasted the > > rectagle (solid with required colour). > > I then send the rectangle to the back and then the tab control to the back. > > The problem is that most (but not all controls remain hidden) on each tab. > > Subform and list boxes are visible, but labels and text boxes aren't. > > I've done this before in another application, but can't remember how I did > > it. > > Any ideas? > > > > -- > > Bob Darlington > > Brisbane Not sure I understand your issue. Anyway, check in properties and set the background to transparent. ...

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 ...

Control Container inside a Tab Control
Is there a generic container that can go in a tab control? I cant seem to get a tab control (which can hold many types of other controls) to be contained by another tab control. My main form uses a tab control (8 pages). On each page I would like to have a few groups of controls (no tabs in the group, just buttons, combos etc). I thought the tab would be a great container, but I cant put it on the 'main' tab control. Any ideas? (Currently I'm using a naming scheme) TIA No. There is no control array, and you cannot insert a tab control on a page of another tab control. You can put a subform on the page of a tab control, and the subform can contain its own tab control. -- 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. <cefrancke@yahoo.com> wrote in message news:1111241572.858053.147460@z14g2000cwz.googlegroups.com... > Is there a generic container that can go in a tab control? I cant seem > to get a tab control (which can hold many types of other controls) to > be contained by another tab control. > > My main form uses a tab control (8 pages). On each page I would like to > have a few groups of controls (no tabs in the group, just buttons, > combos etc). I thought the tab would be a great container, but I cant > put it on the 'main' tab control. > > Any ideas? (Currently I'm using a nam...

Maximum Number Of Controls On A Tab Control
Is there a "best practice" maximum number of controls that can be loaded on to a tab control before things start getting messy and sluggish? I'm asking for a "best practice" maximum number across all tabs and not the maximum number that is theoretically possible. I figure that trying to add lots of controls to lots of tabs must affect performance at some point. Any help is appreciated. Wayne wrote: > Is there a "best practice" maximum number of controls that can be > loaded on to a tab control before things start getting messy and > sluggish? I'm asking for a "best practice" maximum number across all > tabs and not the maximum number that is theoretically possible. > > I figure that trying to add lots of controls to lots of tabs must > affect performance at some point. > > Any help is appreciated. There is a maimum number of controls on a Form. Not sure about a TabControl. Think of it this way. A TabControl is just a handy way of toggling the visibility of a bunch of controls all at the same time. It likely has almost no affect on performance at all. Certainly not any that I have been able to perceive. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com On 9 Mar 2007 18:35:53 -0800, "Wayne" <cqdigital@volcanomail.com> wrote: In some applications tab controls contain subforms. If things get sluggish I typically only...

Valve control
Hello, I am still trying to figure out a method of controlling a discharge valve for compressor testing.&nbsp; The valve is controlled by a slider, but when it hits a certain point of being closed, the compressor surges.&nbsp; At that surge point, I want the user to click a button, and then have the valve slowly open while the data is being sent to&nbsp;a file.&nbsp; This way, the data is recorded and the valve opens to prevent damage to the compressor all at the click of one button.&nbsp; I have the VI up and running, all except for the opening part of the valve.&nbsp; I have included a simple example of where I am going with the valve control.&nbsp; Any advice would be appreciated, for then I can implement that code for the valve opening into the rest of my programming. &nbsp; Thank you, &nbsp; &nbsp; Jmc Valve control.vi: http://forums.ni.com/attachments/ni/170/198874/1/Valve control.vi ...

how to access database control of many oracle10g database instances on same server
I am on Redhat Linux 9 and using Oracle 10G (10.0.1.3?). I know how to create a Oracle database instance and use EM database control to administer the database. To access database control from a browser, Oracle asks to enter a URL: http://server_name:5500/em The URL does not specify the ORACLE_SID. I however want to create several database instances on the same box. Will Oracle automatically set up a different port (e.g., 5501) for second instance. All the documentation I have found on Oracle's web site refers to a single database instance on a server. Appreciate any pointers. Thanks a lot, Prem You need to read about Grid Control. Actually when you create your database using DBCA, it should ask you whether you want to use Grid Control or DB Console. Jining Han Jining Han wrote: > You need to read about Grid Control. Actually when you create your > database using DBCA, it should ask you whether you want to use Grid > Control or DB Console. > > Jining Han I hae read about Grid Control, but I think there is still a way to access many instnaces on the same server using database control. Prem Of course you can, a DB Console for each database, and you can choose that as your preferred approach, too. But I really think it's a waste of resources and a big inconvenience. You are probably better off with the "tradictional" desktop console. Just my 2 cents. Jining Han <premmehrotra@hotmail.com> wrote in message news:...

How to control the tab control using event structure?
Hi, I am using tab control and event structure in the program. When i run the application event is not happening for the active page. When user switches from active page to the other page then event is&nbsp;taking place for all pages &nbsp; So, how to get the event trigger for the active page when the application is started &nbsp; For more clarification i am attaching the code "Test Control Tab using Event Structure.vi" Test Control Tab using Event Structure.vi: http://forums.ni.com/attachments/ni/170/288159/1/Test Control Tab using Event Structure.vi You have a basic misunderstanding of dataflow. Maybe you should start with some tutorials or study some of the examples that ship with LabVIEW. - The event structure belongs inside the while loop, and not vice versa. RIght now, the event structure only runs exactly once and never again. - If the stop is pressed first, the VI will stop. Game over. - If the tab control is changed (from any state to any other state!), the inner loop will spin forever as fast as the CPU allows, either executing one or the other case. It just reads the tab terminal to decide which case to execute. Changing tab never triggers any events.&nbsp;The VI is trapped inside the event until stop&nbsp;is pressed to&nbsp;stop the VI. you were closer to a reasonable program in the other thread: <a href="http://forums.ni.com/ni/board/message?board.id=170&amp;view=by_date_ascending&amp;message.id=287905"...

tab control strict typedef hides controls
"Has the issue of no typedef tabs been resolved in LV7? I am modifying a LV61 vi and severely broke the panel trying to convert a tab to a typedef. I was able to customize, however there was a compile/save error and all the embedded controls on the tab pages became hidden and un retrievable." Jim Henderson" Zvezdana In my disgust, I had deleted all copies of the offending vi. I believe my problem must have been, primarily, a corrupted compile/save. Thanks Jim ...

Control visiblilty of a text box on a Tab Control
Hey, thanks for reading my question. I'm using a combo box to control the visibility of a text box. When I make a change to the combo box it will set the visible property to true on a text box. When I had these objects not on the Tab Control everything worked great. Now with these object on the tab control and I open the form the vicinity works but when I change the combo box which set the visibility nothing changes. What am I missing? Any one got any suggestions. N. Graves wrote: > Hey, thanks for reading my question. > > I'm using a combo box to control the visibility of a text box. When I > make a change to the combo box it will set the visible property to > true on a text box. When I had these objects not on the Tab Control > everything worked great. Now with these object on the tab control and > I open the form the vicinity works but when I change the combo box > which set the visibility nothing changes. > > What am I missing? Any one got any suggestions. Is your code behind your combobox still there? When you move an object (cut and paste) to a tab control the event procedure code is "lost". You may note that your Event Procedure is not there anymore in your combobox properties.. but when you click on the build button it will bring up the code... and upon returning the Event Procedure reappears! An Access quirk:) -- regards, Bradley Is it possible that your text box is behind the tab control? Peter De Bae...

OT: MS Access runtime wants to control all MS Office charts
Office 97, Access 97, Sagekeys scripts. In addtion of Access 97, my runtime package is installed too. This is an old application that has been running since 1998. The customer is happy with it. I have a glitch in.... Powerpoint 97. When an user double-clicks a chart, it starts my Ms Access Runtime Installer! It will do the same if he right-clicks and uses 'Edit'. If he selects 'Open', it will do it in a separate windows and it is Ok. Thius probably comes because MS Chart is shared among office apps. I would really like to have this problem even if there is a turnaround and I have the feeling that the solution should be in the registry, but I can't find where. Any help appreciated. TIA. "saintor1@hotmail.com" <saintor1@hotmail.com> wrote in news:1183816847.132126.79420@c77g2000hse.googlegroups.com: > Office 97, Access 97, Sagekeys scripts. In addtion of Access > 97, my runtime package is installed too. > > This is an old application that has been running since 1998. > The customer is happy with it. > > I have a glitch in.... Powerpoint 97. > > When an user double-clicks a chart, it starts my Ms Access > Runtime Installer! It will do the same if he right-clicks > and uses 'Edit'. If he selects 'Open', it will do it in a > separate windows and it is Ok. Thius probably comes because > MS Chart is shared among office apps. > > I would really like to have thi...

Access Controls in Access
How on access can you set access controls to your users? If they log in with one username and password they can just read information and if they log in with another username and password they can read and write? I have no idea how to do this, is it even possible?? Thank you Try playing with the access security tool, you can add users, groups, passwords, read/write allowances etc. to your database using that. Its under the 'Tools' menu of Access. Brian wrote: > Try playing with the access security tool, you can add users, groups, > passwords, read/write allowances etc. to your database using that. > Its under the 'Tools' menu of Access. Playing is not the proper word for it. I would never "play" with installing security without a backup copy of the System.mdw file or a backup of the application. You should also recommend the SecFaq when "playing" with security. http://www.mvps.org/access/resources/techpapers.htm. Dangerous http://www.youtube.com/watch?v=ASIVv_LiBoU Yeah i suppose playing wasn't the correct word for it. Hey Thanks for both your help. I'll try that. "Hanny J" <hannyjones@aol.com> wrote > Thanks for both your help. I'll try that. Note that a well-versed author and authority, Roger Jenkins, back in the days of Access 2.0, characterized Access' Security as "labrynthine". It has not gotten any less complex, and I caution that, while it is "doable&qu...

[rfc-dist] RFC 5417 on Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option
A new Request for Comments is now available in online RFC libraries. RFC 5417 Title: Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option Author: P. Calhoun Status: Standards Track Date: March 2009 Mailbox: pcalhoun@cisco.com Pages: 6 Characters: 11551 Updates/Obsoletes/SeeAlso: None I-D Tag: draft-ietf-capwap-dhc-ac-option-02.txt URL: http://www.rfc-editor.org/rfc/rfc5417.txt The Control And Provisioning of Wireless Access Points Protocol allows a Wireless Termination Point to use DHCP to discover the Access Controllers to which it is to connect. This document describes the DHCP options to be used by the CAPWAP Protocol. [STANDARDS TRACK] This document is a product of the Control And Provisioning of Wireless Access Points Working Group of the IETF. This is now a Proposed Standard Protocol. STANDARDS TRACK: This document specifies an Internet standards track protocol for the Internet community,and requests discussion and suggestions for improvements. Please refer to the current edition of the Internet Official Protocol Standards (STD 1) for the standardization state and status of this protocol. Distribution of this memo is unlimited. This announcement is sent to the IETF-Announce and rfc-dist lists. To subscribe ...

Syntax form moving from page-to-page (actually, Tab-toTab) in Tab Control on form?
I thought it was DoCmd.GoToPage - but that doesn't work for Tab Controls, it seems - only for forms with page breaks in them. Anybody know Syntax form moving from page-to-page (actually, Tab-toTab) in Tab Control on form? On Wed, 15 Feb 2006 06:31:38 -0500, MLH <CRCI@NorthState.net> wrote: >I thought it was DoCmd.GoToPage - but that doesn't work for >Tab Controls, it seems - only for forms with page breaks in them. > >Anybody know Syntax form moving from page-to-page (actually, >Tab-toTab) in Tab Control on form? Courtesy of Rick Brandt in another thread... The TabControl has a Value property that corresponds to the the page index of the currently selected TabPage. Setting that value brings the TabPage with that index to the front. For example to switch to the 3rd TabPage... Me.TabControlName = 2 (index starts at zero) Thx, Rick. ...

What is syntax for displaying a specific tab of a tab control upon an "on open" event of a form?
I'm starting to learn about the tab control. How would I write an on open event procedure in VBA, that upon opening of the form, a specific tab opens (say tab 1)? Thanks Jerry The pages of a Tab Control are 0 based meaning the first TabPage is page 0. Add this code to the open event to open to a specific page: First Tab --- Me!NameOfTabControl.Value = 0 Second Tab --- Me!NameOfTabControl.Value = 1 Third Tab --- Me!NameOfTabControl.Value = 2 etc -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications Over 1100 users have come to me from the newsgroups requesting help resource@pcdatasheet.com <jerry.ranch@pioneer.com> wrote in message news:3dskt19hnui0jq35norc4sth6r5d72sjcr@4ax.com... > I'm starting to learn about the tab control. > > How would I write an on open event procedure in VBA, that upon opening > of the form, a specific tab opens (say tab 1)? > > Thanks > Jerry Yep Thats the syntax Thanks a bunch Jerry > >First Tab --- Me!NameOfTabControl.Value = 0 >Second Tab --- Me!NameOfTabControl.Value = 1 >Third Tab --- Me!NameOfTabControl.Value = 2 ...

How to access only boolean control value that is part of a cluster of controls
I have created a set of boolean controls in a cluster. Is there a way to access only one of the boolean control (i.e. "stop" button) so that I can change its states in the program, indepent of the rest of the boolean controls in the same cluster? &nbsp; Thanks! &nbsp; -NewUser2007 NewUser2007 wrote:-once I unbundle the boolean clusters and selected the stop boolean, how can I "wire a new value" to it (since it was created as a boolean control).&nbsp; I never said anything about "unbundle"! There is a 180� difference between "unbundle" and "bundle". :) You only need to unbundle if you want to know the current value, this is not needed if you want&nbsp;to write a new value regardless of what the current value is. &nbsp;<img src="http://forums.ni.com/attachments/ni/170/287328/1/clusterModify.png"> Message Edited by altenbach on 11-29-2007 08:20 AM clusterModify.png: http://forums.ni.com/attachments/ni/170/287328/1/clusterModify.png ...

Tab Control Back Style Windows Themed Controls
A2003. I rather like the appearance I get with windows themed controls turned on, but I'm running into an odd problem with tab controls. When I set the back style to transparent, it really isn't transparent. I'm finding instead of one text box or a button that I'd like to have on the form "shining through" and displaying with all pages, it's as if the tab control keeps the odd colour background it generates. I originally developed the current app in question in A2003, but with a different theme than I have right now on my PC and the colours, such as the standard system colour -2147483633 for form backgrounds is a nice beige/tan colour. In spite of the nice colour, however, instead of one text box that lists information from another form, I must place one on each of the tab's pages. Instead of one OK button and one cancel button, I must either raise the blinking bottom of the tab control or put a copy of the two of these buttons on each page. It's irritating. Anyone else run into this and have a solution? TIA -- Tim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me ...

MS Access Stock Control
Hi Guys, I am doing a stock list of Printer tonors, with the following tables Printer_tonor_Stock Tonors Printers ----------------------------- ------------- -------------- RecordID TonorID PrinterID PrinterID Tonor Printer Name TonorID Colour Serial Number Date Stock Model DepartmentID I have done a form with th Printer_Tonor_Stock Table, basically what I want is, when I fill out a record (combo box of TonorID), i want a query (or 2) to say if the Printer_tonor_Stock.tonorID = Tonors.TonorID, then Tonors.Stock should = Tonors.Stock-1. How can I put this into a query pleeease Help!! (the results will be shown at the bottom of the Printer_Tonor_Stock form). Also please excuse my bad database design as I am just a lowly Helpdesk guy :o( Thanks in advance Phreake I would change your database design slightly Phreake, You should not be storing stock as a number. It should be a calculated field. Try the following site for example data-models: http://www.databaseanswers.org/data_models/index.htm They don't have an exact match but any stock control model should suffice. Failing that try butchering the Tradewinds example database which ships with access. HTH John. "Phreake" <phreake@hotmail.co.uk> wrote in message news:1143714918.673460.293590@e56g2000cwe.googlegroups.com... > Hi Guys, > > I am do...

Web resources about - Syntax of control on tab controls - comp.databases.ms-access

Control - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

From Armenia to Australia, how the mob controls the trafficking of ice into Australia
In America, they are called the "Five Families". The term refers to the five major New York organised crime families of the Mafia, with a history ...

From Armenia to Australia, how the mob controls the trafficking of ice into Australia
In America, they are called the "Five Families". The term refers to the five major New York organised crime families of the Mafia, with a history ...

From Armenia to Australia, how the mob controls the trafficking of ice into Australia
In America, they are called the &quot;Five Families&quot;. &nbsp;The term refers to the five major New York organised crime families of the Mafia, ...

How-To: Reduce iPhone screen brightness beyond what’s possible in Control Center or Display & Brightness ...
... about sharing in the past, involves reducing iPhone screen brightness beyond levels that are possible with the standard brightness slider controls. ...

Stagefright-based ‘Metaphor’ exploit can take control of your phone in just 15 seconds
The old Android malware beastie is at it again, with researchers uncovering a new Stagefright-based exploit that can be used to take control ...

Creative Control explores the dark side of augmented reality—with humor
... Here's what the future looks like: collecting data on people while wearing AR glasses. 7 more images in gallery In the film Creative Control ...

4 Ways to Control Your Mind and Lose Weight
... after a week of eating the same things. I have found that almost anytime I have plateaued, a cheat meal has broken the plateau. Gain Control ...

Cruz on Border Control: 'Nothing Is More Important Than Having Boots on the Ground'
We know how to solve the problem of illegal immigration, Sen. Ted Cruz (R-Texas) told a gathering at the U.S.-Mexico border in Douglas, Arizona ...

MIT, Harvard researchers push new way for users to control access to personal data
Cryptography researchers at MIT and Harvard have developed software called Sieve that is designed to help users keep track of encrypted personal ...

Resources last updated: 3/21/2016 1:05:49 PM