VB problem...

Results 1 to 2 of 2

Thread: VB problem...

  1. #1
    Join Date
    Dec 1969

    Default VB problem...

    I&#039;ve put together a VB module in Access 2000 and want to run it from an ASP page. I dont think I can call the module directly from the ASP so I think I have to transfer the VB code to the script. However I get lost at this point! The VB module is shown below: <BR>Function Update() <BR>On Error GoTo Update_Err <BR><BR> DoCmd.SetWarnings False <BR> DoCmd.TransferSpreadsheet acImport, 8, "dummy", "D:workimport1.xls", True, "" <BR> DoCmd.OpenTable "dummy", acNormal, acEdit <BR> DoCmd.RunCommand acCmdSelectAllRecords <BR> DoCmd.RunCommand acCmdCut <BR> DoCmd.Close acTable, "dummy" <BR> DoCmd.OpenTable "main", acNormal, acEdit <BR> DoCmd.RunCommand acCmdPasteAppend <BR> DoCmd.Close acTable, "main" <BR> DoCmd.OpenQuery "maintest", acNormal, acEdit <BR><BR><BR>Update_Exit: <BR> Exit Function <BR><BR>Update_Err: <BR> MsgBox Error$ <BR> Resume Update_Exit <BR><BR>End Function <BR><BR>If anyone knows how to make this into an ASP I&#039;d greatly appreciate it. :)

  2. #2
    Forum Police Guest

    Default CROSSPOST


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts