I'm trying to change the display of a bound control on a form to a linked field in another table. Seems like it should be easy to do; I just can't figure it out.
The bound column is [StudentEnrollment]![AnnualClassNumberID] and is linked to a table called AnnualClassNumbers. The field I want to display is the ClassNumber from the is the AnnualClassNumbers table.
I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?
View 1 Replies View RelatedOn my form, I currently have a combo box that updates text box data with each new selection. However, after these text boxes for FirstName, LastName, etc. are updated, they cannot be edited. Here is the error message that appears in the status bar:
Control can't be edited; it's bound to the expression '[Form]!EmpList.Column(13)'
I'm thinking it might be a result of the data source for the text boxes being a combo box expression.
Any suggestions on how to fix this?
Thanks. :)
In my Textbox Control source I have given a formula =[Product Price]+[Delivery Costs].
I would like to provide an option to ther user to overwrite this Textbox (Should able to input a value).
When I try to edit the calculated value on the form, I get a message "Control cannot be edited, bound to expression". What can I do?
Is there a possibility that a control CAN be edited that is bound to an expression?
All of my Form properties are set to editable, no locks, allow deletion, allow addition, etc.
I just want a text box in a Form to be edited by users if they want to update it but they CAN'T since it is bound to an expression.
I have a Main form with several sub forms on it the tables behind each form are related tables. The user enters data on the main form with the exception of one bound control then moves on to enter data on the sub forms On exiting the record or the main form I want to take data from several of the sub forms and add them together and enter result in the bound form on the main form. Because this bound control is not used to enter data in there are no event triggers to code to get this done.
View 3 Replies View RelatedHow can I control the display of fields in a form? I see in a given database, that in the design view that some fields exist in a form but in the form-view some of them are not displayed.
I can't find how it was done, i see no difference in the fields' properties. Another question is how can i make a comboBox to display just the text without the ID number...
I have a main form bound to a query. Within that form, I have a button which calls up another form (pop up form). I simply want value of the "claim#" field-control to display in the "claim#" field-control of the pop-up form.
View 4 Replies View RelatedHi,
When i try to select a record from a combo box this message appears in the bottom of the screen :
Control Can't Be Edit; it's bound to AutoNumber field 'EventID'
It will not let me choose a PK/ID. what am i doing wrong or what setting needs to be changed?
thanks
Hey guys, I am trying to input data into a form, the form consist of mulitiple tables. Once I set it up I get a "#Name?" error in the text box, and when I try to input data into the text box, at the bottom of the form it keeps saying "control can't be edited; it's bound to unknown field 'FieldName'."
Can anybody help me with this problem?
Thanks
I have written a code to look up by the unique reference number rather than use the wizard to avoid this error happening... The field is restricted to list only so you can't actually edit the number.For ease of use you cannot scroll by record and I need to filter by the ID. Is there an easy fix to this combobox?
Would creating a seperate query work? Is there another lookup code I could use where I don't need to have the combo box bound to the ID field since it's not being edited anyway? I had a go at one and although it would now let me select it wasn't updating the record, tried a few ways but it seems that it needs to be bound to the field.
I want to display a month view control on one of my forms.
I only want to use it for viewing purposes only. But I don't see the Calendar control or MonthView in Activex list.
Where I might obtain such a month view control?
I'm using Access 2010 and Windows 8.1
Is there a way to create a text default value for a control box that is bound to a number field?
I have a combo box that is bound to an auto number ID but displays text. Bound column = 1, Number of column = 2, Column width = 0; 4cm
I want to use sample text in all my controls (and I know an alternative would be to use the control tip text). In a text box it is easy, I just set the default value to that value and then a before_update event considers the text box empty if the field value is the default value (e.g. Name text box has: Name... as default value). This doesn't work with my combo box since the bound column is a number. I could create a value in the table but then it would appear in the drop box and it is messy.
[URL] .....
I have a form with a tab control, inside the tab control I placed an ActiveX control (Microsoft Web Browser). These are at the bottom of the form.
Everything displays fine if the entire form fit on the screen but if the form is too long and I scroll down the browser control is getting obscured by the tab control and getting chopped off (the contents are covered). It is as if the browser control is staying in space where it was and moving behind the tab control as I scroll.
This problem does not occur if I place the browser control directly on the form. Also I note that the browser control is sitting correctly within the tab control.
I have been through all the settings and properties of both controls and haven't been able to fix it. I searched all over the web but no one has previously stumbled across this one by the look of it.
See the attached image ...
Hopefully a simple one that is eluding me at the moment.
I have a control on a sub form that refers to a value on another subform. When I enter data in the controls subform it will display the correct answer. However, when I close the form and return to it later the control is blank and will only display the answer if I go into another field on the form and make a modification to the data. It seems that the control will only calculate on an after update event but I need it to be visible at all times when the form is open. I have tried requery on open and on load with no effect.
Any thoughts out there?
Thanks
I have a form that I have set up that uses a tab control. I have set the background color of the form to blue and have set the back style property of the tab control to transparent. On some users computer that tab control is transparent, but on some other users computer the tab control is the default gray. I don’t know of any settings on the users computers that could cause the tab control to loose it’s transparency.
Can anyone help me? Why would the tab control display differently on different computers, normal on some and transparent on others?
I have a unbound form in my data base now i want to bound it to a table in the database .
how to do it
Table1 has field (% Completed this Period) that may contain a value, or may be NULL for each entry, depending on how much work was performed that period. The records are sorted by date.
Form1 has a textbox that basically keeps a running tally of "% Completed to Date" by summing the "% Completed this Period" for the current period and all previous periods. So, my Control Source for the textbox is the DSum(...) function.
The problem is this: If I am looking at the first record and there is a 0 (null) value for "% Completed this Period," (i.e. No work was completed that period), I want to display 0 on Form1. However, Access just displays nothing - a blank textbox. I tried making a default value, but nothing will show up since I already have a Control Source set for that field. If I take the DSum function out of the Control Source, then the 0 will show up. But, obviously that defeats the whole purpose of the textbox. I guess I'm trying to figure out how to display the DSum value IF it is something other than 0, BUT IF IT IS 0, then I want 0 to be displayed. Any help would be appreciated.
Hi, I'm not sure how to write something and would like assistance. The form is taken from a table and then there are two diffenterent forms displayed as datasheets within, on tab controls. I have a combo box taken from a query on each form and would like the combo box to display a certain list if the control on the form (the bit taken from the table) has a P in it, a different list if the control has an R in it or to display the whole list if the control has a B in it. Trouble is, I'm quite new to this and I'm not sure on how to write any code for if statements or whatever is needed. If you are able to assist I would appreciate it. Thanks
View 1 Replies View RelatedI have a search page and would like to display the search results in a grid/table format. User will be able to select a row to go to a detail screen. What is the best component type to use for this?
View 1 Replies View RelatedI agree completely with everyone when it comes to not using lookup fields in tables.But does that extend to Display Control of yes/no tables? What are the problems with setting the Display Control to "Check Box"?
View 4 Replies View RelatedI have a database that has student table (I am not a student doing an assessment!) with a one to many relationship to coursebooking and then a course table that has a one to many relationship with the coursebooking table so coursebooking seems to be acting as the link table between the many to many relationship. (I didnt design it).
I am creating forms to make the booking process faster and to perform the correct sums to produce an invoice and update a financial transactions table along the line.
I have an entry form that creates the student, and then other forms synchronise to the master form and gather the data. I am now at the point of wanting to get product details so ex course A, taxi to school and enrolment fee and add these to the booking table.
Historically the process was messy and couldnt calculate course A cost (per week) times by number of weeks.
I want to be able to select the products from a combo to build up an invoice and then once acknowledged as details correct commit to the tables coursebooking and transaction table.
I am not sure how best to achieve this ie is it best to have a bound form to the booking table and add new records to it line by line or to use an unbound form and some kind of product picker and to see the products built up perhaps using vba and storing products in an array until ready to post.
Some advice would be most welcome.
regards
Peter
:eek:
I have a form that has a subform in it. I want the key field in the form to dictate what fields show up on the subform. When I try to set the Link child and master fields, I get a 'can't build a link between unbound forms'. How do I make this subform bound to the form????
Thanks, JOe
I have a form with about 30 controls. I organized it carefully so that all the controls show on a single page. It actually looks really good. However, several of the controls allow multiple values. These appear as a check box showing up beside each item in the list from which these controls take their information. When I run a Filter by Form process, the form flawlessly pulls the data from the table that I'm seeking, and the check boxes are visible, both the ones with checks and without. In a few cases, in order to fit everything onto one page, I have most of the related list hidden, and use scroll bars. This works really well for data entry and for editing individual records.
Where it DOESN'T work like I want it to is in situations where the checked item(s) in the multi-value control don't show up in the box on the form without scrolling. In the table where these multi-value fields actually live, what shows up is just the code for each option, a simple numeral, with commas separating any multiple values. Is there a way to make my form show only the selected codes like in the table? My suspicion is that I'm going to be told no, that the best way to do this is to use a report and query.
I am creating a database to manage multiple mobile devices. The table structure is complete and I'm trying to build a set of forms.
Simplifying things, I have tblUser, tblSim and tblDevice. I also have a tblJoin where you can select a UserID, SimID and DeviceID to create an item of inventory.
I have created a parent form (frmCreateInventory) base on tblJoin, so it has JoinID and combo boxes for UserID, SimID and DeviceID in the lefthand side.
I have also set up 3 sub forms sfrmUser, sfrmDevice and sfrmSim, based on their respective tables, which I want to display on the right hand side of frmCreateInventory.
I'd like to be able to create a subform control in frmCreateInventory, but change the subform it displays based on what combo box is clicked, e.g. if I click the UserID control, the subform displays sfrmUser, and the relevant data based on the UserID that is linked to the JoinID. if I click the DeviceID control, the sfrmDevice is displayed and the relevant info etc. etc.
Is this possible? if so, how would I go about doing this?
I'm using a web control to display a page. I want to have a code that can copy to a field in that same form, the html source of that page that is displayed in the web control. How I can do that?
View 13 Replies View Related