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!

Recent content by gertNo1

  1. gertNo1

    Error while parsing name field

    Hey Guys, I have a large field (named Details) that contains names and other information. I am trying to parse the first and last names. select LEFT(SUBSTRING(Details, 1, 26), CHARINDEX('', SUBSTRING(Details, 1, 26) - 1)) AS LastName LEN(LEFT(SUBSTRING(Details, 1, 26), (CHARINDEX('F'...
  2. gertNo1

    Cannot get report to count

    Thanks Guys but they changed the specs. However, I'm sure I'll see this problem again.
  3. gertNo1

    Cannot get report to count

    This is my first report in Crystal. I have figured out everything (so far) except how to get Crystal to count. Here is what the old report looked like: Error Description Analyst Source Error Cnt Action Requested - Doris RYLAR 2 Action Requested - JoLynn Penningtone 1 Action...
  4. gertNo1

    Has table been opended??

    Ok, that makes sense, but I still should be able to exec code On-Close of database shouldn't I? I thought the form_close would allow me to do that but it doesn't seem to be working (the database closes without exec the code). If not that then should I be using? Any idea? Thanx guys for the...
  5. gertNo1

    Has table been opended??

    Thanks Jerry for responding, but this table is not linked to any form and the Users don't want it to be linked. The Users want to allow updates directly to the table but would like the changes validated. I agree if the form was behind a table it would be much easier. Thanks again, Trudye
  6. gertNo1

    Has table been opended??

    Hi Guys; I am trying to validate a table after it has been updated in order to do that I want to know if it has been opened. The database is used in several production runs and I don’t want to impact production unnecessarily. I created a form that is suppose to hide and loop until the table has...
  7. gertNo1

    Isloaded works for table?

    Even better, is there a way to tell of the table has been updated? Whenever someone updates the table the owner wants to validate it. Thanx again,
  8. gertNo1

    Isloaded works for table?

    Hey Guys, got a question. Can you use the "CurrentProject" and the ISLOADED function to tell if a table is open? If not is there a way to tell if a table is open? Thanks
  9. gertNo1

    Delete query Syntax Error

    Hi Guys, I'm having a problem with this Delete query but I can't find the error. I tried to match it against queries I found in the Search Archives but I'm still getting a SYNTAX error. Does anyone see what I'm doing wrong? DELETE Invalid_Last4_Final_Output.* FROM Invalid_Last4_Final_Output...
  10. gertNo1

    Compress/Repair Question

    Thanks so much HarleyQuinn for responding. We have been manually compressing it to keep it from reaching the limit. When the compress was scheduled, it was not at the limit. You are 100% correct a backup is always best. The problem is if a production job calls the newly compresse database and...
  11. gertNo1

    Compress/Repair Question

    Hi Guys, got a question. In the past we have had problems compressing our Access databases, on occasion macros have been deleted, and keys have been dropped on large files (100k). We are currently running MS Office 2003 has anyone ever heard of this? I checked Advanced Search but either I wasn’t...
  12. gertNo1

    Database or object is read only

    DUH and double DUH!!! That's why a fresh pair of eyes is always good. If the error had been a snake it would have bitten me. Thanx so much Remou
  13. gertNo1

    Database or object is read only

    Ok, I give up!!! I have read several postings and only found one that kinda helps. I tried exporting the table as TransferSpreadsheet and it worked. But I did that just to rule out that the database was read-only. I am getting the msg: "Cannot Update. Database or object is read only" Here...
  14. gertNo1

    Outlook Upgrade problem

    Excellent question, I'm very sure. But it does sound strange doesn't it? The kicker is I can import the file successfully in Outlook 2k but not in 2007.
  15. gertNo1

    Problems with SQL Server Install

    I figured out what the problem was. There is a Activation module that needs to be uninstalled. It can be seen from Add or Remove Programs. Now my problem is: When I finally got SQL Server loaded I couldn't see the test databases (Northwind etc..). So I uninstalled SQL Server but one module...
See more

Part and Inventory Search

Back
Top