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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ghh3rd

    How to start learning Illustrator?

    I just purchased Adobe Illustrator and found that I have to wait until at least April before a class opens up at my local college. Can anyone recommend a really good book to begin self-learning Illustrator? Any tips on choosing a path to get up to speed quickly? Thanks, Granville
  2. ghh3rd

    Setting reference WRQ Reflection for IBM Version 13.0.1 and Excel VBA

    Here's the entire program. The "MyLine=" is right after the "Select Case"/"End Select" at the top. Thanks for taking a look. Function Interface_Parer(network) ' Requires a reference to Microsoft Scripting Runtime (Tools > References) On Error GoTo Interface_Parer_error Dim...
  3. ghh3rd

    Setting reference WRQ Reflection for IBM Version 13.0.1 and Excel VBA

    Thanks for your reply Mr. Wilson. Sorry for the delay in getting back to you -- my 10 yr old son broke his leg roller skating on Wed. Function Interface_Parer(network) ' Requires a reference to Microsoft Scripting Runtime (Tools > References) On Error GoTo Interface_Parer_error...
  4. ghh3rd

    Setting reference WRQ Reflection for IBM Version 13.0.1 and Excel VBA

    I use Excel VBA without any issues, but when I set a reference to the "WRQ Reflection for IBM Version 13.0.1" library, I recieve a "Compile error - wrong number of arguments or invalid property assignment" - an example is that it happens on the word "Left" in my exting VB code line: If...
  5. ghh3rd

    Auto fit varying amount of text into a text box

    I would like some tips on auto fitting varying amount of text into an Access form text box - ei: automatically changing the font until it fits. I did accomplish this several years ago, but don't remember what I did. Can anyone remind me? Thanks, Randy
  6. ghh3rd

    Determine what screen I am at with VBA

    I'm just starting off with trying VB to automate some WRQ tasks. Before firing off some code, I'd like to verify that I'm at the correct screen. Can I verify that I'm where I should be by looking at text on the screen -- sort of like a screen scrape -- and if so, how? Thanks, Randy
  7. ghh3rd

    Server on Local PC "Connection Failed"

    Thanks for the information - is it possible to salvage my database so I can open it from a different server?
  8. ghh3rd

    Server on Local PC "Connection Failed"

    I installed SQL Server 2000 on my PC and created a development database. After about a week, I couldn't open the database, I was getting the "Connection Failed, check SQL server registration properties" error. I reinstalled Sequel 2000, started the database over, and all was well for...
  9. ghh3rd

    Want to skip some columns when importing Text file with DTS

    I'm using the DTS wizard to set up a package to import a non-Delimited (it's Fixed Field) file. I select the positions to create the fields, but don't see any way to eliminate those fields that I do not want to include in my table. Also, somewhere along the way, I saw an option to delete the...
  10. ghh3rd

    SQL 2000 - Using DTS to import TXT file to table

    I am new to SQL 2000, took a college course, and went through a book, but now it's time to do a simple import and I'm sort of stuck. I have a text file that I want to import to a table. I have tried doing this with the Data Transformation Services tools, but am not getting it. I'm not sure...
  11. ghh3rd

    Faxing to Multiple Recipients from Crystal

    I came to this thread while searching for direction in using RightFax from Microsoft Access. I do not have experience using API's, but do work with VBA and VB6. All I want to do (for now) is figure out the code for a button to select RightFax as a 'printer'. Thanks, Randy
  12. ghh3rd

    RightFax VBA Coding in Access 2002

    Mike - I'm also interested in using RightFax with Microsoft Access. Although you haven't had a reply to this post, I wondered if you had been able to figure out RightFax? All I want to do (for now) is put code behind an Access form button to choose RightFax as the 'printer'. If you've made...
  13. ghh3rd

    Backing up a database

    Remember... although you will be 'backing up' your database by making a copy of it, you won't actually be protecting it unless you make your copy on another drive. If both your original and 'backup' exist on the same drive, they will both be lost if the drive crashes. Randy
  14. ghh3rd

    Access 2000 Import Specifications trouble

    I converted an Access 97 database that has a Text import specification table called 'MODEL OUTPUT'. When I run the macro to import the text file, I get the error message "In the text file specification 'MODEL OUTPUT', the STATE option is invalid. STATE is one of the fields. The problem is...
  15. ghh3rd

    Access 2000 Import Specification problem

    I converted an Access 97 database that has a Text import specification table called 'MODEL OUTPUT'. When I run the macro to import the text file, I get the error message "In the text file specification 'MODEL OUTPUT', the STATE option is invalid. STATE is one of the fields. The problem is...
  16. ghh3rd

    Open Database

    I was searching the forum for an answer to this problem, and erreric's post worked for me, but only after I removed appAccess. from: Set db = appAccess.DBEngine.OpenDatabase(strPath & strAccessFile, False, False, "MS Access;pwd=" & password) Randy

Part and Inventory Search

Back
Top