MajP

T

• T

  Thales750

• Jun 2, 2025

I wanted to apologize for not treating you with the respect you deserve. I somehow envisioned you as a young smart aleck kid. I think maybe based on your profile photo. I saw your video on TreeView. Thank you for your service in the Marine Corp, and thank you for continuing to serve by sharing your experience with the rest of us.
Your generosity is very appreciated.

W

• W

  WSpivak

• Aug 16, 2023

Hi, thanks for sharing the getValueFromPopUp snippet. Question: I have a field, Customer, which has three alternative lookups, Name, Phone, Email.

How would I accomplish returning the Customer Number back from a single pop-up with 3 lookups (only one would return a value).

Thank you.

E

• E

  EdK

• Jan 10, 2022

Hi MajP Thanks for showing me this trick! Can I do this in about 3 hours time as I am looking after my grandkids right now and about to have dinner with them, hope that's OK, I'm really looking forward to the session (hopefully it won't be too late for you by then?) otherwise can we make it same time as this, tomorrow? Hope you are OK with this EdKM

I

• I

  Ihk

• Sep 1, 2021

Hi @MajP
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)

P

• P

  Polopudding

• Jul 26, 2021

Thank you MajP for your Date Picker selection. I'm a real novice a Access VBA but learning a bit more every day, your instructions are perfect and they got me out of a hole. Much appreciated.

I

• I

  Ihk

• Jul 1, 2021

Thank you for helping me most of the time. I posted a question, may be if you have time to help out in this post.

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

W

• W

  wikihow

• Nov 15, 2020

Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an issue. Please review the recent post, whenever you have time and let me know what is possible solution. Thanks for all your help

S

• S

  sribblett

• Sep 7, 2020

I attached my database today (9.7.20) for your review in the previous thread due to not allowing for me to upload it here.

S

• S

  sribblett

• Sep 4, 2020

I'm creating my table now. the Primary keys they are not auto number, correct? what does "indexed" mean?

S

• S

  sribblett

• Sep 4, 2020

You asked what is does Program mean. It is actually the classroom identification for that staff person. there are several staff who would not have that due to staff who do not work in a classroom or staff who are "floaters" or AN(as needed) who are not assigned to 1 particular classroom.

S

• S

  sribblett

• Sep 4, 2020

We can forget the PIR Table. this is keeping track of all staff who had been hired and left during the program year. But I will have this information one my DB is done correctly.

S

• S

  sribblett

• Sep 4, 2020

ok...I'm ready to tackle the issues with my current database. As you know there's a lot of work to be done. Where should I begin? You suggested combining some tables and changes their PK and creating FK. I'm ready whenever you are able to help me to get this done right and most effective.