Recent content by gammaman

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...

Works Great. Thanks.

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...

Let f = field. I am trying to update column "Previous" to 'Y' in tb1 where tb1.f1 = tb2.f1 and tb1.f2 = tb2.f2 and .....

Ok, so no more error but there are not any rows being updated. See attached msgbox. "UPDATE fred_backup SET Previous ='Y' where exists(select 'X' from fred_backup_old where " & strSQL & strSQL2 & ")"

OH s**t I cannot believe I missed that. LOL.

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...

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...

Ok, If I do Msg on List5.Value I get the name of the table. How can I take it and use it as the source parameter on the TransferDatabase?

Ok. So I got it working. I removed the function and just did everyting on form load. I am now trying to take the selected value from the listbox and pass it into TransferDatabase to import the selected item into the current db. Private Sub Form_Load() Set db =...

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...

After the macro finishes executing, I have the VBA macro export the table to excel for reporting purposes. "They" want to have the process instance on the report as a reference point.

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...

OMG. I can't believe I forgot that. Do you know how long this has been driving me crazy. LOL.

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 =...