Search results

I have a form where i want to hide some fields unless a certain condition is selected from another field. ie. there is a field called Decision, and in it it has the following values: Suspended Cancelled Approved when the user selects "Suspended" i want the form to display the following fields...

I have two seperate queries base don tables which give the following results.: Meeting_Query (based on meeting table) - Meeting_Date Location Type 11/11/03 Darwin Monthly Meeting 17/12/03 Alice...

I have two seperate queries base don tables which give the following results.: Meeting_Query (based on meeting table) - Meeting_Date Location Type 11/11/03 Darwin Monthly Meeting 17/12/03 Alice...

I copied an example off the web, but when i try to run it, the following errors comes up. Compile Error - cannot find Project or Library I have - Microsoft DAO 3.51 Object Library selected... but it still doesnt work... :confused: :mad:

Im trying to use the on NotInList value to update a table that i have. at the moment im using the onUpdate value of another field to determine the record source of this field (The one that im using the on NotInList value). The code that i have is this: Private Sub...

Im trying to use the on NotInList value to update a table that i have. at the moment im using the onUpdate value of another field to determine the record source of this field (The one that im using the on NotInList value). The code that i have is this: Private Sub...

i have a combo box (cboCity) that changes rowsource depending on a value selected in another combo (cboCountry). ie. tables: Country, City. with values: Country - USA, AUSTRALIA, GERMANY and tables USACity - Boston, NYC AUSTRALIACity - Sydney, Brisbane GERMANYCity - Berlin... now i want to...

I am running a query on a value in a form. and i want the result to be displayed in another field. The query which i have is this: SELECT Premises.[Premises Name] FROM Premises INNER JOIN Meeting_Agenda ON Premises.Premises_Number = Meeting_Agenda.Premises_Name WHERE...

I select a value in Combo1, and it cascades the values in Combo2. however, Combo2, is not refreshed until i close down the form and reopen it again. is there a way of refreshing Combo2, once i make a selection in Combo1? for instance using the OnUpdate event for Combo1. but i dont know what...

i have a combo box which displays 3 values (number, name and subject), and when i select it only the number is displayed, which is what i want (the other info is just to make sure that the user is selecting the right record). the number and the subject values are from the same table, but the...

Im trying to use the Dlookup value on a form just to display some info for the user. im using =DLookUp("Premises_Name","[Meeting_Agenda]","Meeting_Agenda_Number = " & [Meeting_Agenda_Number]) but instead of displaying the premises_name = its actually displaying the premises number (i.e. 16...

Im trying to set up a case situation for my cascading combo. i have ... Case "Liquor" Other_Agenda_Item.RowSource = "Liquor_Other" Decision_Type.RowSource = "Liquor_Decision" Nature_Type.RowSource = "Liquor_Nature" ... but when ever i try to select the drop down...

I have a cascading combo which goes to a different table depending on the value selected in another table. i want to set up a "NotInList" event procedure which will allow me to add something to the table if its not in the table. what is the syntax for the RecordSet paramaters, so that it...

can someone please give me the syntax for requiring or updating a combo box, after i have made a selection in another combo box. it has to do with cascading combos. i have been told that i need to requery, but i dont know how. :(

im trying to use an SQL statement to filter a dropdown box on a form. the following is the row source value for the field Meeting_Subject on a form: SELECT DISTINCTROW [Meeting_Agenda].[Subject] FROM [Meeting_Agenda] WHERE HearingMeeting_Date=[Meeting].[Meeting_Date]; there is a field on my...

I have set up a function that will select a row source in an afterupdate. but i want to filter this row source. at the moment the row source is a table that displays all the data in the table, but i want it to only display the data that matches the criteria set in another field. so that once...

I have a table which stores different agendas for meetings. (Agenda meeting number is the primary key - auto number), and there is a field - Meeting Date - which is where the user enters the date of the meeting. i have another table called hearings. now some meeting agenda items become hearing...

hi. i have a main table which has the following fields: Subject: Liquor Tobacco Kava Other_Agenda_Item. Liquor_Other Tobacco_Other Kava_Other The subject is a table with those values in it, and i have 3 tables set up for...

I have made my cascading combo box, and it works well. i have it running in a subform. where the user selects a subject within the sub form and the associated actions related to that subject are displayed in another combo box. however, i cant make it store the value that i select for the...

I have 3 fields. one is a date field - Date the second is a number field - Number_Days the third - Finishing_Date. when the user enters the starting date (Date), and the length of the meeting (Number_Days), i want the finishing date to be auto. calculated. i tried making a query with this as...