Search results

  1. 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?
  2. 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...
  3. 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?
  4. 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...
  5. 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...
  6. I

    Update data on subform

    I have a form with a listbox and a subform. The subform has to be updated when the listbox is clicked. In the subform i have a query on opening the form. SQL = "SELECT field FROM table WHERE id = " & listbox.value Me.Recordsource = SQL. I tryed Forms!FormSubToezicht.repaint in the onclick of...
  7. I

    disable menu option

    I created a menubar with some option. I was wondering if it is possible to disable (gry out) an option based a on if then formula?
  8. I

    form open?

    Is it possible to check if a form is open? I want to do this to prevent an error on closing forms that aren't open.
  9. I

    different color for line in listbox

    I want to fill a listbox from a Recordset and define the color of the depending on a value from the Recordset. Ik can only find how to change the color for the whole listbox. I'm thinking of something like this: If status = "actual" Then listbox.line1.forcolor = "red" Else...
  10. I

    fill listbox from recordset

    I want to fill a listbox with results from a recordset. I used to fill it with listbox.rowsource = "SELECT veld FROM tabel". That works fine but now I have to retrieve data from another database. How do I tell the listbox to connect to the other database? I allready have this; Set ws =...
  11. I

    Open Query/SQL

    I want to open a query which is build in VBA. I tryed Docmd.OpenQuery en Docmd.RunSQL but both didn't work. My code: If field1.value = True then SQL = SQL & "field1, " End If If field2.value = True then SQL = SQL & "field2, " End If etc. SQL = Left(SQL, Len(SQL) - 2) SQL = "SELECT "...
  12. I

    Start Word Macro with variable

    If want to start a Word macro from Access. For this I use the code which stands under. Is it possible to give a variable that can be used in the macro? ' Word starten Dim WordApp As Object Set WordApp = CreateObject("Word.Application") WordApp.Visible = True ' macro starten...
  13. I

    record locking

    When a record is locked (because an other user has it open) access block the possibily to enter text. Some users are confused by that. Is it possible when a user opens a record that is locked to give a msgbox that the record is locked?
  14. I

    sellength to end

    I want to select text in a textbox from a given position to the end. I found the sellength property but I can only select text from the beginning to the given position. Is it possible to select from a given position to the end?
  15. I

    put cursor on position in textbox VBA

    Is it possible in VBA to put the cursor on a specified position in aan textbox? F.E. I have a textbox with "Ingrid" I want the cursor to be after the "g"
  16. I

    Font/style

    Is it possible to put multiple textstyle in one textbox by VBA. What I want to do is some text bold en some text normal. In ASP/HTML I would do it like this textbox.value = "<B>Tekst</B>" & vbCrLf & "text......."
  17. I

    Dynamic heigth text

    I have a form (defaultview=1). I want to set the height of a textbox dynamicly deping on the length of the string that has to be shown. Can anyone tell me how to do that? Thanks, in advance.
Back
Top Bottom