Recent content by chris11590

Thank you!!!!!!!!!!!!I am so jealous. I wish I had the ability to do it that quickly. I am been trying to teach myself but has not come easy. thank goodness for the forum and all the help i receive. the only problem i face, is i can have the form showing the filter and sorting buttons.. i m...

i created a subform of branches which breaks down to groupsector. i would like to just select branches by Ids groups. for example, branch id #1 I dont know want to see branchid #2 or branchid #3. the form is based of table. i have tried to base it off a query but then too many queries are...

what does it mean to read only. i dont think so. one thing i did notice i did not have a parent/child relationship set on the subforms ..

nope.. it set to yes

the combo box is based of a sql "where" query.. its not the control or record source...

i have a combo box which will not allow me to select any of the options. i have limit to list set to no. i believe all the properties with are necessary are set correctly. any suggestions?

i dont know if this helps but i am still learning and want to help. when my reports were empty is because it had to do with parent and child relationship founded in the properties. the relationship had nothing in common to bring the data to display. good luck.

it takes 4 different parameters( branches =" incident commander and staff", "planning", "fire", "hazmat" ). is there a macro or VBA coding so that the front end user doesnt not have to input every parameters-for the most part the parameter hardly vary. i needed to group the branches which...

this sample db is similar to what i am trying to accomplish. i have numerous branches but on this form there are 4, on the average there can be 8. each branch breakdowns into various group sector. what i did was created queries with a SQL "where", which group the branches. the problem...

okie dokie thank you...i underdstand..

Re: Help!!!Same Table Two different Forms(db attached) Can you look at the example i have attached. on the form object look at branchform2needtodividerecords. i have created a form based off query2 (both queries are the same), but the problem i encountered as I mentioned is the first three...

i dont think this will help because the records are, i think, need to be sorted then filter. for example, i made need record number 1 and record number 20. it may not be necessary in the top 10. any suggestions chrissy. thank you all in advance

is the SQL only in the query or can you use them in forms reports and tables????:rolleyes:

is there any way to have two subforms which are linked to the same table but each subform have, again, the same recordsource but on the first form display a few records and the 2nd subforms have the remaining records. the forms would display in datasheet view. can anyone help with this

I have been reading a book on SQL language. Its a great book and very easy to comprehend. I would like to practice the syntax of the language but I dont know where I would write the language. Its in an event tab. VBA code. I doesnt tell me that part. LOL. any help and all help appreciated...