Recent content by MajP

There are a couple tricks to do "cascading combos" in a continous form. Here is an example of the way I do it and a discussion of the other method. https://www.access-programmers.co.uk/forums/threads/cascade-combobox-on-continuous-form.330985/post-1918438...

If you get qryRank then using the wizard row headings, Customer, Order, ItemCode Column heading Rank Data is First of Pick_Bin First works because you only have one value in each row column

But as I demoed with 3 bins for Customer C it does not matter if the assumption is wrong and they have more than 2 bins.

The demo is simplistic. My assumption is that you are putting items in multiple bins for a given customer, for a given order, and for a given item The query would fail if you are putting multple items-codes in a bin, or multiple order, or multiple customer order items.

The big trick is that when form A calls PopUp using ACDIALOG code execution stops in the Form A and does not restart until PopUp closes or PopUp made Invisibile. If your OK buttons makes the PopUp invisible then code execution resumes in Form A and it can pull anything it wants off the invisible...

Regardless if 2 or more pick bins. IDCustomerIDOrder_NoItem_CodePick_Bin 1A11115 2A11119 3B22224 4B22225 5C33331 6C33333 7C33335 SalesData Need to rank the bins used as 1 and 2, 3, ... SELECT * FROM (SELECT A.CustomerID, A.Order_No, A.Item_Code, A.Pick_Bin, "BIN " &...

You would have to number the records first using a ranking query and then use a crosstab Rank A14212 19/06/2025 111 444242 5 --- 1 A14212 19/06/2025 111 444242 9 --- 2 A55545 19/06/2025 222 24242 4 --- 1 A55545...

See thread 10. Process is explained as best I can. Read steps 4 and 5.

My thought is if you really had to do this assignment by names then you can use your current data to get the best break points. This assumes if you have a large distribution of names that future names would follow that distribution. 1. Determine how many buckets you want. Maybe that is one...

@andymartin3186, On a current database I am working we have lots of large lists with lots of categories that using a standard combobox would be hard. You need lots of features to search what you want. This design gives us a lot of flexibility without a lot of code to sort filter and search...

@ClaraBarton There are several ways to pull values from a pop up. The trick is you want to have the calling form pull values and not have the called form push values. This makes the code more loosely coupled. In the trick I am doing this is how it works. 1. the calling code you open the pop...

@ClaraBarton, That code was an attempt to write a generic function that can be used most places to return a single value. This works in conjunction with a pop up that has an OK and Cancel button. The OK hides the popup and the Cancel closes it. The popup needs to be called by the function...

Isn't that just an issue of setting it from private to PublicNotCreateable So you can use it, but still not create it AFAIK. So then you can build a function in a library that creates the instance.

Not sure I even get the crosstalk idea, unless you really want columns. Assume I have my qryCertDetails above. If I Cartesian join people to certs I get a query with all people and every cert. If I left join that query to qrycertdetails by person and cert. it will form a record for every person...

I agree I do not understand that either. EmployeeTable - EmployeeID - Employee Name -Other employee fields Certification Table - Certification ID - Certification Name - other Certification Fields Employee Cert Taken Table - EmployeeID_FK ' foreign key to employee table -CertificationID_FK '...