Search results

Ah i see it now thanks again

Wow....exactly what i was looking for thank you ! Just one question, where does that code go ?. I've checked your sample file and can't see it anywhere. I can't see any modules in the Navigation Pane either ? I'll give it a go and see i f i can get it working. Thanks again

Thanks for the suggestions. I intend to just put the pics in a folder called Images (same folder where the database will live)

Hi All, I have a form with five Txt Box controls and an Image Control. I've also got five images (Pic1, Pic2, Pic3, Pic4 and Pic5). Is it possible to make Pic1 appear in the Image Control when i click into Txt Box 1 and Pic2 appear when i click in Txt Box 2 etc ? So i need Pic1 to appear when...

I just rechecked the formula and the = sign wasn't there. I can't believe i did that Thanks a lot CJ :)

Sorry it wouldn't let me attach the actual spreadsheet.

Hi All, I'm trying to create a formula in Excel to display information. Basically there are 10 cells and you can select from 3 options the text you'd like to appear in that cell. I'd like a value to appear to the right, displaying what percentage of each option has been selected (You'll see...

Sorry arnel my mistake. I forgot to add the little bit of code to the BeforeInsert event of the subform. Working fine and thanks a lot for your help Em x

It seems to be working fine arnel thank you. I have one question.....if i don't enter any information into the parent form and go straight to the subform, it will accept information and then let me save it. Can this be prevented ?

Thanks for the suggestions guys. Ranman.....where do i put this code to get it to work ?

Hi All, I've Googled this to death and found one or two solution suggestions but they don't work for me. If i have a parent form called frm_Main and a SubForm called frmDetails, is it possible to keep frmDetails locked until the four fields on the parent form are filled in ?. By locked i mean...

Thanks lads. I changed the table field to Double and reset the code into the AfterUpdate event and all's well again. Appreciate the help as always Em x

Hi All, I've got a database for entering maintenance information about various machinery. On the data entry form, i have a combo box which has several columns and i've used some code in the OnChange event of the combo box to populate other text boxes on the form when i make a selection to...

Thank you guys it's now working just right. Appreciate your help Em x

Easy for you to say Mr Doc Man but i'm none the wiser 😊

Hi again all......i'm a little disappointed i couldn't work this one out. I've got a form with a combo box (cboPaper) and a text box (txtPaperValue). The combo box allows you to either select Yes or No. If the User selects Yes i'd like the value 0 to appear in the txt box...but if the User...

That's working fine now...thanks arnel. Thank you everyone for the great suggestions and your time. I appreciate it as always Em xx

Ok my Flash Point field is Number, Field Size is Double and Format is General Number. The expression in the report i'm using is =Nz([FlashPoint(C°)],99999). I've attached a screenshot of how the flash point part of the report is filtered

Hi....sorry guys i was away for a couple of days. I know i said Melting Point in the OP but it should have been Flash Point........doesn't make much difference but i apologise anyway. I already had a report deigned for this so i thought the best option would be to add the expression to the...

Hi All, I have a database which deals with various chemicals. I want to print a report listing all the chemicals in the database but need to put the chemicals with the lowest melting point at the top of the report. My problem is that some chemicals have no melting point and the field is just...