Update Form While Still Open And No Record Cycle
Apr 13, 2007
Hi,
I am entering data into 2 tables using the same form, the PK of the first table cannot be entered in the second table unless it exists on the first table. The problem is that the first table does not update the data entered before the second table looks for the PK in the first table.
I wonder if it's possible to make the form update its source table while the form is still opened and no records have been cycled?
Any suggestions will be very much appreciated.
B:)
View Replies
ADVERTISEMENT
Sep 20, 2005
I've got a combo box on my main form which lists different contractors. I've also created a command button on the main form which opens another form and allows the user to add another contractor to the contractor table which populates the contractor combo box on my main form.
However, when the user has added a new contractor and closed this form, this new contractor doesn't show up in the combo box until the main form is closed and reopened.
Is there a way to update the main form without closing and reopening it so that it shows the new contractor in the combo box?
Thanks in advance!
View 1 Replies
View Related
Oct 2, 2013
Is it possible to open a form to add a child record related to the highlighted record in the subform?
View 2 Replies
View Related
Apr 23, 2013
I have a form "IntUnderwriterSearchByName" which is based on the query "Search by Name". This form opens with a parameter (please enter name of broker) and is set out like a datasheet with the following fields- "Broker Name", "Domicile", "Broker Code" and a couple of others. I'd like to be able to click on a record and open the form "IntUnderwriterPopUp" so that the details of that specified record are displayed.
Broker Code is what I'd like the form to look for and this Broker Code is unique for every one of the 900 or so records. This code can be numerical e.g. 01233 but also can be a mixture of both e.g. EU2885. It is also worth noting that this code is not the primary key- i have an autonumber (called ID) that does this- but this field does not appear on the form.
View 7 Replies
View Related
Dec 16, 2014
I am creating an events database. In my main form, I have all the details of a single event (billing code, fees, customer, support personnel, etc.). Then, I have a subform (form view) that lists each of the other services which share an event ID (this ID comes from a separate, unrelated events management suite). In the subform, I display the most-commonly-edited fields so that they are editable without navigating to a different record.
However, there will be instances where it becomes necessary to navigate to one of the records listed in the subform. I would like to make this a quick process by just clicking on the primary key in the subform, and have the corresponding record appear in the main form.
In my searches I've found a common suggestion to use a DoCmd.OpenForm method where the form opens to that specific record -- in effect filtering by the primary key number. I don't prefer this method because it disables the ability to navigate to other records using the previous, next, find records, (etc.) buttons without closing and re-opening the form.
Is there a way to make the main form 'jump' to a specific record by clicking on a control in the subform, without limiting the ability to navigate in the main form?
View 10 Replies
View Related
Feb 5, 2014
I have 2 forms: frmExcEntry and frmItemSearch. frmExcEntry is a data entry form where the associate enters PO#, Item#, Qty, etc. frmItemSearch is a popup form that is used to narrow the search of the Item# from frmExcEntry. Right now, when the associate types the Item# (either PartNo or FactNo)in the txtItemNo control on frmExcEntry, frmItemSearch opens (frmExcEntry remains open) with all potential item #'s associated with the text entered in [txtItemNo]...(there could be multiple FactNo in our inventory system but PartNo is unique and the bound field for the control). frmItemSearch uses an unbound textbox (txtSearch) that populates with the text from frmExcEntry on txtSearch_GotFocus and queries a listbox with the list of possible PartNo to select. I want the associate to be able to double-click the accurate PartNo from the list box which will then update the value initially typed in txtItemNo and copy the PartNo over txtItemNo in the currently open frmExcEntry.
View 3 Replies
View Related
Mar 18, 2014
I have an Access DB with a form that allows the user to select a new backend database. I can connect to the backend and then .refreshlinks but nothing on the form is updated. I have tried requiring the form but that doesn't do anything. I've tried loads of other things, refresh, recalc etc., but nothing updates the open form.
The only way I have managed to get it to work is to close the form and reopen it, then it shows the data from the newly linked backend database.
While it works, it doesn't look good but also there seems to be some problem with it because eventually it reports an error saying "cannot open any more databases" and when clicking OK comes back with "An error occurred while sending data to the OLE server (the application used to create the object" and a whole bunch of other messages.
I think it might have something to do with the fact that the form has a number of MS graphs open on it, but I'm not sure. Also, I can't track down a particular line of VBA code which causes this error.
how to update a form after changing the backend database.
View 14 Replies
View Related
Jan 26, 2015
i want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
View 4 Replies
View Related
Apr 15, 2013
I have some code on a button that opens a form and changes the caption of a label:
Code:
DoCmd.OpenForm "frmRepair", , , , , , "CancelNo"
Forms![frmRepair].Form.[lblmain].Caption = "Missing Parts"
This code works well and frmRepair opens with the updated label caption. The original value was "Return/repair Information"
A few other things need to change on frmRepair depending on this caption as well as the values of some other fields, so I use the following code in the onload event (although I later tried the onopen even)
Code:
'Disable labels button if there is no RMA and the item is a repair
MsgBox Me.lblmain.Caption
If Me.lblmain.Caption = "Return/Repair Information" Then
Me.txtRMA.SetFocus
MsgBox Me.txtRMA.Text
[Code] ....
However, I cannot get this to work as the "if" statement always returns "Return/Repair information" and not the modified caption. The message box confirms that this is the case.
I suspect that this has to do with the point in time that the frmRepair loads or opens and when my code enters the modified values.
View 13 Replies
View Related
Jul 10, 2014
I have a report that is linked to a form's List Box. Users can select Product A, Product B, Product C, etc. on the form, and the report will populate with data for the corresponding product.
I'd like to export each version of the report to Excel automatically, and I'm trying to figure out how to use VBA to enter the parameters. Is there a way to cycle through each value in the listbox?
Here's my code so far.
Code:
Sub ExportReport()
Dim ctr As String
Dim BillingTemp As String
Dim qryBilled As DAO.QueryDef
Dim dbs As DAO.Database
Set dbs = CurrentDb
[Code] ....
View 3 Replies
View Related
Jul 30, 2014
I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.
At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.
continuous form: "04 - GASTOS_BUSQUEDA"
id field on continuous form: "Gastid"
pop-up (details) form: "GASTOS_EDITAR"
id on pop-up (details) form: "editar_id"
This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):
1)
DoCmd.OpenForm "GASTOS_EDITAR", acNormal, , "[editar_id] = " & Me.Gastid
2)
DoCmd.OpenForm "GASTOS_EDITAR", , , "[editar_id]=" & Me.Gastid
3)
stLinkCriteria = "[editar_id]=" & Me![Gastid]
DoCmd.OpenForm "GASTOS_EDITAR", , , stLinkCriteria
4)
Private Sub btn_editgs_Click()
On Error GoTo btn_editgs_Click_Err
Dim strWhere As String
strWhere = "[editar_id] = " & Me.Gastid
DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere
btn_editgs_Click_Exit:
Exit Sub
btn_editgs_Click_Err:
MsgBox Error$
Resume btn_editgs_Click_Exit
End Sub
View 9 Replies
View Related
Jan 27, 2014
I am trying to create a proposal log for my company to make things easier to track. I have made a multiple items form to list the proposals. I want to be able to double click the record to open up another form (that i have already created) that shows the information from the proposal table and the proposal details table. So.....
I want to double click the field named "Proposal Name" and have it open up to form i have called "proposals details form".
View 3 Replies
View Related
Apr 2, 2014
I have a main form[frmResearchNotes] with combo box controls that filters a query populating [subfrmNotelist] containing several records from the filtered query. From there, I double click on a field within one of the remaining records, [CompanyName] for example, and it opens the new form[frmNoteDetail]. The problem is that second form is not displaying that selected record. The second form's record source has been set to the same query so when it loads, it displays the same info but it's displaying the 1st record out of the entire filtered list, not the record I clicked on in that list.
I figured I could use the strWhere function to copy the record I selected in the event procedure and then open the new form with those details. Not sure how to actually do this with VBA or if it's even the correct approach.
View 14 Replies
View Related
Apr 17, 2014
I have three objects a Main_Table , ClientDataForm and a MapForm all three share a common ClientID number
From that Main_Table I have created a ClientDataForm form which I enter all Data
From ClientDataForm I wish to create a button on it which runs a Macro that Saves ClientDataForm Record and then populates another form named MapForm with whatever record is currently open in Form One whether a newly created one or previous record.
How would I write this code for that button? Also why I would write it that way?
View 3 Replies
View Related
Jan 14, 2008
Hi,
i have a form that has various buttons. one button will open a form to add a payment based on the person shown on the main form. how can i open the new form to be ready for a new record but already set up for the person shown? for example:
"main form" the name shows Nigel Shaw
press button " add payment"
Payment form opens on top ready to receive info with my name already shown.
i have based my payment form on a qry and i core around ContractorID
many thanks,
NS
View 3 Replies
View Related
Mar 19, 2005
I have a form with a sub form. The form allows users to enter data into the database and the subform displays all records in the database. I want users to be able to click on one of the records displayed in the subform and that record to display on the form in the format it was entered.
View 1 Replies
View Related
Apr 12, 2005
I have a database to keep track of my mp3 collection. Amongst my tables I have the following:
tblSingers (SingerID, Singer etc)
tblAlbums (AlbumID, Album etc)
tblSongs (SongID, Song etc)
tblSongsSingers (SingerID, SongID)
tblSongsAlbums (SongID, AlbumID)
Eventually, from these tables i created the required queries and forms.
Now i created a new form for searching purposes, so in the form header i put some unbound combo boxes which are populated from the above mentioned tables (ex. the singers combo, has this rowsource
SELECT tblSingers.SingerID, tblSingers.Singer FROM tblSingers ORDER BY tblSingers.Singer; ... with a column count of 2, widths 0cm, 2.542cm). Eventually, when i choose a singer from this combo box i will requery the form, and it will display only those songs for the singer chosen. So far so good.
My problem now is here, i want that from the records which are displayed if i will double click on them, the main songs form will be opened and it will display the record in this form as well.
In similar situations I used to do it as follows:
Dim stLinkCriteria As String
stLinkCriteria = "[txtSongID] = " & Me.SongID
DoCmd.OpenForm "frmSongs", , , stLinkCriteria
However, this time first i am getting the parameter box to enter the txtSongID and then another parameter box prompting me for qrySongs.Singer and if in this boxes i will try to put some data, i get run time error 3009.
Any ideas what might be wrong pls ?
Thanks
View 8 Replies
View Related
May 12, 2005
I want to make a form where I can only make a new record. I basically need a normal form that opens and automatically clicks the new record button. I do not want to be able to view and of the other records, only see the new record that I am putting in.
View 9 Replies
View Related
May 12, 2005
My form is opened with an on click event:
DoCmd.OpenForm "FrmEnhancedEnrolment", , , , acFormEdit
MyValue = InputBox(Message, Title, Default, 100, 100)
The msgbox then gets the value of the record I wish to find(at present the form is at the next new number despite opening on edit)
I am not sure what method to use to get it to open at the selected myValue.
I am searching on studId PK so I guess I have to convert the string from input box to a long.
help would be much appreciated.
I tried this also:
DoCmd.OpenForm "FrmEnhancedEnrolment", , , "[studentid]='myvalue'", acFormEdit
but it reports docmd action cancelled.
regards
View 4 Replies
View Related
Nov 3, 2005
I am starting to get back into access and I am finding out that I am very rusty at it. I am having a hard time figuring out how to open a form from a button on a specific record. What I have is a table that is built like this:
Shop Table
ShopID
Shop
What I want to do is have a form that has a button for each shop in the "Shop Table" and open a form showing only the records for each shop. I am sure this isn't very hard but for some reason I can not get it to work no matter what I do. Thank in advance.
View 7 Replies
View Related
Nov 10, 2005
Hello, it's me again, Forum People.
What I want to do is click on a button in an existing form which shows one record at a time, and another form opens that relates to that particular record.
The current form has a subform in a one to many relationship.
How do I do this?
Mrs Miggins
View 1 Replies
View Related
Dec 21, 2005
please help me how can i open the form showing the last record
View 4 Replies
View Related
Jan 9, 2006
Hello,
I have created a "Pop Up" form that asks the user to make a selection.
"Open New Form", or "Edit or Update existing Form"
If the user requests "Open New Form" I want the intended form to open up with a brand new (blank) record.
Does anyone know how to do this.
Thanks
View 1 Replies
View Related
Jan 10, 2006
hey guys, was wondering the coding so that when a form is opened, it automatically sets you up with a blank record. This thread has probably already been done, but I would appreciate any help
View 11 Replies
View Related
Sep 15, 2005
My form is always open and runs a timer event which runs a series of functions and procedures. I don't want to run a certain procedure on every timer cycle, but rather, every other timer cycle.
Any thoughts on how best to accomplish this. I'm having a mental block!
Scott
View 3 Replies
View Related
Jan 22, 2014
I'm in the middle of writing a multi-language procedure, and in order to populate the label database I would like to cycle all forms (regardless of whether they're open or closed) and cycle all controls within the forms.
View 3 Replies
View Related
