I have modal pop-up form1 showing list of items. There is a button that opens a new modal pop-up form2 (not subform) to add items to form1, form1 is still open behind form2. This all works fine, but when you click save button on form2 it saves new data to database and closes taking you back to form1
but does not refresh new data to form1 unless you (shift F9) or close form1 and reopen or use refresh button on form1.
I would like to have form1 refresh data as soon as form2 is closed from the save button. I can do a timer event on form1, but this flashes the screen...which is annoying. I have tried various methods to make this work but just can't seem to get it to work. If form2 was a subform of form1 then refreshing mainform would not be an issue. Can anyone shed some light on this?
Hi all, not been here for a year or two, hence i have forgotton a lot of Access stuff.
I have an unbound Data Entry form which when populated, adds the record to the table. Simple enough.
I have some code on the form which basically stops the user entering a new record without having a First Name and a Last Name. This code works well.
I also have some code which confirms that the user wishes to add the record to the table. If Yes, the record is added to the table but when entering data for the next record, the first code doesn't kick in about having a First Name and last name, however the Confirm Add record code kicks in.
How can I solve this, I have tried the me.refresh command in various places but as yet to no avail. Hopefully someone will point me in the right direction.
I have added the DB in both A2k and Access 2003 Versions
I have a form which is deisgned to generate the selected reports from a list of reports.
The user selects the Year and Quarter from two drop down lists and checks the reports he wants to preview. There is a command button which generates the preview for selected reports.
It runs fine, but sometimes, when it does not updates the query for reports. For example, if I generate a report for Year 2004, Quarter 3 as an instance, I get one correctly, Now I close the report and try to generate another report for Year 2004 Quarter 4. Now if I click the preview button, I don't get the new report. I still get the previous report.
I am trying to use a combo box to refresh a subform. I am working with Access 2007 as my front end and SQL 2014 on the back end. On my main form called frmDealers I have an unbound combobox where the user selects a dealer and then text boxes are populated with address and phone number. I have it unbound because I don't want the user to make changes to the dealership at this point. On the subform I have people that work at the dealership. That form is called sfrmDealerContacts. The subform could have multiple contacts for each dealership. The subform is bound to a query called qryDealerContacts. I have it bound to a query because I want email hyperlinks in the table too. I tried searching the forum and found this thread number 279791.
After searching I added:
Form_sfrmDealerContacts.Form.RecordSource = "SELECT * FROM dbo_DealerContact WHERE DealerID = " & Me![cboDealerName].Column(1)
But this brings up an input box so I must have something wrong. My code is:
I have a navigation form with two tabs. One tab contains a subform for a technician to enter several part request. The other tab is for the parts room to edit and update the request.The issue i am having is i need the parts room form to be requeried every time the technician enters information on his tab.
I added a command button and tried
[NavigationSubform].Form![FRM New Request Part Room] .Requery
but it can't locate this form since it is in a separate tab.how do i do this?
I've got a form built on a tab control. The form is a sales order form with multiple tabs. One of the tabs is used to enter shipping information and cost. The problem I'm having is:
A field I have added to this tab which is a stored total of the sales order total plus the shipping charge is not showing up after I enter the shipping charge until I switch tabs and return back to the shipping tab.
It's been a while since I've dealt with these refreshing problems. Which event is happening when a tab control is switched so I can call it to trigger my field total?
Btw, the shipping information on that tab is a subform.
I have a mainform in access with a subform (continous form mode). The subform's source is a query that has a criteria parameter that gets the values from a combobox in mainform.(list of projects) Combobox name= cmbProject
It works fine for some records (old records), so when I migrate new data into the table the comboxbox display the new data but when I select the record to be dispayed on the subform, the record or data is not in the subform, so the record is in blank.
One of the directors of the company I work for would like to have a large screen display the current status of jobs that my database stores. To cut a long story short the table he is interested in is called tblJobsLogging and is updated manually by our laboratory on a regular basis as jobs are completed using a form linked to a query in turn linked to that table.
Think fast food chain order monitor. He wants to be able to look up from his desk and see the progress directly in front of him at any point.
Is there any way that I can have an access form displaying these records in a datasheet view which continuously refreshes every X seconds / minutes or updates as a record is updated in the underlying table?
I am having some minor issues with my current database. The way it works currently is having a MainMenu where you can either go to customers/ ProductList/ Product OR ProductList straight away. I have a CustomerT and a ProductT. I have made a Query where I link the two tabels to have the feature showing the customer to the specific product with the criteria: "Kunde: [CustomerName] & " " & [Subsidiary]" on the form I have a txtsearch (Textbox) connected to a button with this coding:
This allows me to search for text in each of the boxes with information on the single product(s) for example searching for Kunde (Customer in Danish) or ProduktNavn (Name of product) HOWEVER when I do this the "Kunde" turns into "#Navn?" c..If i reopen the Form it will show with the right information. I also tried to code the "Byactivation" to
I have a form with a Count textbox. It's control source is a field named "Audit Count" in the table "DB Audits". The idea of the textbox is to display a running count of how many audits a specific auditor has completed that day. To do this I have the textbox set up with a default value of:
Assuming I'm using the DCount function correctly, this is supposed to count the number of [Loan Number] records entered in the "DB Audits" table by the auditor (whose name is found using fOSUserName()) on today's date. So, for example, when opening up the form at the beginning of the day the Count textbox would read 1 and when the auditor clicked Save and New it would increase to 2.
The problem I am having is something I encountered while doing some random tests of the form. If an auditor submitted an audit (let's say the 1st of the day), the form correctly displays the next count as 2. However, if the auditor were to delete the record from the underlying "DB Audits" table while the form was still open, if they were to enter a new record, the Audit Count field would display 2 even though it should be 1 (since the 1st record had been deleted).
How can I have the Count textbox refresh whenever someone deletes a record from the table while the form is still open? I tried a Requery command using the AfterDelConfirm event but I couldn't get it to work.
I got a database that has lots of subform which are all locked, I got a button that open the same subform in a pop up form with a macro that insert a new record. But when I close the subform after puting the information in the new record does not update on the main form untill you go away from the current record and come back again
Hi there. I have a form with two sub forms on it. The form loads with a reference number that I pass to a function that in turn requeries the first sub form. The function call is in the on load event of the main form. This part works fine. The second sub form uses a similar requery function to the first one. The only difference is that the query for the second sub form is based on a reference number from the selected record in the first sub form. If I put the function call for the second sub form in the on click of the first one all is well and the second sub form displays all records with a matching reference number.
The problem is that when the main form loads the first sub form will display the correct data but the second remains blank or displays the wrong data. I know this is happening because the first sub form has not loaded fully and so the second sub form cannot get the reference number. I just can’t find a way to make the second sub form display the correct data when the main form loads.
I have tried calling the requery function for the second sub form from most of the events on the main form and many of the events on the first sub form but to no avail. I also tried putting a meaningless sub form at the bottom of the main form and putting the requery function for the second sub form in the on load event but that was no good either. This surprised me as until that point I was assuming that access was loading the sub forms sequentially from top to bottom.
Can anyone tell me how I might determine the point at which the first sub form has been loaded so that I can get access to the reference numbers needed for the second sub form query. I would prefer not to use a timer for this as there is no way to determine the maximum time it will take access to load the rest of the data but at present it looks like the only option left.
Any comments would be much appreciated and sorry for the lengthy explanation.
I just added a ActiveX control to my program and I have a scroll mouse, and there when the user used the mouse to scroll through the records, the record changes but the ActiveX Control doesn't. My activeX Control is used for a digital signature. Anyone Have any ideas?
This is a lot more complicated than the title suggests. I was asked to reset the work order numbers used by the maintenance department. When they reach work order #9999 they want to start over. My best bet is to make a backup of the tables and create new ones that include the last 2-3 weeks of activity. If I do that I'll have two potential problems:
The next autonumber needs to be lower than the pre-existing records but not start at 1 Recombining data from the old table (for whatever reason) will create false relations
Does anyone know a possible solution to these problems or is there a better method to refresh the database?
I have a 'Snapshot' report, which gives up-to-the-minute data on a business - sales year-to-date, month-todate, week-to-date and today. They run this many times a day, but ideally, they would like to have the information display on a monitor, and be updated automatically every few minutes. Is there any way that a query can run by itself every few minutes, and gather the current information?
Quick question, in Access 2007, i created a table that pulls data out of our system via ODBC. No if the system gets updated, how do i refresh data in access? Please advise. Thanks in advance.
Hi all, I have a form (sub_Main) that opens and has an openargs value (Department) from my main form when user clicks on a cmd button. However, if I were to go back to my main form and click on another department the openargs value is not passed along. I have tried using Me.Refresh under LostFocus but it doesnt seem to work.
What is causing the openargs value from updating? Any help?
I have a field "NameView", irrelevant but it grabs a name from a seperate form from an ODBC connection. The purpose for the field is simply to grab the data from another form.
On the same form As NameView theres another field "Name" This Grabs the data from NameView and writes to the main table.
Everything works fine but "Name" will only update from "NameView" on a new record only and not on the current one. I have a VBA Statement on an afterupdate which Me.Name = Me.Nameview
I know this is probably something really simple - but I'm relatively new to VBA.
I'm trying to run an update query from a form, then refresh the form having all the input boxes and checkboxes etc set back to normal.
The problem being that I have a list box to select a record to update from.
Now, if I just refresh the form this list box updates properly - but none of the other controls (text boxes and check boxes) reset to their defaults.
If I try to reset them manually in the code then a) they don't reset and b) the list box no longer updates (depending on the location of the reset code).
Though the code I'm using to reset things works when the query is not executed.
The code I'm using is currently:
Private Sub Save_Record_Click() On Error GoTo Err_Save_Record_Click
Dim stDocName As String DoCmd.RunCommand acCmdSaveRecord stDocName = "Return to training" 'DoCmd.OpenQuery stDocName, acNormal, acEdit Me.Refresh Current.Value = False Exit_Save_Record_Click: Exit Sub
I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box.
I have no VB skills at all have to do everything with macros etc. So please keep any replies simple. I have a database for students, courses and tutors - all worked fine until the customer wanted each student to do 2 courses at a time. The whole database is designed for statistical returns ie females with child care responsibilities living in a rural area etc., and the Course Id has to be the same on each course table. I split the course table into 2 tables with the same data, made a course entry form which appends new courses to both tables. My problem is that when I select a course ie no 234 for course 1 and 345 for course 2 I cannot get the subform to show the data unless I go to the next/previous record and back again; when I do this the main form opens at record 1. Is there a macro or piece of code I can use to automatically refresh OR a macro that will go to next record and then reopen the mainform at the place where I started?
I'd like to ask for your help in the following issue:
I wanted to refresh the filtering of my combo-list on a subform according to the change of a field on the main form.
With this
Private Sub supplierID_AfterUpdate() Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery End Sub
it succeeded. But when I turn a page on the main form (to see records registrated in the past), the combo-list on the subform doesn't change (because Access doesn't get any after-update info - I guess).
But I'd like to use a solution that always watches the actual value of the main form displayed on the screen and so it changes the filtered list of the sub-form - combo-list according to it.
Please help if you have a good idea/solution to it. (take care I'm beginner at Visual Basic)
