arnelgp

O

• O

  Odeh Naber

• Tuesday at 1:21 PM

Hi Arnelgp! You are king! Thanks again for the help!
Your solution to my previous thread (checkboxes) will be implemented into this project soon

O

• O

  Odeh Naber

• Oct 25, 2024

Hi, Arnelgp! Best greetings from Portugal!
You are fantastic! Thank you for your help!
Thank you!

1

• 1

  113hans

• Jan 3, 2024

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

1

• 1

  113hans

• Dec 25, 2023

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.

K

• K

  Kamayo Ako

• Jan 11, 2023

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

• R

  Rupeshns03

• Jun 11, 2022

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

• I

  Ihk

• Apr 14, 2022

If you have time, will be nice to help me, I have attached sample db.
Send current Form record in Email body | Access World Forums (access-programmers.co.uk)

I

• I

  Ihk

• Nov 14, 2021

Dear arnelgp,
sorry to bother you, may be you can help me like always. thank you.
Users password encryption in users table in MS Access - multiuser system | Access World Forums (access-programmers.co.uk)

R

• R

  Rania01

• Nov 6, 2021

Dear arnelgp,

Thank you for your help, is working well done

F

• F

  Futurz

• Oct 18, 2021

Hi @ arnelgp,
i have a query subject "excel vba vlookup multiple values" could you please reply a solution...
thanks,

I

• I

  Ihk

• Sep 1, 2021

Hi @arnelgp , I am grateful you always helped me. If you have time I need your expert opinion on following thread, Please take a look. Thank you
Splitting QR code information into different controls | Access World Forums (access-programmers.co.uk)

I

• I

  Ihk

• Jul 1, 2021

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

• H

  hatmak

• May 29, 2021

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!

H

• H

  haitham Elareny

• Apr 18, 2021

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

H

• H

  haitham Elareny

• Apr 16, 2021

can you help me to modify that database

• 

  conception_native_0123

• Apr 11, 2021

thank you for pointing out that that helped me. it was obvious but i made a mistake.

• 

  GaDauBac

• Mar 28, 2021

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

• I

  Ihk

• Jun 30, 2020

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

• B

  BGIBERT

• Jun 29, 2020

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

M

• M

  musmoniem

• May 2, 2020

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