Forms :: Autofill Combobox With Change Option

Jan 7, 2014

I currently have a form with two comboboxes. One contains a list of products that the user can select from the other contains a list of percentages (sales commission rates).

What I want achieve is that when the user selects a specific product then a specific commission rate is select.

However, after selecting the product the user should still have the possibility to select a different rate if that is what has been agreed with the client. Ie. deviate from the standard rate defined by choosing the product.

How can I link the two comboboxes so that the correct rate is selected? while still retaining the the possibility to select something different?

View Replies


ADVERTISEMENT

Forms :: Autofill - Possible For Fields To Have Auto-complete Option?

May 20, 2014

I have combo boxes set up with the different choices for major, minor, year, etc. Is it possible for these fields to have an autocomplete option? For example, there are about 30 different subjects that students can choose for a major, so rather than having to look for it in the drop down menu, could the person entering the data just start typing "ant" and have it automatically fill with "anthropology" for example?

I should also mention that the reason I made these fields into combo boxes is because I built SQL in the row source so that it is bound to the primary key but displays the description instead (with the column widths set to 0; 1).

View 2 Replies View Related

Forms :: Change ComboBox Drop Down Menu From Displaying Checkboxes For Multiple Values

Oct 14, 2013

I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.

I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).

I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.

I use a very standard SELECT statement to pull the data for the combo box:

SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName

View 7 Replies View Related

Change A Listbox Recordsource With The Use Of Option Buttons

May 27, 2005

Good afternoon

I have been helped out so many times in the past here I thought I would try my luck again.

Is it possible with the use of option buttons to change the row source of a listbox?
I want to use the listbox for a search criteria and thought it might be easier to have 1 listbox been updated from the choices made using a group of buttons.
I would like like the row source to be based on different tables maybe I might need to use queries.


Can anyone point me in the right direction?

View 6 Replies View Related

Change Option Group Label Colors

Nov 5, 2004

I have an option group with 3 options. The labels are black. I would like to change the label to red for the given option that was choosen.

Option group name: OptionCarrier
Options: Option1, Option2 and Option3
Labels:Land, Sea and Air

Thanks for the help - John

View 3 Replies View Related

Reports :: How To Change Enter Parameter Value To Option In MS Access

Jun 2, 2014

I have Access database I want to change enter parameter value to option when I want to view a report.

View 4 Replies View Related

Forms :: Update Row-source Of Combobox Based On Value Selected On Another ComboBox?

Apr 26, 2015

I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.

Code:

Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub

But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?

View 5 Replies View Related

Refresh / Requery Subform Upon Combobox Change

Jun 17, 2013

I have been using AYS2000 database example from Rogers access library. I have been in the process of modifying to meet my needs. Although I have run into a problem that was prevalent in the original database example. I have attached the original database for your reference.

Problem: At the bottom of the database beside the "New Response" button there are 2 combo boxes that allow you to select the survey and response in which you want to view in the subform. Although when selecting the response the subform does not always update the record in the subform. It would appear that the problem occurs only after a response has been previously selected. I have tried adding additional code to refresh and requery the subform already without any success.

View 3 Replies View Related

Forms :: Option Group - Warn User When Neither Of 2 In Option Group Not Ticked?

Jul 25, 2013

I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".

[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]

The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.

Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.

Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.

View 1 Replies View Related

Modules & VBA :: Change Row Source Of Combobox By Clicking On Checkboxes

Jun 28, 2014

I have a Form with a combobox and 3 checkboxes now i want to change the Rowsource of the Combobox by clicking on the checkboxes. When i click the Checkbox the Rowsource gets Changed as i want it but i can not use the new Values cause its giving me the error "The value you entered is not valid for this field"

The Funny thing is its always bound to the type of data i choose first. When i first select the Week i can select only Weeks (17,18,19 etc)
When i choose Day first it only accepts Dates (01.01.2014 etc)There is no Control Source set . And the Bound Column for all Sources is 1

Here the Code

DD_Zeitraum is the Combobox
CB_Day CB_Week CB_Month are the Checkboxes

Code:
Private Sub CB_Day_Click()
If Me.CB_Day.Value = -1 Then
Me.CB_Month = 0
Me.CB_Week = 0
Me.DD_Zeitraum = ""
Me.DD_Zeitraum.RowSource = ""
Me.DD_Zeitraum.RowSource = Dist_Datum
Else
Me.CB_Day.Value = -1
End If
End Sub

