Search results

strFilter = strFilter & "AND [Description] Like '*" & Me.descriptionCombo & "*'"

Do what jdraw suggested - explain more or give one specific example encompassing both activity and equipment. We are still guessing what is what.

Your 2.jpg describes the physical goings on of each activity. Your 1.jpg lists stuff i'd expect to be part of a junction table, i.e there is a budget for an activity and a piece of equipment, and then there are the measured values for that activity and equipment: both go into the junction...

If each activity has an entirely disparate set of parameters you might consider this: https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model

IS your business so totally unique that nothing satisfactory exists already? Cmmercial or open source? Really? Have you scoured the net for Access templates, that perhaps cover 50 or more % of the needs and can be built upon? That is so much better, especially if you are a beginner ... Own...

Have a read: https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model

And what exactly has evidence to do with faith? There is nothing evidence-based nor rational about the issues espoused by the brigade arming themselves against the evil black helicopters.

http://www.access-programmers.co.uk/forums/showthread.php?t=268689

Begin by saying what you are trying to accomplish. Split into what exactly? Hard to guess from first glance at the code.

And here, finally, someone who can set the record straight and put women where they beling: http://biblicalgenderroles.com/ Enjoy.

@Frothingslosh: Yes I remember that Austrian pastafarian and his driver's license: http://www.bbc.com/news/world-europe-14135523 and THAT made news in our insane world! As if FSM were more idiotic than the other "faiths", which it obviously isn't.

You do not understand which words in: "It has to be in the subreport's On Format event"

which On Format? It has to be in the subreport's On Format event And btw: for ever skip "doesn't work" the most useless phrase. See my signature.

Don't get surprised if you get new surprises. Reports have their own outlook on things and do not follow the ordering set in SQL. Follow MarkK's advice to be sure.

Try it in On Format

@Libre Thanks man. Will have to see what God has to say about The Flying Spaghetti Monster and especially Russel's Teapot (..." between the Earth and Mars there is a china teapot revolving about the sun in an elliptical orbit").

How about explaining what "stock number" and "stock detail of stock number" are

Am still waiting for a posting from the almighty on Facebook and also on her 1-800 number. Don't be shy!

It seems a many-to-many would be in order. tblLeases ---------- LeaseID CustomerID TruckID FromDate ToDate would formally store the information about each truck on the most essential level. Instead CustomerID you could have a LeaseAgreementID - encompassing more than one truck and also the...

",0"? So how is it supposed to store the decimal?