i just to know how to list the all data at subform that same thing that i selected at combobox..
ok for example..
i want to list all car part that purchased in nov 2005 at subform...
date(nov 2005) selected from combo box...
then if i change other date (ex: dec 2005) it update n view new parts..
is there need some coding at macros?
plz help me im new with access... :confused:
My database is centered on a main form where users select pieces of information from ComboBoxes (primarily) and submit.
The first part of the form, they must choose from a list of our clients, which is a table with with roughly 5000 rows.
Later on in the form, they must choose a contact person from that client. While Client's may have several contact names (which need to be stored in a table), only one name is necessary for the form portion.
How can I make this Contact Person ComboBox only load names attached to the specific Client selected above?
As it stands right now, the Client List has its own table (along with additional information), and Contact Name is a separate Table with a look up field of Client List.
I have a database that is used to generate quotations. I have a form that I want to use to Re-Quote something. By Re-Quote, I mean I want the employee to be able to go in and search for the Part desired for Re-Quoting and create a new quotation with all of the information from that part and have the ability to change any of the information as needed. The Form is unbound, and has tab control with three tabs. I would like to search by three different categories "QuotationNumber", "Customer", Or "PartNumber". How do I have the combobox filter the list box below based on what is being typed in the combobox?
View 6 Replies View RelatedI am still trying to get a hang of development in access 2010.
I would like to design a form with a listbox or a combobox which holds all 8 of my reports (a table has all the reports), with a Print and a Preview view buttons. In addition, the user must be able to select if they want to view the report by month, quarter and the year in question.
How do i have a specific report print or previewed based on the value selected in the listbox or combobox and the date criteria.
I am creating an Access program for logging in Parcels that are delivered and I am having some problems.
I have a Table called 'Contacts' and within this there are 4 Columns: 'Names', 'Departments', 'Extensions' and 'Emails'.
I also have a Form and there is 1 Combobox and 3 Textboxes relating to this Table: 'Addressed To', 'Department', 'Ext Number' & 'Email'. (see http://c0ld.homeip.net/parcel_log.jpg for details).
What I would like to do is select the Name from the Combobox (Addressed To) and the have the other Textboxes (Department, Ext Number & Email) get auto-filled with the corresponding data that’s within the Table for that Name.
If anyone would like the .mdb for this, please PM me.
Thanks for your help in advance.
Ross Hurrell
I'm building a new db for tracking tests/results, using Access 2007.
On this issue, I'm working with 2 tables, Sample and Equipment.
On a form to enter sample info, I have a combo box to select a piece of equipment.
When the equipment is selected, I need to have a sub-form populate with several fields of data from the equipment table, based on the equipment selected.
I'm not trying to save the equipment data again, I just need to display it, based on the equipment the user selects. This is just a kind of second check to remind the user what the equipment he's selected will do.
I have a Table with 57 fields. I would like to display this table in a form as a subform, but only certain fields depending on what selection is made in a combo box.
For instance, if the user selects "Missing Information" in the Combo Box, then the form will show a few standard fields such as ID, Market, Sales Manager, and then some specific ones such as date missing information requested and date missing information received.
If the user selects another option, again the standard fields will remain plus a few different ones.
I have done much searching on this and feel like I am so close but so far. I have looked into controlling the record source of the subform, columhidden =false and a multitude of others. All of which may or in fact probably do work in this situation but I can't seem to put it all together.
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?
I have 2 comboboxes, the first one is called "activity", whereby I have 3 options to choose from, and the second is called "level".
When I click an "activity", for example Drawings, I want the "level" combobox to list a unique set of options for that category. and if I click on a different "activity" for example Planning, I want the "level" combobox to show a completely different set of options.
If anyone can give me any help on how to do this then I would be very grateful!!
Thanks
Angela :eek:
Microsoft Access 2003
Novice and working on a project with deadline... please help.
I have a table w a field that I want to convert into a combo bo and use data in the field as the options:
FIELD: Student Status
OPTIONS:
Enrolled
Suspended
Withdrawn
How do I get the combo box to automatically pull the values from that field into the options in the field when u pull down the drop down box?
Am I being clear?
I have a list box with a row source query as follows...
SELECT qryPendingCompletions2.ID, qryPendingCompletions2.Department, qryPendingCompletions2.[Employee Name], qryPendingCompletions2.CompletionDate AS [Completion Date], qryPendingCompletions2.[Entered By], qryPendingCompletions2.Goal, qryPendingCompletions2.Comments, qryPendingCompletions2.[Verified By]
FROM qryPendingCompletions2
WHERE (((qryPendingCompletions2.Department)=[cbocurrentemployee].[column](3)) AND ((qryPendingCompletions2.[Verified By]) Is Null))
ORDER BY qryPendingCompletions2.Department;
I also have a combo box at the top of the form showing what user is logged in where the row source query is the following...
SELECT Employees.UserID, [First Name] & " " & [Last Name] AS EFullname, Employees.AccessLevelID, Employees.Department
FROM Employees
WHERE (((Employees.AccessLevelID)=1 Or (Employees.AccessLevelID)=2 Or (Employees.AccessLevelID)=3 Or (Employees.AccessLevelID)=4));
How to only list the data in the list box when the department is the same as the logged in user.
So I'd like to add the criteria to the first query something like criteria = [cbocurrentemployee].[column](3) but this doesn't seem to work as criteria in queries.
I've tried searching the forums and haven't found quite what i'm looking for. I would like to be able to change the source for a combobox based on another combobox. The simplest way i can summarize that is i want to be able to choose A or B, depending on my choice i want another combobox to display all the values that A or B can have.
Thanks
Jim
I'm not sure I worded that very well. :(
Hi,
I am quite a newby to Ms Access but have had a real 'stab' at this ..... but I have hit a wall !
I have the following query which forms the basis of a subform.
I use it to select and recall records via Text box (ClientID) on a form (frmMainForm). ClientID is the Primary Key
SELECT tblClientDetails.ClientID, tblClientDetails.Title, tblClientDetails.FirstName, tblClientDetails.LastName, tblClientDetails.HouseNameNumber, tblClientDetails.Street, tblClientDetails.Town, tblClientDetails.County, tblClientDetails.Postcode, tblClientDetails.RegisterDate, tblClientType.Purchaser, tblClientType.Vendor
FROM tblClientDetails INNER JOIN tblClientType ON tblClientDetails.ClientID=tblClientType.ClientID
WHERE (((tblClientDetails.ClientID)=forms!frmMainForm!Cl ientID));
If I also wanted to search by (as well as ClientID);
LastName
Postcode
How would I change the SQL ? I think I need some Is Null statements but cannot figure out how.
I would like to able to narrow down on the required record by using a combination of the above parameters (LastName, Postcode, ClientID) in this query.
For example, LastName "Smith" is popular, but teamed with Postcode should result in just on record being returned ?
Finally, can I ask you experts, is this the best way of tackling this issue ?
Many thanks for any help or pointers.
This is a bit of a weird one.
I have a combo box in a subform that has a hyperlink to open another form which in the on click event of the hyperlinked form saves the new information and should then update the combo box in the original subform.
i figured i would use a requery to accomplish this. Using the syntax
Forms!Student!sfrmDDS_Classes_add.form.requery
This doesn't error out, but it defenitely doesn't update the combo box within the subform.
Any suggestions
I am trying to use an unbound subform based on a query to display only records for a specific date. The query works fine on its own, but the subform returns a blank.
I am using the Calendar control on the same form for the user to select the date they wish to view. This in turn inserts the selected date from the calendar into a textbox on the main form and the query that the subform is based on reads this and opens the corresponding records.
Problem, its not working.
Thank you in advance if you can help me throw some light on this one.
Hi,
I need to click a command button that placed on sub form while being on Main form. In other words if I clicks a command button on the main form, at the same time another command button on the sub form should be clicked. This is to take some actions.
I know the way like this "CmdSave_Click" but when I am on any of the form.
How about if I am on main form and need to click command button on subform?
Regards,
Ashfaque
how do i make 2nd combobox list based on 1st combobox list, mean if i choose A at 1st combobox, only A1-A5 option appear, and when i select B at 1st combobox, only B1-B8 appear to select at 2nd combobox..
TQ
I have a form with a subform in datasheet view with a combobox on it. When a user presses the Arrow to dropdown the menu it will stick on the screen after they leave the field. Any idea's?
View 3 Replies View RelatedI want to have a combobox in a report ,
In a report using a query with a field named: "plantno" and as criteria" :Like [Fill in the plantno]
I can put in a plantno.That is working Oke!
I want to do the same thing as above but then that i want to see
a combobox with a few plantno,s which are put in a valuelist,so that i dont have to type in plantno,s
but that i only can choose out a valuelist.
Who can help me?
Is it possible to alter the values displayed in a combo-box dropdown at run time. I tried using the following bit of code in a listbox's 'After Update' event , but it does not alter the combo-box's value list.
dim strSponProjStatus as string
dim StrNonSponProjStatus as string
strSponProjStatus = "Seed ; Growth; Consolidation; Phase Out; Closed"
StrNonSponProjStatus = "Under Nego;Funded;Part Funded;Suspended;Unfunded"
Me.cboProjectStatus.RowSourceType = "valuelist"
If Me.cboFundingSource = "Sponsorship-ADP" Then
Me.cboProjectStatus.RowSource = strSponProjStatus
Else
Me.cboProjectStatus.RowSource = StrNonSponProjStatus
End If
Any suggestions as to why this is not working?
Cheers :eek:
Hi guys
Just wondering how could a make a listbox or combobox to have the names of all or some of the tables that are currently in my database
I only know how to get the values from a table or query in RowSource using SQL language... but how can I display the names of the tables
Thanks in advance for the help.. I really appreciate it
(I'm upgrading an old database)
I have a combobox who lists te values of a table.
In that table are say: 5 records filled with a,b,c,d,e.
In my form i have a combobox who is default filled with a blank field, but i can select a,b,c,d or e.
If i select nothing in the combobox, the value has to be set at "0"
But i cannot add "0" as a value in de table of the dropdownlist.
if i can get the value default for "0" i'm happy, but if i can display the "0" as default in the combobox, i'm very happy.
Hi,
I have a table of records, with one field of the records a combobox populated by a select query based onanother table.
My problem ism that it doesn't seem to recognise any of the values as on the list, though deleting one character and then replacing it results in the value being accepted with no problems.
This is a database I have inherited (Cheers predecessor!), the table is populated with a few thousand records and scrolling through this table results in an error message on this field for every record and is making displaying data on this form a nightmare! Anyone know of the cause or of a quick fix?
I don't know the history of this table unfortunately.
Cheers in advance
John
I have a form and I need a combobox on the form to produce a list of Dates for every Saturday starting from the current day displayed in a short format for the user to select. Does anyone have an idea how I could manage that?
I was going to make a table and write in each one and use that for the rowsource, but someone said that there might be a way to do that dynamically.
When you use a combobox to search values in the form - and someone searches for a value that isn't there - the form just defaults to the first entry. Is there a way of putting a message box that says "This is a new patient" (or something like that). The NotInList event doesn't work - any ideas??
View 2 Replies View RelatedI currently use this code to trigger a not in list event, ask the user if they want to add it to the respective table, and then add it.
I'd like to be able to add the text in the combo box that triggers the event to show up in the msgbox.
Private Sub cboCategory_NotInList(NewData As String, Response As Integer)
Const Message1 = "The data you have entered " & me.cbocategory.text &" is not in the current dataset."
Const Message2 = "Add now?"
Const Title = "Unknown entry in CATEGORY Field..."
Const NL = vbCrLf & vbCrLf
[Code] ....