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

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

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

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

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

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

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

Hi Guys, I was under the impression that if you do not have a key on a table the order in which the table was written would be maintained. I created a table that requires headers for each group of account numbers. The hdr is based on the 1st 8 bytes of the account number. e.g. 9991803 9 00...

Hi Guys, I'm new to Stored Procedures and cannot for the life of me see the error in this procedure. Here are the error msgs I'm getting: Msg 102, Level 15, State 1, Procedure Get Unmatched SYNC vs DMS, Line 37 Incorrect syntax near ','. Msg 102, Level 15, State 1, Procedure Get Unmatched SYNC...

Hi Guys, I'm trying to call a macro from a *.bat file but not having a lot of success. I know that I can run it from the scheduler but I really need it to run from batch. Any suggestions? When I ran “C:\Program Files\Microsoft Office\OFFICE11\ MSACCESS.EXE" “X:\GEL\Sysmat.mdb” /x...

Hi Guys, I am relatively new to SQL Server. I am trying to export a file but I keep getting this msg: The product level is insufficient for component "data conversion 1" [69] I dbl ck'd my field sizes and they all seem to be ok. Any idea what this means? Thanks so much

Hi Guys, is it possible to call a specific macro or program (within Access) from a batch file. I have an Access pgm (SysProcess.mdb) that gets used by everyone so I cannot put a AUTOEXEC in it. However It contains some tables I need to update. Is there a way (other than linking the tables into...