f



dragging existing controls onto a new 'tab control'

I have an form that I want to reorganise by putting some of the
existing controls onto a new tab control (using Access 2K)

When I drag a control onto a specific page of the new tab control,
rather than appearing just on that page, the control appears on all
pages of the tab control.

Can anyone tell me how to make it visible just on the page on to which
it is dragged?

Thanks

Damian.
0
4/16/2004 1:56:54 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
334 Views

Similar Articles

[PageSpeed] 29

Go to design view, select the tab control and make the background property
'Normal' rather than 'Transparent'. You can then drop controls on any page and
they will only be on that page. After installing the controls, you can change it
back to Transparent if that is what you want.

--
                                         PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdatasheet.com
                                 www.pcdatasheet.com


"Damian H" <damianhelme@hotmail.com> wrote in message
news:2b893e38.0404160556.163b4d90@posting.google.com...
> I have an form that I want to reorganise by putting some of the
> existing controls onto a new tab control (using Access 2K)
>
> When I drag a control onto a specific page of the new tab control,
> rather than appearing just on that page, the control appears on all
> pages of the tab control.
>
> Can anyone tell me how to make it visible just on the page on to which
> it is dragged?
>
> Thanks
>
> Damian.


0
spam8773 (270)
4/16/2004 2:21:31 PM
Reply:

Similar Artilces:

A 'datagrid' or 'table' in MS Access
I'm developing a form in Access with VBA. But i didn't found a good way to display the results of a query. I would like to show the results in a way simular to a table in access. (and not as a subform) Any suggestions how to implement this ? Regards, Jon S. wrote: > I'm developing a form in Access with VBA. > > But i didn't found a good way to display the results of a query. > > I would like to show the results in a way simular to a table in > access. (and not as a subform) > > Any suggestions how to implement this ? Ummm.... A subform in datasheet view? A continuous subform with fields side by side to look like a datasheet? A listbox? Br@dley I used a subform in datasheet view, and it starts to look as i intended it. Thanks for the reply Regards, ...

Controlling the 'On change' event for a numeric control.
Hi, I would like to be able to compare a control's new value with its old value, whenever it is changed by a user. The control holds a numeric value, qty_Sold, when this value changes I need to check its validity and apply appropriate actions. I have tried to do this using the control's 'On Change' event, and the properties '.Value' and '.Text' to return the control's old and new values. Unfortunately this event triggers on each character entered. i.e. to change an old value of 1 to a new value 234 would trigger the code behind the event three times: changing the “1” to a “2” - code triggered; user must now re-enter control, position cursor to right of the “2” and enter “3” - this triggers code; user must now re-enter control, position cursor to right of the “3” and enter “4” - this triggers code, for the final (and only required) time. Clearly this isn't acceptable to the user, so how do I achieve the required comparison only when the user has completed their change? I don't know if this effects anything, but the control is in a datasheet sub- form. Many thanks, Simon -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200803/1 "SimonG via AccessMonster.com" <u41095@uwe> wrote in message news:809bdb88ac39d@uwe... > Hi, > > I would like to be able to compare a control's new value with its old > value, > whenever it is changed b...

