Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BarkinB

  1. BarkinB

    mapping drive on Mac, Win2k not remembering different username setting

    So the main problem, I have found, is that Win2K insists on prefixing the username with the computername on the first try, but not subsequent tries. Anyone have any idea what may control this behavior? Out of the 3 things I mentioned, the third (a Mac user account named...
  2. BarkinB

    mapping drive on Mac, Win2k not remembering different username setting

    I've not been able to get mapping a drive letter (M) on my Win2Kpro box to the share on my Mac (OS 10.2.5) to survive a reboot. Of course, I'm enabling "reconnect at logon", but when it tries, it seems to insist on trying the default username/password, which the Mac rejects, and then...
  3. BarkinB

    How to run code? Access VBA

    Oops. Sorry about the duplicate post. I agree with everything you said. I checked, and MS DAO 3.6 is active.
  4. BarkinB

    How to run code? Access VBA

    Wow, Thanks! I did some more work on it, too. Type ScriptType Line As String End Type had to be changed to: Private Type ScriptType.... Some other lines had to be commented out to get it to compile cleanly. I still can't get it to work in the DB I'm dealing with, but I did get it to work on...
  5. BarkinB

    How to run code? Access VBA

    Wow, Thanks! I did some more work on it, too. Type ScriptType Line As String End Type had to be changed to: Private Type ScriptType.... Some other lines had to be commented out to get it to compile cleanly. I still can't get it to work in the DB I'm dealing with, but I did get it to work on...
  6. BarkinB

    How to run code? Access VBA

    cainemart: The real task is to convert the existing schema of an Access db to Oracle. Not even worried about the actual data yet, I need to build the tables in Oracle. This code I found would supposedly examine the Access db and write scripts to run in Oracle to re-create the db there. beetee...
  7. BarkinB

    How to run code? Access VBA

    Hmm. The toolbox choice in the View menu is grayed out. No wonder I wasn't getting anywhere. I did get back to Access (not the VB editor, but Access itself), and try creating a form there. I created a button, and then had to build a macro whose action was 'OpenModule' and point it to the module...
  8. BarkinB

    How to run code? Access VBA

    I'm trying to convert an Access db to Oracle (8i). I did some searching, and ran into this code. The person posting it wasn't the author. There isn't much to go on, there's no instructions. My experience with VBA is limited. In the VB editor from Access, I can't see how to create a new form to...
  9. BarkinB

    How to run code? Access VBA

    Hi, Sorry if this is a FAQ... I found some VBA code on this forum that seems like it would do exactly what I need, but I don't know how to run it. I've opened the VB editor, created a new module (calling it 'convert', but now what? When I just try to run it, I get a list of 'macros' (they really...
  10. BarkinB

    Importing Access/Excel into Oracle

    Hi, Not trying to be dense, but how do you 'run' the code? In Access, I started the VB editor, created a new module (called it 'convert'), pasted in the code... but now what? Just clicking the run button gives a list of macros to run- FieldProperties FieldX GetProperties InitScriptLine ... how...

Part and Inventory Search

Back
Top