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 RepliesThis 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 RelatedI 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 RelatedI 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.
Is there another field that can be used beside the lookup field in an Access table? I am currently using the lookup field as a multivalued lookup field and I am limited to the the things I can do with it when creating a report or a query on that field. Is there a similar field in Access 2010 that has the same look as a lookup field and allows for multiple values to be selected?
View 4 Replies View RelatedHi there, really simple question
I just wanted to know if I could edit the access interface so that the access help options would not be displayed, but I can add a link to my own created HTML help files for the system I have created. Is it possible?
my departments seems to want to add some sort of notification feature to our database. It's supposed to notify the department when a certain date is approaching.
How do you even begin to think about adding this feature into Access? I don't know where to start. I'm no Access guru. :confused:
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
Hello folks first post here. I tried reading through the boards to find someone with a similiar question, but not luck yet. I have been working with a basics of Access for about a year. I did take take a bit of programming in college but I don't remember much of it, so I looking for a little help. I can usually Google for answers but I cannot seem to find the write key words this time.
A while back I created a table that tracks employees' data and recently I started working with the insurance data I have gathering for sometime.
It goes something like
Field Name Data Type
SS# Number (primary key)
Insurance $ Number
PPO YES/NO
HMO YES/NO
Self YES/NO
Spouse YESNO
Children YES/NO
Family YES/NO
Dental Self YES/NO
Dental Spouse.......etc.
What I'm trying to do is turn the yes/no's into total dollars for each person. I have done this in Excel but the fields were differnet and I had to use a many, many if.'s or a lookup table(data array)
PPO doesn't = a dollar amount by itself, but PPO + Self = $19.03 or PPO + Self + Dental Self = $23.00. Or the person can just have Dental Spouse = 8.86. Pretty much the people can take a piece and leave another.
"Insurance $" is another field name and is where I am trying to get the total to go.
I was thinking of a lookup table but I don't know how to do that in outside of Excel.
I am thankful for any help or even a nudge in the right direction.
~Profector
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
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?
I have a data base in access 2007, and I'm trying to add into my code one option that includes in the CC: field contacts that I already have in my DB.
This is my code:
Dim rs As Recordset
Dim vRecipientList As String
Dim vMsg As String
Dim vSubject As String
[Code] ......
We have a query that calculates the cost total of three different types of costs between three different parameters. I now need to run a query that prompts the user for the days currency conversion rate to create a new report. I don't want to permanently convert the original fields, it is purely a monthly report where when the report is run is shows both British £ and USD.
View 3 Replies View RelatedI have two tables called "tblFundingBodies" and "tblGrants". I have a form that allows me to view all the records for each of the funding bodies. By this I mean, it shows information on a funding body but to see information on the next funding body, I must click on the next record button. Just wanted to clarify that it isn't in the form of a table.
This form also has a subform in the same format that shows each of the grants that funding body has provided. When I select the next record from the main form, it will show me the grants from the company in the next record. The field that has the funding body is a text box.
I want to be able to add a seach facility to the main form that allows me to search for a funding body and get back exactly what I have described above, but just the details on that funding body/grants. In other words, I want the form view of the funding body I search for with the sub form of the grants from that funding body, not in the form of a table where you can see them all at once, I want to be able to click through each grant in the sub form.
I have made a few lookup tables in the database I'm working on using the lookup wizard and entering the text I want in them. I made a form and they come over fine on them.
My question is that I thought that there was a way when you entered something other than was in that field it would automatically add it to that list and you could just select it next time instead of typing it in again. Is that possible or am I thinking of something else.
In the tutorial listed here: [URL]....
It states after opening the database in Datasheet view :
In the Navigation pane, double-click the table in which you want to create the lookup column - this opens the table in datasheet view.
On the Datasheet tab, in the Fields & Columns group, click the lookup column.
And it show you some icons.
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
In Excel, I can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.
It might have something to do with design view i guess.
First time user out here and I thought I already posted this question but cannot see where.
I have a form I created (called Employee) that has a subform in it (called voucher) which has a subform in (called aduitee).
When I am in the auditee subform I need to indicate from a list of over 1,800 records (table called companies) who the auditor audited that month....which could be one of several from the list.
Not sure how to do this in my auditee subform....I've not worked with this before, can anyone walk me through this once?
I have a people table for all the people .I set a query to select only those that are Family Navigator Mentors ID,FName,LName..I use this query for a lookup on the family navigator table to select a mentor on the form I want the ID FName and LName to show up not just the ID.????
View 9 Replies View RelatedI have a query which looks up records from a table, now what I would like to do is append the word All Projects to this query - is it possible, and if so how?
View 7 Replies View Relatedhow 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
As one is typing in a field with a lookup wizard - dropdown list - is there anyway to see the list without clicking on the down arrow? Perhaps there is a choice somewhere in the program where dropdown menus for the lookup wizard can be made visible?
View 3 Replies View RelatedI have got a a form storing all employee's information and on that form I have a lookup field which looks up all the records in the "Qualification table" and the user can select multple qualifications. What I want to add to the lookup field is a data box so you can select a qualification and then enter the date that it expires (different for expiry date for each employee) How do I do this?
I have added the date field to the qualification table but when I create the lookup field on the form it shows the qualifications and a blank column next to it which data can't be enteed into.
I have a table with some combo selections with row source No;Yes, bound column 1, column count 1, and default value "No", limit to list set to yes, required = yes, allow zero length = no.
When I create a new record though, all of the combos show 0, and I have to select No or Yes manually. The requirement is that No is the default value..
Lots of thanks in advance,
Aidan
I've managed to use the lookup wizard to show me two fields in the drop down list, first name and last name, but when i select a record I can only see the first name in the cell, not both.
Is there a way to display them both together?