I have forms that show commitments by Client, by Cost Centre, by Provider etc.
If I add new commitments or edit commitments it is done through the Commitments by Client form, as all other forms lead back to this one.
To create a new or edit an existing commitment, it is done through a Commitment Form, which goes into a query (query A)which does all the calculations. My client form has subforms based on Query A, however my other forms (commitments by Cost Centre etc) have subforms which have querys that are based on Query A . I hope that made sense.
My problem is that If I edit a commitment, the client form and subforms refrlect the changes imediately, even though they are open and I can see them changing when I change the commitments. However the other ones don't unless I close them and re-open them.
My navigation within the database is based on once a form has been opened it is set to be invisible untill called on again (i.e. visible = False).
How to requery all the forms without having to close them.
I am working on making a DB to use as a production schedule. tblBuilds holds a list of builds. I have several reports to show this list with different filters. One such report is rptBuildsToday. This report will be open on the production warehouse computer and displayed on a huge screen all day every day.
Is it possible to make it so this report auto runs again every so often? When new builds are added to tblBuilds, or if a record on the table has its date changed to "today", It would be nice to have the report reflect this change within a certain time without having to manually refresh the report. The people looking at the screen will be doing so from their work benches and nowhere near the computer that has it opened.
If this is indeed possible, could the proposed method also work on a report or form inside the tab of a navigation control?
I have a access form that has a text box that holds a search term. The search term is used as a variable in a query. The query results populate a list box. Selecting a result in the list box populates the rest of the form where the record can be edited. All of that works great...sort of. When first opening the form you cannot view any records. The search function works fine and the list box populates but selecting a record does not populate the rest of the form. Attempt to navigate (next, first, etc.) and you get a "You can't go to the specified record" dialog. There is a simple fix for this. Open the form as normal. Then switch to design mode. Do absolutely nothing. Switch back to form mode. All is well.
I've searched and can only find information setting the visible property when selections are made on an open form--I want to set the visible property when the form is opened depending on which avenue the user chooses from the navigation form.
I have a navigation form (Form A) and a second form with a subform (Form B). The user will choose from a combobox, either an existing record or a new record on Form A. On Form A there are two buttons, one that will take the user to the correct record on Form B for editing and one that will open to a new record on Form B. Once Form B is open, all controls will be blank (if a new record is chosen) or with certain controls prepopulated if an existing record is chosen.
What I want to do is to hide controls on the main form (not the subform) of Form B if the user chooses an existing record. Form A's buttons work correctly to open Form B right now. I want to be able to hide prepopulated controls on Form B if the user chooses an existing record from Form A.
Here's the code I'm using to open Form B to an existing record. I'd like to set the visible property here if at all possible.
NOTE: "Form A" and "Form B" are not the actual names of my forms--it's just easier for illustration purposes here in my question.
I'm using a navigation control to switch between forms. In one of those forms, I have a continuous subform which is a list of Projects (source is a query) that is read-only. To edit a project, I can click on its name, which switches the form displayed in the navigation control via docmd.BrowseTo (with acEditForm as the last parameter). This works fine. The proper form opens, with the proper project being displayed.
Now, on this second form, I have on the right the list of tasks contained in the project in a continuous subform (source is a query), and on the left another subform which is kind of an "edit bar" that I use to actually edit the individual tasks. So, when I click on a task in the task list, the OnCurrent event triggers a docmd.BrowseTo command that updates the "edit bar" subform and passes the ID of the task as the WhereCondition parameter. This updates the values displayed in the Edit Bar to that of the selected task, which I can then edit.
Now here's the thing: depending on the project I open, the Edit Bar doesn't work. Actually, it looks like only one of the projects is working, while the others are not (and I managed to have a different project working, but only one works at any given try). When it doesn't work, the Edit Bar is in "NewRecord = True" for some reason. All the other properties of that subform seem to be the same between when it works and when it doesn't.
So, it looks like the same command (docmd.BrowseTo with acEditForm) opens the subform properly in acEditMode when it works, and in something else when it doesn't, depending on the parent record that's being opened. This really gets me, I really can't figure out how that's even possible.
I suspect it might have something to do with locked records, maybe?
I have combo box that lists data from another form (frmCity) . If the required data in not in the list then frmCity is opened, a new record is entered and form closed. The combo box in the first form (which has remained open) does not show the new entry unless it is closed and re-opened. How can I get the new record to show without closing and reopening?
I have a form that has a check box on it. For some reason the check box is not being checked when an update query is run prior to load. I issued the 'Me.Requery' command after the update query is run (via 'On Load' and 'On Open' in the 'Event' property . . . neither worked) of the form. Is this the correct way to refresh a form after an update query is run ?
How do you refresh all of the data on a form when the tables that are the source for dlookup fields on the form are changed by command buttons on the form?
I have an Access 2010 database with a form that allows me to input data which is saved into two tables (i.e. Orders and OrderDetails). I use a simple select query to bind the form to the tables.
When the form loads it asks for an order number, which it uses to pull details from the Orders table and auto-fill some fields on the form (these fields are not enabled as they are predefined, such as the order date).
So, when the order number is entered my VBA code does a Form.Refresh, which then breaks the code with the Run-time error 3022 - "The changes you requested to the table were not successful yada yada.." (I'm sure you all know the one)...
I have checked that there are no duplicated keys in my tables, I have checked that what should be indexed, is indexed. I have done a compact and repair on the database, and even created a new database and imported all the tables (used new data). Still get the same issue.
When opened it displays all records (no selection yet).
I put would like to put 2 buttons to filter records (Male/Female).
I'm thinking of 2 possible options:
1-on click run a script that will close current form, then reopen it with selection criteria 2-directly apply a filter on the current form that would automatically refresh itself with the right records
Another (heavy, inelegant?) solution would be to create duplicates of this form. they would be loaded from separate queries that select the right records in either choice.
Form 1 - Data entry for a new project Form 2 - Data entry for a task associated with the project in the Form 1
Button on form 1 that opens Form 2.
What I am trying to do:
Use a combobox on Form Two to choose the Project entered into Form 1, so I can capture the Form1 PK as a FK on Form 2.
Here is the problem:
Refreshing the record on the button click so that the new option entered into Form 1 shows up in the combo box on Form 2.
Full disclosure: I'm not much good at VBA so I have been trying to do this by customizing the button macro. I have tried Refresh, and Requery, but I can't seem to get it to update the list in the combo box.
2 questions:
1. How can I get this accomplished? 2. Is there a better way to get this data into the table than what I am trying to do?
I need to refresh listbox field (Total_price) situated on parent form. My sub form is called "Lines_form". I want to sum values of all lines for column "price". Result of calculation I want see in parent form in field "Total_price". My parent form is called "Main_form".
On "price" field settings I used AfterUpdate event : Me.Parent!Total_price.Requery
I see result in parent form, but value isn't saved to table and I can't use it in next calculations.
I need refresh/requery/save patern form. I try this code:
I have a field on a form that is the results of a dlookup to a table.field. I want the value to be updated when I execute a button that is running a macro. How do I do this automatically, and not have to hit the refresh button?
I have been trying to figure out how to make a form refresh after deleting a record in a subform. The code in the combo box that populates the subform works fine. If you select the "Action" of "sign" from the unbound combo box above the subform, it places "Sign" in the the subform and then makes a checkbox on the main form [WillTake] = True.
But when I delete the record by right clicking on the entry, the focus is sent back to the main form so I can refresh the form and thus update the [WillTake] checkbox. I have tried just about everything. I can get the focus to a field on the form, but I cannot figure out how to refresh or requery the form.
The code to transfer focus is on the OnDelete of the subform.
I have two subforms on a "Page"/Tabs. Subform #1 is a continuous form which accepts data about dimensions of a pattern piece. The other subform needs to update its information display each time the last control of the first subform loses focus, because it tells me how much material is required for all pieces of this pattern that are entered.
My first feeble attempt at this was to add the following code to the "Lost Focus" event of the final control on the first subform: Form.Parent.Refresh
This succeeded in forcing the second subform to re-run its calculation.
However, after the recalculation took place, I wasn't able to move to the next record on the first subform. This subform is a continuous form, and I need to be able to add another row of data and then see the second subform change based on the additional information in the first subform.
I have a Main form with a combo box that pulls names from a table. Alongside the combo box is a command button that opens a form which allows the user to edit the names in the table.
The problem: When a user edits a name and closes the edit form, the edit is not immediately displayed in the combo box. However, when the Main form is closed and reopened, the edit is properly displayed. Can I somehow refresh the combo box in the On Close event of the edit form?
Test findings showed that when I open a form the data does not update. I added a refresh action after the openform action. If I want to open three forms via the macro, do I need three refresh actions, one after each openform action, or simply a single refresh action that would apply to all three forms.
I have a form called Add New Delegation, i have combo box of Institution names on the main form and a subform for Agreements discussed. with a combo box called agreements. I successfully cascaded the combo boxes so that the agreements discussed on the subform are filtered by their respective institutions on the main form. However i am unable to refresh the list each time a new institution is selected as the Macro will not allow me to requery a control on the mainform from the subform..
Access 2010 doesn't seem to like the last line. It gives me an error saying the form name doesn't following access object naming rules.
Sub update_subform() Dim dbsCurrent As Database Dim qryD As QueryDef Dim strSQL1 As String, strSQL2 As String, strSQL3 As String Dim mytmp As String Dim proc As String, myot As String
I have a form that maximizes when it loads and that works fine, but when I run a macro to open it the command is bypassed. Is there a way around this?
I've tried setting the code to run on different events (open/activate) but that didn't change anything.
The reason I want a Macro to open it is so I can set the property to Add only, perhaps there's another way I can do that, perhaps as part on the form open event in VBA instead?
What is the best way to accomplish this? I have a database that split into the Front end and the Back end. The form that the users entering the information uses the queries from two sources. One is the a table within Access and the other is an excel spreadsheet that I link to it. How can I update /replace the Excel spreadsheet while users are using the form of the front End?
