requery combobox in web database Access 2010 - using a macro

This question applies specifically to a web-based Access 2010 database. It does not apply to a client database. all of which apply to client database forms - not web compatable forms.

Web-based forms do not allow VBA code - they use macro's only - and only have "On Current" and "On Load" properties in the Event property box. This meansthat they do not accept code.

The context:

On the 'Projects' I want users to select a teacher name from a combo box. When the name is not on the list, there is a button that opens the TeacherDetails datasheet form. This datasheet form is bound to the Teachers table where the FirstName and Lastname fields are 'calculated' into Teachername.

The Projects table has a lookup field 'TeacherName' to the 'Teachers' table.

As I understand 'requery,' once the user has added a new teacher name to the Teachers table and closes the TeacherDeatils datasheet form, I want the Teacher table requeried so that when theuser returns to the combobox on the ProjectDetails form the new name appears.

Sponsored Links:

Related Topics

Access 2010 Web-compatible - update textbox field value with combobox selection
Working with Access 2010 web database which will be published to sharepoint. I wish to make a combox selection which will display a number in a separate textbox.
in the textbox's control source :

=combobox.Column(1)

or perhaps

Me!textbox.Text = Me!combobox.Column(1)

But it is not working at all. At best I receive an error message telling me my form is not web-compatible.

I attempted the macro route, thinking I could use the "settempvar" option but it seems that there are a lot of functions missing when in the web compatible mode. furthermore whenI go in the expression builder, where my loaded form is located, then select my combobox name, I only have columncount, columnheads, columnwidth ; nowhere to select my combox selectionvalue.


Access 2010 - Creating a Data Macro
Office 2010 Developer Training Course > Access 2010 > Building Solutions with Access 2010 Lab using the Contacts Web Database template.

I'm at Exercise 4: Creating a Data Macro and for whatever reason my macro is not working at all.

I created the macro and confirmed it matched to the guide and I had no errors when I saved it, so that has to count for something.

The macro is suppose to be invoked when the 'Status' variable is "Offer Outstanding" more than once in the database.

Yet I can select it multiple times without any instances of the macro displaying any warning message as it should.


Navigation Form control syntax 2010
I have a load of forms that now have been put into navigation forms using Access 2010 wizard. I know have found that most of the controls such as cascading comboboxes don't work and other comboboxes ask me for the parameter values when I open the form. I am unsure of the syntax for referning to these as I know the navigation forms are subforms and sonme of the comboboxes are in subforms themselves. I have as an example a combobox (cmboDepartmentID) that is asking me for the parameters whenever I open the formEvent ( through the navigation menu) this then has an unbound combox (cmboSubteamSF) on a subform (SubFormSubTeam). I have tried to work out the new reference but it isn't working so far I have as requery on the cmboDepartmentID:
Forms!frmMainNavigation!NavigationSubForm!Form!Sub formSubTeam.Form!cmboSubTeamSF.Requery but this doesn't requery and the combobox is blank. Can anyone point me in the right direction please


requery mainform unbound combobox using subform combobox value afterupdate
I want to requery form1 from the afterupdate event of form2, but using the combobox value in the form2, as the form1 combobox value.
In form2, I enter opportunity name in a text box and country selected in a combobox dropdown.
The country selected in the combobox of form2 is used to determine the record in form1 unbound combobox


Requery a comboBox
just wondering if its possible to requery a Combo box with text allready partially entered
(ie a Name Combobox from table with hundreds of names the drop down list changing with every text character entered)
way I figure should be possible with a requery on update for field with a criterea of [Name]=[Name] but with a partial selection like a column selection works


Requery Issues
I am pretty new to Access and have already received some good advice from this forum (thanks kipcliff!).

I am having some issues with requerying a combobox on a form. I have two tables, tblPatient with pkUMRN (not autonumber, a 8 digit alphanumeric code) and tblAdmission with pkAdmissionID andfkUMRNAdmission (linked to tblPatient_UMRN).

The control on the form (frmMaster) is combobox tblAdmission_UMRNAdmission, and entering a known UMRN code autopopulates the form with data from tblPatient. Entering an unknown UMRN in to the tblAdmission_UMRN combobox starts a Not In List event macro that opens a form (frmNewPatient) for UMRN/tblPatient data entry as new record.

My problems are:
- I get the error notification "the text you entered isn't an item in the list" as the frmNewPatient pops up. How do I disable this error message?
- The frmNewPatient opens a new record. Is it possible to copy across the UMRN entered in the frmMaster combobox tblAdmission_UMRNAdmission (ie the the unknown UMRN that initiated the NotIn List macro) in to the tblPatients_UMRN control in the frmNewPatients? Or does it have to be re-entered manually?
- After I enter the tblPatients data via the frmNewPatient, save and close, the tblPatient updates but the combobox tblAdmission_UMRNAdmission doesn't update unless the frmMaster is closed and reopened.

I have tried running requery macros linked to Event On Got Focus for frmMaster and Event After Update on the combobox. I have tried these requery macros both with and withoutUMRNAmission set as the control.


Access 2010 Macro
I have an MS Access 2010 Database that will be run @ 6:00 AM Automatically. The Autoexec Macro has been created. the purpose of the Macro is to update a local table with data from SQL Server. In previous versions of Access I used setwarnings = off to accomplish this without user intervention. However in MS Access 2010 I don't find that option. Anybody know where it is or how I can accomplish this


Requery a form from a macro
I'm trying to automatically requery a form after executing a macro. I know there's a lot out there about requery, but I can't seem to get it to work. It's clear that the best way to do this,

I have a form called "Formulier_afspraak_nieuwe_patient" that I'm trying to requery from the converted macro Macro_toevoegen_nieuwe_patient()


