Tables :: Combo Box And Check Box Showing As Textboxes
Aug 22, 2013
Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at the fields it clearly says it should be a checkbox or combo box. Iv done it the same way I always have and this time its just wrong.
View Replies
ADVERTISEMENT
Oct 5, 2014
I have a form (frmHourEnter) with a combo box (cmbJob) and if the number entered into the combobox is not in the list then another form (frmJob) is opened and a new number is entered. On closing this form I run:
Code:
Me.Form!frmHourEnter!cmbJob.Requery
The combo box (cmbJob) does not show the new number unless I close the form (frmHourEnter) and re-opened it. If I add the following code to the one above:
Code:
DoCmd.Requery "Form!frmHourEnter!cmbJob"
Then click out of, and then back into cmbJob the number is in the list! What can I do so that the number is in the list when the second form is closed?
View 11 Replies
View Related
Dec 27, 2014
When UseDDelivery is checked the three textboxes should be disable and when the form is opened UseDDelivery is set to be checked by default so the textboxes should be disabled when the form opens but they aren't. the two different ways of doing it are shown below.
Elements specific to my system :UseDDelivery = checkbox
AltDeliveryAddress = textbox1
AltDeliveryTown = textbox 2
AltdeliveryPostcode = textbox3
Solution 1:
Code:
Me.AltDeliveryAddress.Enabled = UseDDelivery.Value
Me.AltDeliveryTown.Enabled = UseDDelivery.Value
Me.AltDeliveryPostcode.Enabled = UseDDelivery.Value
This is a bit of vba a friend wrote for me quickly, it includes all three textboxes but the checkbox enables them instead of disables.
solution 2:
Code:
Private Sub UseDDelivery_AfterUpdate()
If AltDeliveryAddress.Enabled = True Then
AltDeliveryAddress.Enabled = False
Else
AltDeliveryAddress.Enabled = True
End If
End Sub
With this bit of vba I found the checkbox enables the textbox instead of disabling it and I can't figure out how to include the other two textboxes
View 4 Replies
View Related
Aug 30, 2013
I have a checkbox which when checked then turns textboxes to locked as below. However when I navigate to the next record which may not be checked the text boxes remain locked. I obviously want to lock the boxes depending on each record. I am navigating via the windows next/back record buttons. How do i do it?
Private Sub Check44_Click()
If Check44.Value = -1 Then
serial.Locked = True
gain.Locked = True
swst.Locked = True
Else
serial.Locked = True
gain.Locked = True
swst.Locked = True
End If
End Sub
View 6 Replies
View Related
Oct 28, 2005
hi
when a value is selected in a combo box then values shud be set to the textboxes in the same form
plz let me know hw to do it.
Please reply ASAP
thnx
View 2 Replies
View Related
Nov 8, 2006
Hi all,
Is there any way of enabling/disabling a number of text boxes/checkboxes, based on a combo box selection, for example:
Combo Box 1: Airport Selection
Combo Box 2: Customer Selection
Once the user has selected the customer, based on the airport selection there will be about 10 text boxes and a few checkboxes that I'd like to allow or "ghost" depending on whether we are contracted to carry out work for that customer.
Any help would be appreciated.
thanks, Graeme
View 2 Replies
View Related
Apr 22, 2015
On design, layout and report view, everything looks exactly how I want it. However, when I display it in Print Preview mode, checkboxes appear about the Project Name.There's nothing in my report to show that I have these checkboxes on the report. Where these could be coming from and why they only show in the Print Preview layout?
View 2 Replies
View Related
May 5, 2013
I have 3 tables.
Table 1: contains staff names and contact numbers
Table 2: contains training above staff have been on or need to go on
Table 3: contains pc and printer asset numbers of above staff
I used a form and entered some new members of staff in table 1. They got their auto numbers etc but when I open table 2 and table 3 those new members are not showing up in those tables. I have checked the relationship status between the 3 tables and the staffID from Table 1 is associated to table 2 and to table 3.
What's stopping the new entries from showing up in tables 2 and 3 ?
View 10 Replies
View Related
Jul 6, 2005
In one table i Have component group Id and the description as fields then another table has the sub groupings for each Component Group Id
Example
Component Group ID = 1 which is the primary key
Description = Keyboards
Component
Sub datasheet has Group ID = 1 foreign key
Descriptive Options = USB, Wireless, PS2, Serial
I have joined both of these in a query but what i want is the query when i link it to the combo box on the form i have to only show the Group ID once and not repeat it for as many times as each subdatasheet has records.
Example: When i click External Device I dont want to see the word Keyboard being repeated 4 times (which is because there are four subrecords/types of keyboards) Please Advise.
View 2 Replies
View Related
Nov 24, 2012
I have one combo box bounded with two fields, Id and Description through a query.
I entered a new id in bonded table but for some reason I don't want to enter description now.
And if I delete the entered id then I will loss that unique id which is using for description, which I don't want.Now the problem is one blank space showing in my combo box.
So what criteria I should use in query criteria to avoid blank spaces?
View 5 Replies
View Related
May 28, 2014
I have a report on which I have a combo box showing text value as open issues and closed issues. What I want to do is on the report in a text box show count of open issues and closed issues separately.
View 1 Replies
View Related
Oct 5, 2012
I have a combo box to show bring up the cost of my products .Although it shows the correct prices in the combo box ,when i select the cost it posts an entirely different cost in the appropriate field. It seems to be posting the product id number with £ sign in front of it
View 2 Replies
View Related
Dec 18, 2013
I'm creating a form where people can choose something in the first combo box [ComboBox1] which results in the second combo box [ComboBox2] displaying only the items that are associated with the first combo box [ComboBox1].
In my second combo box I have the amount of "empty lines" that equals with the items associated with the first combo box. But there is nothing displaying. No words.
View 8 Replies
View Related
Mar 4, 2013
I am about to set up a database but wanted to check the relationship of the main tables before I add to it. I have attached the relationship design
For a PROJECT, there can be many TESTS, for a TEST, there can be many PRODUCTS
Is my design reasonably sensible?
View 6 Replies
View Related
Jan 4, 2007
Hi,
I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes.
For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box.
Thanks a bunch!
View 5 Replies
View Related
Apr 9, 2014
I am a novice to Access and in order to get some training in my workplace I need to show how access can be applied to my role.
I have a table of information consisting of 3 fields:
Motor manufacturer
Model
Attachment (picture of particular car)
I want to have someone able to select the manufacturer and Model from Combo boxes and this will pull up the image associated with this model.
There are more than 1 model for each Motor manufacturer so you may have:
manufacturer Model
Ford Fiesta
Ford Mondeo
VW Beetle
VW Golf
Fiat 500
You must not be able to select the wrong model for manufacturer, i.e.
Ford 500
The images are currently saved onto the table as an attachment,
This may be wrong as well,
This may be a simple task to do, but hopefully I can get it running smoothly and show this is the right tool for the job.
View 3 Replies
View Related
Aug 13, 2014
Access 2010. This has worked before but I don't understand why this is not working for me now. When i select an item in a combo box in a form and click on a button to run a query with the results, the query is blank. If I run the query alone, it prompts for an item, I can type it in and it works. I have even tried the DoCmd on the combo box but still same results. Attached is a dummy down DB. If you run the query, it will prompt, select Paper or Rock, see results. But run the form, the drop down will not show the results. What am I missing?
View 3 Replies
View Related
Oct 7, 2014
I made a form for users to go back and see saved records as and when required. However my cascading combo box are not showing the saved information. Information is saved in back end.
View 5 Replies
View Related
Feb 26, 2015
In the Purchase Order details form a Supplier has to be chosen via a combo box. Based on that another combo box in the subform displays products only from this supplier (Products table is linked to supplier table).
I managed to let the subform combo show only relevant products using criteria referring to the main form combo box. Also other product data will show accordingly in text boxes. So far so good.
However when I close the form and reopen it the subform combo box is blank, other text boxes still show the right values. If I remove the filter criteria for the subform combo then all fields show all data correctly. (However the combo box is unfiltered again 8-/)
So somehow the 'criteria' prevents the combo to show the value that was previously chosen.
View 2 Replies
View Related
Aug 10, 2015
Is it all possible to create the equivalent of a combo chart in Excel in Access?
What I need is a graph showing a certain dataset as columns but also a line showing the average for that set.
As an example lets take an exercise programme in a school, each child performs a series of exercises every week and data is recorded, to monitor their fitness progression.
Lets say I wanted to show a graph of one particular exercise, with the class students listed along the x axis, and then show the class average for that exercise dataset as a line on the same graph.
View 3 Replies
View Related
May 4, 2013
How I can get the zero in my telephone dialling code to show up in my tables?
I have set the number display to the Long Integer.
View 13 Replies
View Related
Aug 9, 2006
Hi
I have a form which has two command buttons A and B. I set that when somebody click the button A then table A will be open and so on. But I dont want that table opens in new window. I want that I can "draw" a "box" in form where the table will showed. So can anybody help me and tell how to set that table will always show in "box". Can I set this somewhere in Access or do I have write VBA code. (I'am very very poor at coding)
View 4 Replies
View Related
Jul 26, 2013
Table Info:
EmpProfile: EmpID (Primery Key), EmpFirstName, EmpLastName, Emptitle, EmpPhoneNumber
EmpTimes: EmpID (1 to Many relationship with EmpID primery key), Timein, Break, TimeOut, Totalhours
Query Name:
Selects the table from EmpTimes
Calculates the total hours worked for an empid, on a given day. It produces the total hours as "CalcTime"
Form Info:
1st Form Name: MainForm
Text name to enter empID : Txtempid (unbound)
Record Source: EmpProfile
2nd form name: SFTimeSheet
This is a subform within main form
Record Source: QryTime
Child and master fields are linked using : EmpID
Expecting Result:
When enter empid on the MainForm, in txtempid
subform should retrieve all entries for that empid
Getting result:
regardless what empid entered in txtempid, subform shows only the 1st record available in EmpTimes.
View 3 Replies
View Related
Aug 8, 2013
I Created a form and linked it to a ODBC table with no data. Set the Allow Additions property to Yes. It shows fine if there is data in the table but not when there is no data.
View 1 Replies
View Related
Dec 17, 2006
Hello (Again!)
I have a form that is mainly used for data entry (for call logging). Ideally it will be linked to 4 different tables, however I need to get the basics working.
My new problem is being able to look up data that is selected in a combo box to see if it is out of date. I shall clarify, as stated the form is for call loggin, when someone calls I ask for their postcode, this is in the combo box.
I want to then use the postcode selected to data from another table that lists services due, and if the service is due for that postcode within two weeks highlight the text box in red.
Any ideas?
(access newbie so please bear with me!)
Many thanks.
B.
View 2 Replies
View Related
Sep 3, 2013
I have a form with a combo box (it has two states (In process / On file)) and a checkbox and I need that when the checkbox is checked, change the status of the combo box..The combobox and checkbox are in different tables (Assigned and Movements, respectively) and refer to different types of data.
The checkbox Refers to a set of tasks FINISHED, then, if that's the case, They must change the values of the ComboBox That has two values or options (In process / On file). Note: These two values are searched fields in a table "Status", and searches for values in a table with the wizard searches
For example: While ComboBox contained in "In Process", the checkbox is unchecked and if this "On File" checkbox is marked.
View 8 Replies
View Related