Hi all,
I have a main form with tabbed subforms(all based on different tables) where I want to display only the records the specific viewer is able to see. I know that I need to change the record source for the subforms based on the criteria of filter I want but somehow I'm lost in the syntax.
Help?
Thank you!
I have created a form which has a main section (Client demographics (bound to tblClient) and then five tabbed pages with subforms.(Data associated with the Client- all forms derived from tblAssociatedDetails). The subforms on the tabbed pages are all linked via a ClientID number.
In the form header I have put a a combo box and with the wizard said that I want it to select data from my form (in the case search via Surname). This works but only for the top part of the form (ie it will load the demographics) but will not load any of the data from the tabbed pages (subforms).
Any idea where the missing link could be?
I have a form with a tabbed area, each tab containing a subform. One of these subforms adds records to a table. Another subform shows the totals from that table.
But when I add records, the totals tab is not updated with the new quantities unless I close the form completely and go back in. I tried adding Me.Dirty = False to the subform that adds the records but that makes no difference.
It seems as though the 'totals' subform gets those values as the form is loaded and does not change, even when records are added and then that tab is selected.
How can I get the totals subform to show the updated totals?
I forum could someone tell me:
I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.
When I try to link them it says you cannot link items on an unbound form.
regards in advance
Peter:eek:
I have 7 tabs on my frmQuestions. They all the same layouts (see attached). Each tab has its Save_Button (e.g. CmdSave1, CmdSave2, ... ,CmdSave7). I do not want to write the same procedure on each CmdSave1_Click(), CmdSave2_Click() ..., CmdSave7_Click(). Are there any alternative ways to do this such as concate the string or ?
Thank you very much!
When I load my tabbed form, it always scrolls it down a bit and cuts off the tab. The user has to scroll up to show the tabs. I have tried any number of things and cannot get the form to open with the tabs showing. Is there a setting I am missing??
View 7 Replies View RelatedHi all! Going ga-ga over this, :eek: so please see if you can help!
Access 2000 by the way.
I've a really pretty form made up and it has 3 tabbed pages.Each page contains some fields which contain 'memo' data, so the entries in each field are pretty long.
When I try and print the record e.g. File->Print->Print selected record...it just
a)prints the front page/tab, as opposed to the contents of all 3 tabs
b)Truncates the data in the memo fields...it seems to just print the image of what you see when you open the form up - rather than printing the actual content of each field.
Similar thing when I try and print from datasheet view. Or from the table that the form feeds into.
What am i doing wrong? Please help! :D
Hi all! Going ga-ga over this, :eek: so please see if you can help!
Access 2000 by the way.
I've a really pretty form made up and it has 3 tabbed pages.Each page contains some fields which contain 'memo' data, so the entries in each field are pretty long.
When I try and print the record e.g. File->Print->Print selected record...it just:
a)prints the front page/tab, as opposed to the contents of all 3 tabbed pages
b)Truncates the data in the memo fields...it seems to just print the image of what you see when you open the form up - rather than printing the actual content of each field.
Similar thing happens when I try and print from datasheet view. Or from the table that the form feeds into.
What am i doing wrong? Please help! :D
Any help will be most appreciated!!
1) I have a Main form with a tabbed form that has two subforms attached to it. How do I move the focus from the last field on the first subform to the first field on the 2nd subform without using the tabs at the top of control.
2) Subform #2 is a dependent form of subform #1. Since I can have many products associated with the customer form, I have added an add new record command button using the wizards. The button does not take me to the first field on the 2nd subform it just sort of blinks.
Thanks in advance
~VanEpps
I am very new to Access and am designing a multiuser database with tabbed forms. One of the tabbed forms has 7 tabs; the first tab contains the part number and other information about a product and the remaining 6 contain additional information about that product. Is there a way to have the part number field/control remain visible when the user changes tabs, ideally without using VBA?
View 2 Replies View RelatedIf I have a tabbed from of say 3 tabs, can I use each tab to populate 3 different tables or can each tab only populate one table, hope this is clear.
I have 3 tables
a) General
b) Process Design
c) Mechanical design
By putting the tabbed form on a plain master form, I have to select one table for the record source for the master form, thus it would appear is the only table I can populate. :confused:
Thanks in advance
Hi folks,
I've got a questionnaire which has about 80 fields in 5 sections. all sections are linked to a person Id - which is the unique identifier.
I'm thinking that a tab form is the way to go in putting this form in Access in order to facilitate data entry. Is this the best way or is there another way to accomplish this task?
Does anyone have a sample form that I can modify to meet my needs?
Thanks
Will.
I have a number of tabbed pages and I was wondering if you could increase the size of the tab to make it (Vertically) larger so you could write the headings over two lines.
Also what does "Multi row" mean in the tabbed row pages?
I have a Tabbed form where one of the tabs shows about 20 rows of a table. Another tab shows a single record from that table with all the fields for that record.
I want to be able to move from tab to tab and and stay on the same record (hopefully that's clear).
What is the cleanest approach... any suggestions?
Thanks
Can you Filter a Tabbed Form?
The menu selection is dimmed for some reason.
Thanks
Hi I'm having a bit of a problem with the sql query below
SELECT [Table 1 Personal Details].Surname, Sum([Table 3 Daily Activity].[Public Holiday]) AS [SumOfPublic Holiday], [Table 3 Daily Activity].[Week Commencing], Sum([Table 3 Daily Activity].[Authorised Absence]) AS [SumOfAuthorised Absence], Sum([Table 3 Daily Activity].Holiday) AS SumOfHoliday, Sum([Table 3 Daily Activity].Sickness) AS SumOfSickness, Sum([Table 3 Daily Activity].[Unauthorised Absence]) AS [SumOfUnauthorised Absence], Sum([Table 3 Daily Activity].[Hours Per Week]) AS [SumOfHours Per Week], [Table 9 Funding].Project
FROM [Table 1 Personal Details] INNER JOIN ([Table 3 Daily Activity] INNER JOIN [Table 9 Funding] ON [Table 3 Daily Activity].[ID Number] = [Table 9 Funding].[ID Number]) ON [Table 1 Personal Details].[ID Number] = [Table 3 Daily Activity].[ID Number]
GROUP BY [Table 1 Personal Details].Surname, [Table 3 Daily Activity].[Week Commencing], [Table 9 Funding].Project
HAVING ((([Table 3 Daily Activity].[Week Commencing]) Between [Enter Start Date] And [Enter End Date]) AND (([Table 9 Funding].Project)="NETWORKS"))
ORDER BY [Table 3 Daily Activity].[Week Commencing];
My problem is that the Surname is displaying for each record.. what I mean is that I want the surname to be grouped so that I get the SUMofHours summed correctly?
here's an example of what I'm getting
SURNAME, WEEK COMMENCING, SUM OF HOURS, PROJECT
Brown,13/02/2006,35,NETWORKS
Brown,20/02/2006,35,NETWORKS
Malcolm,13/02/2006,35,NETWORKS
Malcolm,20/02/2006,35,NETWORKS
Here's what I'm really looking for though
Brown,13/02/2006,70,NETWORKS
Malcolm,13/02/2006,70,NETWORKS
I need the Hours SUMMED with no replication of surname.
Thanks
CJ
Thanks
CJ
I have been using a calendar control on a subform and have now split the data into a tabbed form with 4 subforms. The calendar is now entering the date selected into the first record of each subform instead of just the one on the subform that has the focus.
Do I need to add the calendar control to each subform now or is there a way to reference the correct form in my current code?
Private Sub Calendar_Click()
' Enters the selected date into the DateCompleted field
Forms![Training]![ElectiveTrainingSub].Form.[Date].Value = Me.Calendar.Value
Forms![Training]![CorpReqSubform].Form.[Date].Value = Me.Calendar.Value
Forms![Training]![XOGReqSub].Form.[Date].Value = Me.Calendar.Value
Forms![Training]![Recommended Training].Form.[Date].Value = Me.Calendar.Value
I have tried If Me!TabCtl159 = Me.Page160 (first tab) Then
'enter date into that record
with no luck
Any ideas would be appreciated as always!
Thanks,
Toni
Hi
I have set up a tabbed form to preview data going onto a report. There are four sub forms each on its own tab. I have locked down the data on the sub forms.
However when I open up the tabbed form the focus seems to shift to the first control on the tab. Ideally I want all the data controls on the tab to remain without focus leaving only the tab controls and the close form control that can get a focus.
Is there any way I can do this, or am I not making myself clear?
It isn't a deal breaker but it makes the form look a tad ugly!
Thanks for any help.
Tabbed multiple-page form
I have created a tabbed multiple-page form, consisting of two pages.
On one-page forms my Access is configured in such a way that, ctrl-pgDwn gets me to the next record. I want to use this on the multi-page form as well.
But I always want a new record to start with page 1, and then click forward to page 2 if required.
At present ctrl-pgDown always takes me to page 2 of the new record if I start from page 2 of the previous record (and correspondingly from page 1 to the next page 1).
Question 1:
How can I go to page 1 of the next record regardless of where I am in the previous record? (with one key-stroke)
Question 2:
Is there a way of moving through all pages of each record with the same keystroke, thus:
Record 1: pg 1, pg 2,
Record 2: pg 1, pg 2
Thanks for your help.
Adrian
I am trying to use a tabbed form, but the labels that are not associated with a text box or other control (like titles, etc) seem to aquire hyperlink properties which blink horribly when the cursor enter and leaves the label area. The two hyperlink properties are blank and I sure don't need them for anything. I tried associating the labels with a text box (which already had a label normally associated with it) and the hyperlinks and blinking goes away, but Access will only let me associate one label per control. When I have the same situation but not on a tabbed feature the hyperlink property is there, but no blinking occurs. I really - really would like to be able to use the tab style for these very busy forms. Can't imagine why a non-associated label must have hyperlink properties, or why this happens on tabbed pages and none others. GRRRR! HELP!!!
Thanks a billion!
Kye
What is the syntax for defining the tab that has focus when a tabbed form is opened under various situations?
View 2 Replies View RelatedI am trying to limit the number of records displaying in a subform [amendedLoans] by selecting only those records that have the same ClientID as the mainform [Customers] and the same loan number as the subforms parent form [ClientAccounts loan changes].[loanno].
I have no difficulty selecting records just using the clientid but as soon as I add the reference to the subform [loanno] field I get no selection of records. I suspect there is an error in the where clause for
[Amended Loans].Loan)=[Forms]![customers]![ClientAccounts loan changes].[Form]![LoanNo]) .
I have built the clause using the expression builder and have had many attempts all ending up with the same result. I'm now at a loss as to where to go from here....
When using tabbed pages is it possible to change the color of the page?
View 2 Replies View RelatedWhen tabbing through a form is it possible to highlight the field you have tabbed to?
View 1 Replies View RelatedBecause of certain design considerations and the amount of data I'm maintaining, I have chosen to use tabbed documents rather than floating windows or subforms.
The hierarchy is supposed to be a person who is categorized as either a client, family member, donor, etc. Further, a client may use one or more services. In the example, our client uses Specialized Home Care. However, the tabs are intuitively out of order: the people tab is left-most, followed by the Specilaized Home Care tab, and lastly the Client tab. It should be People, People:Client, People:Client:Service. If a person uses a lot of our services, there will be separate People:Client:Service tabs and the People:Client tab will scroll off to the right. I'd like Access to order them properly but see no way to do it.when the forms are opened, it's people first followed by the high-level classification (i.e. Client), and the lastly the specific Client:Service tabs. I would expect Access to open and display them left to right, but, as you can see, it doesn't.
I've set hyperlinks to a couple of forms using the hyperlink address in properties. All works fine, and I've done it this way because the cursor changes to pointy hand when hovering over.
However, I need to navigate to a tabbed form in a main form.
Is there a way of doing this? I've been searching all sorts, and the most probable is to concatenate the destination?
description##Page1#page2... or something like that?
Is this correct?
What ever I've tried doesn't work, this includes ...
adding the main form destination to Hyperlink Address, and tabbed form in the SubAddress (Can't find main form)
Using the hyperlink builder. (Can't find anything)
Objects in this database (Only one form).