Search results

Hi experts, I have table tblReg and form frmReg. On that form have an unbound text box (txtAge) for Age where I put expression ***=DateDiff("yyyy", [DoB], Date())*** to count how old is every person in Reg table. Field DoB is bounded to text box txtDoB on the same form. It is working perfectly...

Thank you for a detailed explanation. Will arrange tables as you suggested. Cheers

Hi Plog, Yes I did it like you suggested. Thank you very very much.

Hi Plog It is wonderful. Thank you very much. Query is working exactly what I want. I have one more question. How can I have sum of each column from this query. For example: Sex Breakfast Lunch Dinner Male: 57 61 60 Female: 42 45 44...

HI Yes you are right, I want sum of every gender for each day per meal. Thank you will try tomorrow and will give some feedback.

Thank you for your quick reply. I want to have sum of ticked check boxes for three meals for males at the end of every day. This will help me to track IDs who took a meal. On that basis I will create for Females as well. Attached is screenshot of my continuous form and Food_List table. I have...

Hi all I have on table Food_List where I have three columns set to checkbox as value Yes/No and fourth column for Sex (Gender). I wrote a query to count for every ticked checkbox as first criteria and sex 'Male' but result is always 0. Could you please help with this query, it is important to...

On a form I would have one record which is set in REG table. On a sub form will have sometimes 1 or up to 8 records. I need to copy main parent record from a form and related records on a sub form. For the next record on a form will have another related records on a sub form etc. Thanks

Thank you, That code is working fine but I need to copy current records from continuous sub form. if I add another append query it copies only first record. I have added a code to count how many records is current on a sub form, but do not know how to combine it with my code for chckbox. Thanks.

Hi there is a checkbox on a REG form called FL in the upper right corner. The reason is for reporting purposes, because It change every day and do not want to mess with the main table REG. I would like to have it that way because DB will not be big and I found that solution the best. Thanks

Hi I would like on click event to copy current records on a form to a temporary table. When i Clear checkbox to delete these current records from temp. table. attached is demo db. Thanks.

Hi everyone, I have a checkbox on a form with record from REG table, which I use to copy current records from one table to a temporary table which changes every day. I have set checkbox on click event to execute a VBA code to copy these record with append query: Private Sub FL_chkbox_Click()...

Yes I read you link. Thank you. I want some other solution if is possible not to use Lookup option. If you have something in your mind will appreciate.

Because I need to see all records from two tables like in excel sheet. It does not work like a form and subform nested.

That is not happening.

Yes but need to display only a symbol for gender on the form RegDtafrm in a textbox

Table Reg has Gender field where is record e.g. Male. In Gender table in the second column is symbol for Male is M.

Yes that is what I meant.

I have to use combo box in DLookUp but I need just to edit record (Gender symbol) on a form from Gender table. Hope this answer will find all others who replied to my thread. Thank you