Topics Search

requery combobox in web database Access 2010 - using a macro

requery combobox in web database Access 2010 - using a macro
Views: 30
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:

Similar posts...


Access 2010 Web-compatible - update textbox field value with combobox selection

Access 2010 Web-compatible - update textbox field value with combobox selection Icon
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 :


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

Access 2010 - Creating a Data Macro Icon
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

Navigation Form control syntax 2010 Icon
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

requery mainform unbound combobox using subform combobox value afterupdate Icon
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

Access 2010 Macro

Access 2010 Macro Icon
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 comboBox

Requery a comboBox Icon
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

Requery Issues Icon
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.

Refresh or requery data

Refresh or requery data Icon
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

Requery a form from a macro

Requery a form from a macro Icon
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()

Access Web Databases: 2010 vs. 2013

Access Web Databases: 2010 vs. 2013 Icon
Access web databases are dead. But there’s no cause for alarm. Now we have Access web “apps”. With the introduction of Access 2013, Microsoft has made substantial changes to its vision of how to put Access database applications on the web. The differences between Access 2010 web databases and Access 2013 web apps are major, and you should consider them carefully before embarking on an Access web project.