arnelgp

arnelgp

..forever waiting... waiting for jellybean!
Joined
Last seen
Viewing latest content
Messages
19,463
Solutions
13
Reaction score
3,441
Points
113

Profile posts Latest activity Postings About

  • 1
    Hi @arnelgp, I find your help for @Mercy Mercy here

    Solved - Print selected invoice

    Hello everyone. I have a slight problem. The following code does not fire to print selected records in invoice. It is supposed to filter the selected records and the studentID Private Sub Command48_Click() Dim sFilter As String On Error Resume NextDoCmd.CLOSE acReport, "INVOICE" sFilter =...
    www.access-programmers.co.uk
    • Like
    Reactions: AccessBlaster
    View previous comments…
    1
    113hans
    Sorry, I don't have permission to write more than 420 characters, so I reduced my message to small parts, sorry If this bothers you.
    Gasman
    Gasman
    PMFJI,
    You should start a new thread. :(

    However look at the WHERE parameter of the OpenReport command.
    1
    113hans
    I will post a new thread, thank you for your attention.
    1
    Dear arnelgp, warm wishes to you on the Christmas!
    I was lucky to have you help me 2 years ago.
    Now I posted the subject

    Help with creating a button to export PDF file

    Hi guys, wish you all a merry Christmas! I know on the Print Preview, we can create a PDF file through right click and choose "Export". But on the Table, I wonder can we make 1 button which automatically does 2 things: 1. Exports the PDF file to a folder on our PC 2. Names the exported file...
    www.access-programmers.co.uk
    Click to expand...
    Hope you read this and give me a hand, thank sir.
    arnelgp
    arnelgp
    if you can "show" the supposed pdf to create (what info is in the pdf).
    also can you post a sample db with same table you want to create pdf, individually.
    1
    113hans
    Here my sample db, thank you for your attention.
    1
    113hans
    I mean I posted on the thread

    Help with creating a button to export PDF file

    Hi guys, wish you all a merry Christmas! I know on the Print Preview, we can create a PDF file through right click and choose "Export". But on the Table, I wonder can we make 1 button which automatically does 2 things: 1. Exports the PDF file to a folder on our PC 2. Names the exported file...
    www.access-programmers.co.uk
    K
    Hi sir arnelgp,

    I have tblStocks

    Table Entry
    StockID-0001
    ItemDescription-Boy Bawang
    InStock-20


    Stock Form

    Stock ID - 0001
    Description - Boy Bawang In Stock - 20

    I want to Display the following

    Minimum Stocks (3 months)=
    Actuall Consumptions( 3 months) =
    Average Monthly Consumptions =


    Thank you so much sir for your support
    R
    Hi arnelgp,
    How could I copy and paste all records from one table to another.? yesterday, you helped me with resetting HSE incident count. After I having it done, the orginal table need to updated. If I have to use update the records, what shall be the parameter? Alternatively, is there any way where I can copy all records and paste into original table, using a macro or query?
    I
    View previous comments…
    Gasman
    Gasman
    @lhk You do realise these conversations are not private?
    I
    Ihk
    Yes I agree, but this was specefic to arnelgp, because discussion was on his vba module. I did not want to get unnecessary involved every body.
    isladogs
    isladogs
    If it was specific to arnelgp, why send the same message to moke123 & myself?
    Notice that, until now, none of us responded here.
    Personally, I'd recommend using a private message AKA conversation instead
    F
    Hi @ arnelgp,
    i have a query subject "excel vba vlookup multiple values" could you please reply a solution...
    thanks,
    Gasman
    Gasman
    Just post to the correct subsection, and allow others to help. Arnel will pick it up as will any others.
    I
    Hi @arnelgp , thank you for helping me most of the times. I posted question, may be if you have time to help me out there..

    Solved - Combo list item wont show up immediately in a navigation form

    I have navigation form with different tabs. One of tab is connected to a form “FormA” and this form has a combobox with limit to list items. This combobox list items are sourced from a table. But infront of this combox is button to pop up a form “AddTypeForm”, by this user can add more items...
    www.access-programmers.co.uk
    H
    hi arnelgp

    still I need your help in my post

    ranking with many condition

    good day for all please help in following In company we have a lot of employee Company make summer resort to many place Like place 1 ,place 2, place 3… And we want to get ranking for each employee depend on many rules If many employee select place1 and group1 I want ranking employees...
    www.access-programmers.co.uk

    please check ranking serial

    is not correct

    thanks for you help!
    View previous comments…
    arnelgp
    arnelgp
    I already given you two examples.
    you ask other people in the forum.
    I already done my part.
    • Like
    Reactions: hatmak
    H
    hatmak
    thank u for reply
    when I filter data
    rank not change as filter
    look like
    1
    2
    4

    number 4 should be 3

    do u understand me
    thank u again
    H
    hatmak
    please try to change filter and see ranking
    H
    hi..i want to design a message which appear from right to left at bottom of screen on opening then disappear from left to right on closing .i tried using inside height
    GaDauBac
    Hello!
    You can make changes to the [Maintenance Date] field once a month until the Departure Date does not change.
    This means it changes once a month.
    For example:
    - OutOfDate = 27/3/2021
    - Maintenance date = 27/4/2021
    Then 1 month Maintenance Day = 27/5/2021
    If OutOfDate = Current date will not change
    At stops: - MaintenanceDate = OutOfDate
    Thank you!
    I
    Hi @arnelgp
    If you have time, I have posted a thread regarding "current active user". Please have a look.

    Highlight currently logged users in access / Mark user as active at the moment

    Hi, I have multiple user login based access database. There is table with name""UsersActivity". I created a form based on this table. I want to highlight users whose status is still logged in but not logged out yet from the the database. There are three fields in form (taken from table), and a...
    www.access-programmers.co.uk
    Many thanks
    B
    Yesterday you provided the SQL
    select id, invoice, dcount("1", "yourTableName", "ID <= " & [ID]) As Sequence, Status from yourTableName Order By id Asc;
    I do not have an ID value. To simplify, assume a table of only invoice numbers with duplicates. How would I change your SQL to:
    1) get a sequential number for each record
    2) get a subset of sequential numbers by the invoice number
    isladogs
    isladogs
    @BGIBERT
    You should ask this question in the forum thread where you are more likely to get a quick answer
    M
    hello .. hope you are fine
    i need to make a list box field in an access table its value depends on the value of another list box >>
    Example a field2 is a list box its values appears depends on the value i chosen from field1 list box ,, so
    i made a table for field1 values and another table for values of each value in field1
    how could i control it
    E
    Hi, Arnelgp. 2or 3 years ago you supplied me with vba.accdb that included basBrowse and basSelected so that my FE would run on Access 64-bit computers. That user left but now have 2 new users with 64-bit Access installed. Neither can open the FE--getting error#7960. The only code changes (other than cosmetic) is that the distributed FE is now done on my installed Office 365 Access.

    I don't have another computer on which to install a 64-bit version for debugging purposes, so one other probably dumb question: can I set up a VM and install it there?
  • Loading…
  • Loading…
  • Loading…
Back
Top Bottom