Search results

I have a table containing people (e.g. students) and I put in one field the job of their father and in another the job of their mother. How else could I design it? Does this mean to build another query from the two queries?

It wouldn't. It is actually their parents job, mother's and father's. So I want to get, for instance, all the records, where either is a doctor, but only have in the report the field of the doctor. Meaning one record will return father: doctor (without mother: lawyer) and another record will...

I have a table with data of people, in which table two fields contain two (not necessarily different) jobs. I want to build a query (and later a report based on that query) which will return the name, address, phone of the person, plus only the field of the job that I asked for it. when...

Yes, it is, I will try it. Thank you.

How can I prevent that the user enters his own data? Without the relationship it can't be avoided (I think) You mean by putting a CmdButton on the student's input Form, which opens the Form of the Professions, right?

Is it not exactly what I am doing? How?

If I do this then the user should enter always the same data. In this way I will have redundant data and possible errors. He may put .... Carpenter .... ..... Catpenter Then by searching all parents whose profession is Carpenter (that's the objective) he will not get the 3rd record of the...

No. The only relation parents_prof.ID_parents_prof = students.mother_prof and parents_prof.ID_parents_prof = students.father_prof i.e. in table parents_prof: ID_parents_prof profession 1 carpenter 2 teacher in table students: Name Surname Father's Prof. Mother's Prof. John Doe 1 2

A person (e.g. Bill) can have more than one colours chosen. A color can be chosen by more than one person. In Relational Databases this is called a many-to-many relation. You need a third table to represent what you want and a bit of ...theory learning to understand it. The limit of 4 color...

I have a table called 'students' with the appropriate fields. There is another table named parents_prof which contains records of common professions. The tables are related through the 'ID_parents_prof' of the 'parents_prof' table to two fields on the table 'students', thus...

Found it! Thanks.

It worked now. I inserted the Exported Module 'dOpenFile.bas' and everything is OK. It wasn't so elementary, after all. Thanks for your nice help, ghudson. Still, I wonder why the previous method has problems opening pdf files? Anyway...

Private Sub bOpenFile_Click() On Error GoTo Err_bOpenFile_Click OpenFile (LinkToOpen) Exit_bOpenFile_Click: Exit Sub Err_bOpenFile_Click: MsgBox Err.Number & " - " & Err.Description Resume Exit_bOpenFile_Click End Sub I did it again naming the button bOpenFile, I run it...

ghudson: It seems to be my case. Thanks. Using dopedealer's way it worked as in the following: Private Sub Hlink_Click() HLink.HyperlinkAddress = LinkToOpen.Value End Sub where LinkToOpen is the field containing the Path. How should this be changed according to your way? I changed it into...

Yes! It worked (...half). Thank you. It opens chm files but not pdf files... Here are some more details: I'm using Acrobat 7 and Access 2003. If the file is a pdf, acrobat will execute and then close instantly. If an instance of the programm is running it will not load the file. OS is WinXP SP2

I have created a database where I store my ebooks. Therefore, let's assume that in the field "Title" there is an entry called "cooking.pdf". The file is physically stored, let's say at C:\MyEbooks\cooking.pdf I created a query where I get the records of the table (all or filtered) and I added a...

How can this be done?

Hello, I have created an Access DB for personal use and I am willing to sort the queries in folders. I haven't found a way to do this, is it actually possible? Having 40 queries all inside the database window is not so convinient... Thanks in advance for any replies.