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 derfloh 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. xtreme1

    Reserved Error -1601

    No dice, whatever happened, it's in bad shape...=( I'm going to have to try and salvage as much information as possible from this I suppose. I'll check back shortly to see if any other suggestions have been posted, but from the looks of things, I'd say this is not going to be easily fixable...
  2. xtreme1

    Reserved Error -1601

    I appreciate the help, and I'll post back as soon as I try the utility you mentioned. Access repair just completely corrupts the file by the way, so that's a no go. Thanks for the help so far though, I appreciate it. xtreme1 rbio@excite.com
  3. 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...
  4. xtreme1

    SQL statements in Visual Basic

    What error is created with the double quotes? xtreme1 rbio@excite.com
  5. xtreme1

    Compacting database, through VBA, while running module?

    Gracias Paul, was very helpful. =] xtreme1 rbio@excite.com
  6. 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...
  7. 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...
  8. xtreme1

    Pattern Matching

    I wasn't even aware of that...that's cool stuff. I'm going to look into it, but if you do find out could you post the info here? I'd definetely like to know about that one...=] Good luck! xtreme1 rbio@excite.com
  9. xtreme1

    I want to open Explore with VBA code in Excel- POSSIBLE??

    It doesn't work because it should be: OpenExplore = Shell("C:\Windows\Explorer.exe") not: OpenExplore = Shell("C:\Windows\Explore.exe") xtreme1 rbio@excite.com
  10. xtreme1

    Compacting a Database?

    Sure, you could just write another MDB thats only purpose is to compact the other. Just write the code necessary to compact the external database, then include a macro named "Autoexec" which executes that code. The compacting code should also exit the entire...
  11. xtreme1

    Corrupted queries in database

    Can any computer access the database file in any way? I don't honestly understand why yet, but in most the two occurences of that problem I've had, one to three computers on the network have still been able to access the file. If this is the case, I recommend exporting the queries to another...
  12. xtreme1

    Combining records into one field

    I sent you an example database doing what I think you'd like to accomplish.&nbsp;&nbsp;I hope it helps. =] <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>
  13. xtreme1

    Growing mdb file ! ! !

    &nbsp;&nbsp;&nbsp;&nbsp;The front end may be growing due to appends to tables that occur frequently.&nbsp;&nbsp;In other words, if you're appending data to a table temporarily with a query of some sort, and then deleting it, the memory the deleted records once occupied is still...
  14. xtreme1

    Periods in text fields

    I have the same problem with memo fields in Access97, I assume the same would happen in a text field but it has never occured.&nbsp;&nbsp;The computers here also substitute the black bar for the three periods, let me know if you find a solution to this strange problem.&nbsp;&nbsp;I'll ask around...
  15. xtreme1

    forcing data entry onto a new line in a memo field

    Try &quot;VbCrLf&quot;, I think this is what you're looking for. =] <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>
  16. xtreme1

    Sql statements in access

    &nbsp;&nbsp;&nbsp;&nbsp;That's an interesting problem.&nbsp;&nbsp;One way of solving it might be to create a recordset of the archive table and actually do one record at a time, one field at a time, UPDATE's to it.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;In other words, set each of the archive...
  17. xtreme1

    Sql statements in access

    That is definetely strange, I tried it here and it worked OK.&nbsp;&nbsp;Maybe an error in one of the source databases fields is causing it to halt early?&nbsp;&nbsp;Not really sure why that would happen, but if you can let me know what was the cause when you figure it out.&nbsp;&nbsp;Good luck...
  18. xtreme1

    Network or Disk Errors in Access

    Vic, yes it was.&nbsp;&nbsp;Multiple NICs actually, it's a complicated story...but you were correct.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;It wasn't the servers NIC, it was a few of the client NICs that were causing problems, it was tough to determine which was the actual problem...
  19. xtreme1

    #error - What causes this error?

    Oh, and also.&nbsp;&nbsp;The cause of the error is when two people update a record concurrently.&nbsp;&nbsp;One of them, the last to attempt to exit the record, will receive a message:<br><br>&quot;This record has been altered since you have started editing it.&quot;<br><br>They then have a...
  20. xtreme1

    remote syncronization via dial up or ?

    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You might want to look into Carbon Copy 32, as it allows synchronization of files.&nbsp;&nbsp;I use it quite often, though it is usually a one way deal.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Once you commit the file transfer methods though, you could always...

Part and Inventory Search

Back
Top