Search results

You guys are just brilliant, thank you :) I will have a play with this later, and get back to you :) I am liking the look of arnelgp's function, as it may prove useful further down the line. Could I use this same function for an unbound combo-box to have the records appear in descending order...

I have a table which has a text field containing alpha-numeric information, simlilar to the below: 850.1 850.2 860.01 860.04 979 - A 979 - B 1001.2 1001.3 This data is historical, and cannot be changed as it is used outside the database as a reference number. What I need to do is to have a...

Given that I knew the grand total of absolutely nothing when I started visiting these forums (and was petrified to even think of VBA) the good people here have taught me massive amounts, to the point that I can now reasonably quickly knock something functional together that seems to work quite...

Very interesting - when you produce a database for a customer, do you copyright it or protect it legally? When you mention a professional installer package, I take it that will handle installing the front and back ends in suitable locations, and then linking them up?

Sounds sensible, however the error currently shows as the database is first opening, so I am extremely unsure as to how I would capture the error and populate any boolean field?

How would I be able to do that on a machine that has the runtime environment - it does not give access to any of the code?

I do seem to have a tendency to solve things whilst stuck in traffic.... or in the bath.... or in the middle of the night :D

Just got back in, and come to post exactly that - I had one of those "Ah, ya silly auld git..." moments to myself whilst sat at some traffic lights :D I should think slower, and post less.... :o Thanks

Is it possible to subtotal an unbound textbox on a report? I have a textbox which itself contains a calculation as its data source =([txtRateForYear]*52) Now, if I have a record that has that field a number of times, is there a way to have a subtotal at the end of each record, and then...

You are a genius! If I put that in a standard module, what event makes the code fire?

Thanks guys - users would be running the runtime version, and whereas most of them would have some form of Office installed, I cannot guarantee that nor can I rely on them (or our IT guys) to be able to locate this DLL and/or copy it to the correct location. Somewhat more concerning is that the...

I am having to revisit this (potentially) - I tried running the database on two machines other than my usual PC, and both chucked up an error that a reference file was missing (MSO.DLL version 2.7) - looking into the references, Microsoft Office 15.0 Object Library was marked as missing, so I...

Thanks :) It is certainly interesting - I am trying to picture in my head how I would relate that in reality. I will knock up a spreadsheet at some point over the coming days as suggested, and then I will post it back here before going any further - be interesting to see the advice on...

OK, dinner munched. Hopefully the attached map will give some idea of what I am prattling on about :D If something happened at the point where the red blob is, it could radiate back throughout the area within the red lines. The blue line represents, very roughly, the path of some routes - as...

I worded that badly when I said adjacent, as the vagaries of London means that the propagation of disruption can be really strange; I'm just about to have dinner - back soon with a better example.

:D Trust me, mediocre is what my place is good at! I am slowly trying to drag them into this century.....

I like your thinking - if I am getting you right, have the postal code areas that each route passes through noted against the route number, and then when there is disruption in that area it will lookup what the affected routes are? The only slight issue for me would be when a route is affected...

I reckon so - until another curve ball arises (which I have a feeling is in the offing with this one.....); apparently, this 'issue' has not been resolved for many, many years (20+ at least) as prior attempts to work it out have been excel based and with not an ounce of logic or finesse. I now...

It is some TfL routes, some non-TfL routes; like all public transport nowadays, the contracts to run TfL routes are awarded to private companies, hence the need to be able to vary the route numbers as contracts change. The same applies outside the London area, where we also operate. Indeed...

Doh! Yes, I do need the live employees to exclude leavers (or to include returners as sometimes happens). Works perfectly now, thank you. :)