Recent content by pdrua

Hello esteemed members. I need some assistance with this. I am currently working on a loan management application with Access. The borrowers will repay the loan fortnightly. I am using the PMT function(=-PMT(Rate, Nper, Pv,[Fv],[type]) to calculate the repayment amount. I am stuck with how I...

Thank you, I prefer using codes to manipulate the data.

Thank you. Very useful information. I will be using the StartDate value to calculate the loan repayment schedules and save the data in the loan repayment table. Thank you so much. You guys are Super!

Thank you Sir. I have decided to work around it. I set the Default value of the Textbox to date by using =Date() Here is the screenshot of my form. The date textbox is indicated in a red square box with its default value set to the current date. I then use the following code upon the Textbox...

I removed the Input Mask but got the same error. I even changed the date format to Medium Date but the error persisted. The textbox is unbound and has no events attached to it or no codes under it. I am using Office 2013. There may be some known compatibility issues...????

Thank you for your prompt response. Appreciate it! I have an unbound textbox on the form, the format is set to Short Date, and Input Mask is also set to accept Short Date. No code. I entered/edited the date in its correct format and when the textbox lost focus the posted error was displayed.

I am delighted to join this elite Access forum. I am a moderate access user. I will appreciate your assistance. I will assist where appropriate. Thank you

Thank you all for your selfless assistance. I am working on MS Access Forms. I set a textbox field date input but when I entered the dates I received the following error. I searched many resources but could not locate the correct solutions. Attached here is the screenshot