Search results

  1. G

    transform xml using xslt

    I am trying to transform my xml using xslt so that I can load it into access tables in the way that I want. I have no experience at all with xslt Please see the attached xml input file and desired xml output file. (It does not appear I can upload .xml, so I saved files as .txt) Basicaly I...
  2. G

    TransferSpreadsheet & Append Additional Fields

    I am trying to use transferspreadsheet to import access worksheet and then I want to append additional fields. I am able to import the excel sheet into access, but need help appending the other fields. In the code below, how can I do the piece in red? Dim fd2 As FileDialog Dim xlapp As...
  3. G

    update sql error: too few parms

    my udpate sql is throwing too few parms error. Not sure why. Public Sub doCompare() Set db = CurrentDb() Set rs = CurrentDb.OpenRecordset("fred_backup") Set rs2 = CurrentDb.OpenRecordset("fred_backup_old") columnCount = CurrentDb.TableDefs("fred_backup").Fields.count - 41 strSQL = "" strSQL2...
  4. G

    Trouble Concatinating String in loop

    I am trying to concatinate string in a loop to generate a dynamic SQL to compare 2 tables. But I am not getting the result I want Set rs = CurrentDb.OpenRecordset("r1") Set rs2 = CurrentDb.OpenRecordset("r1_old") columnCount = CurrentDb.TableDefs("r1").Fields.count strSQL = "" For I = 0 To...
  5. G

    Populate ListBox with Table Names

    I am trying to populate a ListBox with the names of the tables from another database. I have the following function which loops the table names from the database I want. The function is caleld on Form Load and passed into the ListBox but the List Box is empty NOTE: The message box in the...
  6. G

    update recordset using vba

    I am trying to update a recordset using VBA based on the max "process instance" from another table. After the code executes, the field I am updating is still blank. Set rs = db.OpenRecordset("myTable", dbOpenDynaset) If Not (rs.BOF And rs.EOF) Then rs.MoveFirst Do Until rs.EOF = True...
  7. G

    help writing fields to table definition

    I am trying to write some fields to an access table definition. It is working for the most part except that I want to write some of the fields as dbText and others as dbDate. For some reason it is writing all of them as dbDate and I don't know why. additionalColumns =...
  8. G

    Update Field based on existing record fields

    I have a field called uniqueID which I would like to update based on 2 other fields that are already populated in my recordset (from running previous queries). I heard it is not possible to do an Update Select like shown below. select max(uniqueID) from myTable where a = "value of field a...
Top Bottom