Search results

just switched the true and false around and its working now

yes im sure. the final display isnt important, its more important that it functions correctly. so far i have coded an on click event Private Sub CQC_Click() If CQC = Yes Then CQC_Subform.Visible = True Else CQC_Subform.Visible = False End If End Sub...

hi i have created a form with 3 subforms on. i was just wondering is it possible to display/ hide these subforms based on a Yes/No field in the form. as the subforms would only be valid if the field is ticked as yes. thanks for any help michael

you wouldnt believe that i was i just completely missed the option to insert a sub form. I'll put that down to sleeplyness. thanks a lot tho

i know its bad pratice to name things like that. however this is just a concept database not the real thing. also im the problem im having is i dont know how to insert a sub form into a form. i have used the wizard to create a form with one subform in however that will not allow me to create the...

heres the relationships

is it possible to have 3 subforms in a form? if so how would i go about this i have created the form and the 3 subforms however it only allows me to link one into the form. im using access 2003 thanks for any help Michael

i have solved it. you need to go to the forms properties and select control source and add the fields to the SQL statement. hope this helps anyone stuck on the same problem

hi i have created a form and its working correctly. however i have just been informed some of the fields needed deleting and different ones put in their place. so im just wondering if there is anyway to updated the field list so i can just add the new fields without having to recreate the whole...

thanks i cant believe it was that simple

hi, i have set up a query to count the different ethnicitys of people who have submitted a complaint. it works fine when I leave it just doing that. However when i add a field to allow me to add the parameters for a search between to dates. the query will only count the ethnicity of people...

hi im currently trying to count the amount of records that fall in each month in the date complete field. i am currently using a count query and it it bringing up the dates not the month thanks for any help michael

I can't as I currently have no Internet in my office and I'm on my phone

Hi I'm working in access 2003. I am running a count query on the ethnicity field from the patient table. This part is working fine. However when I try to add a parameter to search between two dates it stops the count functioned working properly. I am trying to add the parameter from the...

Thanks for the help. I would have included more details however I am currently on my phone as my office currently hasn't got Internet. So I didn't want to over complicate the typing. Thanks for the help guys I have sorted it now

Hi I'm creating a simple delivery management database. I have created a query that calculates the time taken to deliver a package. However I need it to work out how many times it took longer than 3 days and just display the amount of times that this occurred. I'm using access 2003. Thanks for...

Yeah that worked great thanks :)

Hi I'm currently trying to make a simple phone book database that use queries to search through the records. I need to set the search parameters to pick up all records containing a value rather that just search for that specific value. For instance if I type in "mic" and search I want all...