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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: hughed00
  • Content: Threads
  • Order by date
  1. hughed00

    Iomega Zip, why open "explorer" when disk inserted?

    I happen to keep my financial files on a zip disk. So, I put an internal IDE Zip drive in my box. Every time I put in a disk, the explorer (or whatever it is called now) opens up. I really don't like this and wish it would not, but I can't seem to dig up the place to prevent this. I turned off...
  2. hughed00

    What is wrong with this snippet?

    Private Sub Text57_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("AssignedNumber", dbOpenDynaset) Text57.Value = rst!AssignedNumber rst!AssignedNumber = rst!AssignedNumber - 1 Set rst = Nothing End Sub */ This bit is supposed to fill a field on a form with the...
  3. hughed00

    SQL2K @#@$%@ Logfiles

    How do I get the logfile to truncate? I have tried everything (except obviously the right thing). Actually, everything short of writing a query to do it, which I have not attempted since every gui way seems to fail so my faith in writing the query is low. I do daily FULL backups, I only have...
  4. hughed00

    Fill Field from table with one entry, stumped.

    We are creating a form that "creates" an EAN-13 code when requested. These codes have a fixed 7 digits(basically a license)followed by 6 digits you can do anything you want with. We have decided to use the 5 digits following the license as the ones which will indicate unique...
  5. hughed00

    Form Function/Macro Help

    I have to calculate a check digit from a 12 digit code. Each digit needs to have an arithmatic operation done on it. My first hurdle, how do I get the 12 digit number into another table with each digit in its own field (so I can then go to work on them). I thought I will likely have to convert...
  6. hughed00

    Multiple Conversions for EAN Check Digit Needed???

    I have an application that creates an EAN code (13 digit code of which the first 7 numbers are a purchased license and static, the next 5 assigned by the app, and the last digit is a check digit using the EAN ISO approved check digit algorithm). I am struggling as to how to get this to work. I...
  7. hughed00

    Creating License Numbers

    I have worked with SQL to deliver reports in the past, but have never had to create anything more than a simple data imput form. Currently, I have been given the task of creating in Access2K a form which allows for data imput (got that part OK) and then creates a new EAN-13 license for the...
  8. hughed00

    Sort on Sub-total, ARGH!

    I have a report that has 3 groups and 4 fields. The one field not grouped is "message size" so that I can sub-total message volume against the other 3 groups which are "site", "transaction", and "destination site". I managed to get the report to sort...
  9. hughed00

    DTS why string to int conversion not working?

    I have done this before, I just can't figure out why my straightforward import of a flat fixed length field won't allow the last string to be converted to an int. This always worked in the past. Now I am getting the error conversion invalid for datatypes. What did I forget to do??
  10. hughed00

    SQL 2K Problem with DTS and Job Scheduling

    DTS data jobs that I used to be able to run with no problem in SQL7 are now refusing to run in 2K. Other jobs run when scheduled. The really odd thing is that I can run these jobs by selecting them in local packages area in Enterprise Manager and selecting execute. I figured it had to be...
  11. hughed00

    DTS Load text to int

    I don't remember having problems with this before (good since I don't know how to do it!). I have a text file source which is fixed length fields. The last field is a "number" representing length of a message. When I setup DTS import using the wizard before, I seem to remember having...
  12. hughed00

    simple, but UGLY

    I have a huge (500mg and growing) text file which is fixed field length with no delimiters. I need to determine is the 28-->77 characters are ever repeated in a subsequent row/record, and if so, spit them and the entire record it is contained in out to another file leaving only one occurence of...
  13. hughed00

    SQL2000 New "Feature"

    I recently upgraded from SQL7 to 2000. One of the tasks in my database was to go out and retrieve a couple tables from an Access database. I used the default name in my SQL7 database which was the same as the table name in Access, namely, '_EAN13Codes'. SQL2000 doesn't complain about the DTS...
  14. hughed00

    SQL 7.0 , any patch for ODBC timeout?

    Enterprise manager times out prematurely on some queries and the maximum setting for timeout threshold seems to be 30000 ms. I have been told this is a bug (not being able to increase the timeout threshold). Any fix?
  15. hughed00

    Perl on the server, does it fit the bill for this job?

    I have a SQL server machine that has Perl on it. No one currently with the company knows how to use Perl. Unfortunately for me, I am supposed to come up with the answer to the following question, oh, like yesterday! I apologize in advance for my ignorance, but what little I do know of Perl is...
  16. hughed00

    Distinct output to a table? SQL 7

    I have a mess on my hands and very limited personal or organizational resources. I apologize in advance for what is likely a stupid question, but here goes; I have a fixed field text file that consists of the headers from MQ Series messages. Each record 'should' contain a unique 48 character...
  17. hughed00

    Pattern Matching, Desperate Newbie.

    I have a very LARGE text file which has interspersed 2000 unique codes throughout alot of junk I don't care about. The task of identifying these codes was dumped on my desk. My first thought was "Why didn't you learn Perl when you had some free time?". My second was, this should be an...

Part and Inventory Search

Back
Top