Mutiple Option List On Form

Jun 21, 2006

Hi,

I have the following say;

tblProducts:
Name
Categories
Price

tblCategories:
Name
IDNumber

at the moment, no relationships built

tblProducts "categories" requires the IDNumbers of the categories in tblCategories - there are mutiple IDNumbers for each product, and they need to be seperated by a comma - for example ProductA has categoryIDs 1,3,6 (where categories 1,3,6 and called A,C,F)

At the moment, I am having to manually look up what each categoryID number is by CategoryName, and then type it in the tblProducts category field.

I want to have a form which provides the tblProduct "Name" and then a long list of all the tblCategory "Name" contents as option (or tick) boxes. So all cateory Names listed.

Then when I tick mutiple boxes on this form for the categories, it populates the tblProduct "Categories" field with the tblCategories "IDNumber" codes, with a comma between each one! (so the names chosen actually populates with the ID number)

So basically if on my form, ProductA has category A,C,F ticked -- so the field tblProduct "Categories" is "1,3,6" (where 1,3,6 are the category IDNumbers and A,C,F are category names)

In other words, I want to be able to choose the categories for my products by choosing the Category Name (rather than ID) but having the ID populated into the relevant field -- I can do this with a combo box displaying a different field to that thats populated....but this only allows one selection....

I want mutiple categories to be chosen (via the form with option/tix boxes), and thus to populate the relevant field with commas seperating.

Is this last bit possible?!!

How!

thanks in advance
rob

View Replies


ADVERTISEMENT

Forms :: Data Entry Form - Drop Down List With Free Text Option

Aug 6, 2013

I have a simple data entry form with drop down facilities on 2 fields. One of these fields incorporates a drop down list from a table but there are occasions when I wish to make a free text entry for the single record, but do not wish to add it to the drop down list.

I have tried to achieve this with a Combo Box but without success, although I am sure that I have read that it is possible.

View 14 Replies View Related

Forms :: Open Form From (Edit List Items) Option In Data Entry Mode

Feb 4, 2014

I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin "allow edit list items" feature of Access 2007 but the form always opens on the first record of the form on which they are to add the new item. Is there a way to specify that it should open in Data Entry view apart from using VBA?

View 4 Replies View Related

List Box Help. Is It The Best Option?

Oct 4, 2005

Some background: I posted last week seeking help starting my first access project. I am trying to create a database that will allow me to enter every employee in our company along with their foreign language skills (and other skills) that they have.

Then I want to be able to create a form that will allow me to search for all the employees that have a certain skill combination (or better) that I am looking for.

Thanks to a lot of help from this form I was able to make a lot of progress.

I have three tables. One table with employee name and number, one for language/skill and language/skill number and a junction table that I want to query.

But now I am stuck on what I believe is the final step; Creating the form control that will query my junction table.

Can someone get me started on how exactly I can implement this? Is a List Box my best option?
Do I have to code it in SQL? How do I do this? Any beginner tutorials online? I couldn't find any.

I had a combo box that allowed me to search for ONE language/skill and that worked fine but I need to be able to search for employees that have combinations. Do I need a List Box for this?

Because I will in the end have about 20 languages+skills in the list I was hoping to use checkboxes on a form.
In this way I could just check next to all the skills I want, hit the control button and it would return everyone that met the requirment + anyone that exceeded the requirement. This seems better than a long list box with 20+ options.

Any ideas? I will attach my project and would appreciate help.

Thanks!
Rush

View 2 Replies View Related

Help Needed To Add 'ALL Option' To List Box

Oct 29, 2007

Can anyone point me to where I might get help setting the above up. I have a list of unique enties in a query, and have set up a global variable so that on my form when I choose an option from the list only data relating to that option is pulled back from a number of tables/queries and output on a report. I would like to be able to get the data for my full list of options. I'm afraid I'm lost here. I don't know of any way of setting my variable to 'ALL'. Is this available in Access 2000? I have Access 2002 at home but I need to work on a PC that only has Access 2000, so I have kept it as a 2000 database. All help appreciated.

rgs
Ginny

View 9 Replies View Related

List Box With NULL Option?

Dec 29, 2014

I have a table for holding client responses to a questionnaire. 10 of the fields in this table are List Boxes with options "Yes", "No", and "Blank/Other". The "Blank/Other" option is supposed to be reserved for forms handed in where the field has been intentionally left blank. If the form has not been handed in at all, I want the fields to just be NULL. The problem is that if someone accidentally fills out information for a row that should all be NULL, there is no way to correct it. I have tried adding NULL (no quotations) as an option in the list box, but this does not work. I have also tried adding "" as an option, but no luck there either.

How do I add an option in a list box to leave a field NULL?

