theDBguy
Reaction score
6,330

Profile posts Latest activity Postings About

  • I would like to make the Archived Date field a "required" field if the Archived value is selected in the Status field in Access 2016. Is there anyway to have the cursor automatically go to the Archived Date field so that the date can be selected? Does you have any idea how to fix this?
    S
    shenekas
    I used the following code:

    Code:
    If Me.Status = "Archived" Then
    
    If IsNull(Me.Archived_Date) Then
    
    MsgBox "You must enter a date when the Status is Archived.", vbOKOnly
    
    Cancel = True
    
    End If
    
    End If
    How are you theDBguy I am struggling with this issue if you could follow the link:

    Thank you so much in advance!
    theDBguy
    theDBguy
    Hi. Unfortunately, I am out of the country, so I only have limited Internet access. I'll take a look if time permits or when I get back in a couple of weeks.
    Hello good morning sir

    Please sir I need your help, i design a database in MS access for a pharmaceutical shop. These are the field I have in my form
    a. Name of drugs (in combo)
    b. Quantity
    c. Unit price
    d. Total
    e. Grand Total
    Sir, if a customer bought more than one drugs how do i add more field in my form to add more?
    e.g
    Name of drugs Quantity Unit Price Total
    1. Panadol 2 30 60

    Please how do I add more Drug Name, Quantity, Unit price and Total either by clicking on a button. Thanks for your usual assistance
    D
    Dirtboy
    Have you considered using a Sub-Form? If you have the main form display the customer's data (name address phone etc.), the sub-form can display the products (drugs) purchased, date purchased, order number, quantity etc.
  • Loading…
  • Loading…
  • Loading…
Top Bottom