Search results for query: *

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

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

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

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

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

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

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

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

Trying to construct a query using Query Grid to select records with ACTUAL_FINISH_DATE >= 1/29/07 and this is my results list. Access 2000 and Oracle 9i backend. My expression in Grid column is Format([SYNERGEN_SA_WORK_ORDER_TASK]![ACTUAL_FINISH_DATE],"yyyy-mm-dd") In the Criteria row I have...

I have a field that might contain null values... I have a parameter query over this field as follows: [Enter the Type of Work or * for All] & "*". This is leaving out the null records. How can I pull All including Nulls if * is entered? I've tried [Enter the Type of Work or * for All] & "*"...

I've also posted this in "Crystal Reports Other" as I was not sure of the best fit....: We are looking for a reliable yet low cost and low resource driven method to deploy Crystal Reports v 9 & 10. We don't have the resources or need to go full blown with Crystal Enterprise or Web Server. I...

We are looking for a reliable yet low cost and low resource driven method to deploy Crystal Reports v 9 & 10. We don't have the resources or need to go full blown with Crystal Enterprise or Web Server. I saw a prior post listing a website with numerous "viewers". Does anyone know about CView...

We have a user who has a handfull of Excel files that now have an ext of MHT. i.e. filename = myfile.xls.mht. What could cause the file to become named "mht"? (Excluding intentially saving it as type mht). Uses Excel 2003. She was working with the file just last week and it was in type XLS...

Hello, I have a table with a Description field that contains data as follows: (there is a carriage return before each "Class...." string. --------------- Mary Heads Carter Park Class "A" Josey Ranch Greenbelt Class "B" ------------- I want to create a new column containing the substring 'Class...

I have a parameter query to prompt for "Enter the Building or * for All" as: Like [Enter the BUILDING or * for all] & "*" Problem is that some records do not have a value in Building field and the query is ignoring those records. How do I structure the query to allow for entering one building...

(I posted this earlier in Oracle9i Forum, but just saw this forum.) We have a data link using HSODBC from our Oracle 9i server to an AS/400. The link is working fine on the Production db connection and used to work on the TEST server. Our Oracle TEST box crashed and we have rebuilt it. Now the...

We have a data link using HSODBC from our Oracle 9i server to an AS/400. The link is working fine on the Production db connection and used to work on the TEST server. Our Oracle TEST box crashed and we have rebuilt it. Now the link from TEST box to AS400 test libraries gives the following error...

I need to grant Select on various system tables (dba_tables, dba_indexes, dba_segments...) and the instructions state it must be granted by SYS. I have logged in to SQLPlus (windows) as a user with DBA authority. How do I connect as SYS? We use Oracle 9i Release 9.2.0.6.0 on Windows 2003 server.

I have a prompt query shown below which runs fine for most values. My problem is that some values in the field are of the format *ADMIN, *ELECT, etc... When I enter one of these "*...." values I return NO records. How do I code the prompt or instruct the users to enter the value? Like...

I have a prompting query to enter a specific AREA or * for all. The backend is Oracle and Area values are entered in Upper case. I want to force the value entered at the prompt to UPPER. The following code does not pull any records. when I remove the UCase function and answer the prompt with...