Sync Tabbed Form
Feb 25, 2008
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
View Replies
ADVERTISEMENT
May 31, 2005
Hi Gang,
I am using Access 2000.
I have a Main form that displays a sub-form. On the sub-form is a image box that displays a jpeg associated with the current record. The jpegs are stored outside of the db as links and the links are stored in a table in a field called Image1Lrg_Path. Due to the GUI design the image box is a set size = 4cms X 5cms.
On the sub-form I have a cmd button that when clicked should open a seperate pop-up form that *should* display a large version of what ever jpeg is being displayed on the sub-form. The user would then have to close this pop-up to return to the db in order to continue scrolling through the records as normal.
Main Form = frmPlant_Main
Sub-Form = frmPlant_Sub1
Sub-Form Control = Garden_Sub
Image Box = Image1
pop-up form = frmLargeImage1
pop-up Image Box = Image1Lrg
Here's my problem:
If I set the pop-up form up a normal form and have a linked control on it (to display the image) and a text box (in which to type in the image path and name) and a cmd button that, when clicked, sets the image box to the value of the text box. Then this all works great, what ever jpeg file name I type in the text box, providing it exists of course, is displayed when I click the command button. Iset it up this way first as a test to see if I could get the image displayed OK.
Just for reference, here is the code I use for the command button;
-------------------------Code Start---------------------------
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Me!Image1Lrg.Picture = Me!Image1Lrg_Path.Value
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
----------------------Code End--------------------------------
Now, if I try to link the pop-up to the image being displayed in the sub-form Access throws up "Can't find the form" errors.Just while I set this up, I am using the cmb button to set the path but in the final db I will want the pop-up form to select what ever jpeg is being displayed on the sub-form as its path.
Can any one suggest how I can get this to work?
Again, for reference, here is the code that I am trying to use when linking the image in the pop-up with that shown on the sub-form;
-------------------------Code Start---------------------------
Private Sub Command1_Click()
On Error GoTo Err_Command1_Click
Me!Image1Lrg.Picture = Forms![frmPlant_Main]![Garden_Sub].Form![Image1_Path].Value
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
----------------------Code End--------------------------------
My grateful thanks in advance,
Kenny
View 2 Replies
View Related
Feb 17, 2015
I have tblEmployees for employee info
tblEmployeeAbsences for employee absences
tblVacation for employee vacation info
While entering the employees hours I want an adjacent subform to show the matching employees absence and vacation days taken if any.My approach was to use a Cartesian qry for the record source for the subform and link it with a fake key from the main form.
View 3 Replies
View Related
Aug 29, 2012
I have a main form and four subforms all of which were created from the tables without queries. The main form pulls employees personal data (never changes). The subforms pull Events attended, Lodging at the event, Family that attended the event and Employee minutia which changes per event. I'd like to have a button on the main form that changes the records in view for all of the subforms at once. This way it is easier for the users and I know that I am view all the pertainent info for event A instead of viewing event A's lodging info with event B's family info.
View 3 Replies
View Related
Jul 28, 2014
I have a main form with multpile tabs - each tab containing a different subform.
Link Master Field: ClientID (field in Master Form)
Link Child Field: Client ID (field in all subforms)
There is another field that all the subforms (continuous type) have: ObligorName. All the subforms are based off of a huge table (subtable) with fields: Obligor Name, Address, Zipcode, City, DOcuments Required, Bank Account Number, etc......
Essentially, the user will fill in the 10 obligor names associated to ONE client on the first subform on the first tab + address + zip code + city.
When the user clicks on the second tab to fill out the next subform, I want all 10 obligor names to be there already, so then they can fill out Documents Required + BAnk Account Number.
If I fill out the first subform and then exit out of the form and then reopen it, the other subforms autofill.
HOWEVER, I dont want to have the user have to do this. It wastes a lot of time. What can I do about this so that the table is automatically updated right away. They are all based on the same table so I do not see why there is so many issues.
View 14 Replies
View Related
Apr 15, 2005
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!
View 7 Replies
View Related
Oct 17, 2004
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 Related
Feb 6, 2006
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 Related
Aug 15, 2006
If 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
View 3 Replies
View Related
Jan 5, 2007
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.
View 11 Replies
View Related
Feb 20, 2008
Can you Filter a Tabbed Form?
The menu selection is dimmed for some reason.
Thanks
View 1 Replies
View Related
Apr 13, 2005
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
View 5 Replies
View Related
Mar 30, 2006
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.
View 2 Replies
View Related
Jul 10, 2006
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
View 1 Replies
View Related
Aug 12, 2006
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
View 4 Replies
View Related
Oct 12, 2006
What is the syntax for defining the tab that has focus when a tabbed form is opened under various situations?
View 2 Replies
View Related
May 5, 2015
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).
View 4 Replies
View Related
Sep 28, 2014
how to populate a tabbed form with a different record on each tab?
View 3 Replies
View Related
Oct 6, 2013
I want to have a navigation Form where the top tab will show the main Customer, and in the same tab also a sub table with chosen contact information.
With that top tab chosen, I want to chose left tab wich shall open (in this example) the phone number of that contact.
I provide a PDF with a few pictures of tables, relationships and how I want the forms to look.
View 5 Replies
View Related
Mar 10, 2014
everything has been working perfectly except for date diffs.I am simply using an unbound text box with a date diff as a calculator of sorts, which meets the form's purposes. Everything works fine when the two dates are on the SAME tab using the formula ' =DateDiff("d",[DOB],[date of treatment]) ' entered in the textbox.
The number of days between treatment and DOB pops up immediately.
However, when trying to create a second date diff between two source text boxes on SEPARATE tabs, (i.e. DOB on Tab 1, and date of treatment and the unbound date diff calc box on Tab 2) the date diff does not work unless the form is opened, and closed again. As in, the only time the number of days pops up is if the form is closed and opened again.
View 3 Replies
View Related
Jan 22, 2014
I have a form which consists of four (4) tabbed sheets. The first sheet is the main form and the other three sheets are the linked subforms.
Pressing the tab key on the keyboard navigates from field to field in each individual form; however, I would like that when I get to the last field of each form, pressing tab moves to the next sheet or the first field of the next subform.
The problem I am getting is that when I get to the last field of the main form and/or subforms, hitting the tab button creates a new record in the specific form, which I do not want. I want to just tab to the next subform.
View 14 Replies
View Related
May 31, 2015
I have an unbound form with 2 tabbed Controls on it.On the first Tabbed Control my command button code works but not for the 2nd tabbed control. Although the command buttons themselves work as far as going to the appropriate record.
What I mean by this is that I use code to enable/disable the command buttons depending on what record you are on.
Example: If there is only 2 record, the other command buttons will be disabled, Do I have to refer to the Tab Control ?
View 1 Replies
View Related
Sep 11, 2014
If I have a field in a tabbed form (the form has pages), can this field be moved from a tab to another programatically?
The form is called "ProjectMain". The field is called "Lenght" and the page (form tab) it is on is "specs1". Sometimes I need to have this field in the page (form tab) "specs2"
View 3 Replies
View Related
Nov 17, 2011
I have an application where I have developed a tabbed user input form with several tab pages to populate several tables with data using the master/child linking philosophy. There is one subform in particular that has two combo box fields that are related. I have them both set up to display value choices based on an undelying query. I want to restrict the scond box's choices based on the choice made in the first box and have written the following code to be applied after the first combo box is updated.
Private Sub RteGroup_AfterUpdate()
Form_Routing.OpType = Null
Form_Routing.OpType.Requery
Form_Routing.OpType = Form_Routing.OpType.ItemData(0)
End Sub
This effectively limits my second combo box choices based on the selection of the first box. It works fine if I run the subform individually but if I run it as part of the master form in tabbed mode I get an "Enter paramter value" dialog box asking for the value of the first combo box. it appears the requery is not functioning under the tabbed mode.
View 9 Replies
View Related
Feb 1, 2005
I have a client using an access DB that I have built. It was built using Access 2000 and he is running it on Access 2003. The problem is that when he opens one of the forms which is tabbed and he moves to the second page when he moves the mouse pointer over some hyperlink buttons the background colour ,which is normally blue flashes to yellow. Every other user working with 2000 does not have this problem. I cannot find the reason. Can anyone help please?
View 1 Replies
View Related
Dec 5, 2006
Hi all
This isn't the standard problem with DTPickers & Tab to which I've found lots of references!
I have a form with a Tab control, each page of which has a subform on it. There are several MS Date & Time Picker (6.0) controls on each tab. My problem is this: whenever you change tab when one of these DTPickers has the focus, you then can't type text (into a text or combo box, for instance) on the new tab until you have been into and out of another DTPicker control! (The KeyPress etc events do get triggered though). Once you've selected a DTPicker, you can then select another control and type text in OK.
The forms/controls aren't bound if that's relevant. It may be that the problem is caused by moving between subforms rather than between tabs.
Has anyone else had trouble with this? Is it a bug or expected behaviour (though I can't see why it would be)?
And most importantly, how can I get around it? Hope someone can help.
Dave
View 1 Replies
View Related