Search results

  1. I

    Create table -> Numeric fields

    It works. Thanks!!!
  2. I

    Create table -> Numeric fields

    Thanks, but this isn't possible. I need to do it in a SQL-statement.
  3. I

    Create table -> Numeric fields

    Round() doesn't seem to work in access 97.
  4. I

    Create table -> Numeric fields

    I have a table with some numeric fields with property double precision with 2 decimals. When using a table create query the property in the new table is double precision with automatic decimals. Now 3,40 becomes 3,40335162067604. How can I prevent this from happening?
  5. I

    activeX webbrowser in Access97

    I'm using Shell.Explorer.2 activeX to show a webpage on my form. I can't seem to give it the right size. I'm using a popup form without scrollbar, but when I do that the browser also doenst give a scrollbar, but on some pages I do need that. I also can't arrange the heigth en width. I hope there...
  6. I

    total in a subform

    On the subform (in the footer).
  7. I

    total in a subform

    that also doesn't work.
  8. I

    total in a subform

    In the formfooter on the subform. I also tryed to place it in the Pagefooter on the subform but thatone I don't see when I show the subform.
  9. I

    total in a subform

    I created a subform and want to show the total of the field "vaantal" in the footer. I tried this: Create texbox in the formfooter. In the controlsource I placed: =SUM([vaantal]) but this doesn't work. I'm using access 97. What am I doing wrong?
  10. I

    Update data on subform

    I just found out that this also works: Form_SubForm.RecordSource = SQL
  11. I

    subform textbox value

    That's it! It was locked and disabled.
  12. I

    conditional formatting

    I'm using access 97. Could that be the problem?
  13. I

    subform textbox value

    Then also nothing happens.
  14. I

    subform textbox value

    I' m clicking on the textbox in the subform.
  15. I

    subform textbox value

    And then still nothing happens:confused:
  16. I

    subform textbox value

    Private Sub vomschrijving_Click() MsgBox vomschrijving.Value End Sub The value I expect is the value that is in the field "vomschrijving". Nothing happens when I click.
  17. I

    conditional formatting

    I have a subform in which I want to use conditional formatting. The recordsource is a query, so the problem is how to determine what value a specific field has. After that I think it´s easy: If field.value = "bla" then field.backcolor = 0 Else field.color = 255 End If I hope anyone can...
  18. I

    subform textbox value

    I have a subform with the field "description". I have a commandbutton with Sub commandbutton msgbox description End Sub This works OK. I would like to msgbox the description with clicking on the field "description" but that doens't work (nothing happens). I also tryed a label with msgbox...
  19. I

    different color for line in listbox

    I'm using access 97 :(
  20. I

    Update data on subform

    It works! Thank you very very very much!!!!
Top Bottom