Recent content by maheshashish

Dear Members, I am trying to write a small piece of database, who owns a medical shop. Which is an medicines inventory management database. But when ever I try to pull a query for sales entry via query, I am getting a result which is ultimately unable to edit. I am working with these tables...

Respected Members, I have a table Med_List has fields [drugname] [form] [taxpercent] [medcode] (Medcode is concatenated of drugname and form)(PK) etc Another table Purchse_detailsT [medcode] (lookup) [purchaserate] [qty] [taxpercent] Now i am having a datasheet from which has fields all fields...

Thanks for the Reply sir, that solves my problem. Thank you once again.

InvoiceID AutoNumber CustomerID Number InvoiceDate Date/Time InvoicePaid Yes/No ProposedDueDate Date/Time NextDueDate Date/Time BillAmount Number PaidAmount Number DiscountAmount Number BalanceAmount Calculated Program ShortText AlertStatus Yes/No Respected pros I have this particular table...

It works, thanks

Let me give it a try.

Hi yousef please see the attachment in in my reply post and insert the code and kindly post me back Thank you

I had attached the sample db, please also see the attached db, thank you

Does this work with months of february, and months with 31 days as well? I don't think so

Yeah even that works fine with me, can you please help for that scenario

It depends on what program he chooses, and it goes like this program Next invoice date Monthly November 27 2017 quarterly January 27 2018 Half yearly March 27 2018 Annually October 27 2018

Hi all, I have a form, in several fields out of which, I have a combo box called "Program" which contains "Monthly";"Quarterly";"Half yearly";"Annually". Now there is another field called "Next Invoice date". I want the Next invoice date to be updated automatically based on the program...

Hi sorry for the late reply. My problem has got solved. I had deleted the table link and then recreated the table link. and now the problem got rectified. Thank you all for your support.

I have unsplit version of my database. :o

Hi thanks for helping me out, the database is working fine, and I went and double checked the table it is there and I tried refreshing the link and I used the linked table manager and remapped them all again to the same back end. but still I am getting this error sadly:( I made numerous copies...