Recent content by Truckfin

Hi, Im not too sure about the best way to update/refresh values in a field based on a lookup from a combo box. Hopefully I can explain myself clearly enough for someone to be able to help me. I have a form called FrmPlanningPositions that looks after space requirements for various...

re add hyperlink in notes Not sure if you've worked this out yet. If you are just trying to have a hyperlink within an email body take a user to a database residing on a shared drive try this: Highlight the text which is to become the link. then go to Create/Hotspot/Link hotspot and you should...

Thanks, that's it. The name of the control on my subform was defaultly name "child6" or something instead of "MySubForm". & after renaming it correctly =[Forms]![MyParentForm]![MySubForm]![MyField] works. THANKS FOR YOUR HELP!!

Hi, i'm working in access 97 and am having difficulties pulling a subtotal or referencing any fields on my subform on my main form. I've searched the forum and help and tried to apply the info provided, but i still can't seem to get it to work. as far as i can tell this should work...

Thanks Wayne! It works like a charm.

Thanks Wayne, the two values represent the number of offices to number of workstations. ie. 20 offices to 250 workstations in a building. I need a way to programmaticaly reduce the two values to a tidy ratio figure. But not sure how to go about doing this. Sorry for not giving you enough...

Thanks for that Wayne. Yeah you are right - i don't think the lcd will help me with what i want to do. Don't suppose you'd know how i'd go about calculating the ratio between 2 values to get a value1:value2. Do i just work it out as a decimal and then try and convert it back into a fraction?

Hi, I'm trying to calculate a ratio between 2 numbers. ie. find the lowest common denominator between the two values and express it like this ie. 1:2 Could someone help me out with the formula? & the best place to calculate this ie. Can I calculate this in a query? Thanks