Search results for query: *

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'...

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

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

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

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

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

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,

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

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

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

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

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

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

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.

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

Hi Blue Horizon, thanks so much for responding. I tried Importing and using File;Open. Outlook imports the calendar, contacts some of the smaller folders I created but not the Outbox or the Inbox.

Hi Guys, Happy Holidays! I just installed MS Office 2007 on my new laptop. I tried to open my old Outlook.pst file but recieved a error msg: The file C:\....Microsoft\Outlook\Outlook.pst cannot be opened. Does anyone know how I keep from loosing all my saved emails? Thanx much

Hi Guys, I'm not sure I have the right forum but here goes. I am trying to install SQL Server on my new laptop, but I am recieving ugly messages. Error 1706. Setup cannot find the required file. Check your connection to the Network, or CD ROM. For other potential solutions to this problem see...

Thanx so much dhookum for responding, I too loved your analogy and agree with it although it didn't help my cause much. Oh, well I'll have to find another way.

I'm sorry, I should have said the account number field is Indexed not Keyed Thanx