Search results

Ok, I did a querry of my table named "People" using the following fields: People ID, Title, Name, Second Name, Last Name, Job Position, Company and PeopleContactMethods ID, which is the field that has the one-to-many relation (this field being the one with the infinity sign in the relationship...

Hello, I have made some changes to my database based on suggestions found in this forum. I have now a main form and subform - the main populates a table named People and the subform a table name PeopleContactMethods. When I do a query to pull the people's name and contact info I get a blank. I...

Hello, I am trying to work on this again. This is my new relatioship chart based on your comments. What do you think? Also, I am having a little bit of an issue setting up my subform. when I enter the data it goes into both tables but it looks like there is no relation between the data...

Hello HighTechCoach, Thank you again for taking time in answering my questions. I am starting to have a better idea of what to do next. I will revamp my forms and tables to follow your advise to the best of my abilities. By doing this I will eliminate any "many-to-Many" relationship I had...

I am not too familiar with multi-select combo boxes...what are the advantages, what would it allow me to do in my case.

Hello HiTech, I agree that it would be easier perhaps to have just one table with contacts for both brokers and clients but how can I associate them in a given record for a client which broker, if any, is involved? Do I need to create a query to pull contacts for the Brokers only and then do a...

Hello, Here is a copy of the file with the database. The data is made up for now just to test if it works or not so it can be changed if needed, I don't mind. Let me know your thoughts! Thank you for showing interest in helping me!!! Jorge/Eurojourney

Hello, Ok, I am hitting a wall with my simple database that I need to create. I need to register in my real estate company clients who might be associated with a broker, many brokers or no brokers. Also, I need to register brokers who may have one client, many clients or no clients at all. The...

Wow...it did not work...I copy and pasted exactly as you provided...I went to events on the form and clicked on the three-dotted bottom on the current event and pasted the code. One portion is on the current event of the form, the other on the After event location. I can't select the check...

Ok, I am going to try this now! I did not know I needed the "d" - I copy pasted the stuff provided before...I'll let you know if it works and try to avoid spaces from now on...thank you for you patience...

One question, when I do a query for the two tables using the registration table, do I just use the Primary key of the registration table or do I have to include also the primary key of the registration table as well as the Client and Broker table...Thank you. Jorge/Eurojourney

I have primary keys in all my tables and everything works and have the proper relations between them - i.e. one-to-many for the small tables feeding the combo boxes in the client's table, one-to-many for the client table and registration table, one-to many for the broker table and the...

Now, since I’ve been told that having lookup fields are not necessarily a good practice, I need to find a way to relate my two main tables, Client and Broker, presumably by using my Registration table so I can use my Client form and choose a broker associated with the client in the same manner...

Hello, I am new to MS-Access and this site has been great in answering some of my questions. I know that my questions are rather basic for the most part but so far I think I have managed to have my database close to working conditions. However, someone pointed out in this site that using lookup...

I read the article about lookup columns. How Do I link my two tables so I can plug in two both tables from the same Form?

Hello, I am so sorry but this is not working for some reason. I think I am doing exactly what you are suggesting - this is what shows up in my VB screen: Private Sub Broker_Involved_AfterUpdate() If Me.Broker_Involved = True Then Me.Broker_Name.Enable = True Else Me.Broker_Name.Enable =...

This might work - I will try to understand the ins-and-outs of how it works and applied it to my database. Thank you. Let m eknow if anyone else have other suggestions.

I would like to post the way I structured my tables as shown in the relationships view. Is that possible. I do have a junction table - is a many-to-many relationship - but I don't know how to use a form to fill fields on different tables, i.e. fill name, last name, email, etc for a client in the...

This is the code I used: Private Sub Broker_Involved_AfterUpdate() If Me.Broker_Involved = True Then Me.Broker_Involved.Enable = True Else Me.Broker_Involved.Enable = False End If End Sub Private Sub Form_Current() Call Me.Broker_Involved_AfterUpdate End Sub The name of the CheckBox is...

I tried this but it did not work. Also, what is the connection between the combo box with the names of the brokers in the client form and the check box - I don't see in the code anything that relate the two. This is the code for the checkbox under the Afterevent event: Private Sub...