Refresh or requery data
If you are sharing a database over a network, other users could be changing data while you are viewing the same data in a datasheet or form. Microsoft Office Access updates the data that you see at set intervals. However, you can immediately display the most current data by refreshing the records. You can also perform a more thorough update by requerying the data.
What do you want to do?
* Refresh data
* Set the refresh interval
* Manually requery data
* Use a macro to requery data
* Use code to requery data


Access 2010 Web Form with regular Tab control ?
Are Tab controls of any use in Access 2010 Web Forms? In web forms the tab change doesn't appear to expose any properties to know what tab was selected. I tried using the navigation control first but didn't want to always requery my main page automatically as the navigation control does.


Combobox:Web DB, Select values from combobox and store in a table
I have a web database, with a form that submits data to a table (table1). I also have another simple table (tableForCombo) that contains names, which are being shawn in a combobox.

I want the user to
open the form,
pick a value from that combobox and
store it in another table.


Cannot requery combobox from another form
It's a hot day here in the UK, but I've promised to finish some Access programming for the database that handles bookings for our training courses at work, and I can't update a combobox oneone form from a button on another form.

Form A is a waiting list of people who want to attend one of our several courses.
Form B is a bookings form where the operator selects a course from a list, a person's name from a combobox then clicks a button to make the booking.

I'm trying to make things easier for the operators by allowing them to highlight the entry for person X in form A, then click a button on form A that opens form B and writes SQL code (whichcontains a where statement that identifies the ID number of person X) to the recordsource property of the combobox.
The code then requeries the combobox to populate the rest of the columns and other controls on form B.

The problem is the combobox on form B doesn't seem to requery. I'm writing to the bound column but after .requery the columns contain nulls, but if I click the combo box it drops down toshows only one person correctly identified by the ID value I've written to it.
I can write values to text boxes on form B easily from one form to another, but the combobox has 16 columns (don't ask) so I don't want to go down the route of adding many extra hidden text boxes to form B.

DoCmd.OpenForm "BookCourses"
Forms!bookcourses!cmbFindDelegate.RowSource = strSQL1 & strSQL2
Forms!bookcourses!cmbFindDelegate.Requery


sample database form(s) updating combobox
I have a form w/combobox, if not in list a subform popups and new user information needs to be entered/save which works fine, but I need the a) combobox doesnt requery - but instead I'm stuck in a loop, of do "do you want to reenter", does anyone have a sample of how they got this to work


Use combobox to control Subform
I realise this question has been asked before but the answer haven't been able to figure it out.

I have a form with a single combobox "Contact_Type" that is populated form a contact type table. The form also has a subform "Clients_Subform" that is to list all the clients with a particular contact type. Now my combobox defaults to the first contact type and the subform lists those clients.
Two problems

One: When I default the combo box to the second contact type the subform list still gets populated with the clients from the first contact type.

Two:When I select a new contact type from the combobox nothing gets updated. For this I have tried new events in the afterupdate

1 Me.Requery
2 Me.Refresh
3 Me![subform_name].Form.Requery
4 Form![Main_form_name]![subform_name].Requery

Nothing seems to work!


When web users use 'client' database objects?
I am designing a web database in Access 2010 so that company employees and managers can enter and manage data. As it grows (as databases seem to do), I increasingly want to make some 'client' features available to branch managers - like providing them with detailed financial reports with charts and queries that allow date selection criteria.

Because I'm finding it hard to find an Access Services host, I've not yet been able to trial it.

In the Access help I read that: "People can open the web database in Access, and then use the client objects.

Can anyone who has published a web database assure me that this means that a user who has Access 2010 installed can log in to the web-database - and use 'client' functions? This is what I'dlike to believe from the above,

(and bearing in mind how user permissions are organised in Sharepoint), can I then organise it so that employees have access to one level of data on their web browsers,and managers use their logins to be able to use the more flexible 'client' functions - also by logging on to the web? then MSAccess 2010 really does rock!


Access Web Database
I have downloaded a sample invoice database from templates of Access 2010.

However its in Web Access format. Can I not edit the fields in this in Design View?

How is best way to go about customising it to my liking?

Also does anyone know if I should use Web DB or Desktop DB for a client who will have database on a PC but could host it on server in the future. Would using Web DB make it sort of future proof?


Suppress delete record confirmation
I am having this problem in an Access 2010 web database. I have a macro set to delete a record but when it does, a delete confirmation message comes up. Even worse, if the user selects yes to delete, an action failed error (#2950) pops up. I would like to suppress the message but in the new macro language I don't see where there is an option to do so. Since it is a web database I can't use VBA. Does anyone have a solution?


VBA vs Macro
I have the following code in the AfterUpdate event in a modal form. but if I try putting the code in a macro with the Requery action I get an error 2950. Isthere some reason I can not use the Requery action to update a different form? Or, am I referencing the subform container incorrectly in the macro argument?


What's a Web Database?
I am trying to learn something about Access and I have Access 2010. I notice the Web Database choices in the templates. I think they are new since my last look at Access a number of years ago.

I've done some searches to learn more about them but I haven't found answers to my most basic questions.

How do they differ from non-web databases? Are they of any use in a non-Sharepoint context? If made available via the web are they updateable? Via the web?


Access 2010 Runtime crashing database
I have a different thread up regarding problems installing the Access 2010 app (hope that get's solved), but I actually found a user whose workstation has it successfully installed (unfortunately, he doesn't know how)?!

Now when we try to run my db on it, whenever a combobox or command button on a form is clicked, the app crashes. I checked and he's running Office 2010 v14.0 32-bit (the Access 2010 Runtime is the latest one from MS, published 5/10/2010).