Search results

I have table FD with all beneficiaries where I open form to enter Food Distribution for every day. But my form is continuous form and cannot add date next to each ID number. I used unbound box with date Now() which is working fine, but need to save that date for statistical purposes in my...

When I add date it only add it on the first record. That is problem with continuous form. That is why I put unbound text box on continuous form next to each record and set Now() date. My FD_Date is invisible on the form.

I have tblFD and on the frmFD have unbound text box where date is set Now(). Form is in continuous view and would like to save date for each ID with cmd button on click event. When I open form Date is set for present date but would like to save this date to FD_Date field in tblFD. Experts could...

Hello, Is it possible to create Named Data Macro to update date from one table to another on open database. I will put that Named Data Macro to Autoexec macro to execute update. Can you please help with this because I do not have big experience in access. Thank you.

Soory but cannot copy database from the server. It is a company policy but will give you some screenshots.

Hi Thank you for quick reply. Yes you are right but when I set Exit date once I want after 48 hours that data macro sets Departure automatically since I do not enter every day to check who is exceeded time out. This should happen automatically when I open database next time. Than his profile...

Hi everyone, I have a table tblCompound where is created named data macro which calculate time out of compound in hours after I insert Exit date and time in frmCompound. I would like to create after update data macro when customer is more then 48 hours out of compound to set Departure date to...

Excellent I've got the result. Thank you all guys. Result is in hours but need to type date and time in my text field in format 01.06.2020. 14:30. DateDiff("h";[MyDate];Now())+(Format(Now();"dd\.mm\.yyyy hh:nn";2;1)<Format([MyDate];"dd\.mm\.yyyy hh:nn";2;1)). Just removed one h from formula...

Hi This is an expression

Hi everyone, I have problem to update PuchaseDate with the date in the field PurchaseOrderDate. Both fields are in the same table tblPurchase. Image is attached. Could you please help with this issue. Thank you.

I am trying to get result in TimeDiff column in my table where I have run DataMacro on TimeDiff column. DataDiff is between MyDate and System date and time. I would like to have hours stored in my TimeDiff column, but keep getting an error. Could you please help. Thank you...

Hi everybody, I have one little problem. I want to set format on the field Year of Birth where I record only a Year when the person is borne (without day and month). How to set only a Year format when I edit the date type format in the table, I see only Access standard date format types and do...

Thank you, I thought the same. Thank you very much. Just wanted to be sure. Cheers

Hi Everybody, I would like to setvalue of ID_No which is on the continuous subform from the parent form. I know how to setvalue of the ID_No on the parent form but would like to setvalue of the continuous subform from the main form when I open the next form using command button on the parent...

Thank you all for your answer. I have managed to create Macro PrintOut. Could not see that option because I did not press Show all action in Macro design view. Thanks again

Hi everyone, how to create macro to print preview and print only first page in access report. Could anyone help on this. thank you

Hi I have explained relationship between fields from two tables. First table is Reg and the other one is FM table. I guess it is possible but I am a beginner in access. Thank you.

Yes I showed only part of my query. The rest of data are the names and surnames which I do not want to show. If is possible to do it would appreciate your expertise. Thank you.

Hi everyone, I have Two tables with a relationship Reg_ID to FM_ID one to many. When I create a query I get good result. But is there a way to take out repeating IDs from query somehow. Sample is attached. Thank you.