View 4 Replies View Related

Adding List Option Automatically

Aug 7, 2006

This is probably something already talked about, but if i have a combo box that has an "Add New Entry" selection in it, and when the user clicks on it, i want to add what they want in to the table that the combo box chooses from. can I have that "Add New Entry" selection open a form with a text box, and then have that value enter into the table? What is the easiest way to do this?

View 3 Replies View Related

Adding Text Option In Lookup List

Jul 20, 2013

I was checking if it is possible to add a text option after creating Look Up Tables, and I am also getting extra spaces while creating lookup tables where the drop down list goes more than 100 items.

View 2 Replies View Related

Modules & VBA :: How To Have A Shortcut Option When Right Click On Each Item On List Box

Aug 1, 2013

how I can have a shortcut option when right click on each item on the list box. So I got my answer with below code that opens another form "frmshortcut" with a listbox inside that shows list of options like "new task" , "edit item" . Now my problem is (like attached picture) the shortcut list (frmshortcut) will be open in another place when I right click the mouse, it is far from location of click. Also it shows some default in access when I right click in the listbox ("subform", "cut", "copy"), actually I do not like it shows these, just I like it shows shortcut list I have defined by the list box.

Private Sub ItemList_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Const RIGHTBUTTON = 2 If Button = RIGHTBUTTON Then DoCmd.OpenForm "frmshortcut"
' DoCmd.OpenForm "frmshortcut", acNormal, , , , acDialog
Forms!frmshortcut!txtparameter = Me.ItemList.Value
End If
End Sub

View 1 Replies View Related

Forms :: Single List Box Option To Input Data To Text Box

May 9, 2013

I have a form with a list box on it that has 4 teams (Team1-4)..Below this list box I have a text box:"People on shift tonight"..I want to be able to select a team from the listbox and this prepopulate the people on shift box with the names of the colleagues from the team specified, is there a way to do this?

View 2 Replies View Related

Mutiple Tables Into One

May 16, 2005

