Search results

thanks, worked like a charm!

Hi, I have a database with one main table (Projects) and 3 other tables (Students, Organizations, Professors) linked to the main one through many-to-many relationships (through linking tables that is). Basically, the organization I work with does research projects, and each project could have...

hi guys, i had the same message when tryin to replicate my db. would installing jet 4.0 service pack 6 solve it for me as well? cheers sw

hi, i have a fairly complex DB with lots of demographic info. On one form there is new student information that is continuously added, and there is a buton that leads to extended information for the student. I chose this as a design option since it is simple, and it does not add lots of data to...

i forgot to mention that during import access stops while importing the same table where the form was based on (tblProject, frmProject)

same problem this problem started today access stops working and it offers to call Microsoft and report the error. it only happens when loading one specific form....i tried doing what pat suggested, started a new db and imported everything, but it crashed and asked to call Microsoft again...

hi, i have two tables, tblContact and tblorganization, linked on a many to one relationship through OrgID (OrgID is foreign key to tblContact). I have created a subform, which is used in another form, to create a link between another table, tblProject and tblContact (these are many-to-many...

an idea: why don't I just link Projects and contacts on many to many, and then when from the como box the contact is selected, the appropriate organization shows up? If this is good, how would i go about doing it? thanks penar

hello again, i have seen the db you forwarded me to, and i feel that what i am looking for is more complex. so again, lket me try and explain. so we have organizations that might have multiple contacts (eg. YMCA New York has contact person 1, YMCA Bonx has contact person 2). From one...

thanks pat i understand your solution. but then how would i go about showing this into forms and reports, is there another place i could look into what someone lse has already done before? im having trouble with the terminology for this. pm

fixed this problem by using a row source modification: SELECT tblStudent.StudID, tblStudent.LastName & ", " & tblStudent.FirstName AS Expr1 FROM tblStudent ORDER BY tblStudent.LastName; it works awesomely !!!

Ok, let me see if I can explain my situation. I have a database that deals with community-based projects (tblProjects) which are linked in many-to-many relationships with Organizations, Students and Professors. I got the whole architecture of this thing sorted out, but something came up. It...

alrite, i tried it and it seemed to work, but there are a few glitches. first of all, i have some Projects in the database linked to multiple professors, organizations and students. In the report, I get duplicates for each of these fields (ie. for a project with two professors, same student...

similar issue i have a similar issue with the one that morlan had initially i need 3 fields: firstname, lastname and and third which would be populated by both. i need to do this because, well, i have 1 main projects table linked in many-to-many to two other tables: students and information...

YEESSSS It works !!!! Thank you pm

thanks for the really quick reply, but how would i go about doing that (sorryy....im part of that growing group of idiots !!) pm

Hello, I searched up and down these forums for about 1 hour or so to find a topic related to my problem, but couldn't find anything... I hope this post is not redudant Anyway, the problem is this one: I have two tables: tblProjects and tblOrgs which are in a many-to-many relationship with...

hello, i'm totally new to this forum, and fairly new to access but i'm gonna send a message just to give it a try.... here is the problem... i have a database with a central table "Projects" and 4 linked tables: Students, Professors, Organisations and Departments. Each of them is in a...