Search results

  1. W

    Limit Ole Object Type

    How do i do this? I have the field on a form with instructions to right click and insert object. Is there a better way of showing this on a form and thus adding validation rules?
  2. W

    Limit Ole Object Type

    Hi Guys, I have a an Ole Object type field in a table. To limit size I would like to have users only upload ZIP files. Is this possible? Thanks!
  3. W

    Joining Fields

    That worked, so simple! Obvious I'm not a programmer!
  4. W

    Joining Fields

    My tables are (LEV) MEB Overview I which has the data and (LEV) MEB Overview II, which has no data Code is: Public Sub s_runMe() Dim cn As ADODB.Connection Dim rs1 As ADODB.Recordset Dim rs2 As ADODB.Recordset Set cn = CurrentProject.Connection Set rs1 = New ADODB.Recordset...
  5. W

    Joining Fields

    Hi Ken, Thanks for the link to the DB. I'm trying to implement the solution into my DB. However I'm getting the following error "Syntax error in Union Query" It occurs at RS1.open I've used the same setup as in the example. I created a temp table with no data but the same fields and field...
  6. W

    Joining Fields

    Hi Guys, I have a problem which I cannot figure out. I have a table which has an ID field and also a field with data. The ID field is 'not' unique. I need to join all of the data fields which have the same ID field into one field. So it would be ID; Data 1, Data 2... Any ideas? I would...
Top Bottom