'is not' or '!='
A newbie question to you; what is the difference between statements like: if x is not None: and if x != None: Without any context, which one should be preferred? IMHO, the latter is more readable. On 2014-08-18 21:35, ElChino wrote: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: > > Without any context, which one should be preferred? > IMHO, the latter is more readable. > "x == y" tells you whether x and y refer to objects that are equal. "x is y" tells you whether x and y actually refer to the same object. In the case of singletons like None (there's only one None object), it's better to use "is". "ElChino" <elchino@cnn.cn>: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: Do the following: take two $10 bills. Hold one bill in the left hand, hold the other bill in the right hand. Now, the bill in the left hand "is not" the bill in the right hand. However, the bill in the left hand "==" the bill in the right hand. > Without any context, which one should be preferred? > IMHO, the latter is more readable. In almost all cases, both tests would result in the same behavior. However, the "is not" test is conceptually the correct one since you want...

'^=' and '~='?
Hello, What is the difference between '^=' and '~='? Thanks, Duckhye ...

Controlling the text in plot 'xyz' title 'text'
Hi Can somebody help me out? I want to change the text fonts which appear in keys for every line, in command: plot "file" title "xyz" How to use desired font size for xyz above? Thanks -- Your's truly Masroor Bangesh help title: gnuplot> help title The `set title` command produces a plot title that is centered at the top of the plot. `set title` is a special case of `set label`. Syntax: set title {"<title-text>"} {offset <offset>} {"<font>{,<size>}"} {{textcolor | tc} {lt <line_type> | default}} {{no}enhanced} show title If <offset> is specified the title is moved by the given offset where <offset> is specified by either x,y or x,y,z, and may be preceded by `first`, `second`, `graph`, `screen`, or `character` to select the coordinate system. See `coordinates` for details. By default, the `character` coordinate system is used. For example, "`set title 0,-1`" will change only the y offset of the title, moving the title down by roughly the height of one character. <font> is used to specify the font with which the title is to be written; the units of the font <size> depend upon which terminal is used. `textcolor lt <n>` sets the text color to that of line type <n>. `noenhanced` requests that the title not be processed by the enhanced text mode parser, even if...

"Method 'Controls' of ojbect 'CommandBarPopup' failed" ?
I get this error every so often. Some bogus error number (such as -2147467259), too. Google searches imply that it can be caused by manually adding/deleting menu items on the fly, but it happens to me when a modal form is active and a timer function fires. Some of the code it runs (not sure what exactly) breaks it. Part of the menus are then hosed (i.e., you click and it doesn't "drop down", even if there are items in there). The only "solution" I've found is to resort to a backup and re-code everything since that point. Can anyone help me find a better soluti...

'Logarithmic' option under 'Scale' of a Slider control does not work on PDA?
Hello, &nbsp; &nbsp;&nbsp;&nbsp; In a LabVIEW PDA application, I need to use a 'Slider' control with a logarithmic scale.&nbsp;For this,&nbsp;the scale has to be made logarithmic using the slide control's properties &amp; check the 'Logarithmic' option under 'Scale' tab. I observe that the scale becomes a logarithmic one on desktop but on PDA, the scale does not become logarithmic i.e. it is still the default scale. I have attached a sample VI which shows this problem on PDA. Has anyone faced this problem before? Is there a solution or a workaround for this? &nbsp; Thanks &amp; Regards, Subhashini &nbsp; TestSlider.vi: http://forums.ni.com/attachments/ni/170/314938/1/TestSlider.vi Hi Shuba, &nbsp; That is a known issue for us, and unfortunately&nbsp;at the current time logarithmic scales on LabVIEW PDA are not supported.&nbsp; This is documented in CAR ID: 96710.&nbsp; ...

Can control file be 'too new' in RMAN?
As part of delete obsolete after a level0, rman deletes a bunch of older control files. Can a control file be 'too new' for any PIT recovery in the past? We use 'copies 3' instead of 'days x' in our rman config. My understanding was that it's not having the latest control file that can pose a problem, not the other way around... Thanks, ........ We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) remove NSPAM to email NetComrade a =E9crit : > As part of delete obsolete after a level0, rman deletes a bunch of > older control files. > > Can a control file be 'too new' for any PIT recovery in the past? > > We use 'copies 3' instead of 'days x' in our rman config. > > My understanding was that it's not having the latest control file that > can pose a problem, not the other way around... Is the database in archivelog mode? Which Oracle version? On Tue, 18 Mar 2008 06:24:48 -0700 (PDT), vitalisman@gmail.com wrote: >NetComrade a ?crit : >> As part of delete obsolete after a level0, rman deletes a bunch of >> older control files. >> >> Can a control file be 'too new' for any PIT recovery in the past? >> >> We use 'copies 3' instead of 'days x' in our rman config. >> >> My understanding was that it's not having the latest control file that >> can pose a problem, not the other way around... > &...

'Tab Control' (TabCtl), subforms; performance question
Hello, If I have a form containing a Tab Control with N pages, each page containing a subform, are those subforms loaded into memory when another page has the focus? I have tried iterating through the AllForms collection, but it only shows the parent form as being loaded. I have a project with a large number of single forms that I would like to group together under one or a few parent forms, using Tab Controls to accomplish this; however, my users are in a shared-resource environment (Citrix) with limited resources, and if all subforms in all pages are loaded at all times, I would probably need to keep the page count for each parent form to a minimum. If anyone has any comments ofradvice, I would very much appreciate hearing them. Much Thanks, Robert Waters robert.waters@gmail.com wrote in news:1159274554.694967.40110@m7g2000cwm.googlegroups.com: > If I have a form containing a Tab Control with N pages, each page > containing a subform, are those subforms loaded into memory when > another page has the focus? Yes. The subforms are populated when the main form is loaded. > I have tried iterating through the > AllForms collection, but it only shows the parent form as being > loaded. That's because the subforms are loaded as children of the main form, so their name is not the same as their name when they are not imbedded. You'd find the same thing when you use the Forms collection (which is for open forms only). > I have a project with ...

'''''''''''''The Running Update/Append Queries Using VBA code Ordeal''''''''''''''
Hello fellow programmers, I am trying to run an append/update query from code, a command button on a form initiates the queries. the format i am using is; _____________________________________________________ SELECT "criteria" FROM "criteria" WHERE "criteria" UPDATE/APPEND "field selections" RecordSource "qryExample" = above text strings" _______________________________________________________________________ When i am running a SELECT query in this manner it works fine with no problems, and accepts the values of specified linked form fields. This never works when doing an APPEND/UPDATE query. It can never find the values of linked form fields, Access always asks for the parameter value of the field(s) in question, or Access comes up with an error 3323 - No recordset. I am sure there are other people that have had this problem. What is the difference between Select queries and append/update queries? the append/update queries never seem to be able to find values in linked form fields. Can anyone shed any light on this or point to a knowledgebase Item, or even recommend a book focusing on this subject, I will go and buy it now. I have been for up 2 nights trying to acomplish this and now considering suicide, please help. Thanks In advance, Aaron. I know of two ways you can accomplish this. 1. You can create the SQL script for you append or update query and run the script with DoCmd.RunSQL. 2. You can create a...

How to corrupt a MS Access database file in a 'normal' way?
Here is the situation: I wrote a VB programm, which stores all the information in a single Access database file using jet engine. It worked well, however one of my customs reported that there was some problems with this programm. I checked, the log files showed that the database was corrupted. The customer told me that there no 'illegal' operation such as pull out the plug, or kill the programm via task manager... So is there any possible normal operation which could corrupt the database? such as 'Weird characters' I guess? (The custom is from Italy, is there any special Italian chars could do this?) Of course it is possible that there are some bugs in the programm, which possibly caused a error may corrupt the database file, but still, how? The program wasn't stopped violently anyway ... Anyone could give some idea about this? Since it is rather hard to talk to Italians... So I can not completely investigate 'what they did about the program'... I have to check the program and potential operations which may corrupt the database. Thanks a lot. shineofleo wrote: > The customer told me that there no 'illegal' operation such as pull out > the plug, or kill the programm via task manager... > Of course it is possible that there are some bugs in the programm, > which possibly caused a error may corrupt the database file, but still, > how? The program wasn't stopped violently anyway ... > > Since it is rather hard t...

How do i controll the 'datatip'?...
Hello All, I have applied the 'slice' function to a 3-D surface. I am interested in getting the 'datatip' to follow and display the values at the intersection of the original 3-D surface and the surface generated by the 'slice' function. Is this possible? Many thanks in advance Bek ...

How do i control the 'datatip'?
Hello All, I have applied the 'slice' function to a 3-D surface. I am interested in getting the 'datatip' to follow and display the values at the intersection of the original 3-D surface and the surface generated by the 'slice' function. Is this possible? Many thanks in advance Bek ...

' More controls' empty
I've seen several references in newsgroups to using the 'More Controls' button on the toolbar, for such items as the built in Rich Text Control. But when I press this button, I get nothing. I am using Office XP Developer. I have tried resetting the toolbar. -- Bob Darlington Brisbane ...

'''''''''''''The Running Update/Append Queries Using VBA code Ordeal'''''''''''''' #2
Hi, Thanks for ur help there HJ. I know how to do the tasks you specified there. I would like for the update query to use field values from some of the fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, DateTo. My problem is that an append/update query can't find the values in the open Form (frmInvoices) when I specify them as; [Forms]![frmInvoices]![InvoiceNumber] a select query has no problem finding the field values on a form. please help. Aaron Hi Aaron, Could you post the entire code that you are having trouble with? Now it is not possible to see what goes wrong. HJ "Aaron" <aaron@rapid-motion.co.uk> wrote in message news:260d7f40.0408120245.2f3d01f8@posting.google.com... > Hi, > > Thanks for ur help there HJ. > > I know how to do the tasks you specified there. > > I would like for the update query to use field values from some of the > fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, > DateTo. My problem is that an append/update query can't find the > values in the open Form (frmInvoices) when I specify them as; > > [Forms]![frmInvoices]![InvoiceNumber] > > a select query has no problem finding the field values on a form. > > please help. > > Aaron First off, if you are not always using all the parameters specified in your form, then you have to add parameters to your query on the fly. Also, you can't just do something like qdf.SQL = "SE...

if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.') Any shorter ?
Hi, there. =20 I'm just curious if it ever dawned on anybody how to abbreviate this line : if str_mo not in ('','.') and str_da not in ('','.') and str_yy not in ('','.')=20 =20 Igor Kurbeko Clinical Programmer Analyst 678 336 4328 ikurbeko@atherogenics.com =20 no brain no pain =20 how about: if not (str_mo in ('','.') or str_da in ('','.') or str_yy in ('','.')) OR if not (missing(str_mo) or missing(str_da) or missing(str_yy)) Eric On 22 Oct 03 21:13:37 GMT, ikurbeko@ATHER...

A function with 'and' , 'not' , 'null' , 'car' and 'cdr'
What's this ? (defun enigma (x) (and (not (null x)) (or (null (car x)) (enigma (cdr x))))) "I suppose I should learn Lisp, but it seems so foreign." - Paul Graham, Nov 1983 On Wed, Oct 07 2015, CAI GENGYANG wrote: > What's this ? > > > (defun enigma (x) > (and (not (null x)) > (or (null (car x)) > (enigma (cdr x))))) Bad taste? It returns T if the list X contains nil as an element. It would be clearer to write (some #'null x). Helmut CAI GENGYANG ...

How to add records with 'Autonumber' property to a MS Access database using LabVIEW?
I am trying to write to a MS Access database. Everything works fine as long as I add data to all records at the same time. The database I am using have two tables (just for testing) with a 'one-to-many' relationship between the two. They both have a PrimaryKey with the data type 'AutoNumber'. From what I understand those numbers should be automatically generated when new data is written to the DB. I can't get that to work with LabVIEW. I am using the function 'DB Tools Insert Data.vi'. According to the manual I should be OK with specifying the column I want to write...

[News] [Rival] Melinda Gates 'Plants' Self-congratulatory 'Articles' in the Paper Whose Board She Controls
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Melinda makes an informercial disguised as an oped for a newspaper where she sits on the board ,----[ Quote ] | Next time Gates Keepers wants to publish an | infomercial disguised as an oped in a | newspaper we will be sure to go to a | newspaper where we sit on the Board of | Directors. That is what Melinda has done. | Has this Gates Foundation board member no | shame? Why didn't she send it to another | paper where she doesn't sit on the board? `---- http://gateskeepers.civiblog.org/blog/_archives/2010/2/23/4463848.html More propaganda.... "In Hanson and Edstrom's view of the world, Gates should be Microsoft's spokesman. Microsoft's cofounder, Paul Allen, had resigned in 1983 after battling Hodgkin's disease, and Gates fit the consummate developer image. Hanson sent around a gag order—no talking to the media. This was, to say the least, not a popular decision with Microsoft's developers." --Barbarians Led by Bill Gates, a book composed by the daughter of Microsoft's PR mogul Gates Foundation relationship with Catholic Relief Services questioned ,----[ Quote ] | In exchange for perpetuating this glorious | deception and maintaining a silence on the | Gates/Buffett world-wide killing machine, | CRS has received in excess of $40 million | for global and agricultural development and | financial services for the poor from 2003 | to 2009. Compared to the billio...

'Adding new data file' vs 'extending existing data file size' to increase Tablespace
As the Tablespace is almost filled on the running system now, we have to add additional space to the Tablespace. As I understand, the following are the two options available to do that: 1) Add a new data file to hold the additional data in Tablespace: SQL> alter tablespace my_TS add datafile '/someDir/my_TS2.dbf' size 100M; 2) Resize the existing Tablespace's data file. SQL> alter database datafile '/someDir/my_TS1.dbf' resize 200M; What is the best way to go? In my understanding, the 1st option is not preferable as the Tablespace is spread over 2 data files and hence, performance may get impacted slightly. Hence, I would prefer to go for the 2nd option. Kindly give your opinion on it! "qazmlp" <qazmlp1209@rediffmail.com> wrote in message news:db9bbf31.0410200930.2fa3a642@posting.google.com... > As the Tablespace is almost filled on the running system now, we have > to add additional space to the Tablespace. > > As I understand, the following are the two options available to do > that: > 1) > Add a new data file to hold the additional data in Tablespace: > SQL> alter tablespace my_TS add datafile '/someDir/my_TS2.dbf' size > 100M; > > 2) > Resize the existing Tablespace's data file. > SQL> alter database datafile '/someDir/my_TS1.dbf' resize 200M; > > What is the best way to go? > In my understanding, the 1st option is not preferable as the > Tablespa...

error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ##...

error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ########################################################################### #define MODULE #define __KERNEL__ #include <linux/config.h> #include <linux/module.h> #include <linux/kernel.h> /* printk */ #include <linux/fs.h> / #include <linux/errno.h> /* error codes */ #include <linux/types.h> /* size_t */ #include <linux/proc_fs.h> /* proc file system */ #include <linux/fcntl.h> #include <asm/system.h> /* cli, flags */ #include <asm/uaccess.h> /* copy from/to user */ /*Registers to get qadc access*/ volatile unsigned short * qadcmcr = (unsigned short *)0x40190000; volatile unsigned short * qacr0 = (unsigned short *)0x4019000a; volatile unsigned short * qacr1 = (unsigned short *)0x4019000c; volatile unsigned short * qacr2 = (unsigned short *)0x4019000e; volatile unsigned short * qasr0 = (unsigned short *)0x40190010; volatile unsigned short * qasr1...

Override 'and' and 'or'
Is it possible to override 'and' and/or 'or'? I cannot find a special method for it... __and__ and __rand__ and __or__ and __ror__ are for binary manipulation... any proposals? Have marvelous sunday, Marco Dekker <m.aschwanden@gmail.com> wrote: > Is it possible to override 'and' and/or 'or'? I cannot find a special > method for it... __and__ and __rand__ and __or__ and __ror__ are for > binary manipulation... any proposals? If you want to customize the truth value testing you have to implement __nonzero__ " __nonzero__( self) Call...

'[OFF]' as in 'offensive'???
Hi, given that 'off-topicness' is indicated as '[OT]' and taking a look at those postings that started the threads indicated as '[OFF]' (which may both be seen as being somewhat offensive) may lead to the conclusion that '[OFF]' stands for offensiveness. I don't think that this is the intended meaning so what actually *does* '[OFF]' mean? I never came across that abbreviation before (although I have been around on the USENET for quite some time) but maybe it is worth knowing? Josef 'Jupp' Schugt NOTE: mails >100 KiB are ignored -- German edition of comp.lang.ruby FAQ - http://oss.erdfunkstelle.de/ruby/ Aurox Linux - http://qurl.net/7q | http://qurl.net/7r - Firefox Thunderbird - http://qurl.net/7s | http://qurl.net/7t - Liferea Enigmail - http://qurl.net/7u | http://qurl.net/7v - GnuPG [Josef 'Jupp' Schugt <jupp@gmx.de>, 2004-12-10 23.20 CET] > I don't think that this is the intended meaning so what actually *does* > '[OFF]' mean? Off-topic. ...

Web resources about - dragging existing controls onto a new 'tab control' - comp.databases.ms-access

Resources last updated: 3/21/2016 5:40:54 PM