Recent content by shez

It does make sense and but i dont know how you would code that! I have been playing around with my test chart i created using pivot chart and in the design mode, i am able to add condition however when I view the pivot chart, it isnt obeying those conditional formatting :s (did you create...

i know how to do what you want in access 2007 AND USING reports (textual) so if you want me to give it a try attach your database & lets see if i can do similar with graphs! i just spent some minutes creating a test graph and no i cant do it with graphs! well not easy way!

nevermind! i was probably talking rubbish!

i am just wondering why would you have multiple report names in the first place? I think you have something like: reportId, reportName, 1, 1stReport 2, 1stReport reportId, dueDate 1, 01/01/2009 2, 02/02/2009 in this case you should be getting two report name?

not sure which form you are having trouble with but I had a form & a title i wanted that title to refresh everytime user clicked on next/previous record so i simply created a procedure: sub assignCaption() title.caption = firstName & lastName end sub and then called it from pageLoad and...

post your query? & relationship diagram if you can

dont quote me on this but if you want the query to run based on parameters users can input via form then u shud do: select * from table where personalID = formname!formfield

I know and have seen people replying to similar posts on the net by advising to use custom menus and that is what i used to do before i learnt that there was a switchboard implementation in access. So I would like to know if anyone has successfully altered the limit access imposes (8) ? I...

Hi Thank you RABBIE & NEILG and everyone who has helped me. I took into account what you have said rabbie & after thinking about it, you were right about the unnecessary field i was creating. I modified my design & now it works (so far!)

thanks for answering! one last question and if it doesnt work then I will rechange the relationship. I was trying and rebuild query from scratch. I added different tables individually to see where the problem lies and i found out that somehow it lies in the uni_link/university table! The...

i am sorry for being so silly! I should have mentioned the form. it is the ADD PARTICIPANT form. I have created a similar form to add participant but it uses subform. This seems to allow me to change data in the dummy record and also allow me to add data however there is a problem because it...

I have tried a query too and when i run the query it gives me all the records (currently 1) in the table! when i convert that query into a form, same thing happens i.e. i can view the current record but cant add/edit the data :s form properties are appropriately set

Hi I have no idea what i am doing wrong but i cant seem to create forms based on multi-tables! If i create them using wizards, the forms can be seen and they have the "dummy record i created" displayed. however i cant seem to edit it or create a new record through the form! In desperation I...

Hi Thanks for the reply BUT i have stated that in the subform I have pId which is the same field as the one in the main form.. The funny thing is that when I added a record manually i.e. entered data through TABLES and then looked at the form, it worked ie the subform had data relating to...