Parent Form Vanishes When I Tab To Option Group In The Child Form?!
I have a rather annoying and frustrating problem which I cannot find a solution for through searching the forum.
The situation is that I have a parent form with 1 unbound subform, the source of which is determined by the part number selected in the parent form (diffetrent parts have different fields of the source table displayed)
This all functions perfectly well in all but one case which is when the source of the subform is a form with an option group.
There is only 1 form like this, and the problem I have is that when tabbing through the fields, as soon as I tab into the option group the parent form disappears, and I am left with just the subform on screen! Clicking into the group is fine, just tabbing to it causes the problem, and if I remove the option group then tabbing through all the rest of the fields is fine...
I could powssibly change the option group for a set of option buttons and code them to function a bit like an option group, but this would mean changing the code for numerous reports etc. and I don't really want to do that if I can help it.
View Complete Forum Thread with Replies
Related Forum Messages:
Child Form Loads Before Parent?
Hi, I've got a parent/sub-form set up, both of which derive their data from linked tables connecting to a central database. As a result I've had to add coding to the NewRecord events to fetch the next primary keys from the database. Unfortunately I'm finding that one loading the new record, the child form seems to be loading before the parent, ie the child form_Current event occurs before the parent form_Current event. Is this how it should be? It seems intuitive that the parent should load first. I'm sure I can develop some cunning logic to get around this problem but I'm sure there must be a better way. Has anyone any experience of this parent/child set-up with linked, central database tables? thanks! Dave
View Replies !
Trouble Updating Parent Tables With Child Table/form
Sorry this is so long but I am trying to make it as detailed as possible... The Setup My database is similar to the sample "Service Call" db. I have a main table called "tblTT" which has an autonumber primary key. The table also contains several foreign keys such as UserID (not an autonumber) from "tblUser", TechID (also not an autonumber) from "tblTech", etc. I have the relationships setup with "Enforced Referential Integrity" for both updating and deleting records. Each relationship has a RIGHT OUTER JOIN ("Join 3" in access) so that all records from child (tblTT) and only equal from parent (tblUser, tblTech, etc.) will be included. I have a form for nearly every table which serves different purposes but the main function of the DB is to create new Trouble Tickets (TT's), a.k.a. service calls. Therefore the main form used is my "frmTT" form in add mode. The form contains all the fields from my "tblTT" table and contains (directly) no fields from any other table (I guess indirectly it contains fields from all the parent tables...). The Problem When I pull up "frmTT" and try to create a new Trouble Ticket for a user that does not yet exist in the table "tblUser" I get the error "You cannot add or change a record bcause a related record is required in table 'tblUser'". What I want is for my users (the "Techs") to be able to create a new Trouble Ticket without having to worry about populating the "tblUser" table (and other parent tables) first. My Solution I was going to (and unless someone can find an answer for me still will) fix this using VB script by setting up a query to check all the parent tables for the values in their corresponding fields in the form. If the query returns no results an "INSERT INTO" statement will run to populate the parents tables so that the form will save itself into the Trouble Ticket table ("tblTT"). I feel that this is a huge work around and not the proper fix. I would prefer to do this the right way both to have a correctly setup DB and for future reference. Can anyone help me with this? Thanks, Andy
View Replies !
The Form Vanishes
I am adjusting the form. I inadvertently touch the right click, or the mouse wheel, and voila! there the form isn't. The scroll bar has appeared, and is hard at the bottom. I try to pull the form back up, in case it has somehow shot far downwards. The scroll bar indicator comes up to the top, but there is no form, and the moment I release the indicator, it shoots down to the bottom. I restart and still none of the centre part arrives - unless I let it appear just in user mode (shift not held down). No, I've not been out for a wet lunch. And this isn't the first time. Anyone had this before - anyone know the answer, please?
View Replies !
Help On Printing Out Form(s) Using An Option Group
I've got an option group that displays the selected chart as a sub-form within the option group form. I want to print out the selected chart using one cmd print button. Below is my code ..... It works fine, however how do I keep the database window hidden? Select Case Frame2 Case Is = 1 stDocName = "Open Issues by Project Chart" Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, stDocName, True DoCmd.PrintOut DoCmd.SelectObject acForm, MyForm.Name, False Case Is = 2 stDocName = "Open Issues by Assigned To Chart" Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, stDocName, True DoCmd.PrintOut DoCmd.SelectObject acForm, MyForm.Name, False Case Is = 3 stDocName = "Open Issues by Category Chart" Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, stDocName, True DoCmd.PrintOut DoCmd.SelectObject acForm, MyForm.Name, False Exit_CmdPrtChart_Click: Exit Sub Err_CmdPrtChart_Click: MsgBox Err.Description Resume Exit_CmdPrtChart_Click End Select End Sub
View Replies !
Require Answer For Option Group On Form
I'm creating an employee survey database and I'm using option groups for collecting general information such as office, department, etc. My question is can I make it a requirement for them to answer an option group before moving on to other questions? I'm trying to control and track how many employees have taken the survey. Right now I can skip these general information questions and just go into the survey questions so I'm trying to prevent that. Also in the same train of thought is it possible to not save any incomplete surveys? Say I have 50 questions and someone starts the survey but only answers 10 questions and then exits for whatever reason. I would like that record to be deleted so it does not count. If I allow incomplete surveys then I can get skewed numbers. As always you help is greatly appreciated. Thanks, Chester Campbell
View Replies !
Updating Option Group Within A Form (problem)
I have a form where the users need to update an option group when they enter any information on the form. The problem is that the users don't always update this option group. The option group does not have a default value and has only two options. When the user updates a form they need to choose a value. One problem though, they may have to go in and update the form later and this action may cause them to change the option selected within the group. Is there code I can use to alert them to first update the option group when updating the form and second to change the value within the option group when they need to. Option Group --- Incomplete and Complete Date Resolved can trigger the Complete option to be updated I am seriously thinking we should make Incomplete the default value and then I would only need code for changing the option group from Incomplete to Complete. However, Management wants the Option Group so we can run a report that lists all of the Incomplete and Null values within it. Any help would be greatly appreciated. Thanks...
View Replies !
Parent/child Relationships
Hi all I seem to be having a problem with acess 2003 in that when ever I set the parent/child relationships and go back to the front end the simple disappear? any thoughts would be grate Thanks James
View Replies !
Parent-Child Cascading Deletes
I have a simple Family table: PersonID Name ParentID where, in the case of a child, its ParentID contains the PersonID of its parent. In the Relataionships window I put two such tables, Family and Family_1 and I joined Family.ParentID to Family_1.PersonID. I set referential integrity, cascading updates and cascade deletes. I made a Parents form (by setting the ParentID criteria to Is Null), and added a Children subform (linking the ParentID of the subform to the PersonID of the main form). The cascading updates works when I add a new child but when I try to delete a parent I get the error: Could not update; currently locked. Why doesn't the cascade delete work?
View Replies !
Update Subforms - No Parent/Child
I have a main form with 2 subforms. Subform 1 shows the results of query 1, subform 2 shows the results of query 2. Query 2 uses query 1 as a starting point. Query 1 is updated with an option group on the main form. In other words, when I select an option on the main form, qdef for query 1 is updated and query 2 will also be affected. If I select an option the subforms don’t update. If I close and reopen the main form, the subforms show the correct information so the queries are being updated but the subforms are not showing the updated information. I’ve been trying to requery the subforms using the following code in the OptionGroup_Click() event: Forms![MainForm].[Subform1].Requery Forms![MainForm].[Subform1].Requery By the way, I don’t have any parent/child relationships. Am I missing something simple.
View Replies !
Limiting Number Of Child Fields Per Parent
I have a field in the parent table which indicates how many child tables there should be at the most. I'm uncertain about how to enforce this. I"m using access as the database to a Vb.net app. Should I do it in access or Vb.net or both.
View Replies !
Query On Parent-Child Based Table
Hi I have a parent-child base table (accounts) with the following fields: - id - parentid - name every record's parentid is either 0 ( which means it is in the most upper level) or another record's id (which means it is the other record's child) different levels of records are being used. I mean some accounts are used in the most 1st level with no childs, some in the second level, .... I need a query to list the accounts which are not parent to any othe records, regardless of what level they are defined. Thanks again for the help.
View Replies !
Duplicating Parent And Related Child Records
I am creating a purchase request form for my company. The main form contains the PO Request # (autonumber) and general vendor and shipping information. The subform contains the item numbers on the order, the quantity and costs. What I am trying to do is make it so that users can click a "duplicate" button on the main form of an existing PO Request and have all the data replicated into a new PO Request. A lot of what we order is repetitious and it would time saving if users could just duplicate an order and modify as necessary. Can anyone help me with this one... Thanks!:confused:
View Replies !
Passing Data From Child Form, To The Original Form
Hi All, I'm not sure if this should go in here or in VB Programming, because it's to do with an Access Database but it's VBA code. But I understand that VBA and VB are different in the way they work. I think this may have been looked at before, but I'm not very good at using the search function. I've looked on google, but all I've seen doesn't seem to be for my use, so I came here as recommended by "RadioActive Frog" who I believe is a member here. Right, basically, I am writing an Access database for my company's ordering system. I have a form called "Enquiry" which has many tabs, one of these is the "client" tab in in here are many fields: Firstname Surname Company Addressline1 Addressline2 Town County Postcode Phones Fax AltMobile Email ContactType Now, there is an option to enter a new client or search the database for an existing client and it is basically the "new client" which I'm having issue with at the moment. Basically, clicking the button "New Client" opens another form called "Client". Here, the user enters the data into fields which are the same as above (but on this contact form). When done, they click a button called "Save and Close" which then asks the user if they want to paste their entered data into the original main "Enquiry" form. It's this last bit, the transferring of this data I can't get my head around and would be incredibly greatful for help with. My Code is below: Code:Private Sub Save_Click()On Error GoTo Err_Save_Click ' On clicking save, a dialogue box will open asking if you want to paste this data ' into the enquiry form. Clicking yes will do this. Clicking no will just close the box 'declare intpress as an integer Dim SavePress As Integer 'Save Command DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'when save and paste is clicked, ask if the information should be pasted into the form or not SavePress = MsgBox("Would you like to paste this Contact Information into the Enquiry Form?", vbQuestion + vbYesNo, "Paste details") If SavePress = 6 Then 'If the enquiry form was the form which initiated the cotact form, then copy and paste 'the informtion into the enquiry form and the close the form 'If "Enquiry" = Me.OpenArgs Then <------ I have decided not to use this, as it doesn't seem to work. (I'm probably not using it correctly) Enquiry!FIRSTNAME = Me.FIRSTNAME Enquiry!SURNAME = Me.SURNAME Enquiry!COMPANY = Me.COMPANY Enquiry!CATEGORY = Me.CATEGORY Enquiry!ADDRESSLINE1 = Me.ADDRESSLINE1 Enquiry!ADDRESSLINE2 = Me.ADDRESSLINE2 Enquiry!TOWN = Me.TOWN Enquiry!COUNTY = Me.COUNTY Enquiry!POSTCODE = Me.POSTCODE Enquiry!PHONES = Me.PHONES Enquiry!ALTMOBILE = Me.ALTMOBILE Enquiry!EMAIL = Me.EMAIL DoCmd.Close acForm, "Contact" Else DoCmd.Close acForm, "Contact" End If Exit_Save_Click: Exit Sub But It's not working. It's giving an error saying "Compile Error: Variable not defined" and it highlights the word which I've mad RED in the code above. Now, I tried changing the exclamation for a fullstop, and I also tried writing "Form.Enquiry.FIRSTNAME" (and also with exclamation marks). None have given a working result. I'll try and get some print screens too for more visibleness (new made-up word there) so you can see what I mean. Blessings, Si Edit: here are a couple of print screens: 1. The Client tab/page of the main enquiry form: http://i6.photobucket.com/albums/y218/Mr_Si/Enquiry.jpg 2. The Client Details form, which opens as a result of pressing the "New Client" button in the main enquiry form (shown in the background): http://i6.photobucket.com/albums/y218/Mr_Si/Client.jpg Argh! I forgot I couldn't post links to URLs
View Replies !
Blank Option (radio) Buttons In Option Group
I am using an Access database for a foreign language dictionary project. One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA. This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad. The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA. When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.) Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too! Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event. Me.FilterOn = False Me.Filter = "wordtype = 'A'" ‘(or N, etc) Me.FilterOn = True And this for the Lost Focus event Me.FilterOn = False Thanks for the help.
View Replies !
Select Option Group Option Based On Checkbox Value
Hi I've got an Option Group with 3 options; Yes, No and Future. I also have a range of Check Boxes; 1 for every day of the week. When one of the check boxes is selected I want the Option Group to change to Yes. Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed. Any help will be greatly appreciated! Cheers
View Replies !
Help: Pass Argument From Child Window To Parent Window?
Hi, I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window. How does one pass argument back from child window to parent window? From parent window to child window, I used docmd.openform ,,,,,,[argument] and me.openargs in the child window thanks in advance.
View Replies !
Parent & Sub Form Mix UP
I have a parent form and a subform linked to the parent. My client decided that he wants one of the controls from the parent form to be placed in the subForm area. The source of the control is still in the parent table but he just wants to place it in the subForm. I am having a hell of a time doing this...... I tried to do it by changing the recordsource of the subForm by joining the Parent and Child tables so I could have access to that field in the subform. But this is very ineffecient and I am getting new errors coming up as a result. Any ideas ???? Thank you
View Replies !
Getting Data From A Parent Form
I have been having alot of trouble with this and just can't figure it out, I am trying to get data from a parent form into a subform so I can use it in equations. Specifically I have a DOB (Date of Birth) field on the main form, and want to have a =DateDiff("yyyy",[DOB],Date()) to find their age. I need this in the subform because of some other information that relys on it. The way I have it right now you have to manualy put the DOB in the subform, and it can be different from the value in the main form. Could any of you tell me what I am doing wrong here?
View Replies !
Linking To Parent Form In Query?
I have a query which is run in a subform... however, I need a value from the parent form. How do I link to this value in the parent form? The query should look like: SELECT tbl2.name, tbl.number FROM tbl1 LEFT JOIN tbl2 ON tbl1.aID = tbl2.aID WHERE tbl2.aID = parentform.[aID] Now, the question is about the WHERE clause... how do I link to the parentform? any help is appreciated Jazz
View Replies !
Reflecting Changes On The SubForm To Parent Form
Hi, Scenario: Parent form: An order form (Order table) with data fields like Order ID and etc. In my Order Table, I have a revenue data field, which is a calculated field based on numbers of items in its subform (OrderDetails table). Since the profit data field is based on the items of the Order Details, for each time the user add an records in the OrderDetails table, it need to be recalculated. Currently, I used a calculated field in the query of the OrderDetails subform and bind it back to the main form, again it bind it back to the profit data field in the Order table. With this method, everytime user add a record in the subform, the calculated field in the query will reflect the changes accordingly, but I have difficulty to force the changes in the calculated field to update the profit data field in the Order Table. I most of the events (like On Changes, On Dirty ....) on both parent and subforms, it seems does detect the changes. Please help ...
View Replies !
Listbox Displays Data Associated With Parent Form?
Hey guys, I was wondering... is there a way to have a listbox display values associated with a parent form ID? in other words... say I have a customer with invoices associated with their name, I want to display a form for that customer with a listbox (or maybe even subform) containing the invoice IDs associated with their name. Right now, I've got: SELECT qryClientData.InvoiceID, qryClientData.InvoiceDate FROM qryClientData ORDER BY [InvoiceDate]; to display information in the listbox. How do I modify this to display ONLY Invoices associated with the Clientname on the parent form? I hope this makes sense. I can clarify if need be, I am just completely stumped. thanks and happy holidays!
View Replies !
|
TRACKER
