Search results

What makes the data different between these two tables that you need two tables? For example: If Table1 contains "Seniors" and Table2 contains "Freshman", then you could create one table with another field like "GradeID" that could be a FK. Then you could alter your combobox rowsource to only...

Search this forum for normalization. If your data tables are set up correct, then everything is easier after that.

I have to admit I was interested to see if anyone could other than brute force. I am still hopeful. :)

Thanks Nigel, In my situation, I have only one subform control in my parent form. I am setting the sourceobject to either subformA or subformB, dependent on the value in one of the controls in the parent form. Totally different data is being presented in the same 'real estate'. But, I do...

I just had to tell you that I actually had a situation where using this sourceobject method came in handy. It works so purdy. :p Thanks much!

Basically OK, but I don't like the _Adult_1, _Adult_2 or _Child fields in tblIndividual. You have nothing in the table structure that would prevent an individual from having all three attributes set to true at the same time. I would combine those three fields into one field that would be a...

What you describe sounds easy enough, but you don't say what your problem is exactly. The first thing I would want to check is that your tables have been designed correctly. Then it would be (relatively) simple to build a query based on the first table to be the source for frmFamily and a...

Welcome Randy! I work in Renton!

While you could break it up into two tables, you still could combine them under one table. Store both the reps and time into the same field, but the field needs to be a Double data type. Whole numbers for push-ups and sit-ups. The fractional numbers would be the time. This way you still only...

I am thinking just one table as described above. Then take the values from you form (Sex and Age) and the manually entered raw score to retrieive the final score for each event. Then I would simply sum the results of the three events. I wouldn't get too worked up about entering the data for...

Thanks Gemma. That made a lot more sense. Based on what I know about my friend's project, your first option seems more likely. Heck I didn't even know the second option was even possible! :eek: Makes me want to invent a situation and implement this type of solution. :D Thanks again!

Galaxiom, thanks for your input. That pretty much is inline with my thinking, but I don't have the depth of knowledge or experience to confirm. Gemma, I get what you are saying about the stored query. I have to admit, I never thought of Access having a 'plan' in place for a particular query...

Rogue: I think you are going to need to design a basic table that will house the relationships between the raw score (ie number of pushups), the age, sex and the final score. For example: EventID (the id that represents the event being scored: like pushups) Sex Age RawScore (actual number of...

I have a question concerning the pros and cons of setting a form's recordsource using a dynamic SQL statement versus setting the form's filter property. My friend's project has a form with multiple sub-forms and within those sub-forms, some have more subforms. He has starting running into...

Minor modification of JR's example: strSQL = "UPDATE [patient] " & _ "SET [Current_Med] = '" & MyMed & "', " & _ "[SType1_Desc] = '" & Me.SType_1 & "', " & _ "[SType2_Desc] = '" & Me.SType2 & "', " & _ "[SType3_Desc] = '" & Me.Stype3 & "' " & _...

This might get you started..... http://www.access-programmers.co.uk/forums/showthread.php?t=234753

Rat1Sully: No, I actually think for the original question, yours was a better solution. He stated that he wants a User to click a button, then automatically run some updates. whdyck mentions that: This leads me to believe he is using code to assign the value of "D" into the control that is...

You obviously got an answer that works, but a simple command to force the save of a record: DoCmd.RunCommand acCmdSaveRecord

A simple example of the recordset example: Public Sub EmailQuery() Dim strQuery as string Dim blnEmailSent as Boolean Dim db as DAO.database Dim rs as DAO.Recordset strQuery = "Query Name or SQL Statement goes here" set db = currentdb() set rs =...

I would make my query into a recordset, then you could step through the returned record(s) and then call the function above using the data from the query. I would insert a small example, but I am running short on time. I sure if you searched this site, you could find a number of examples. I...