Search results

From the highway code site it appears that both % and 1 in x nomlecatures are acceptable. I think this is backward compatability and all new signs will be in percentage with some old sinage in obscure places still giving the 1 in 10 or whatever. It is certainly a very longh time since I saw a...

Len, Almost! In the UK there are signs for steep hills are a red warning triangle with a black triangle inside that slopes down to the right, indicating steep hill downwards and the opposite indicating a steep hill upwards (a triangle sloping up from the right). Of course, you are likely to...

I just found the same site checking this out myself. :o Apologies to all those in whom I have planted a false idea. The original explanation given is correct: Units of rise over one hundred horizontal units gives the percentage, thus 1 in 10 would give 10 rise over 100 along = 10% A 100%...

Hi MStCyr, Thanks for the response. It wasn't really an active thread so I didn't expect anything immediately. I have been further messing around with this and searching the forum. For one of my uses (ranking personnel for telephone listing etc) the number is meaningless so I can simly not...

Thanks Guys, I have checked out Steve Lebans site and the latest version of the utility supports using a bitmap as the background. :) This may be in the version that GHudson posted as there are some mentions of bitmaps in the code. http://www.lebans.com/changemdibackground.htm Anyway, if I...

Matt, I thought it was a percentage of the 90 degrees between horizontal and vertical. Thus a 0% 'hill' is a flat road and a 100% 'hill' is a vertical cliff. A 60% hill means you are ascending or descending more than you are traveling horizontally and a 40% hill would be the other way round...

Thanks for the replies Gents. Ted, I am using the DoCmd.RunCommand acCmdAppMinimize to minimize the whole application rather than just the form the button is on. I think docmd.minimize will just minimize the form it is on. ghudson, Thanks for the link. This site explains what the AcComands...

A possibly apocryphal story about the construction of the Nuclear Power station at Hartlepool in the UK. The designs were American and so had to be converted in to metric units for construction in the UK. This was around the time of metrication in the Uk and so not everyone knew that an inch...

Hi Folks, Is there anywhere in help that describes acCommands in detail. Clicking F1 while an AcCommand is highlighted only gets you into the 'Microsoft Access Constants' listing where you can find the constant value but not what the comand actually does. eg: acCmdAppMinimize 11 This...

A couple more shortcuts to add to the list: Properties & methods: Edit/Lists/Properties & Methods Ctrl+J Constants: Edit/List/Constants Ctrl+Shift+J Hope this is of some help.

Awesome! Hi MStCyr, Very impressed and I intend to implement something based on this in my DB. The twist is that I want to be able to reset the numbers in the order list on the click of a button so that the order runs from 1 onwards sequentially. Thus, If there are any gaps in the list they...

Hi ssmith, I think your text box is highlighted as it has the focus. Try changing the fromat to flat. I will have a play about and see if anything else comes to mind.

If me.option1.fontbold = false then Me.Option1.FontBold = True end if Hi, My switchboard labels use a function to bold them on mouse over that I got from this forum. I wanted to use the fontbold = false to get rid of the annoying flicker but I am having difficulty referencing the labels. I...

Hi Ssmith, Could you post a screenshot showing the problem as a .jpg or similar. My office PC can't read your html. Regards

This thread offers links to information on resizing forms in relation to screen resolution. http://www.access-programmers.co.uk/forums/showthread.php?t=107070&highlight=screen+resolution

You're welcome Hawksesm. Enjoy the forum.

Hi, I had the same request a few months ago. Check out this thread. http://www.access-programmers.co.uk/forums/showthread.php?t=108451&highlight=find All my find searches, either from the find button or the control+F give the criteria set to 'any part of field' which suits my users. Hope...

Hi SheaLea, To stop the warning messages, use docmd.set warnings = false at the beginning of your code and docmd.setwarnings = true at the end of your code and in the error trap. Depending on the situation, you may be able to use echo off to stop any repainting then echo on after your code...

TWIPs verses resolution Bob, Thanks for the opinion. I think that trial and error is the most obvious way to go. I'll test my db on the best and worst case scenarios and tweak until it is viewable on both. Long time ago I did see something on the forum regarding zooming for different...

DJohnson, I'm not sure that the link ShaneMan posted is actually what you are asking for. If it is, sorry for posting and possibly confusing things. here is how I would takle your problem. If your employees table does not have a primary key, go back to it and set one now. Add a field called...