Search results

It is unbound text boxes and unbound form. No underlying table. It is just like a a calculator. The user just enters the departure date and arrival date for each entry and exit ( left side boxes are for exit and the right side boxes are for entry). And then press the button to calculate...

Please find attached. I have only a form. I deleted the code behind the command button since it was not working. Thank you.

I have to calculate a person's number of dates he is out of office. It is for calculation purpose only. I have 16 unbound text boxes (date) in a form. 8 for Exit date from office and 8 for entry date back into office. I need to calculate how many days he was away from office in a month. He...

Thank yo MajP. I had a wrong understanding about this. I was thinking it is for enforcing integrity in data entry. Rather, it is about orphaned data and cascading delete and modification. Thank you for this link. This cleared me.

Thank you.I will read and update you. Thanks for your help.

Thank you. Yes, I meant data entry. Thank you again.

Thank you for your reply. I will keep this in mind while designing my tables. Thank you.

Thank you theDBguy, but if the beneficiary is not married and or no children, data won't populate since both files in join tables are not equal,. Please correct me if I am wrong.

Ok, Thank you.

Sorry, join properties in the relationship window, which option I need to select - first or second or third?

Thank you for your quick reply. So in my case I can not say both fields are equal because the beneficiary may not have spouse and children. Thanks for your patience!

I have five tables, one for beneficiary's biographic info and other four are for spouse and three children biographic information. The beneficiary's primary key is the foreign keys for spouse and children. And also Spouse and children have their own primary keys. 1. Am I doing correct? 2. And...

Thank yo for all your help for almost all my questions in this forum.

Unable to upload, company policy. Anyway they decided to go with Evermap and Jotform. Thank you very much.

Yes it is with access.

I do not have DB. I just created a blank form with a text box for last name and a command button for the code. Thank you.

I don't have a DB so far. I just created one text field for Last Name and a command button for your code. I have the form W2 in the same folder. No table in the database. Thank you.

No difference it made. I got the same blank form. Thank you

<?xml version="1.0" encoding="UTF-8"?> <xfdf xmlns="http://ns.adobe.com/xfdf/" xml:space="preserve"> <f href="W-2.pdf"/> <fields> <field name=" Last Name"> <value>RAJAN</value> </field> </fields> </xfdf>

When I open, it opens in Adobe DC - the w2 form itself. But no data (Last Name). Thanks. The last name field is blank.