Search results

Thanks jdraw for your response, and interest. There are no tables in the Relationship window! This user did not practice the linking up of tables in this window. He did link up tables when he had to in the creation of a query. So, how can a table be 'directly' dependent on another table? I...

I am using Access 2007, and have inherited a database from a co-worker that is no longer with our company. This particular database works fine, and has for quite awhile now. I was reviewing and analyzing all the tables and decided to find out the Object Dependencies for each one. Much to my...

I am currently using Access 2007 and have an inherited a database with an unusual problem. When I run a report I receive an unusal prompt. This is weird because the query driving this report does not give this prompt when it is run by itself! Also, when I simply click on this prompt with no...

Well, very impressive speakers_86. Thank you. Quite a bit to take in. I believe you have made my db in 4th Normal Form, is that correct? How did you know to expand or normalize the tables and how far to do this process? Does it have something to do with some data in the tables as static...

I think some clarifications are in order here. I do appreciate the efforts though, so please don't get me wrong. I want my main form to emulate the card that is presently used to collect this data. It is a 2-sided card so I captured both sides onto one document. The audited by is the...

UPDATE: When I click on the ellipsis for the Link Master Field and Link Child Fields in the property sheet of the subform I receive an error message "The expression you entered refers to an object that is closed or doesn't exist." I googled this and am confused by the hits. They talk about VBA...

How's this?

Once again, thank you for the vote of confidence RainLover. The attached db is obviously different than my descriptions of my posts. I was trying to generalize to expedite things. I hope you understand. Please feel free to play with it. I feel I am close but I just can't figure out what I am...

Okay, thanks again RainLover for your interest and enthusiasm. There are no other fields in the other_table that can link to the main table. I have some news that may be bad. A colleague just pointed something out. My FK should have data in it in order to work. I created the FK field hoping...

Thanks for your interest Rain Lover. See attached.

Thank you John BB and speakers_86. But those fields are filled in properly. I used the Form Wizard and specified that the link was the PK and FK. Any other suggestions?

I'm using Access 2007 and my PK for the main table is an auto-number. For table #2 I added a field as an FK of the same type as the PK, long integer, and then linked the PK with the FK. Both tables were made into forms and separately they work fine. When I make frm_table #2 a subform of the...

Okay Mike, now I'm confused. What do you mean by 'everything is in order'? When I open the form called tbl_safety_review_situation (prefix error here...) I see only part of what I expect to see. I do not see anything for the safety category and the observed activities! I want to see...

Sorry about the lack of information. The subform frm_observed_activities is a subform of frm_safety_category. They work fine together. The subform (frm_safety_category) will not show anything when linked to the main form (tbl_safety_review_situation - this should have been prefixed as...

I am using Access 2007 and having trouble with designing the input form based on a current manual procedure using a card. I have attached my database (so far) and a sample card. Any help would be greatly appreciated!

Thank you vbaInet for responding. The subform and main form were both created using the Form Wizard. There are no fields that relate to both of the two tables, other than the PK (auto-number of the subform) and a foreign key in the main table that I made similar to the PK. Is it possible...

I'm using Access 2007, and developing a safety observation db application. There are 40 prescribed activties/safety practices to check for. This is a table with auto-number PK, description of activity, and active status. These activities are not static. More could be added, or existing ones...

Hi everyone. I'm a long time user of Access and have decided to get more involved as a developer. I think it is a great software that is sadly under-utilized. I have also found that the more you use this software the more you learn about it! I am also Canadian and presently work for a...