Search results

consider the following tables i have 2 interfaces for the above 2 tables. the training attendance is a subform of the training program form. and the form looks like follows the training sesssion sub form saves data as follows. (i.e the sesion id starts again from 1 for a new program id)...

oh yes.. i've forgot to mention about the table which refers to the form. it stores the group types. it goes like this [program attendance table] ProgramID GroupName GroupType TotalAttended

hey thats funny... hmmm what can i do... lets see.. i can see the images clearly though... the images below "consider the following form and table set " are http://i47.tinypic.com/ng7i3d.gif and http://i47.tinypic.com/18n8lf.jpg and theres no image after "also theres a query which contains...

fix what bro ?

consider the following form and table set also theres a query which contains the following fields [Participant Group NAme] > all the names of the above tables [Group Type] > VC for village committees, PG for producer groups, PH for Pharmacies the group name combo box's Row source is this...

the currency data type always shows values with $ sign. cant i modify it and insert any localized currency symbol ? (like Rs. etc ?)

is there a way of creating combined unique keys in Access ?:confused::confused:

whats the difference between this 2 terms ? i.e OLAP versus data warehousing ?? c'mon this is not home work so i'm specially saying this to "some people" who usually make "idiotic" comments when they cannot find answers... i'm just curious thats why asked.. so if u know, please share.. thanx :)

consider the following table i want to query and take the total population and the number of GNs group by the district so i wrote the following query SELECT District.DistrictName AS [District Name], Count(GN.GNCode) AS [Number of GNs], sum(population) AS [Total Polulation] FROM (District...

hi i want to generate a graph using access and i'm damn new for this... can anyone guide me ? apples 3 manges 6 banana 4 say i have those data. i need to show them in a chart.. how can i do it ?

hi i have 2 tables here, the Village Main table stores information of all the villages in the system. while some villages don't have details which are mentioned in the village sub table. so, in the village sub only details of some villages are stored. now i have a form with Village main's...

hi i have 10-20 text boxes in a form all these text boxes should do the following if double clicked Me.AllowEdits = True but its a long process to write this code to each and every text boxes double click event. insted of doing that, isn't there any other way to write it only once and pass the...

hey i think i got it.. its Me.AllowEdits = True right ?

hey thank you very much HiTechCoah !! you are a real problem solver !! :) also thanx John Big Booty for the quick response.. ;-) hey theres another problem. say if i include a button in the form saying "edit" which will make the current record editable, then what code should i write in the...

hi how can i lock the fields in a form when viewing contents but to unlock them when adding a new record ?? is it possible if yes, how ?:cool:

DCrake, ma man, sorry dude.. i was little pissed off... ok ok cool man... cool !! i take it back ma man.. ;) @namliam > havent heard about weak entities ???????? OMHG !! http://en.wikipedia.org/wiki/Weak_entity

WTF ???? u call urslef an Administrator ?? have F-ing Manners please... this is not from an Exam u idiot... this is a F-ing practical problem !!:mad::mad:

how can we identify a weak entity ?? is all the weak entities have a 1:1 relationship with their owning entity ? how can we distinguish a weak entity with a normal entity ? can a weak entity have strong relationships with other strong entities except the owning entity ? please answer those...

i have 2 tables training program and session Training Program ============ program ID description duratuion #ofSessions Sessions ============ programID SessionID sessionDate #Participants here, in the training program table, the program ID is an AutoNumber Column. in the session table...

hey then what about the unique IDs of the mentioned Entities.. if i categorized as u said, how am i able to show the IDs and stuff ? its better if u can explain the ER u're proposing.. also bro this DB should be developed for a humanitarian project.. so thats why there are these targeted number...