Search results

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...

If you want i can send you the database you can see for your self and you may post the solution or can tell me what have i done wrong.

Apart from why, do you have answers, to solve the problem. Now tell me you can solve the issue, i can go on replying, but for the benefit of time like i said i am learning, if you have any solution please tell me.

I am learning access databases, i think its a learning curve. Kindly post me some suggestions to solve this issue. It is driving me crazy. I searched every where on the internet to see why this is happening. So i approached this forum.

I am using the standard procedure, I go to database tools menu and then I am using database splitter, to split my database. But there are few tables along with a table named invoice table. when I try to use the option convert to local table, I am getting this error " Property not found "...

Unable to convert a linked table to local table Hi all, I am new to this forum, I recently started to explore access, i had built a gym management software for my gym, but now one of my friend had requested me to sell him a copy so i decided to split the database, Every thing goes fine till i...