Recent content by bennybee

ok that works well. but when i create a new record, it still shows up the fields that are supposed to be hidden. i mean it doesnt show up any of the fields until i select "Suspended' from the list. and that is how i want it. but when i create a new record, the fields are still visible. how do i...

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...

That still doesnt work. Can i email someone my database (its about 500kb) and you can work directly on it. i think that its the fact that im trying to get info from a table joined to a table which is joined to another table which the initial hearing_query is based on...:confused: and its all...

when i run the db that you attached, and i run "new query" i get the following "type mismatch in expression". and it wont display anything. so i dont see what you see...:'( is there another way of doing it? or maybe refining this method?

the fields that are coming up requesting info through a pop up box, are not a direct lookup value from the joined table. e.g. the query is on Hearing_Agenda. the hearing agenda has a meeting agenda, and the meeting agenda has a premises name associated with it. e.g. Hearing ----- Meeting -----...

infact a pop up box does not appear for all fields which have look up values... only some. what would be the property of the values that are requesting pop up boxes that are different from the ones that arent requesting pop up boxes??

Im still getting an error :( when i run the queries seperately, the right information is displayed. however when i run the queries in a UNION query, pop up boxes appear for those fields in the Hearing Query that have lookup values associated with them.. ie... in the Hearing Table, there are...

Yeah that works well. but what if i want to add another field to be displayed in the query, that only has a value for hearings. so i have Date, Type Location for Meeting and Date, Type, Location, Nature for Hearing. can you do some sort of union query - or join query so that you can display...

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:

I looked and found it but it has MISSING: next to it. so it reads: MISSING: Microsoft DAO 3.51 Object Library. this is on Access97. does that mean that Access has to be installed again? also further down the list there is: Microsoft DAO 2.5/3.5 Compatibility Lib. but once i click this one...

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...