Search results

  1. G

    Insert a field value using VBA when adding record using a data entry form

    Hi all, I have a form for entry and some fields are computed or result of a query from another table. I have a function that looks up a value from another table like so ********************************************************** Public Function GetTargetType() As Variant GetTargetType...
  2. G

    Split table record into multiple records/rows in a new table

    Hey Guys, In a situation where I imported an excel file with so many columns and split them into two temp tables and they are linked using a key. the data has a fixed part lets say Field1....Field2.....Filed3.....Field4...then Field5.....Field6.....Field7....Field8 is the same data range as...
  3. G

    VBA module for importing excel data

    I have an excel sheet where the first five columns are unique/fixed (A:I) then after that ranges J:V, W:AI, AJ:AV, AW:BI, BJ:BV…….PJ:PV contain similar data that I would like to import in a new record in an access database table while maintaining AI for each range that is added in the...
  4. G

    Hello Geoff from Kampala Uganda

    I am a newby access programer and excited to learn. Cheers!
Top Bottom