Recent content by Chronik

  1. C

    Question Guidelines on building a db from Solid Edge files

    I'm not even a member n the forum I just mentionned. But it is indeed a crosspost with another US forum. I posted here at first then realized it was a UK, so i posted in a US forum but when i came to delete the post here someone had already replied. I will make sure I update both threads...
  2. C

    Question Guidelines on building a db from Solid Edge files

    Thanks for the tip. I tried with the following code, but keep getting 3251 error. ("operation is not supported for this type of object") Option Compare Database Sub UpdateTable() Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbs = CurrentDb Set rst =...
  3. C

    Question Guidelines on building a db from Solid Edge files

    You were right, there was a problem using the dim functions because Properties and such were allocated to something else in access. My code now kind of works, the only problem is that I have no clue on how to use the movefirst/movelast commands, therefore the database is not being edited...
  4. C

    Question Guidelines on building a db from Solid Edge files

    I skipped the "Method or data member not found" error (by removing the ObjProp part of the handler code, see post #6, 2nd code box, at the bottom I added a " ' "). It seems there really is a problem with the library even though it is activated the same way as in Excel. As soon as it reaches...
  5. C

    Question Guidelines on building a db from Solid Edge files

    As I said, it works flawlessly in Excel/VBA. In both Excel and Access i've include library "Solid Edge File properties". Here is the working excel code : Sub GetFileProps() Sheets("Sheet1").Range("A2:M20000").Value = "" Dim strFile As String Dim strPath As String Dim...
  6. C

    Question Guidelines on building a db from Solid Edge files

    I can't have the DB updated in real time. The data comes from solid edge files created by users. It would be ok to run an DB update only once every couple of hours, or even once every day. Here is the code i have right now. It seems that Access doesn't like the way the Solid Edge File...
  7. C

    Question Guidelines on building a db from Solid Edge files

    Here is the code I am using in VB/excel. I would like this code to be "translated" into VB/Access so that Access as a direct link to the files, instead of going through Excel, allowing me to edit the files properties easily. Sub GetFileProps() Sheets("Sheet1").Range("A2:M20000").Value...
  8. C

    Question Guidelines on building a db from Solid Edge files

    Hi, We are using thousands of Solid Edge parts daily and I would like to create a database that we could use to update some file properties as well as search for existing file instead of creating duplicates. As of right now, I have a VB program that creates an excel table with the data I want...
See more
Back
Top Bottom