Search results for query: *

Hi all! I have a basic question. I have a query that takes two dates as parameters that needs to be scheduled vie SQL*Plus. What is the command that I would need to use? What are the steps that I would need to take? Basically, I need the output to be spooled to an Excel file (or csv, if Excel...

Hello everyone! I have a VB 6.0 / Oracle 9i questions. Basically, I have this query that uses "with clause" as a temp in-line view. The reasons I have to do that is because I can't use PL/SQL (our group is not allowed to create objects in the database) so this temp view is used many times in the...

Hello, I have Access 2000, and I have a report with a text box which has the "Can Grow" & "can Shrink" set to yes. Regardless, it still doesn't show all the data of the text box. Tips? Thanks, Valeria

Hi. I have a problem with my GridView (asp.net 2.0)...Here is what I'm doing. My GridView is bound (HTML tags) to a DataSet. This GridView displays about 8,000 records (paging is enabled). I have added a TextBox which works as a filter on the GridView. User enters search value in this text...

Hello guys! I'm using a FormView to Update(Edit) records in my database. Here is my problem. My FormView is bound to the stored procedure that based on the 3 parameters updates a record in the data base. First parameter is a filter to go to the specific record and the other two will take on the...

Hi everyone! I wanted to see if there is a way to get rid off double quotes when programmatically writing string to a .txt file. In order for me to further use data from the text file it needs to be without double quotes. I tried to use Left() and Right() on the string, however, that yields no...

Hi, I have a problem fully understanding properties. Below is the code and my question will follow righ after it using System; using System.Collections.Generic; using System.Text; namespace SelectIntoDataSet { class Program { static void Main(string[] args) {...

Hi guys, I'm new to C# sharp and wold like to ask a very general question. Could you please suggest a good article or maybe book that would have a very good (detailed explanation) of Interfaces and Inheritance. I'm having trouble grasping this subject. Thanks, Valeriya

Hi guys. I'm having trouble with the Excel linked Table: 1.Have an extract from ERP system saved as an Excel file. 2.Created a Macro in Excel to format everything as a TEXT plus insert a TRIM function to assure that any trailing spaces are removed. 3.So the formatted Excel spreadsheet is...

Hello, I've got scheduled exported CSV file from ERP system which needs to be converted to the default MS Excel format. I've been specialising in MS Access only so don't have much experience in Excel.Trying to come up with the formula/macro (some kind hard coded automatic way)which would...

Hi guys. I'm having trouble with the following code. Sometimes the emails do get sent and at other times they don't. There is no pattern to that problem. Also, is there any way to insure that empty reports do not get sent? I'm using Microsoft Outlook 2003 and my database is an MS Access 2000...

Hi guys, I have got a major problem that I can't seem to be able to resolve. I have a form that works fine in MS Access 2003 and gives me trouble when I run it in MS Access 2000. I have a botton on the form that on click event should open a report based on a certain filter(that I choose). Here...

I have run into the following problem. I have a Projects Database which has a form from which I need to e-mail reports based on the project leader name (which is one of the columns in the report). So basically I need to filter the report based on the project leader name (that way the report...

I have a bit of a problem. My form has a ListBox that gets populated with a result of a query. Sometimes the query returns a zero-string so the value in a my listbox become just a blank (In all other cases it is a numeric value). That does not look proffesional. What I want is to populate my...

Good morning Guys, I don't know much about network security. All our department MS Access databases located on network drive were corrupted recently. Since IT department running a backup everyday, we've restored everything very easily. Now they are working on setting up a permissions for every...

Hi guys! Got a problem with the following code...once code executed I get an error - "Type Mismatch"...Here is what I'm trying to accomplish..I have a Form in which user types in Customer (Cust) Number...That triggers the combo box(called TID)on that same form to populate with TIDs (tissue ids...

Hello guys! I ran into a problem trying to uninstall MS Access 2003. I have it installed as part of MS Office 2003 and just want to uninstall MS Access 2003 (I'm needing to go back to MS Access 2000). When I go to Add/Remove porgrams it does not show as a separate program. How can I uninstall...

Hi guys! I've got the following problem. I have a query that pulls data from several tables. After I run the query the date in the "Month/yr_1" field is populated for some records and is NULL for others). The ones that are populated show the same date(eg. all records in the "Month/yr_1" field...

Hi Guys! I’ve wrote a VBA code to send the contents of record set as an email from MS Access. However, my output just ugly. I’m afraid nobody will understand my message. Is anybody know if there is an Alignment function in VBA I can use to format columns in the Outlook email? Here is my code...

Hi Guys, Don't know how to use a trim function in the following case. --Need to run daily an append query, which would check the table on a server (dbo_FCST_TISSUE_RECON.SERIAL_ID) against our local table (Counts)and find the items we've missed to count. --Everything works perfectly, except for...