Search results

@plog your method worked perfectly. I brought in the WEIGHTS Table twice and Joined like this

Ok I'll try it and update everyone. But yes thinking about it, makes sense.

Okay, let's take a step back. Production shown in #5 is not the table it's a query and the field WEIGHTID is generated by the IIF Statement. The Production Table doesn't have a WEIGHTID Field. Joining on PRODUCTION.WEIGHTID means that I need to make a query (qryPRO) with the Production Table...

I'm just pulled out the relevant data because I'm dealing with a huge, I mean HUGE, dataset. The main tables are PROBRC and WEIGHTS.

On the Production query, WEIGHTSID has the IIF Statement. That's how the WEIGHTSID is being generated on the Production Query.

I don't see how to differentiate it anymore but here's a sample of the data

Sometimes I find myself making one or two additional queries before I can get the join I need. I have this sql called PROSOURCE that generates the WEIGHTID for me SELECT COSTCENTRE.CCID, PROBRC.PDATE, PROBRC.QTYP, PROBRC.DIMENEXT...

Just want to keep this thread alive. Haven't found a solution as yet and have exhausted my google searches, or maybe I'm not searching the right keywords. @isladogs @arnelgp

I'm reading this thread and having the same problem on Windows 11. https://www.access-programmers.co.uk/forums/threads/accdb-webbrowser-and-acropdf-pdf-viewer.313660/ Can anyone help with an update to the .reg file because I tried it and it did not work.

Yes it can be problematic @MajP and so far @CJ_London method in my opinion, is the best solution. I often use that together with your FAYT class module in my form designs. the op can also look at this...

If I'm reading this right you want to cascade the combobox based on a textbox in the form's header (the logical place to put said textbox, in a continuous form design)?

Nice. Thanks (y) So much work to get this functionality. It should be included in the properties window. 🤷‍♂️

But what about if the query is filtered? The Conditional Formatting wont work.

Ok cool, thanks.

Getting the alternate row color is easy enough but how do you get alternate row text color?

Thanks everyone. I decided to give up on editing the data simultaneously and schedule updates until I can get IT to set up both PCs on the same network.

Thanks @CJ_London this solution is so simple I feel like an idiot. Had no idea you could make joins like this b.class=a.class+1

I'm trying to follow Allen Brown's method as seen here http://allenbrowne.com/ser-58.html to convert a single range to Min and Max Values This is the Table +----------+-------+------------+ | SDate | Class | Range | +----------+-------+------------+ | 3-Mar-14 | 1 | 780.00 | |...

Yeah I know but because of the Security setup on the PCs, options are limited.

Is it possible to edit records from outside a database via Excel. Here's the situation. My co-worker has a Database saved in her OneDrive the problem is that, if I want to edit records I will need to download the database, make changes and reupload. If I do that while she is adding records all...