Search results

  1. M

    use an Access query as input to dLookup

    It's possible to use a query from Access as input to dCount. dim n as integer n = DCount("*", "query1") I'm wondering if you can do the same thing with dLookup? I get an error when I try; Dim res As Variant Set res = DLookup("*", "query1")
  2. M

    Combine 2 tables and at the same time write it to a third table

    Hi I want to combine table1 and table2 using union and at the same time write the result to a third table (table3) I tried this: SELECT ID INTO TABLE3 FROM Table1; UNION SELECT ID INTO TABLE3 FROM Table2; but I get the error : "an action query cannot be used as a row source" Is what I'm...
  3. M

    short date in a table

    Using VBA I put date values into a table with this input mask : Format(Me.Txt_dato_ind, "dd-mm-yyyy") The date field in the table are formated to short date. But it seemes that the date are recorded into the fields with month before day: mm/dd/yyyy. The general format for my computer are...
  4. M

    Change the selected index of an Access combobox using VBA

    Hi everybody I'm trying to change the selected index/item of an Access combobox using VBA. I tried this Me.Combo14.ListIndex(1) = True but listindex is a read-only property. What can I do? Michael
  5. M

    Access form fills out the whole screen

    Hi I'm Michael and new in Access. I want a form to fill out part of the screen, but it fills out the whole screen. In the properties of the form I set Autoresize = No Fit to screen = No Width = 10cm Any suggestions to what could be the problem? Best Michael
Top Bottom