Search results for query: *

At my office we use two types of internet connections. A production line and a contractor line. If I boot my host computer up and then my VM I am able to successfully use networking inside the VM. I am unable to switch between the two network connections. If I switch the connections on my...

The FK on the contact table is actually the subject ID. I mistyped it the first time I was posting. The DLookup function worked perfectly and I am now able to open the correct records. Thank you for all of your help

PHV, Thank you for your reply. I think the way I worded the question originally caused some confusion... I do recognize there are sql commands to retrieve the data I need, i.e. a select statement. The problem I am having is with calling the statement from a MS Access Form. I am putting an...

To begin with there are three tables here... Person personID - PK ... Subject subjectID - PK personID - FK ... Contact subjectID - FK ... I have a form which points to the Person table. I am attempting to create an action button which opens the contacts for each person record. The problem...

Thank you very much........both suggestions worked perfectly!

Worked perfectly...One more thing I use a VBA MSG box to confirm the delete at the beginning. Is there anyway to prevent access from asking the user to confirm the delete of the record from each table?

I want to create a single delete button for my Access Form. I have three tables: Contacts, Questionnaire, and Tracking. When the user clicks the delete button I would like to permanently delete the entire record (knowing the subject ID that connects all three) from each of the three tables.

Thank you!! That worked perfectly

This is my first post on these forums. I have a couple checkboxes in a MS access query. I want to summate the total number of "Yes" (Checked) items. Is there an easy way, like putting all the variables in the SUM() function in a new expression? Here is a screenshot of the query...