Bound vs. unbound controls
Force SQL update on a bound form
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
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
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
I am unable to figure out why this behavior is happening. Any help with this is appreciated a lot.
Combo Box Properties (2003)
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
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?
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
Bound Form - Manual Recordset Update?
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
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
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?
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?
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?
Why does my Undo button become active for some changes but not others.
I have an Undo button on my form that is supposed to become active whenever a change is made. This works fine whenever I change a bound field.
However, I also have unbound fields on the form. Once I change an unbound field, this appears to mess up the UnDo logic as from that point, changing a bound field no longer causes the Undo button to become active.
Ideally, I'd like the UnDo button to work with both bound and unbound fields but at least I'd like to prevent the unbound fields from messing up the UnDo for the bound fields.
In my form I am trying to change a bound field with the value of an unbound field that occurs before it on the form so this new value shows up in the table for that field. The unbound field contains a number from a field on the previous record from the table, and the next field, the bound field, is to get that value. I used the AfterUpdate event in the unbound field property, where unbound field = the bound field. I tried this with the control property, then tried using the AfterUpdate event for the form, and no value appears in the bound field and doesn't show up in the table. Both these fields are in a subform. I used the "Me." prefix for both fields and that doesn't work. Probably some minor thing I am not seeing
Unbound Control Mystery
I have a report with a number of unbound controls which show a default value. The report loads fine and displays the correct values as it should. However I need to change the values on some of the controls but for the life of me can't find / remember where I set the the default values. There is no code on the report and within the properties of the unbound controls there is no default value option.
Very confused as I obviously set a default value at some point
sum in form footer
I have this problem and I cant figure it out how many times I have tried it myself.
I have this subform, and it has 4 textbox: three that is bound and the one that is unbound form.
when I do calculations in the bound textbox, I can successfully arrive at the sum of textbox3 but when I sum the fourth unbound textbox, it give an error inside the textbox.
Does it mean I cannot make a summation of an UNBOUND textbox
Why unbound from as Splash Screen??
Can someone explain why this is? Is it just preference to not have bound forms? Can you not have a splash screen that is bound to anything?
Haven't looked into this too much as I'm pretty novice to the development side of forms and such. Someone mentioned unbound in one of my questions and I just saw a tutorial about creating splash screen and it mentions you should create an unbound form
Unlock form by default and user can manually lock it
I'm currently using Access 2007 and I would like to lock down controls in a form with a button, I read about some pretty clever coding for locking bound controls, but it doesn't quite fit my needs. The new forms usually open in a locked state (which bothers me a bit since data will be added regularly), while some blank textboxes, that the user has to fill by himself, are not locked at all.
I would like the form to open unlocked by default (or at least apply no locks on a newly created form), so that the user can manually lock all the controls, bound or unbound, with a click on a command button, after he's finished. Maybe it's not kosher with Access, but I'd prefer to avoid heavy programming in VBA...
unbound text box filter by form on Split Form
I have a split form, with several unbound text boxes, which I would normally use as a filter by form type function. the query has criteria bound to these text boxes.
My problem is that I cannot seem to get the mouse to focus on the unbound text boxes on this split form. when I click in the unbound filter by form text box, the focus immediately moves to the first text box that is bound to data on the form.
Then I will try recreating my split form in a different way. if it is a problem, If perhaps a split form cannot have any unbound data entry controls on it, then I could create a form with the search criteria on, and keep the forms separate. If I was to do this, though I would like to 'dock' this form at the top of the window, and then have the split form 'dock' underneath, as if there was an application level window splitter control. Another option might be to put the filter by form text boxes in the ribbon, and I have added some stuff here, but I am unsure how I might refer to the control in a query criteria.
Data Set not Refreshing after Delete
I have two textboxes and a combo box all bound to columns in the Reminders table. My ADD and UPDATE buttons work perfect, and refresh the data in my bound controls afterward.
I cannot for the life of me get my DELETE button to refresh my bound controls after I click the delete button and delete a row. The deleted row is still in my controls until I exit from the form and reenter.
I have tried clearing the data set, re-filling, etc. I cannot get anything to work.
Date Control feature
Currently in Access 2007 theres a really nifty and sleek date control feature that works with date fields in a table. If you have a bound date field in a form and click on it, a tiny calendar pops up and allows you to choose the date& This is fantastic and I want to use this feature, but my problem is: I want to use an unbound date field.
I want to create an unbound date control on a form that uses the exact same functionality as Access 2007 bound date fields do. How can I do this?
For many years I have used the big bulky ActiveX calendars controls and I really want to get away from them if at all possible. Is there some way to do this programmatically? Or am I missing some new design feature that is already there for use? I've looked around, but I can't seem to find anything along these lines