Search results

I dont get it... Sorry, I don't get it.....If I create a query on the root table, so to speak, I have the option of including any of the ID fields (where keys are kept). If I don't select the key field, I don't have the reference back to the referring table. (I want to keep the reference from...

Version of access Access 2003, 11.5614.5606, updated regularly via MS Update service

I have a DB with about 50 tables. I have arranged them in a particular order in the relationship viewer and would like to print out as much of the viewer as I can by choosing the paper size and/or setting a scale factor. Access does not appear to let one do either. When looking at the...

When I export my access database to XML I noticed that the XML elements for the table keys contain the key numbers themselves, not the table name (or a chosen field in the table). For an application I am working on, this presents a problem. What I have is: One table called 'Process' that...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

HI: I have a db with about 70 tables in it. I am trying to see the relationships among say, 40 of them, all at once. I like the view of the relationship window but: I cant scale it, select multiple tables and reposition them, use the mouse wheel to move it (only the window sliders), and, I...

Clarification... Thank you for the tip...I am not Access savy so I have to ask, "How do I do this?". I know how to do the query of the 'B' table (looking specifically at the FK field I suspect?). To what am I adding the 'tablename' to? Thanks again John

I forgot to mention... If you do not want to go the program you own route, search the web for applets (some even free) that does what you want. If your in a real company, if is often cheaper for them to pay $200-$500 or more for by a program that is embeddable in Access that will do what you...

Don't know if this will help, but.. The import mechanism in access is kinda dumb (as you found out). Each major tag becomes a table (object) and no relationships are made among the tables. I don't know exactly how to do this but I have a suggestion. You may be able to parse each line in the...

HI: I've managed to export multiple linked tables to XML via the Export feature in Access. In looking at the XLM that is generated, I notice that the data that corresponds to the key field contains the key that is autogenerated. If, for example, I look at the last table in the chain, and look...