[code]...

View 10 Replies View Related

Modules & VBA :: Change Which Row In Combobox Is Visible Depending On Event

May 21, 2015

I have a combo box with three columns, the first one is the bound one, the second is text in English, and the third is text in Spanish. Currently when the form is open, both the English and Spanish texts columns are visible. What I would like to do is set up a command button on a different form that will open the form with just the English showing in the combo boxes, and another button for Spanish. I've tried the following code which opens the form, but the combo box is disabled altogether.

DoCmd.OpenForm "frmEditar", acNormal, "", "", , acNormal
DoCmd.SetProperty "niv_gest", acPropertyColumnWidths, "0;1;1"

What am I missing?

View 5 Replies View Related

Modules & VBA :: Combobox / Listbox Change Event Populate Values In It

Nov 21, 2013

I am trying to write a code that will execute at the change even of the combobox/Listbox and when a character is typed in it then all the data from "DocumentType" field whose first character matches with the first character typed in Combo/Listbox will be stored in it.

The following code doesn't work:

Private Sub ComboBox4_Change()
Dim strText, strFind As String
strText = Me.ComboBox4.Text
If Len(Trim(strText)) > 0 Then
strFind = "BarcodeRef like '" & strText & "*'"
End If

[Code] .....

View 1 Replies View Related

Forms :: How To Autofill A Bound Text Box

May 29, 2015

Is there anyway or code to autofill a bound text/combo box for instance with the person who is working the database i have this code but doesnt work with bound boxes

Me![Agent] = Forms("loginform")![cbousername]

View 1 Replies View Related

Forms :: Autofill Form And Allow To Edit

Nov 9, 2013

I have 2 tables StudySchedule and ExamSchedule.StudySchedule contains the detail information of opening classes of many different periods. I need to create a form that can:

1. let the user choose a period

2. form will generates automatically exam schedules of the opening classes of the chosen using the relevant information in StudySchedule. Those entries will be saved in ExamSchedule.

3. Note that there are 8 fields of the exam schedules generated/counted from some fields of StudySchedule. The 3 other fields of the exam schedules need to be entered by the users. User must also have the ability to edit the generated fields.

View 4 Replies View Related

Forms :: Autofill One Of The Field In Form

Jan 14, 2014

I want to Autofill one of the field in my form, by checking specific conditions in my database. Example of which is as below:

1. Date of Maintenance :
2. Loom No. :
3. Component Replaced :
4. Component Type :
5. Latest date for same component replacement :

I want to autofill the Sr. No. 5 in the form itself by checking database, and if Sr. No.2=Sr No.3=Sr. 4, then latest date should be autofill in Sr. No. 5

Say, A component was replaced in a Loom on 01/01/2013 & again after six month same component is replaced on 01/06/2013 so while filling up the form, In sr. no. 5 latest date 01/01/2013 of replacement of same component in same loom should be pulled from data base.

View 1 Replies View Related

Forms :: Autofill Batchdate For Each New Donation

Oct 6, 2013

I have following Tables/Fields

1. tabDonations
ID
DonorID
BDateID
Amount

2. tabDonors
ID
Name

3. tabBatchDate
ID
Date

Process
Donations are entered in Batches by Date

I am creating a Donation Entry Form to perform following STEPS

1. Select a Batch date already in the BatchDate table
2. Enter several donations with the date selected above.

How do I Autofill the Batchdate for each new donation?

View 9 Replies View Related

Forms :: Button To Autofill A Field In All Records

Oct 21, 2014

I know all of the main features and can even do a bit with macros and VBA. I need creating a button to auto-fill a field in all the records in a table.

I have a database centered around a table called tblCand; each record contains a date field called intDate. On the main form, initDash, when the user hits a certain button, a window pops up (either a message box or perhaps a separate form) that asks the user to type in a date, which would be stored as intDateDB. When the user hits OK, I want the value of intDateDB to replace the value of intDate in all the records in tblCand.

I'm not sure whether this is called auto-filling or auto-populating...

View 11 Replies View Related

Forms :: Autofill Form Saving To Tables?

Oct 17, 2013

What I'm trying to do is create a database system for my company, it's not overally complex in the sense it's just managing the estimates and invoices we do.

[Tables]

SalesPersonID
Clients
AccountTerms
Estimate
Invoice
WorkSheet

Now I've tried to break the data down as sensibly as possible.

