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 Chriss Miller 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. mdlaugh1

    2007 lost import specifications

    We have databases created in Access 2003 (using 2000 file format) which had several Import Specifications in each db. We converted a copy of the database to 2007. When we import a CSV file (clicking Open, and locating the CSV file) and click Advanced, the Import Specification window is empty...
  2. mdlaugh1

    select only records with Alpha characters

    Thanks, Remou. That works perfectly!
  3. mdlaugh1

    select only records with Alpha characters

    I have a csv file I have imported into Access. All fields are TEXT. I need to limit the list to only records that have Alpha characters in 'Field5'. The values in 'Field5' contain a mixture of alpha/numeric characters. for example: 021577560 200812345 12201992JW 0002244 09151975AD In the above...
  4. mdlaugh1

    All Logical Files are in Use Shrinking Transaction Log

    This issue is resolved. We did the following steps: 1. BACKUP LOG databasename WITH TRUNCATE_ONLY at this point the log file size on disk was shrunk from 20G to about 3G 2. dbcc shrinkfile (dbname_log,2) After running the dbcc shrinkfile cmd we still did receive the message that "Unable to...
  5. mdlaugh1

    All Logical Files are in Use Shrinking Transaction Log

    Hi, I have read many posts on this subject including thread183-430515 but am still confused. (new to SQL Admin) using SQL 2000. We have a transaction log that is 20G, leaving only 3.4g free space on the server. the data file is about 225MB and the Index file is about 245MB. We have done a...
  6. mdlaugh1

    Security message opening Hyperlinks in MSAccess 2003

    Hello, I've seen some posts about this subject, but seem to talk about submitting email, etc. We are simply trying to open an image file on a network drive (may be a tif or pdf file). Both errors below occur before the hyperlink will open the image on a network drive. Is there a setting in...
  7. mdlaugh1

    Error 0xc020901c - DB2 to SQL 2005 import wizard error

    We are Importing from iSeries AS400 to SQL server 2005 using OLE DB and SQL 2005 Import and Export Wizard. The wizard executes and imports 49588 records then fails with the following error: "Error 0xc020901c: Data Flow Task: There was an error with output column "JE103A" (161) on output 'OLE DB...
  8. mdlaugh1

    converting Calendar year to Fiscal Year

    SantaMufasa.. Pls disregard my last post. I realized that I had an extra line of code for the actual_finish_date YYYY. I have removed that and I was able to create the view! I'm closing the post as resolved. If I find a problem after checking it I'll repost. thank you!!!
  9. mdlaugh1

    converting Calendar year to Fiscal Year

    Hi SantaMufasa! Well... it's almost there! I've listed 3 items: #1 (your code) works... This code does not use aliases and selects directly from the sa_work_order_task table. "select to_char(actual_finish_date,'yyyymmdd')actual_finish_date...
  10. mdlaugh1

    converting Calendar year to Fiscal Year

    Hello, I am attempting to group transactions by month. However we are on a fiscal year with October being Period 1. I'm a beginner when it comes to Oracle so please bear with me. :-) I'm using the following code, which groups and handles the months correctly, making OCT period 01. However it...
  11. mdlaugh1

    hidden data in char field?

    George, Thanks! I've changed Query Analyzer Max characters value and now i see values for Amenities. i guess these are Right Justified, maybe?? Can I change the value in the field in some way in Query Analyzer like I can in SQL Enterprise? When I go back to Enterprise I still see the blank...
  12. mdlaugh1

    hidden data in char field?

    Please bear with me.. a little new to some SQL db stuff,,, I have a Description field char 500. one record contains the following - and it shows up in the query: "Rosemeade Swim Complex includes a 50-meter Olympic size pool with a 25-meter short course, separate diving well, training pool and...
  13. mdlaugh1

    hidden data in char field?

    We have a table containing several Char type fields. Two of these fields 'appear' to be empty when viewed through query with a Select * from tblMeetingRooms. However when including a WHERE clause on that field i.e. WHERE (strAmenities like '2 chairs. Table.%') it pulls the record. And when...
  14. mdlaugh1

    oracle date timestamp

    that's what I had in the beginning I believe (see my first post), except i have " and you have ' for the quotes. Am I missing something from your last suggestion? We're having trouble with those records that basically do not have a time portion to the date value.... and so far it seems that I...
  15. mdlaugh1

    oracle date timestamp

    Tried the Where CDate.... Copied and modified your suggestion, changing "theDatetme field" to actual_finish_date Now getting "Expression is typed incorrectly or is too complex to be evaluated". here is my query grid for date: Field line: CDate(CLng([actual_finish_date])) criteria line...
  16. mdlaugh1

    oracle date timestamp

    Now I am missing the records with the full timestamp of hh:mm:ss AM. And it appears that I am missing a few of the ones without the timestamp, although I am not positive about that.
  17. mdlaugh1

    oracle date timestamp

    I have an Oracle 9i database with Access 2003 front end for reporting. I have a query that selects a prompted date range, but I am missing records. Here's an excerpt from Toad: DATE 2/2/2007 2/2/2007 09:15:22 AM 2/2/2007 12:22:03 AM 2/2/2007 From the list above, my query will pull record 2 &...
  18. mdlaugh1

    Oracle Date Format

    ok, but why does the following not work? Format([SYNERGEN_SA_WORK_ORDER_TASK]![ACTUAL_FINISH_DATE],"mm-dd-yyyy") with Criteria: >=Format([enter the date], "mm-dd-yyyy") when the date field contains: 1/31/2007 3:30:00 PM but setting it up as "yyyy-mm-dd" and then entering at the...
  19. mdlaugh1

    Oracle Date Format

    Got it! ok, one last question (I hope) on this subject. I've tried to find rationale for the format()"yyyy-mm-dd" as opposed to format ()"mm-dd-yyyy" but no success, although changing my format statement to the "mm-dd-yyyy" definitely does not work... I pull data from 2006. My actual data is...
  20. mdlaugh1

    Oracle Date Format

    oh!! it was using the "/" that caused the problem, when I changed it to "-" it works. I want the final query to use a parameter prompt... I'd like the user to be able to enter the date prompts as Beg date 01/01/2007 and End date 01/31/2007. Do I need to change the Format statement in the...

Part and Inventory Search

Back
Top