Topics Search

Bound vs. unbound controls

Bound vs. unbound controls
Views: 297
What is the difference between bound and unbound controls in MS Access? How do they differ? And when on an MS Access Form in design view, how can we tell if a form is bound or not?
Sponsored Links:

Similar posts...


Force SQL update on a bound form

Force SQL update on a bound form Icon
I am trying to force a bound form to execute an SQL update (and a few housekeeping tasks) before I navigate to the next record, even if I am only updating an unbound control (listbox). The beforeUpdate event only seems to fire if I change one of the bound controls on the form. I have to have both bound and unbound controls (I think) because there is a many-to-many relationship between the bound record and the items in the listbox (so I am using a collection table).

If anyone could provide some information on a possible solution, or some better definition on the event order when the form's navigation buttons are clicked, I would be greatful. I am using Access

Using a Form to save data from one Table to another

Using a Form to save data from one Table to another Icon
There is a public master database with a bunch of tables and data in it being maintained by another group. Need to skim some information from this, add some of information to it, and save it in a completely separate .mdb file on our server.

I've used Access to link to the public database, built a custom table just for us, and built a form. The form uses bound controls on the left side to pull in data from the public database, and unbound controls on the right side for user entry of data.

I coded a VBA save button that should save all controls (bound/imported as well as unbound/data entry) to our local table.

The unbound controls save just fine, but the bound controls are missing from the table. A new row is created with no problems, I get no error messages, but half the fields in the table are just blank.

unbound text box data not appearing in print preview

unbound text box data not appearing in print preview Icon
I have a form with some unbound and bound controls. The form has a record source. When the form is run and controls are populated via a query (the recordsource), the user enters data in some unbound controls. The form also has a button which displays in print preview mode.

When the custom print preview button is clicked, the data from the unbound controls do not appear in the preview. But if I use the file-print preview menu item, the data is properly seen.

Below is the code written in the button click to display print preview

DoCmd.SelectObject acForm, "AnswerForm"
Printer.Orientation = acPRORLandscape
DoCmd.RunCommand acCmdPrintPreview

I am unable to figure out why this behavior is happening. Any help with this is appreciated a lot.

Combo Box Properties (2003)

Combo Box Properties (2003) Icon
I have a sub form on which there are 3 different sets of controls. Only 1 set will be visible by the user depending upon a selection made in the 2nd control on the form. I am trying to sue the visible property and change it in VBA depending upon the 2nd control. e.g.
However each time I run it I get the message error #438, Object does not support this property or method. The 3 controls being changed consist of 2 unbound combo boxes and 1 unbound text box (they would all be bound to the same fields which is why they are currently not bound. I will update the actual table later when all the data has been entered.

I am sure I have done this before but stupidly cannot remember how.

Unbound combobox AfterUpdate

Unbound combobox AfterUpdate Icon
On some form I have several unbound combobox controls. Whenever some of them is changed, I want:
1. reset the values for other combos on same form;
2. reset Filter and FilterOn properties for subform on same form;
3. reset Rowsource for a record locating combobox on this subform.

Currently I use combo's AfterUpdate's events for this - like:


The problem is, those events are fired whenever something on combo is selected - even when the combos value really remains same.

I want, that event will be fired only, when some combo's value was really changed, and I can't use OldValue property here, as this works only with bound controls (for unbound controls it is always same as controls current value). So I need something along lines:

Bound Form - Manual Recordset Update?

Bound Form - Manual Recordset Update? Icon
I have a bound form with bound text box controls. I would like to have SAVE button so the record can be updated in place. However, it seems binding the form and controls to a recordset prevents and in-place save. Is this a limitation of using bound controls

Locking bound controls

Locking bound controls Icon
How to prevent users accidentally overwriting data in a Microsoft Access database by locking the bound controls on a form. Handles subforms recursively. Allows you to specify controls that will not be unlocked.

Bound controls "mis"behaving

Bound controls "mis"behaving Icon
When I open a form I would like the bound controls to be unpopulated until after I choose the appropriate record.

What I am getting is the bound controls populated with the data from the oldest record, lowest autonumber, in the linked table. Very unprofessional effect to always have the same person's data show up whenever the form is opened

Text Box control and character limit?

Text Box control and character limit? Icon
I have an unbound text box on a form. The form is bound to a query but only for reading records. The unbound text box is programatically populated with data from the form's recordset. If the text gets around 2038 characters long trying to save via the form produces the error "could not update; locked by another session on this machine." I can still update via the table, just not the form. Also, if I have the form viewing the record containing this long text then even via the table it says the record is locked and cannot be updated.

**The field in question is in its own table because it is a memo field that gets changed regularly in production. The production environment has this as a bound control but I am trying to implement unbound controls to avoid excessive record locking.**

Is there some limit on text controls regarding length of text? I cannot find anything by googling or searching this forum

Multi-select images for report - create array?

Multi-select images for report - create array? Icon
I have 10 unbound image controls on a form and below each I have a bound radio button. On my report, I have 5 unbound image controls. The user selects multiple images on the form with a maximum of 5 selections.

Let's assume the radio buttons representing the image controls on the form are named 1-10. Let's also assume the image controls on the report are named A, B, C, D, E.

In all cases, image control A on the report will contain image 1 and image control B will contain image 2. For C, D and E they would display the remaining selected images from the form. How these images are ordered is not important.

How can I dynamically assign the remaining selected images to image controls C, D and E on the report?