Hi,
I tried in many ways, but Coudn't refresh the combo box values.
the problem is,
I hv created combo box contains Subject "Account","Maths","English". If I select "Account" from combobox, the Teachers name should display in text box which I created in form.
One teacher can take more than one subject.
Ex. First selection is Account, teacher name may be "a","B","c" and for "Maths" teacher name as "a","D","e"
By selecting particular department, the teachers name who all involving that department should display. And also
i need to display in how many classes that teacher involved in text box next to teacher name in the Form.
selecting one option from combo box then how to refresh for another selection in combo box Is anyone there pl.
I've currently got a Combo Box (in the form of a drop down list) in the main part of my form for data entry. I have recently created a seperate form called 'edit' to change current values that may be incorrect. As a part of this, I would like to make changes to the values displayed in the Combo Box (let's say there is a typo). So I have copied the combo box from the viewing page into my editing section, and made the change I want to the appropriate entry. I then go back to my viewing page, and the data hasn't automatically updated. (However, If I look at the drop down list now, the new spelling of the entry is there, the old one is gone, and I can select the new one; making the change complete. Is there a way that I can get it to automatically update all the fields that currently have the old spelling to the new spelling? (all I see on after update for the combo box is a list of my macros?)
I have a combo box on a form to enable users to find records. When the form opens initially, these boxes are blank. However, after a search has been performed, the selected information in the combo box stays there, as well as the record opening up. How can I make the combo box revert to being blank after the record has opened on the form?
I have a combo box in which it's value changes according to user input. It is working but it is annoying to have to click the combo box for it's list to refresh. How to make it seemless?
I have a form where the user selects a client from a combo box.
Doing so populates 4 controls with info about the client, using the Exit function of the cbo box. The Record Source of the form in question does not store this info; it comes from a different table.
This works fine.
When the record has been saved and I come back to it, however, those four controls do not display the client's information, since the combo box hasn't been exited.
What's the best way to get the form to repopulate those controls without having to reselect the combo entry?
I have a form with three subforms, and I'm having problem with one of them. The link between subforms and forms are store number, which is stored in a combo box. Idealy, after a user pick a store from the combo box, the subform would update itself. Two out of the three subforms are based on two crosstab queries and they work perfectly fine. The last subform is a select query, and it seems like it's not rerunning itself after updating the combo box. The query is very simple, it just has store number, description, and grouped by amount. I tried with no criteria in the store field and run the masterform,seems like all it's doing is showing value for the first store in the table, and never changes afterwards, I also tried entering "forms!frmStores!cmbStore" in the criteria for the store, then the subform came out empty, it seems like it's only reading combo box's default value null. I have a line of code for the mater form frmStores as "me.[DisplaySubform].requery" for all three subforms, but it seems like it's working for the first two and not the select query. Anybody can help me with this? oh, the combo box is unbounded, because i do not want my table to be updated by selection. Please help
I have a form with a list box where you can add new names, and a bombi box that lits current names already in use. I want the form to update the combi with the name just typed in the list box. I guess I use OnExit event, but I don't know the code I should use for updating the combi list..
Background: I have a continous form linked to a table and I have 3 combo boxes on the form (linked to fields on the table). The combo boxes are called JOB TITLE, SCHEDULE and SHIFT. The source for the combo boxes are queries named respectively as LKUPJOB, LKUPSCHEDULE and LKUPSHIFT. For the three combo boxes listed abpve, the bound column is the first field of the underlying query and the column width of the first field is set to 0" (so that the second field of the query is displayed).
The way things should work is that for each record on the form, the LKUPSCHEDULE and LKUPSHIFT queries (queries for the SCHEDULE and SHIFT combo boxes), the queries are filtered based on the bound field of the JOB TITLE combo box. The name of the bound field for the JOB TITLE combo is called Labor_Rate_ID.
Problem: Unfortunately, It seems like the value of the labor-rate_ID in the first record (i.e. first job title combo box) determines the query list used by the SCHEDULE and SHIFT comboboxes for all the other records on the form. That is, even though the form has lots of records displayed, the combo boxes for each record don't have a complete list to work with.
Hence, the SCHEDULE and SHIFT combo boxes for some records are showing a blank (since available otions in the combo query list don't match the value in the table for that record.
Can anybody tell me how to get a continous form to refress the list for each record on the form.
I also don't know whether the Requery command for a macro could work and how to use it. I think though, that this problem can't be solved by a macro.
Basically, the question is around what kind of code will let you manipulate the properties of individual controls of a form at the Record level.
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?
I have a form with a combo box that populates a subform with data equal to the combo box value. I have added "<ALL>" to the combo box to display all records if selected. The after update code changes the queryDefs. The problem I have is that when "<ALL>" is selected, no records show. But the query has updated. If I close the main form and reopen it all the records show, but if I select a new value nothing happpens. But the actual query has updated. I have tried many combinations of refresh, repaint...etc. Anyway, here is the code, any help appreciated.
Private Sub cboFeedMtrl_AfterUpdate()
Dim qryAllMat As QueryDef Dim sql As String Set dbsCurrent = CurrentDb Set qryAllMat = dbsCurrent.QueryDefs("qryViewData")
If Me![cboFeedMtrl].Value = "<ALL>" Then qryAllMat.sql = "SELECT * FROM tblMachineSelection" Me![frmViewData].Requery
Else qryAllMat.sql = "SELECT * FROM tblMachineSelection where [feed Material] = [Forms]![frmView]![cboFeedMtrl]" Me![frmViewData].Requery
Is there a way to have the database auto refresh ?? If so how is that done
I use the service management template in Access. The problem we have is there a way to write a script to check for existing names when entering new ones. Like after entering all the information in a new record have it look at the first and last name and if it does exists have a alert come up stating that it already is there
Hopefully this is an easy one...... Have a form... With two subforms. Info is entered into first subform... Second subform shows a recap of info entered. Kind of a running total of an "Average" based on info input on the first subform. OK... Problem is... The second subform updates... requeries the info on close. I want it to update the info every time a new line or record is entered into the first subform. I have tried a couple of ".requiry"s on the first subform... but no luck. I'm not that hot with VBA yet.... And can't seem to get anything else to work. Solution???? Thanks
I have a form with one subform that lists trucking loads. The form is set to run modal. There is one button on the form to add new loads which when clicked opens a popup form to enter new load. When you click on the Save button on the popup form it saves load to table and closes taking you back to the Form/subform with list of trucking loads. I have tried various refresh tips to get the new load to show, but I have to close the Form/subform and re-open for the new load to show up. Is there a way I can get the Form/subform to refresh after I click the save button on add load popup form so it shows this new load without the need to close/re-open the Form/subform?
In my database, I have a form that has 2 subforms on it. Both subforms are set to run off a query that is driven by a text field on the main form. I want to have a button on the form that when pressed, it will refresh the subforms based on the value in the textbox. I can't find a good way to go about this, any ideas?
When clicking a button on a form the code behind that button minimizes that form and loads a second form which just has a label on it stating "Please Wait........" and then my database carries out a number of functions. However, it takes a long time for the "Please Wait...." message to appear and so the user has a blank screen for some time. Is there any way of delaying the database carrying out any other action until the "Please Wait..." message is visible? I have tried:
FORMS![FRM_WAIT].REFRESH
but this does not work. Any ideas most appreciated.
:confused: I have a listbox which using "Table/Query" RowSourceType lists all records in table of Access 2003. The Add Record button clicked, a new record will be inserted to table, and then requery listbox. But it's so strange, the record already existed in table, but listbox still doesn't refresh after requery, I have to presss F9 several times to refresh manually. The update record button clicked, the listbox doesn't refresh too, but when I check the value of the row, the value is new value, but ths listbox on screen shows old value. for deleting, has the same problem.
So I'm not sure, if this is a bug of Access, or I missed something have to do. I already tried many way to solve this problem (sleeping, check if updated listbox, etc), all of them aren't work well.
Please give me a help!!!
Michael
I have a listbox which using "Table/Query" RowSourceType lists all records in table of Access 2003. The Add Record button clicked, a new record will be inserted to table, and then listbox will be requery to show updated table. But it's so strange, the record already existed in table, but listbox still doesn't refresh after requery, I have to presss F9 several times to refresh manually. The update record button clicked, the listbox doesn't refresh too, but when I check the value of the row, the value is new value, but ths listbox on screen shows old value. for deleting, has the same problem.
So I'm not sure, if this is a bug of Access, or I missed something have to do. I already tried many way to solve this problem (sleeping, check if updated listbox, etc), all of them aren't work well.
Please give me a help!!!
Michael
I did it, but it didn't work. Ever I looped 10 times.
you could try requerying the list box on the onclick event of the Add record Button
listboxname.Requery
I did it, but it didn't work. Ever I looped 10 times.
you could try requerying the list box on the onclick event of the Add record Button
listboxname.Requery
Thanks for you help. My code is
With Me.lstISG .RowSourceType = "Table/Query" .RowSource = "SELECT * FROM InternalServiceGoal WHERE Year='" & Trim(lstYear.Value) & "' ORDER BY Year, Department, Service_Category, Service_Category_Details, Objective, Measure;" .Requery .SetFocus .ListIndex = -1 End With
Add button and ListBox on same Form. Add button captures text fileds and insert a record to database, ListBox just display all the records after click Add/Update/Delete button. All of three buttons clicked, the ListBox (lstISG) will be requery. but it doesn't work, I have to presss F9 several times to refresh the Form.
I have a form with four subforms which display highest scores in four categories during a competition. At the moment I have to manually refresh the form to see the latest scores. How can I get this to happen automatically say every 2 minutes? Thanks Dennis
I have many front end's (using ACCESS 2007 runtime version) in different terminals. Suppose that from 'terminalA', I am assigning a task to an employee who's using 'terminalB'. The user is already looged on to the program by this time, so I want that 'task' to appear on his terminal without him having to press the 'Refresh' button (that I placed on the form) every time I give him a new task when he's logged on so he could see it. How would I do this?
Hello, I have a problem maybe you guys can help me with. I have a text field, and I did those code for it:
Private Sub SearchRecord_KeyUp(KeyCode As Integer, Shift As Integer) dim strSQL As String dim search As String search = Me.searchField
strSQL = "SELECT [Mytable].[mycolumn], [Mytable].[mycolumn2] FROM [Mytable] WHERE [Mytable].[mycolumn] = '" & search & "';"
Me.ListBox1.RowSource = strSQL Me.ListBox1.Requery End Sub
As I type it in it doesn't seem to change the RecordList list box. When I put in a message boxlike this:
MsgBox ("anything doesn't matter") Me.ListBox1.RowSource = strSQL Me.ListBox1.Requery End Sub
It works, and it brings lists my query in the list box as I type, which is what I like, but it keeps bringing up the annoying MsgBox. So what I did is, I removed the text box, and tried running it again (didn't work again), so I type in the query without the last letter, so instead of "Smith" I typed in "smit" then I right-clicked (in form view) the list box and hit Properties. I didn't change anything just closed the properties again, as I typed in "h" to finish "Smith" it found it and displayed it (worked). When I deleted the whole thing in the text box and no matter what I type it still doesn't change the text box (even though it should make it blank because it didn't find anything), so it remains Smith it found last time and wont' get refreshed. When I hit properties and close it and as I type in another letter it querries it (something that it wouldn't find results for) and it erases my old Smith entry, and displays no results (what it should do).
This is very weird and it somehow needs some user acknolwedgement or something in order to change the row source of this object, regardless if it is a property box or a message box. Is there any way I can make it work without the message box and not having to right-click properties anc close it every time I type in a letter for it to work propertly?
I have a field on my form based upon a parameter query to assist the data entry person. Because of the number of entries possible, I thought it might be a good idea to narrow the possible selections based upon a possible name string e.g. I used LIKE "*" & [Enter some portion of the firm name to search on:] & "*" in the specific field criteria of that underlying query. The question I have is: after the first record is built and the field is filled, what do I need to do to get the same prompt in the next record? Only by exiting and re-entering do I get the prompt again. I'm not VB event proficient yet so I hope someone has seen this scenario before.
I have approximately 20 people using a shared database form. When someone updates a form creating a new record I want everyone to be able to see that new form record without having to close the form down and reopening it. Each form is given a form number by autonumber.
I have a form in which a 'read-only' sub form is placed. The sub form is based on a query. I have a button on the main form which opens another form with check boxes which allows updates the to table.
I want the readonly subform to refresh/requery after the close event of the update form.
What is the event I need to use? I've tried activate, gotfcous on the main form. I am tearing my hair out.
I am sorry if this has been asked already a million times already but I could not find any relavant information in the time I had.
I have a requery / refresh problem.
I have a Customers form showing all customers, I also have a NewCustomer form for adding new customers.
On the Customer form, on activate I have me.refresh
On the NewCustomer form I have in the onclose,
If IsLoaded("Customers") Then Forms!Customers.Requery
These work well however if Customers is open and I enter a new record in the New Customer Form, then view the Customer form again the new record is not shown.
I can however click back on the NewCustomer from then straight back to Customers and Hey Presto it appears
Any clues as to what I need to do to update the form?
I have a combobox with product description in it. If by mistake, I select a wrong value, then the other values are not refreshed. I have to close the form again and then reopen and reselect the values. What could be the problem? Any help?
I have one main form in which i have 2 subforms on different tabs.All the forms are unbound. Basically i am trying to assign a order to multiple persons.SO the main form has the order information.1st subform shows the already assigned persons and the second one is for assigning new persons.
The problem i am having is that whenever i assign a new person using the second subform i want to refresh the first subform but i am failing in it.
i used forms!firstsubform!refresh on the second subform..but it says object doesnt support the property or method.Then i create a refresh button on the first subform and on its click event i m doing me.refresh but again its failing.
The first subform is not bound and it has datasource as a querry like select a,b,c from order where orderid=txtorderid.
I have a small anoying problem that I'm hoping someone can help resolve.
On my main form I have a text box that shows the current number of members that are in the database. The default count is for all members whether they are active or inactive. On this same form I have a list box that I select whether I want to display active, inactive or all. When I select Yes, for example, the text box doesn't display the current count until I either move off the current record or I go to the Records menu and select Refresh.
I have the following in the control source of the text box.
