Search results

  1. G

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

    I have tried your suggestions but no luck yet, it does not insert when creating a record. I get the normalization hint but the reason why I want it included is purely because of the client....I read something like I have to use ADO when using vba to set values......how can I do that? Thanks in...
  2. 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...
  3. G

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

    Thanks mate.....in my case the repeatitive pattern of fields/data is about 25 times, and note I want to insert these in a new table can the union bit work on these? Sorry might sound naive but still a newby
  4. 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...
  5. G

    Import Excel Data into Access via VBA

    Thanks a bunch for this. However I am importing a second excel file into another table I added it in the tblSpreadsheets with SSID 2 and also used the same table of tblColumns to define the fields. This however throws a verification error. Do I create a different to define fields(like...
  6. G

    VBA module for importing excel data

    Thanks a bunch let me look at this.....will let you know how it goes Gives me this error on opening the form frmImport The expression On Open you entered as the event property setting produced the following error: The code in this project must be updated for use on 64-bit systems. Please...
  7. G

    Hello Geoff from Kampala Uganda

    Thanks Uncle Gizmo
  8. 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...
  9. G

    Hello Geoff from Kampala Uganda

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