Search results

  1. V

    Combo box currency formatting

    Nop that is not it. The combo box is putting it into 2 columns. So something to do with the comma in the fomatted £1,000?
  2. V

    Combo box currency formatting

    I have 1 text box and one combo box I want the combo box row source to be equal to the text box value So in the got focus event of the combo box i put in the code Invoice_Amount.RowSourceType = "Value List" Invoice_Amount.RowSource = Format(Nz(Cost), "Currency") where cost is the name of...
  3. V

    Form Module Visible Yes/No Question

    When code is running in the module it cannot reference a control on a form unless you either send the form and/or control as a parameter with the function call and then reference it... http://www.access-programmers.co.uk/forums/showthread.php?p=977641#post977641 Or you reference it with full...
  4. V

    Lookup values and write in a Table

    I am not an expert in this stuff but i will help you if i can. You need to enter a value into a text box on a form, have a query triggered by a command button use that value to write that value and others (filtered by that value?) onto a table, is that correct?
  5. V

    Using combo boxes with settings table

    Will have a look into that, thanks again for your help.
  6. V

    NEED HELP PLSSSS Main Form to Popup Form Problem

    The attached db illustrates how to link the zoombox to a form textbox via a command button. So if you do not want to see the textbox then just make it very small and set 'visible' property to No. The code in the ZoomBox upgraded is such that when the form closes it triggers a 'If form.dirty...
  7. V

    NEED HELP PLSSSS Main Form to Popup Form Problem

    By far the simplest solution me thinks is to have a hidden textbox on your form (very small below your button for example) and then call the zoombox with your button and telling it to link to that textbox like on the zoombox sample. To get the textbox to be hidden just set the textbox...
  8. V

    Using combo boxes with settings table

    Yes I think i understand you now.... It is not possible to have multiple combos set to the same control source and expect to see different rows on the one form. So the only solution is to have the settings table have different settings fields to accommodate the combos I ended up with a...
  9. V

    Using combo boxes with settings table

    Thanks for that but i am not sure i am meaning the same thing. I think i am wanting to do the impossible. I am wanting to have multiple combo boxes on a form and have them bound to different records/rows on the same table. The combo boxes have simple row source value lists. As far as i can...
  10. V

    NEED HELP PLSSSS Main Form to Popup Form Problem

    Do you mean how to get the text from the textbox on the calling form to the textbox on the zoombox form and back again?
  11. V

    Age/Year

    O yea! lol OK what about... Create a hidden text box on your form called [FatherYearOfBirth] Create a new field in relevant table with similar name and bind textbox to it. then when calculating age in combobox If [FathersAge] > 1000 And [FathersAge] < 3000 then [FathersYearOfBirth] =...
  12. V

    Age/Year

    The previous code works fine as long as names are correct as per your textbox
  13. V

    Age/Year

    On the afterupdate event of textbox something like.. If [FathersAge] > 1000 And [FathersAge] < 3000 then [FathersAge] = DatePart ("yyyy", Date) - FathersAge Else [FathersAge] = [FathersAge] End if *Untested
  14. V

    Age/Year

    O right he wants it all to happen from one text box, apologies.
  15. V

    Age/Year

    Make a combo box and then in the 'on focus' event put in this code where AgeToday is the name of the combo box and DateOfBirth is the text box where date of birth is input. If there is a value in the DAteOfBirth textbox then a calculation of age will appear in the combo box or else you can just...
  16. V

    NEED HELP PLSSSS Main Form to Popup Form Problem

    You could try a variation on this: http://www.access-programmers.co.uk/forums/showthread.php?t=139266 Maybe use a update sql string to insert notes into your desired table. Or if the 1st form is to stay open then just insert the notes text from the pop up into the desired field in the 1st...
  17. V

    Using combo boxes with settings table

    That is the bit i don't understand. How to have 2 combo boxes bound to different control sources but still accessing the one field. Are you not bound by what record source the form is set to? The only way i can work out how to get round this is to put each combo box in a different subform so...
  18. V

    Using combo boxes with settings table

    Hi all, Is it possible to have 2 combo boxes on the one form having the same table field control source but be looking at different rows? I am using the combo boxes to look up setting value in a 'settings' table which has a fields like this: SettingID SettingName...
  19. V

    Ordering a report on function return string

    Thanks for the help! Managed to get it working. If you extract part of the string and then put it in a query field and then try to set ascending then it won't work but if you set orderby in the query settings it seems to be ok with it. But i found that the better way was to extract the date...
  20. V

    Ordering a report on function return string

    Hi all, Is it possible to order a report based on a field which has a long string value which has been returned from a function? The function returns a date along with information relevant to that date as a string. Is it possible to extract the date i.e. left(strReturn,9) and then order by...
Back
Top Bottom