Recent content by ngoz1

no that doesent work. my title is already in the footer

Hi I have a 3 paged form. but each time i open it up, i find i have to use the vertical scroll bar to get the page titles to show. its quite annoying. does any one know how i can solve this ?

Hi Jsteph Thank you so much for your reply.The reason i dont want to make further details a subform to subcase is because there are too many fields in it( further details) and so it becomes cumbersome for the user to have to keep scrolling horizontally to see or enter every thing within a...

Hi I have a continous form called subcase. The primary key is subcaseID(autonumber) which is a foreign key in a form called 'further details'. i created a command button next to each record in 'subcase' which i hoped that on clicking opens up into a related record in the further details...

Hi every one, I have designed a database which my organisation is using to store information on clients with learning difficulties. At the moment i input the date of birth(DOB) and age in the respective fields myself. But i would like the age of the client to be automatically calculated and...

I often see job descriptions that request for an Access database officer to have report writing skills or experience of writing statistical reports. does any one know what these terms mean. is it anything to do with creating reports in access?

hi every one, i designed a database for a womens organisation which will be used to record both member and non member details, it will also be used to record all information on services that bring in income i.e member ship registration, training registration and payment details of these...

Hi, The database i am building is going to be used by 3 to 4 staff and so is only going to be loaded on a single machine. Id like to secure the database so that only i, have access to the design views of the tables, forms etc. i understand that i have to set permissions, but how do i set it so...

Thanks a lot, it worked

Thanks for replying little smudge, I have tried using the full formula the way you explained, but its still not working but can you explain a bit more, what the difference is b/w txtCalculated and ctlsubMain. i seem to be confusing them and i think that might be were i am getting it wrong...

Hi, Could someone please tell me how to display a calculated value in a subform control onto another main form. By 'another main form' i mean, a main form that is NOT the main form of the subform in question. (I already know how to do that). Thank you ngozi

hi, i have two forms linked by a command button. so that the form 1 only displays information relative to the particular client in form 2. therefore the foreign key in form 2 is the primary key in form 1(ie my underlying tables have a one to many relation ship) .i set the foreign key control box...

Lets say i have three tables - a member table, a non member table( storing all contact details of a member or non member) and a profile table( storing all info about events performed in, by a member or nonmember,and their performance acts at that event etc) The member table has a one to many...

please dont get too hung up on my example it was just an example i created off the top of my head to expalin my question. all i am really trying to find out is "what is right thing to do in a one to many relationships were the many side is optional." let me give you a real life...

please dont get too hung up on my example it was just an example i created off the top of my head to expalin my question. all i am really trying to find out is "what is right thing to do in a one to many relationships were the many side is optional." let me give you a real life...