Search results

Thanks for explanation. I have no experience working with union queries at all. I am going to work on it tonight and see how far I can go then will update here if more hints were needed tomorrow. Before I start, is it possible to use the union query for ComboBoxes and OptionGroups simultaneously...

@ Plog, Each table has a ComboBox or OptionGroup connected that user can select the answer in each case. For instance: Click on Yes when asked "Were people around you infected?" Click on Friends when asked "Who were you with in this meeting?" Click on Bus when asked "What kind of transportation...

I still think I haven't clarify myself very well. What happens to all other tables? You want me to integrate all items in one tblRisks and eliminate all those individual tables? Please look at all items in my tables here:

@ plog, thanks for your time. I am not sure if I've understood what you are suggesting here. I understand the last part about friends fields and I will fix that according to your comment. But I don't follow what you say about two new tables and the way they are related to tbl_all_Logs or each...

I need to have the third and second column available at the same time. The second value will be saved in parent table and the total of all riskNum's goes to the last column of parent table. Total_riskValue in my tbl_all_logs should have the summation of all riskValues from each child table based...

Third column of each child table is called "riskValue". When user selects a value from second column using a combobox in my Form, I want to have the third value in the same row to be used in my summation. This way, when all comboBoxes in the Form have selected values to show the user's selection...

Hi everybody. I have a primary table as source of a data entry form. Textboxes of the form are getting their values from the second column of different child tables. All child tables are related to primary table by their primary key's. I need to sum the values in third column of child tables...

Thanks. Do I need to indicate the solution as "Accepted Answer" or something like that? I don't see that button here to click on.

I am trying to display the selected values in a textbox (in form A) locally in AfterUpdate event and simultaneously sending to another textbox in form B. I am using string format because I have numbers and characters at the same place, txt_temp_F <<== 09:45 PM With the modifications "Arnelgp"...

Hi, Thanks for your help. It actually works fine now. You are the best. Now I have to questions here. I was told this is not the safest way to use global variables and it can make unexpected issues later on and very hard to do error handling, why is that if it is correct. Is there a better way...

Hi all, I've used a global variable declared in a standard module. It takes its value from form A and I want to display that value in a control in form B. Although this is my first experience working with modules and global variables but it surprisingly worked the way it was supposed to...

@ MajP It works perfect. Thank you

@ theDBguy Sure, Here is the image attached. When user selects Patrick from customers combo box then all cars belong to Patrick are displayed in subform as you can see in the image. Now user clicks on one of them, for example Mazda MX-5 is selected by user then subform sends the value of...

Hi everybody, I have a subform based on a select query. I need to store the content of one of the controls in selected row (an ID) for later use. Users usually hover on the rows then select or click on one of them. I don't know how I can make my table rows selectable like that. Is there someone...

@ Cronk Thank you for your comments.

@ The_Doc_Man Yes. They are the customers who bring their car to a shop for oil change or services. After a while when more data has been collected then mechanic person can find a customer's name from a combo box and then will see list of the cars that customer has brought to the shop. He clicks...

@ June7 I was able to see more details about the table and queries in that sample database.Thank you for your helps. I now need to learn how to make a table row selectable like what it is in the sample database. Should I open a new thread or you can help me here?

@ theDBguy I can't because it is still incomplete and too messy.

@ Cronk Thank you for your comment. You made me thinking more about my table structures. I am still defending what I have now because a car always has a unique license plate and it belongs to a single customer at any given time. In my carsOwners table I have a complete list of all owners and...

@ Cronk Table customers stores personal info for each customer such as full name, phone number and etc. I created table carsOwners because I can have a customer owning multiple cars. As you can see in this table I am mostly storing ID numbers from four different tables. This helps me to avoid...