Search results

I am at the very early stages of designing some sort of solution to replace some inherited Excel files that are neither secure or user-friendly. One part of these files is worksheets that are essentially just a series of hyperlinks that link out to documents stored on a network drive. I am...

Would all of the text boxes etc need to be in the footer too? They are currently in the header.

The code on format would be ideal - I am assuming that would be something along the lines of: me.something.visble= (len(me.textbox & vbNullstring)>0) If so, what would the 'something' be?

Is there a way to hide an entire group, and not have empty space left, if the textboxes (or at least one of them) is empty?

Thank you both :) I was looking at it the wrong way, and hadn't even considered using grouping - works perfectly now.

Apologies I have not been back to this, I have been snowed under at work. Also, apologies if there was any inference that this post was somehow verified or approved by the moderation/admin team, as that was not my intention - I wished to merely pass my thanks to the site admin for allowing me...

I have a report which has information set out in groups, with some fixed page breaks entered where I need them. However, on occasion, the information that is shown on the report may be such that it rolls over to another page, which means that the group is split between the two. Is there any...

OK - it is a mock up, but pretty much the layout that the final report must have. The section for 'Stands' is repeated again and again for the various stands that may be available along the route - for long routes, there can be a good few of these.

OK, I would have posted a sample had I remembered to pick up my USB stick from my desk.... doh! I will try and knock something up in Word now, and post back shortly

Not all are on streets, no, and there is a standard set of information. Wen I get home later, I will post up some of the information that will give you an idea what the final document needs to look like. I think that the way you are putting it though, would be ideal and possibly covered by the...

Sadly, all the heavy regulation only relates to the legal and structured side of things; we cannot legislate for the hundreds of variables such as accidents, emergencies, roadworks, delivery lorries, stupidly parked vehicles.....) - this is made all the harder when the buses are scheduled...

There are a number of legal constraints and obligations that we have to comply with, many of them are quite archaic in their methods, but they are here to stay I'm afraid - one of those legal obligations is that we must have declared documentation that shows exactly which streets/roads are...

Thanks :) I have a funny feeling that I am going to have to have some duplication of data, purely to store the historical stuff; bit of a pain in the rear, but sadly quite endemic in my industry.

I will try, although it may not make a lot of sense to someone outside my industry. We operate bus and coach services via numerous different routings; legally, we have to issue a document which shows all of the information recorded above. The information can, and is modified from time to...

I am starting a fresh database, and in comparison to the last time I commenced a project like this, I am a little bit less 'green' - so, rather than work around a structure that is OK but not ideal, I would like to try and get the structure right from the start, and to do so I could do with some...

Another fair point, and sadly one that I do not have any way of offering you proof - not least as the elderly couple concerned do not know about the money being raised yet; the intention is to raise the money and then hand it over. I'm afraid that your decision whether to support or not will...

Up to £175 now :)

Fair point, and for what it is worth I agree that there is quite a lot of reliance on charity nowadays, however I hope you will understand my reasons for trying and for having a bit of sympathy in this case. EDIT - £155 and rising :)

Today, it became abundantly clear that there is a need in my new role for a database of some form or other - - there is a degree of disarray in some areas that I can see where a database would help. However, as I am at the start, I am aware that getting the right structure for tables/queries...

BACK STORY - please go to post 2 if you don't want to know :D After approximately 10 years in the same role, being in charge of the same department, the time came for me to move on. Initially, I was looking at going back to the 'shop floor' which would have removed me completely from any...