theDBguy
Reaction score
6,726

Profile posts Latest activity Postings About

  • Does anyone out there have a sample of the VB code to pull data from an access 2016 form and insert that data into an existing PDF form?\

    I had been banging my head for weeks over this, i think its possible but all the code i had found doesnt work. I think as i have learned i need to export that data to an xfdf file from within access is that correct?

    any help is greatly appreciated.
    • Like
    Reactions: Johnson56565
    theDBguy
    theDBguy
    Did you already look at my PDF demos on my website? You don't have to use XFDF if you have Acrobat or another PDF creator tool available.
    can i filter listbox by both command button and search textbox
    H
    haitham Elareny
    listbox datasource based on query and used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" on testname
    but
    button1 on click List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
    button2 on click List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
    when i click button 1 .....listbox nolonger filtered by text search box
    i want to filter listbox by command button then search in listbox by textsearch
    H
    haitham Elareny
    listbox rowsource based on query in which used Like "*" & [forms]![frm1]![txtsearch].[Text] & "*" in testname field
    on load it filters listbox
    Private Sub Command2_Click()
    List0.RowSource = "SELECT tbl1.tstname FROM tbl1; "
    End Sub

    Private Sub Command3_Click()
    List0.RowSource = "SELECT tbl2.tstname2 FROM tbl2; "
    End Sub

    Private Sub txtsearch_Change()
    Me.List0.Requery
    End Sub
    H
    haitham Elareny
    i wish to help me since i was tried more
    hi.... i want to design a message box which appear from right to left on opening at bottom of screen ,then disappear from left to right on closing .i tried with
    form_load inside height=20000&inside width=0 but want to change message width from 0 to line length on opening
    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
    theDBguy
    theDBguy
    Did you get this fixed? Sorry for the delay.
    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