Search results

Thanks for that JHB. I've already done that a few times, but I no longer have MSA 2003. I don't know how to build ribbons.

I hope I'm in the right forum. I created a database in Access 2003 with a number of customised drop down menus-easy. However, I had to convert it to Access 2007. If I click on 'Add Ins' it shows them no problem. Now I have had to modify the database and I need to add some stuff to the...

COMPLAINTS TO COUNCILS IN BRITAIN For some, the art of letter writing is a skill never mastered. The following are extracts from various complaints and requests made by tenants who fall into that category... - It's the dog's mess that I find hard to swallow. - I want some repairs done to my...

Dennis Penberthy, an elderly Cornish farmer, received a letter from the Department for Work & Pensions, stating that they suspected he was not paying his employees enough and they would send an inspector to interview them. On the appointed day, the inspector turned up. "Tell me about your...

Wiremu, a New Zealander, was in Australia to watch the upcoming Rugby World Cup and was not feeling well, so he decided to see a doctor. "Hey doc, I dun't feel so good, eh" said Wiremu. The doctor gave him a thorough examination and informed Wiremu that he had long existing and advanced...

A rich man living in Darwin decided that he wanted to throw a party and invited all of his buddies and neighbours. He also invited Geoffrey, the only aboriginal in the neighbourhood. He held the party around the pool in the backyard of his mansion. Everyone was having a good time drinking...

I'm having a real problem here and I can't work out why. I have an access database in which I can assemble a lot of maintenance tasks. What I do then is to send them to Word to create a document. Every thing works well until I try to insert a pagebreak. I'm using a word template that has a...

Paddy is passing by Mick's hay shed one day when through a gap in the door he sees Mick doing a slow and sensual striptease in front of an old red Massey Ferguson. Buttocks clenched he performs a slow pirouette and gently slides off first the right welly, followed by the left. He then hunches...

An Oldie but baddie - Groan Far away in the tropical waters of the Caribbean, two prawns were swimming around in the sea, one called Justin and the other called Christian. The prawns were constantly being harassed and threatened by sharks that inhabited the area. Finally one day Justin said to...

Hi Uncle Gizmo, thanks for your reply. Yes, I've tried using some error trapping (see Below) but it comes up with the same message plus the id of 462 (very helpfull) Select Case Err Case 4605 Selection.InsertBreak Type:=wdPageBreak Selection.MoveDown Unit:=wdLine, Count:=1...

Hi, I have a problem that is causing me extreme frustration so I hope someone can help me. I have created a maintenance database program that selects a number of maintenance tasks, groups them and then creates a word document with them. It works great.... until I start adding tables to put the...

Thanks stopher You are right.. I'm so stupid, why didn't I think of that? In fact it is so bloody obvious, I'm ashamed I never thought of it... thanks again

Hi Bodisathva I used your suggestion about arrays and it worked... The result is not elegant, but as I said, it works. - Thanks If you are interested this is what I'm trying to do... I'm writing a maintenance program and part of it is to transfer data from an equipment hierarchy of seven...

Thanks Bodisathava, I'll try that

Hi, I'm hoping someone can help with this. I've declared a number of variables ie. gintE1, gintE2, gintE3, etc These variables hold a number, depending on a default setting. They might be 4 or 3 or 5 What I'm trying to do is use these variables to fill another variable ie. For x= 1 to 3...

I Like this one - it's a bit long, but worth it. A Wealthy old lady decides to go on a photo safari in Africa , taking her faithful aged poodle named Cuddles, along for the company. One day the poodle starts chasing butterflies and before long, Cuddles discovers that he's lost.. Wandering...

I agree, but for a simple IIF(IsNull(field),do this,do that) it is far easier than If Isnull(field) then do this Else do that endif don't you think

The 'Case Select' statement is the best, it's faster and more versatile that the 'If Then ElseIf Endif'. However I believe there is a case for using the IIF function in VBA, especially if you only need two or three results.

Have you tried using the IIF statement. ie IIF( test,true,false)

Access has a problem with dates. Most of the time it references the American format. So you have to convert your dates to the American way... (Load of bollocks to my way of thinking.) The other option you have on a different PC is to change the time/date settings from the control panel. HTH