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 bkrike 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: xtreme1
  • Content: Threads
  • Order by date
  1. xtreme1

    Reserved Error -1601

    I'm running into a reserved error (-1601) when attempting to change a date field of a table. I successfully copied the record containing this problem, so I would now like to be able to delete it. Unfortunately, any deletion attempts result in that same error. Has anyone ever experienced this...
  2. xtreme1

    Compacting database, through VBA, while running module?

    Is it possible to compact a database while it is open? I've tried the CompactDatabase method, as well as DoCmd.RunCommand acCmdCompactDatabase. I feel like there must be some way for me to automate this from a single module, instead of having one that runs a program and a seperate one that...
  3. xtreme1

    Saving attachments in Outlook to disk, automated?

    I'm going to be receiving e-mails on a daily basis that will include a batched text file with comma delimmited records in it. Obviously, the person working on this could manually save the attachment to disk at the end of each day, but if I would like to have as little human intervention as...
  4. xtreme1

    Network or Disk Errors in Access

         I'm unsure of the exact reason for this occurence, so I don't really know whether or not it relates to NT or to Microsoft Access.  Occasionally, much more often than I'd like, one of the client machines will temporarily lose it's connection to the master...
  5. xtreme1

    Problems comparing dates and times(i.e < or >)

        Hey guys, having some problems comparing dates.  When using the ">" or "<" symbols, the dates are usually compared by what seems like the first 2 digits?  In some cases the comparison seems to actually follow no logical...
  6. xtreme1

    Comparing Dates, Times, etc.(i.e. > or <)

        Hey guys, having some problems comparing dates.  When using the ">" or "<" symbols, the dates are usually compared by what seems like the first 2 digits?  In some cases the comparison seems to actually follow no logical...
  7. xtreme1

    Control Collections: Anyway to control the index of each control?

         I'm wondering, is there anyway I can possibly predetermine what the index of a control will be on a form?  I need to be able to cycle through controls, and doing it by number is just convenient(and semi-necessary) the way I have chosen to handle the...
  8. xtreme1

    Faxing reports from Access

          Is anyone aware of a good fax program that integrates well with Access?  I've searched around a bit with the time I've had and have come up with little information on the subject.  Is it possible that no one has tailored something to Access...
  9. xtreme1

    Unrecognized Database Error

         Occasionally we receive an "Unrecognized database" error message on start up of Access.  This usually follows some sort of lost network connection in the form of a "Disk or Network Error".  I am curious to find out whether...
  10. xtreme1

    Subscript out of range err when referencing GetRows variant

         I'm attempting to pull one row from a select query using the GetRows method of the Recordset object, and throw it into a variable array.  For some reason, when I try to reference the array I get a "Subscript out of range&quot...
  11. xtreme1

    Performing a COUNT which excludes duplicates

         I'm attempting to query a table, and count all records in a certain field *excluding* duplicates.  I'm sure this solution is extremely simple, but I can't seem to get my mind around to what I need to do.  If anyone can just point me in the right...

Part and Inventory Search

Back
Top