What i'm having trouble with is I have created a autofill combo box to fill out text boxes with information from the Clients table, the idea is that the client can be added via the Estimate form or pulled up from the record depending on the situation. Now the problem I have is one;

I cannot enter data via the form

and two

When you flick through the forms only the combobox information is staying put, either the text field is empty or incorrect.

I'm pretty it's to do with [Data Source] but I can't seem to get it to work. How to make it possible to pull up clients when typing an estimate OR be able to add a new client via the same fields. Secondly, when the Form is review the autofill text field display the clients details.

The link : [URL] ....

View 3 Replies View Related

Forms :: Autofill A Textbox With Current Date

Apr 7, 2015

Short version: I would like to know when that formula was filled out.

Long version: What I need to do is Auto-fill a textbox with the current date and time when I fill-in a combo-box and press enter/tab. Each date needs to be individual, once the date is filled in via event it should not be changed, then the next page of the formula needs to have an individual date...and so forth. In addition it would be nice if the date could not be changed at all, so no one can temper with it, for instance pressing enter again on the combo-box.

Something like this:
Formula page 1:
Name:________ Date:________
Name: Jon_____ Date:________
*press enter*
Name: Jon_____ Date: 08.04.2015; 11:31
*press enter*
Formula page 2:
Name:________ Date:________
Name: Jess_____ Date:________
*press enter*
Name: Jess_____ Date: 12.04.2015; 16:12
*press enter*

Solved all but 1 problem, I just need to find a way to stop the Date field from updating every time I update the Name field after the initial date is filled in.

View 8 Replies View Related

Forms :: Autofill Unit Price In TblOrderDetails From TblProducts?

May 24, 2013

This is a Customer Orders database created in Access 2010.

tblProducts has field UnitPrice.

I want the unit price to auto-fill based on product in tblOrderDetails.

Seems simple enough, but I can't figure it out. I don't know VB other than inserting code someone else has created. Need to be able to do within Access.

I've researched this and found many databases of this sort that has the Unit Price in the Products table but you still have to input the Unit Price when adding an order. If you have to manually enter the Unit Price on an order, what is the point in having it in the Products table?

View 2 Replies View Related

Forms :: Autofill Multiple Rows From One Subform To Second Subgroup

Jul 1, 2014

So I have a master form, with multiple subforms on different tabs within the master form. This form is not used to look up data, just to only enter data in. In one of the tabs, I have a subform in the form of a data table where the person filling it in can put multiple locations of one dealership. In the next tab, I want these loctions to autofill into the next subform on the second tab in the data sheet. If I were to go with the solution of using an unbound textbox on the parent/master form to refernece the first subform and then have the second subform reference the textbox, how would I go about doing this? Just with the expression builder and conrol source? Am I able to autofill multiple rows of data from one subform to the other for one recond?

View 6 Replies View Related

Forms :: Change Button Color After Data Change

Apr 5, 2014

I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form

2346 location warehouse price 29.99 (button - green)
2347 location shop price 29.99 (button - red)

View 1 Replies View Related

Create Check Boxes/Option Buttons/Option Group Using VBA

Mar 14, 2008

I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.

Could someone help on either all of them or some of them please?

Thanks

Richard

View 2 Replies View Related

Blank Option (radio) Buttons In Option Group

Aug 18, 2006

I am using an Access database for a foreign language dictionary project.

One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.

This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.

The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.

When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)

Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!

Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True

And this for the Lost Focus event
Me.FilterOn = False

Thanks for the help.

View 3 Replies View Related

Select Option Group Option Based On Checkbox Value

Aug 22, 2005

Hi

I've got an Option Group with 3 options; Yes, No and Future.

I also have a range of Check Boxes; 1 for every day of the week.

When one of the check boxes is selected I want the Option Group to change to Yes.

Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed.

Any help will be greatly appreciated!

Cheers

View 2 Replies View Related

Option Of Two Sub Forms

Jun 20, 2005

Hello...
I am a newie to the forum... but like the system.

I was wondering if anyone can provide either some tips or sample of how to set up a form that give you the option of linking it to one of two forms.

Say the Main Form = General Plant Description
Sub Form One is for Info on Tractors
Sub Form Two is for Info on Trucks.

On the main form you select an option to show one of the subforms.

I have spent about 1.5 hrs trying to search the forum and so far havent found specific advice on this issue.

Thanks in advance.

Dave P

View 4 Replies View Related







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