Replies

Thanks for all of you responses it was the Kelly’s site that I had visions of someone posting before and it worked a treat

Steve

Thanks for the response Hans

From within control panel nothing happens when I click the icon for the taskbar, I have followed the advice from ‘Leo’ in your link but none of these help. I do remember sometime last year that a similar question was asked and somebody posted a link to a program that could recover the taskbar but searching in the lounge and on google has not yet produced any results.

I thought perhaps a system rollback might help but when I press F1 and type rollback into the search box it just seems to explain about removing new devices or software.

Thanks anyway

Steve

I am sorry I did not realise there was more than one taskbar on windows 2003, the one that has gone is the one that usually says start on it so that you can access your files etc., also I ment to say control panel and not control manager

Thanks

Hi Rupert,

Thanks for the further information.

Many years ago the airlines realised that companies sending a ton of pillows taking up a lot of space were paying the same rates as a company that was exporting say a ton of lead, taking up a small amount of space.

Together they came up with the formula that 6000 cubic centimetres would be equal to 1 kilo, this is true through most of the world except most African carriers that use 5000 cc = 1 kilo. If the dimensions are input in inches the formula is 366 cubic inches = 1 kilo, although people rarely use inches these days.

Thanks again

Steve

Hi Lorraine,

Thanks for the response.

There is no limit to the number of boxes that we can receive. Imagine that you are moving home and have ‘scavenged’ all of your packing boxes from local stores, it is probable that none of them will be a standard size and you could end up with dozens of different dimensions. In reality over many years in my experience there will probably be a maximum of about 15 different sizes.

I am trying to get my head around Ruperts explanation at the moment, very very slowly.

Thanks again

Steve

Hi Rupert,

Thanks for taking so much time for the answer and the example, I was out yesterday so I will take a look today.

Thanks once again

Steve

I pushed F1 (help) on the input mask box and got these, the 9 or the # look promising but I have not tried them.

0 = Digit (0 to 9, entry required, plus [+] and minus [

Thanks for the prompt response, I will start researching as suggested

Steve

Hi Charlotte,

I can’t remember the name of the thread but my basic post was that I had 4 fields on a form pieces, pieces1, pieces2 and pieces3. Pieces3 takes its value form the other 3 (pieces+pieces1+pieces2) I then wanted pieces3 to compare its total to another field TotalPieces. I had tried myself and come up with

Private Sub Pieces3_Exit(Cancel As Integer)
If [Pieces3] [TotalPieces] Then MsgBox “You Have Entered The Wrong Number Of Pieces”, vbOKOnly, “Number Miscount”
End Sub

Which puts the error message up whether the calculation inputs too many, too few or the right amount of pieces.

Mark replied to say he was not flaming but this was against general normalization rules to have pieces, pieces1 etc.

I responded and said that I realised this but on a form I have, people need to calculate the dimensions of an assortment of packages where all the dimensions could differ, to allow for this I have made 3 lines on which they can calculate and store the value on the form. The 3 lines are Length, Width, Height, Pieces (then each followed by 1 Length1 etc, and then followed by 2 for the next line). This calculates the volume fine but I just need to make sure they have calculated it against the right number of pieces.

I have searched all through but can’t find the thread anywhere?

Thanks

Steve (PS. The pop up Lex is neat)

Hi Wendell?

That did not work, the field returned a balnk value, perhaps I am being thick. As the box is taking its value from another source I would not have thought that there would be an AfterUpdate event? When I switch back to OnEnter it determines which is the greater value ActualWeight or VolumeWeight and then uses it, all I want to do then is make this field un changeable.

Cheers

Steve

Thanks Rory that is perfect as is.

Steve

Maybe I have confused you, put simply all I want to do is have a combo box remember a value once it has been entered. If a new form is opened the combo will still have thats value among its stored entries so the user just has to select it from the drop down.

Initially I made tables such as CartonID, CartonType but this would not let me change the property from Yes to No because it says the first field property cannot be 0 (when I set up the combo I ask the lookup to hide the Primary Key so I get 0″;1″). I then deleted all the Primary Keys and made the actual item (for example CartonType) as the primary key, because these values would always be unique I did not see a problem with that. I can now set the property to No and I can type in any value I want but it does not save it.

Hope this explains better, thanks so far.

Steve

The reason I put it there was because I didn’t have a ******* clue were else to put it and it seemed logical to me that if the box was taking its value from 2 other fields it should find / calculate the value as it entered the box. I am currently (1200 Saturday) sitting in an internet pub in Singapore, if I am still sober (I doubt it) when I get home I will try your suggestion, thanks.

Steve

Hi Rory,

I have a job sheet form that people need to enter information into all day, a number of the fields contain 1 line entries, I originally considered setting up tables such as employee’s names, carton type etc. etc. but in other posts I have seen here it is encouraged to have many tables but discouraged to have them with just 1 field.

I then thought that if I had a combo box that automatically stored new unique records it would do the trick. I know how to leave form 1, make a new reocrd in a form 2, return and use the information in form 1 but this would be cumbersome with the amount I am talking about.

Somebody with heaps more knowledge than me just said “Recursive Join” but would not elaborate at all.

Thanks for any help

Steve

Hey, I can’t believe it, I managed to figure it out myself. I shall print out and frame these famous first 2 lines for prosperity. I don’t know if it was good for my laptop because it went to ‘sleep’, I however in true male tradition laid back on bed and had a cigarette.

One thing I still need help on though is how to stop the user going into the field. Because I have made my if statement in the ‘OnEnter’ event I cannot set the tab stop to No. Any ideas please.

Thanks

Steve