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

Tables :: Combo Box Not Showing New Number

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

Modules & VBA :: Disable Multiple Textboxes With A Check Box?

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

General :: Check Box Event - Lock Textboxes Depending On Each Record

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

Populate Textboxes In The Form According To Value Selected In Combo Box

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

Enabling Textboxes Based On Combo Box Selection

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

Reports :: Check Boxes Showing On Report

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

Tables :: New People Added In Table1 Not Showing Up In Other Tables Despite Relationship

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

Combo Box Showing Repetitous Data

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

Combo Box Showing Blank Values?

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

Showing Count Of Different Values Of A Combo Box

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

General :: Combo Box Not Showing Currency Properly?

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

Combo Box Has Right Amount Of Values But They Aren't Showing Up

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

Tables :: Set Up A Database But Wanted To Check Relationship Of Main Tables

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

Text Boxes Showing Information From A Row In A Form Corresponding From A Combo Box

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

Forms :: Showing Image From Table Using Combo Box Selection

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

Queries :: Access 2010 / Query Not Showing Results From Combo Box?

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

Cascading Combo Boxes Not Showing Previous Saved Records

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

Combo Box Filter In Subform Showing Blank At Form Opening

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

General :: Combo Charts - Graph Showing Certain Dataset As Column And Average For That Set

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

Tables :: Zero Not Showing Up In Telephone Numbers

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

Simple Question About Showing Tables In Form

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

Tables :: Subform Not Showing Correct Records

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

Forms :: Fields Not Showing With ODBC Tables

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

Using A Combo Box To Check Data

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

General :: Check Box That Changes Value In Combo Box

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







Copyrights 2005-15 www.BigResource.com, All rights reserved