I have several tables all with identical fields (just different data). How can I put all those records into one table (or querry?
Thanks!

View 2 Replies View Related

Mutiple Users On Citrix

Mar 23, 2007

thank you all for your help.
i haved searched and i did not find an answer.
i have splitted my database which is on the citrix server and put the b/end on the shared drive and put the front end on my document on the users desktop. my question when one is using the form the other cannt use the same form? why is that?? how can i fix that. i would like users to use the same forms to enter data at the same time.
thank you

View 7 Replies View Related

Mutiple Criteria In DLookup

Apr 30, 2007

I'm back yet again with a new and intriguing set of problems.
I am building a fancy report and Come to find out you cannot use SQL to return one simple number in a text box because even though you know you will write the statement to return only one answer everytime, access doesnt understand that so we can do a domain aggregate thing with DLookup.
OK fine I have to do alot of them but still OK, here is my issue
I can get DLookup to give me what I want if i type into each control source the criteria that I want to return.


I want to lookup a number from a recordset but there are two things that make the number unique date and strain. strain is easy to cough up in the right place because i will hard code that into the control source dlookup, the part that is killing me is the date
I can get a dlookup to give me accurate results based on multiple criteria, but how can i get that to include the date for which I am running this report.
I do enter the date parameter each time i open the report.

Here's what i got so far

=DLookUp("csQuantity","SpawnScheduleCulSpawn","csstrain='AC-PA'" & " AND week = #4-29-07#")

That returns the answer i want, but i have 50 of these text boxes in one report so i cant go through and write the date in each one.

how can i make the part following " AND week =" dynamic so that it runs the date that i entered as the parameter for the report?

Thanks in advance!

View 1 Replies View Related

How Can I Have A Mutiple User That Use 1 Access File?

Aug 30, 2007

I have 3 staffs
how can i make it possible for them to work in a same access file
with same form , query ???

View 2 Replies View Related

How Do I Create Mutiple Choice Questions

Apr 21, 2007

I'm making a project in VB, and I need it to link to a Database,I already know how to do this
the project is a bit like who wants to be a millionaire with all the questions in an access table,
I know I need the following fields;

the auto number
the question
Answer A
answer B
answer C

the problem is I need to be able to select which answer is correct ?

View 1 Replies View Related

Sort By Latest Date With Mutiple IDs

Feb 9, 2006

I'm trying to sort dates by the latest date when the query returns multiple IDs with different results. Ex.
ID1 1/1/2006
1/8/2006
ID2 1/2/2006
1/9/2006

In this example I would want ID1 with the date of 1/8/2006 and ID2 with the date of 1/9/2006 since they are the latest date. I will have many IDs that I need to run a query on that will all return the latest date. TIA

View 1 Replies View Related

Summing Mutiple Items In A Query

Apr 2, 2008

I have a sum query issue I am trying to work out and I have trouble trying to coordinate it.I am trying to build sum queries inside one select query that would allow me to sum point values in a separate table. The problem I am foreseeing is that I have three tables all connected with realationships. The structure with the fields is below:

Table1:
Test Case
Description
...


Table2:
Run
Description
test_case
...

Table3:
Task
Points
Group (Run)
Date1
Date2
Date3
...

Relationships:
Table1.Test_case-->Table2.test_case ( 1-many)
Table2.Run--> Table3.Group ( 1-many)


I want to be able to sum the total amount of points in a test case. Currently I am able to sum the number of points per run by doing a sum query on SUM(Table3.Points) in a select query that queries Table2 and Table3. But I try to do that with select query for Table1 and Table2 the query returns the same sum for all test cases. That sum is equal to the point total for the 1st entry in Table1.
Can I add a criteria somehow to make the sum work for each Test Case entry in Table1?

Also in regards to this same summing issue I spawned a second issue. I wanted to run a sum query on Table3 that would allow me to sum all the entries in that table that had valid entries in the Date1 field. I tried the following criteria.

Not IsNull([Date1])

The query came back with the same output as the above sum query.

What I am trying to accompolish essentially is the to get two sums out of the query. The first sum would be to sum all of the points totals for each Test Case. The other being able to sum point totals based of if a Date1 Field being filled in for each Task.

I am pretty sure I can do this in one query and just manipulate the data in the form of expressions and sum queries.

I am still searching through this forum for valid suggestions. But any thoughts will be welcome.

Thanks in advance.

View 6 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

Parent Form Vanishes When I Tab To Option Group In The Child Form?!

Apr 7, 2006

I have a rather annoying and frustrating problem which I cannot find a solution for through searching the forum.

The situation is that I have a parent form with 1 unbound subform, the source of which is determined by the part number selected in the parent form (diffetrent parts have different fields of the source table displayed)

This all functions perfectly well in all but one case which is when the source of the subform is a form with an option group.

There is only 1 form like this, and the problem I have is that when tabbing through the fields, as soon as I tab into the option group the parent form disappears, and I am left with just the subform on screen! Clicking into the group is fine, just tabbing to it causes the problem, and if I remove the option group then tabbing through all the rest of the fields is fine...

I could powssibly change the option group for a set of option buttons and code them to function a bit like an option group, but this would mean changing the code for numerous reports etc. and I don't really want to do that if I can help it.

View 2 Replies View Related

Include Wildcard Option Within Form

Feb 23, 2006

This may well be a simple question.

I have set up a Form to report Client acitivity by department Code for a given month. Users have the option within the form of selecting a Department Code.

These department codes are derived from a department Code Table and set accordingly within my Row Source properties.

If I wanted to select multiple departments for a particular report. how can i allow for wildcard entries i.e if several department code begin with letters OD*?

Thanks

Paul

View 1 Replies View Related

Filter Form With Option Buttons

Oct 4, 2005

Hi All,

Just wondered if anyone can help me with this.

I have a form based on a query that has 16 options for values in one of the fields. I wanted to put an option button for each value on a form that would allow the user to view the records based on which option buttons were selected and have the form update accordingly.

The way I've gone about it is to have some code in the after_update event thingimy of each option button that updates a boolean value in a table that's linked to the underlying query the form is based on - but this just seems a long way to go about this... plus it's not working...

I've searched the archives for clues on this but haven't come up with anything. So I just wondered, is there a better way than what I'm doing. I'm not after somebody to do this for me, just point me in the right direction.

Many thanks,

Peter

View 3 Replies View Related

Problem With OPtion Control Box In Form

Jan 8, 2006

i have field in my table called SEX and there are two types Male & Female and i added two option boxes in my form and i search one specific record with query now i want this when we run form or navigate through record so as record change so as well two option boxes shld change for example if i navigate to next record and that record have MALE as sex in table so option 1 shld b black doted and when sex is Female then option 2 shld black doted and vise vers. how can i achieve this trhough coding


Thnxxx in Advance
Take Care
ENJOY

View 1 Replies View Related

Search Form With Option Buttons

Oct 18, 2005

Hello,
I have a form named Welcome which I want to use as search menu for my database.
I have added 4 option buttons and a unique textbox into which users will write their query criteria.
My database has 4 queries and each option button should refer to one of them once selected

Obviously I will need a command button that will run the query.

Any help or code to do this? Thanks.

View 1 Replies View Related

Forms :: Option To Open One Or Other Form?

Dec 24, 2014

how to give the option to open either forma or formb with a command button.

View 1 Replies View Related







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