Update / Refresh A Form Upon Entering Data In A Popup Box / Form
I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple.
**************************************************
Scenerio:
I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry.
Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen.
Million Dollar Question:
How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form.
**************************************************
Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind :cool:
Thank You
View Complete Forum Thread with Replies
Related Forum Messages:
Entering Data In A Form - Update Autonumber On Two Tables?
Hello, My first post is on something that is troubling me. I have a Form acting as the display and entry point for data for a contact list, which is composed of two Tables as follows: Contact - (text fields including: first name, last name, phone number home, phone number work, etc) Industry Role - (yes/no tick boxes including: film, photographer, audio engineer, producer, reporter, etc) The two Tables have a one to one relationship based on the URN field which is an autonumber. My problem is that when someone enters say a name, and then ticks a box, the autonumber will add two entries because it seems to see the first table then the second tables as sequential, and not the same thing. How do i go about making a form that can enter new records the same autonumber for two connected Tables?
View Replies !
Entering Data Into A Form
I have a form with a sub-form eg Purchase Order with main details on (Po Number, Supplier etc) with a sub form carrying the line items to be ordered. Table PO Form PO Table POSUB Form POSUB When entering main order details into Form PO, why do the fields in the related table(Table PO) immediately get populated when the the focus gets transfered to the sub-form (Form POSUB). with users quiting the database illegally (not by the cancel records button) the result is unwanted records in the Table PO. What I want to do is complete the input fields in the main and sub forms without any records being commited to the tables until the "Save Record" button is pressed. Thankyou
View Replies !
Entering Data In A Form
I've been working on a database (attached) for a health trust. I think the relationships are right but I'm having a problem entering data. The subform shows the correct data but I can't figure out how to enter data using a form. Can someone point me to a tutorial - I have searched the forums - honest!!
View Replies !
Entering Multiple Data In A Form
I've designed a form to enter several items at the same time, eg, I want to enter aeveral company names on one form. The trouble is that when I enter data into one box, it appears in all the other boxes with the same field names, not allowing multiple data, is there a way around this?
View Replies !
Populate Form By Entering Data
I have a form with two fields, EMPLNO and SURNAME. By entering the employee number in EMPLNO or by entering the name in SURNAME I wish to get the correct record onto the form. This is probably covered in the archive, but I'm not sure what to look for. Any suggestions.
View Replies !
Entering Data Into Form To Diff Tables
Is it possible in Access to create one input form that includes fields from different tables. I want to create a single form that dispenses input fields to separate tables, I don't see anything to make this happen. I know you can retrieve data from separate tables utilizing querys. But is it possible to input data into a single form to multiple tables ?
View Replies !
Entering Data In Form And Updating A Querie
I apologies for this sinmple quesiotn to some of oyu, but being fairly new with Access, Im having problems when I update my form and then print our a querie, to obtain certain information, the new data is missing. HOw can I make sure that my querie gets updated when I update my form. Thanks you
View Replies !
Refresh Form Data
I just realized why I wanted to stop using Access long ago...anyway here's my problem. I have two tables: table1 and table2 (I know,creative). Anyway, table1 is linked from another database, table2 is local to the open database. I use table2 as a temporary table to hold data from table1. table1 is then set as the datasource of one of my forms. I have a button which is used to refresh the data. Basically, it deletes everything in the temp table (table2) and inserts data from the linked table (table1). When I do this, the rows in my form then all contain #Deleted, but it never refreshes with the new data after I have inserted it. I've tried using the Refresh, Requery and even Repaint methods. Still no luck. Then, I clicked Remove Filter from the toolbar and the new data appeared, but I don't have any filters in place. So then I tried to do this programmatically by setting the subform (I'm using subforms ) Filter = "", its FilterOn to False and its OrderBy = "". Any suggestions? Cheers
View Replies !
Use Popup Form To Select A Record On Main Form
I'm not sure how to search on this, even in the advanced search. If this has been answered, could you point me in the right direction? I have a main form AddNewCompany (the infamous tab control that now works - thanks to your combined efforts). On it I have a command button that pops up a form of continuous forms with all the companies in the table (the query calls the CompanyID and CompanyName fields only). I have attached an image of the interface. This means the user can see if the company already exists and doesn't enter it again. (I'm sure there are more effecient ways of doing this, but this is simple and it works. I also know key fields should be autonumbers instead of text, but I have reasons for doing it this way). What I would like to be able to do is click on the CompanyID field and have the companies information show up in the main form.
View Replies !
Use Popup Form To Select A Record On The Main Form
Can anyone see what I am doing wrong? I have a main form that has a tab control on it. The main form is called frm_AddNewCompanyContacts. It is opened in edit mode. To see if a company exists I use a command button to call a popup form with a list of all companies' IDs and names. I then want the user to be able to click on a commad button on the popup form to take the main form to that record. After an intial post, and subsequent search, I found the appropriate code. This is what I am using for the onclick event of the command button on the popup form: Private Sub cmdGoToCompany_Click() Dim rst As Recordset Set rst = Forms![frm_AddNewCompanyContacts].RecordsetClone rst.FindFirst "[CompanyID]='" & Me![CompanyID] & "'" If rst.NoMatch = False Then Forms![frm_AddNewCompanyContacts].Bookmark = rst.Bookmark End If End Sub When I click on the command button I get an error message: "The expression On Click you entered as the even property setting produced the following error: A problem occurred while Microsoft Office Access was communication with OLE server or ActiveX Control (I don't have an ActiveX Control). *The expression may not result in the name of a macro, the name of a user-defined function, or [Even Procedure]. *There may have ben an error evaluating the function, event or macro."
View Replies !
Save Form Before Entering A Linked Form
This is the code that runs when a button on form 1 is pressed to open form 2(form 2 is called Replacement Unit): Private Sub Command80_Click() On Error GoTo Err_Command80_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Replacement Unit" stLinkCriteria = "[Repair No]=" & Me![REPAIR No] DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command80_Click: Exit Sub Err_Command80_Click: MsgBox Err.Description Resume Exit_Command80_Click End Sub I want to save the changes to [form 1] before [Replacement Unit] opens. What and where do I enter code? Sorry, only just started to learn VB. (Using Acc97). Any help would be great! :)
View Replies !
"Save Record" Button In A Subform To Also Refresh The Data In The Main Form
I have a form which contains one subform. On the subform I have a command button which saves the record just entered. On the main form I have a "refresh form data" button which updates the main form so that the calculated controls can show the correct results based on the data just entered? Can anyone tell me how I can get the "save record" button in the subform to subsequently refresh the data in the main form as well, thus saving a button??? Many thanks. Peter
View Replies !
Adding A Form In 1 Db To Different Db As A Popup Or Sub Form
Hi, I have a form in 1 Access 2003 database that I would like to add to a different Access 2003 database as a pop-up form or as a sub form. Can this be done with out having to re-make the form in the other database? If so can you please describe how. Here are print screens of both databases, 1. This is the form I want to add. http://www.roofmart.net/OptionEstimator.asp 2. This is the form in a different database that I want it to added to, I want it added under where it says please insert the calculator under this label. http://www.roofmart.net/RoofEst2003.asp Thanks Any help will be very appreciated.
View Replies !
Update Data From A Form
How do we update a data from a form into a field? I have a form call member. In the member form I had created a membership Id combine with several code which can shown in the form. But this is only shown and I need this combine memberID to be update into another field. Anyone have better idea which I just need to add it into controlsource ?
View Replies !
Popup Form?
I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice. So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page. But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up. Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000? Thanks!
View Replies !
Popup Form
I have made a message service in access db using a pop up on timer even. It works fine but sometimes it does not load. My db is split db and so what ever I am doing, doing on my machines only. So is there any way to check if a form is loaded and if its loaded then do requery.
View Replies !
PopUp Form
On opening the form, i want to give a command with Move To command to move to the right upper corner. Is there any such command ?
View Replies !
Entering Information Into Form.
I have couple of forms where...The users enters a name of the river where he/she was fishing in, I also have an option where the user can browse for previous entered rivers.I am wondering how this works, how do I let the information entered go automatically into the browse section and how can I prevent from duplicates will appear in the browse for previous entered rivers. thanxp.s is this something that I will work with in the table it self or can I change this in the form ???
View Replies !
Entering Video Into A Form
Hi all, Firstly i have just started using access for my ICT coursework so i apologise for any ignorance on my part! The problem is I would like to insert a video clip, i sorted out the OLE object column etc and have no problems selecting the video however only the audio from the clip works... In addition the database is for a rental store and i need the video to change everytime the user changes the record, i have managed to do so easily with the pictures - does this system still remain with video? Thanks in advance Alex
View Replies !
PopUp And Select Value From A Form
Hi All, I have a form that has a combo box and a subform. After a choose the value of the combo box I want to start adding values into the subform, and I want to be able to select the values that are to go into the subform fields. Now I am thinking of using a pop-up subform which shows the values that I can choose from and then as I close the form it will populate the fields of the main subform. Is it possible and has anyone got a little example of form that can do that. If so can you put it as an attachment to this post. Thanks Greg
View Replies !
Form Popup Size
Hi All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect. Could someone please help me pls? Thanks.
View Replies !
Popup Form Problem
I have a [frmMain] form which i would like to run maximised. I also have a button on the [Main] that opens another form [frmAdjust] in Popup mode, because i do not want this form to be maximised. The problem i have is that when i return to the [frmMain] after closing the [frmAdjust] i want to update a subform [subAdjustment] on return. The Event i would like to use, the Activate event is not fired on return from a form with the popup property set. The GotFocus event of the form does not work either. Which event would i use for this or how could i get around this.
View Replies !
Subform With A Popup Form
I can't seem to get this to work. I have a Mainfrm with a Subfrm. On the Subfrm I have a field that has to be a concatenation of two inputs. To do this I have created a PopUpfrm for that field that has two list boxes. The user then chooses one from ListA and one from ListB. This populates an unbound field (fldCode) on the PopUpfrm. I need to pass this data to the original field on the Subfrm. I've tried: Forms!Mainfrm!Subfrm.Form.Field1 = me.fldCode and every possible iteration of this that I can figure out. Any suggestions on how to pass this information back to the Subfrm.Field1? If I run just the Subfrm, w/o opening the Mainfrm everything works great. I guess I just don't know how to reference that field when it is actually in the Mainfrm. Thanks in advance
View Replies !
Search Using Popup Form
Greetings all! I am new to access and trying to build a database but having some real issues with the pop up search. Its a database with personal information so I created three forms 1. FrmMain = The initail navigation page which has just buttons and no records. When you click the cmdFind Resident button, it takes you to the second form... 2. FrmPop Up Resident with Record Source: Resident Name (from FrmResident Parking) . This form has 3 controls; 1textbox (Type Resident Name with Control Source: Resident Name from FrmResident Parking), 2 cmd button (OK and Cancel) 3. FrmResident Parking. This form is supposed to open the Resident Info based on the info entered in the 'Type resident txtbox in the pop up form but does not work. I have been trying to get this work in Design view but no luck. I created... A macro: Find Resident with the following properties... Form Name: Resident Parking View: Form Filter name: Left blank Where condition: [Forms]![Resident Parking]![Resident Name] Like [Forms]![Pop up Resident]![Type Resident Name] Data Mode: Left blank Window Mode: Left blank In summary what I want to acheive is that; when a person opens the database, they get the FrmMain and if they click find resident to main page, the Pop up form comes up and they type in a name then click ok. This then should open the record on a new form (Resident Parking). I dont have any queries just one table. I am not good at VB so any help especially in design view will be very much appreciated
View Replies !
PopUp Form Help Needed...
I'm sure this is simple and I searched the forum but I was unable to find an answer so..please help! (btw, newbie here);) I have two tables with a 1 to many relationship. I have two forms based on each table. Table1 has a key field called ECO. Table2 has two key fields, ECO and ItemNumber. When I have form1 open I use a button to 'pop up' form2. Form2 shows only records that have ECO value = to Form1.ECO value. When I create a new record on form2 I would like to have form2.ECO auto filled with form1.ECO value. This is where I'm stuck!:confused: Btw, I cant use a subform, already have too many! Thanks!
View Replies !
|
TRACKER
