Search results

  1. B

    referencing password protected databases in functions

    I have a database, where in a form, I can reference a table as follows, and it works. dim wsp as workspace dim db as database dim rec as recordset Set wsp = DBEngine.Workspaces(0) Set db = wsp.OpenDatabase("c:dtabase.mdb", , , ";pwd=PASSWORD") Set rec = db.OpenRecordset("table1", dbOpenTable)...
  2. B

    export problem

    Hi, Im using an export specification to output from my db to a text file. The specification, and the data within the database look fine. To help, all are classified as text fields. I run the export and the output file doesn't have all the zeros of the field that the db table field does. I...
  3. B

    transferdatabase

    Hi- I'm trying to import a table from one database to the current database. The table I wish to transfer from has the same format as the one I'm importing to, but the names differ. I can't seem to get it to change names- it always creates a new table of the same name as the "from" database...
  4. B

    Code won't stop for form entry

    Hey- I can't seem to get my VB code to stop to allow editing of some data on a form, before continuing. I am using - stdocname = "WC_Sel_CropArea" Application.Echo False DoCmd.OpenForm stdocname, , , stLinkCriteria Application.Echo True as I process a table of...
Top Bottom