Search results

  1. M

    unable to edit with results of a query

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

    autoupdate another field based on entered value by grabing value from parent table

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

    Missed dates from date last visited

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

    Need to update date based on type of program

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

    Unable to convert a split table back to local table

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