Is there a way to make a field on a form dependent on what the user selects from 2 other cbo? By that I mean I would want the user if they selected in cbo1 Easter and they select cbo2 Regional President in the form field I would want it to auto return the name John Smith because in my table he is the Eastern Regional President. I am not sure if I can do this by query or is there an easy way to do this?
View RepliesI have a table called welding, I want to create a user friendly form for input. The database ultimately wants to go on share point so I am building it in the web database option.
One of the fields is called location, if the location is 'Field' I want 10 more fields to appear for data entry such as weld reason, rail temperature etc . If the location is 'Depot' I want these fields to be hidden as they aren't relevant.how would I do this?
Hi,
I've got a data entry form where orders can be created. Within this form there is a ComboBox which is used to search for items and stores the selected item ID in the Order table. However the field for storing the Unit Price relating to the selected item is currently manually enterable. Where as I would like this to be dependent on the item selected within the ComboBox and updated automatically.
At the moment I've added an extra colum to the ComboBox to retrieve the relevant Unit Price and I can show this in a normal seperate text box using '=Combo27.Column(1)' as the ControlSource.
How can I get rid of the text box and incorporate the code into the current UnitPrice field so as it inserts the relevant record (price) into the UnitPrice coloumn of the Order table?
Any help on this would be much appreciated!
I there a way to determine whether or not my checkbox within a form is ticked or not dependent on another value within a field?
I have a field called 'DaysRemaining' and another check box field called 'Expired'. I want the expired checkbox to be ticked if the value within 'DaysRemaining' is '<0' and unticked if '>=0'. Is there a way i can do this within the control source of my check box?
I want to create a different rowsource-query for a lookup field (field1) in each record in a subform. The rowsource changes dependent on the value in another field (field2) in the same record. How can this be done?
- I tried to change the rowsource-query in an eventmacro when the focus is set to field1, but this ofcourse changes the rowsource for all field1's and makes the allready selected values unvisible.
- I think I have to include the value of record 'field2' in the rowsource query, but i cannot find a way to include that value in the query.
Something like:
Lookup field1 in the subform contains this rowsource
- SELECT CUSTOMER.Id, CUSTOMER.AGE, CUSTOMER.NAME
FROM CUSTOMERS
WHERE (CUSTOMER.AGE= me![field2]);
me![field2] however does not function
I am trying to put in a validation rule so that data in one field cannot be less than that in another.
e.g. i want to make a validation rule so that a phone call end time cannot be before the phone call start time.
Can anyone help???
If I have a Form that is used to populate a Table can I make one field entry dependent upon another?
For example, if I have a field for Discipline (with values such as Mechanical, Electrical, Piping) and another field for Equipment Type (with values such as Motor, Gearbox, etc) can I set up the Form so that when I select Electrical for the Discipline, only electrical items (such as Motor) are available to select for the Equipment Type field?
Using the table below as an example, if I select Electrical for the Discipline field in my Form, when I go to select a value for the Equipment Type field the drop down shows only Motor and Fan?
Discipline
Equipment Type
Electrical
Motor
Electrical
Fan
Mechanical
Gearbox
Mechanical
Pump
Piping
DN 150 Pipe
Or, better still, can I set it up so that if I select Motor for the Equipment Type field, the Discipline field will automatically be populated with Electrical?
I would like to display the value of a field [Name] based on the value of another field in the same Table [Position] in a report. My goal is to have a visual representation of data that changes based on the changes to the value of the [Position] field.
View 3 Replies View RelatedHi. I'm unable to work out how to set up a query which will filter records according to what is returned by one control, but will also list all records if the value of the control is null.
Situation: I have a CONSULTATION table linked many to many via a CONSULTATIONLIST relation table to an ADVISOR table. (An Advisor may be present in any number of Consultations, and a Consultation may include any number of Advisors.)
I have a CONSULTATIONMANAGE form enabling the user to select an Advisor from the table ADVISOR via a combo box called SELECTADVISOR which returns Advisor ID (adID).
My CONSULTATION form, displaying the list of consultation records, currently has, as record source, the following query:
SELECT Consultation.*, Advisor.adID
FROM Consultation INNER JOIN (Advisor INNER JOIN ConAdList ON Advisor.adID = ConAdList.adID) ON Consultation.conID = ConAdList.conID
WHERE (((Advisor.adID)=[Forms]![ConsultationManage]![selectadvisor]));
This query correctly lists only those Consultations in which the selected Advisor was present.
Problem: What I also need to do is show ALL Consultation records if the user does not select an Advisor from the combo box.
Any help would be much appreciated.
Mat.
so i'm trying to create a report that only displays certain fields per record based on another field in that record. To clarify: [Type] is a numeric field holding either 1, 2, or 3. I have a function that is instructed to display (ie, change from not visible to visible) a certain combination of fields depending on the number in [Type] when the form is opened. I assume I would have to go through all the records individually (do loop until), but i'm not sure if this works in a report.
is there any way to have different fields displayed for different records within the same report??
Thanks
-Jason
Is it possible to use date dependent field names in a query?
I have this table and there are columns based on year and month (formate of names is: 2014,01) I need to select the columns of last month and then 4 months further down in history.
Is there a way to do that as the information in those columns I need to make calculations and graphs with.
I am attempting to open a website hyperlink, some of the fields contain https:// and some of them dont.
Code:
Private Sub Facebookbut_Click()
Dim Hyper As String
If InStr([TEAMFacebook], "https") Then
Hyper = Me.TEAMFacebook
Else
Hyper = ("https://www.facebook.com/" & Me.TEAMFacebook)
End If
Application.FollowHyperlink Hyper
End Sub
So far this does 2 things, it doesn't open any hyperlinks at all and continues to attempt to until the program is closed from task manager. Before I had this error it would open the hyperlink twice if the field does not contain "https" and the IF statement was passed to the 2nd option.
I have a database of purchase orders
Many of the purchase orders have a revision No against them, eg:-
Purchase Order No / Line No / Revision No / Value
1001 / 001 / 00 / £50
1001 / 001 / 01 / £100
1001 / 001 / 02 / £200
I am trying to find a way to write a query that will show me the actual value of the final revised value of each Purchase order line ie: the answer to above is
1001 / 001 / 02 / £200
Could anyone please help?
Access 2003
Database for tracking job search/applications
I have three tables: Job (includes employer, contact) and Contact (First name, Last name, employer), and Employer (Employer name)
Form.Job is the main data entry mechanism. On this form, I enter the job details. I select the employer from a combo-box that draws from the Employer table. I would like to select the contact from a combo-box that filters contacts and shows only those that match the Job.Employer selection.
:confused: 1. How can I make a bi-directional link so that a new entry in the employer combo-box creates a new entry in the employer table? At the moment, I get around this with a "New employer" button on Form.Job that just opens up the employer table, but there seems to be an updating issue - new names don't show up in the combo-box for a while
:confused: 2. How can I get the contact combo-box to show only contacts with an employer that matches the employer selected in the employer combo-box?
Note that I got this to work once by using a sub-form, but I don't really understand how (presumably Access defaults that did what I wanted), and I don't want to have to use a sub-form.
Ben
I am attempting to create a customized task manager. I have created a form that has a combo box that list a series of categories. This list is pulled from a query. I also have a sub-category list that is pulled from a separate query. The relevant section of the subcategory query looks like this:
CategoriesID / subCateogiesID
1 / 1
1 / 2
1 / 3
2 / 4
2 / 5
2 / 6
3 / 7
The query has a criteria that sources the combo box on the task creator form. This filters out all other primary categories. I have a macro that auto refreshes the page after the primary category combo box is updated. The sub category combo box then displays the related sub categories.This works great as a stand alone form. However, when I attempt to use a navigation form or use the tab navigation window I get the error message "Enter Parameter Value." I know am getting this message, because the related categories query is looking for a category in the combo box on the form, which at this point in the process is missing. It also does not update once it is moved to a navigation form or tabbed window.
hi..
i have to comboboxes in my form. one lists section names, and one lists all staffnames.
how do make the second combo displays only names of staff from a particular section depending on the first combo?
thanks in advance
I have 3 tables:
tblFunctionalArea
FAID, FAName, Active(y/n)
tblSubFunctionalArea
SubFAID, SubFAname, Active(y/n)
tblLinkFAwithSubFA
FAID, SubFAID
What I need is all possible Functional Areas listed on a form where you can click on active checkbox to activate that Functional Area.
Then on the next form I need Sub-functional Areas listed, but only those that tie back to Functional Areas that have been activated.
Is this at all possible to achieve? I really don’t know how to go about doing this. Do I need a form, or may be I need a subform? I'm at a loss.
Any help would be greatly appreciated.
Thank you.
I have a table with 3 yes/no fields. I need them to be dependent on each other meaning if one is yes the others can not be yes. How can I set this up?
View 5 Replies View RelatedI have a form that has two listboxes. The first list box is named "lstType", which pulls in information from a table tblType. The second or dependent listbox, named lstSName, is then filtered and only shows the SName that match the type. This is pulled in from a table "tblSName." Using the form filtering on the query "[Forms]![frmqryTask]![lstType]"
This portion actually works perfectly and filter my form as I wanted it too (at least originally). However, I realized a few days ago that the when clients or the SName does not have any active projects my company will be working on for them, we don't want don't need to see their name on the forms listbox called "lstSNameand", so we want change a status from "Active" to "Inactive". I've already added this status in as well.
What I'd like to have happen is that when using the dependent listbox, the lstSName will only show those with the "Active" status. I've tried adding the status = active onto the query, however I get a error message saying the query is too complex to run, which I'm guessing has something to do with the "[Forms]![frmqryTask]![lstType]" on the query.
I have a form in which you can select a year from a combo box in a subform. I want to create a query to be a subform which uses that combo box to select the year between 1/1/Year and 1/31/Year OR between 12/1/Year and 12/31/Year. The year combo box is in the sub form called YearSubForm and is called Yearcmb. I used Between #01-01-2010# And #01-31-2010# Or Between #12-01-2010# And #12-31-2010# in the query view as a criteria when I wanted 2010, but I want the year from the combo box.
Also, in the form I have a subform that is located on top of a text box. I was wondering how I can have the text box show over the subform. I tried 'send to front' but that did not work.
See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent
In the main form needs to select one customer, only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) ..
I do not succeed despite several attempts with macros to achieve this.
Example11.zip
Hi all,
This is my first time posting at Access World Forums and I hope you can help me out.
I think this is a fairly simple problem but due to my lack of experience (this is actually my first time using Access) I am unable to figure out what is wrong.
I have a entry form for a series of problems that needs to be documented on the plant floor.
The issue is in the 'Manual_Entry_Rewinder_Detail' form where I have two drop-downs -one for the category of which the problem lies and another drop-down for the actual problem itself. I have made (or tried to at least) make the problem drop-down dependent to the category drop-down. The purpose is to list only the relevant problems after the category is selected.
I have made a category ID of which I labelled for each problem. This of course corresponds correctly to the actual (an existing) category ID. Please take a look at the two tables: "Problem" and "Category" for details.
I followed this tutorial http://www.blueclaw-db.com/download/dependent_combo_box.htm .
I even downloaded and inspected their sample database with no idea on what is wrong with my own.
Please help!
I have 2 combo boxes on a datasheet.
combo 2 is depedent on comboxbox 1.
But when i work on futhter and click other occurenses, the values change (because of the query looking at the first combobox)
this is very annoying.
can someone pleeeeease help,
ive been trying for 2 days now
thanks
Joost
Hi all,
i am fairly new to the use of VB so (1) I am not sure if this is possible and (2) i wouldn't know where to start really so any help is greatly appreciated. I guess that in order to achieve whet i eventually want to (assuming it is possible that is) will be based on using some element of DateDiff. I have searched the forum and whilst i now have a basic understanding of the DateDiff function, i could find nothing that would help solve my problem.
On my form - which is a continuous Form displaying a number of the same type of records - i have a number of fields including InvoiceDate and TaxInvoiceDate. What i have been trying to achieve is the following:
1. Should the number of days since the InvoiceDate and the current date exceeds a certain i would like to format the InvoiceDate field, for example, if more than 30 days but less then 45 days have elapsed then the field could be this and if greater than 45 days then this. This indicates overdue accounts, with me so far? This i have managed to implement this using Conditional Formatting.
2. However, if a date is included in the Tax Invoice Date (meaning that the account has been settled / paid) i want to return / leave the text normal colour / font. This second point i guess will not be achievable when using conditional Formatting?
So, i believe that in order to achieve both points i need to use VB? If so, can anybody help me by suggesting suitable coding and where on the form / fields this code should go.
(Grovel Time) I should add that it only recently that i started using Access and developing my own databases but i have learn't so much from this forum - who knows sometime in the future i may also be able to partake by answering queries myself;)
Regards
Alan
Hello All -
I think that my problem is best explained by an example.
In the first field the user chooses between two options for the reporter.
Field 1 - Reporter: Client OR Employee
If the user selects "Client" they have to enter an address, if they select "Employee" they don't have to enter an address.
So, what I hope is to create a form where if they select the "Employee" the address fields (address, city, state, zip) "gray out" and not accept any data entry.
Any help would be SO appreciated!
Thanks -
Amy
See the Main form of attached file, I would like to see contacts list box is made from drop-down list Customers. dependent
In the main form needs to select one customer (for example: Klant1), only the contacts 'de Vries' and 'Van der Linden' can be selected in the combo box of contact (in the main form) .. I do not succeed despite several attempts with macros to achieve this.