• Format a field

    I need to format a text box to begin with a zero with no decimals (i.e. 0310) If I type in 0310, it appears as 310.

    Sue775 pointsBadges:
  • Crystal Reports last twelve months

    I wrote a report that accululates invoice totals for each customer in a sql database based on period and year for period. I manually entered the last 11 months in the formulas by taking current month minus 1, then current month plus 10, year minus one and so forth. How can I make this process...

    Dunbar5 pointsBadges:
  • Connection failure using dotnet 1.0 and Oracle client 10g with Oracle 10g server

    Hi, I have application developed on dotnet 1.0 ( VS 2003) and Oracle 10g server. Client machine has windows XP ( sp2), Oracle client 10g, Oracle.net, mdac 2.6. ODBC connection is sucessful and using toad also i can connect client machine to server but using ditnet application (...

    Mkb20 pointsBadges:
  • Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.

    Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

    Domc1115 pointsBadges:
  • Subject: Limiting information in combobox

    I have two comboboxes, one shows a list of customers, the other shows a list of contracts. One customer can have mutliple contracts, but a contract can only have one customer. I want to limit the contracts in the second combobox to only the contracts of the customer in the first combobox. I have...

    Gavaughn10 pointsBadges:
  • convert csv file to pf file

    i have a file on IFS in .csv format.how to copy this file to pf format in another library.

    Kapiltiwari350 pointsBadges:
  • ActiveX control for Webcam

    I'm creating an application with a webcam to get a snapshot data image, i want to use MS Access for database and use Crystal Report 10 for the print out. My friend told me if i want to use the cam then i hav to use the activeX control, can u help me, please..

    Abekane5 pointsBadges:
  • AS/400 command to convert a file to .csv

    Hi, If I remember correctly thare is an iseries command to convert a file to .csv with the OS environment. Can anyone remember it. Not using Client Access. Thanks.

    tjgm88995 pointsBadges:
  • Process of swapping the kernels

    HI i am working on a sap application where the OS is OS400 and the Data Base is DB2/400, now i want to know the process of swapping the kernels Can any one explain it or refer some meteral for teh same . thanks in advance kiran

    Chebrolu20 pointsBadges:
  • DDL in PL/SQL procedure

    I have a question, i create drop and create a table in pl/sql proc using execute immediate. Later I declare a ref cursor, to process data from table created. Problem is the procedure executes correctly, but after execution procedure becomes invalid. How can i solve this issue. Thanks in advance.

    Binwal5 pointsBadges:
  • Open XL file from ILE program

    We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? Could you show me code examples...

    filuphaze475 pointsBadges:
  • Database report output shows multiple pages

    When I run a report, I see multiple pages, but running the query directly on the database using TOAD gives me only one record. How do I find why the query gives multiple pages? I can ofcourse set printing option as "First Page" for all the fields, but I need to know why the duplication occurs.

    Ms123115 pointsBadges:
  • Web development project with streaming video

    Hello All. I have a site. Now i want a give a option to visitor to put their video on my web site. For this i have three option. 1> put a their video URL 2> put their video Embed Code. 3> Admin put a video. End user can hav option 1 and 2. and the video URL or Embed Code directly save in...

    Sssintu5 pointsBadges:
  • Reduce database size for archiving

    I have one database thta have lage size,now i am trying to archive that database,I al ready reduce 40,000 documents from that databse to archive Dbase,but still the database size is same, some please guide me it very urgent

    772620 pointsBadges:
  • Editing legacy rich text data in a browser

    My customer is moving to a web-only Domino environment and one issue we need to be able to handle is legacy rich text data. We have tons of databases including rich text fields of mixed data types - i.e. text, embedded images, attachments, etc. Editors such as TinyMCE and FCKeditor just cannot...

    RobertLiberman5 pointsBadges:
  • Formatting a subform for printing in access 2000

    I am trying to print a form in access 2000. The form consists of a subform. The problem is when I print, the name of the subform is printed at the bottom of the fields on the subform. The name of the subform appears whenever there is a blank field at the end of the subform. I Don't want the name of...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • Allow Additions Property on Subform In Form View in Access 2000

    I have a main form and a subform in access 2000. I have set both the properties to NOT Allow Edits, Or Deletions, but Yes to allow additions. However, when I open the form in form view the property for allow additions changes back to no. I am able to go back and change the property in form view and...

    TRYINGTOLEARNACCESS30 pointsBadges:
  • How to Determine Database Access on AS/400

    I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.

    DaCurryman5 pointsBadges:
  • database

    I want to create a sample database for a company with employee of 5000+. The employee data will include name, address phone etc. and also have photograph of each employee. In addition, I want to create a list of meeting that some managers have attended and the issue that they have raised during the...

    Ss1425 pointsBadges:
  • Copying our disaster recovery database on a SQL Server

    We are using log shipping on our SQL Server as our disaster recovery solution. When we want to test our disaster recovey with a test transaction, not production, we need to use the secondary copy. However, we don't want to stop it and lose consistency between disaster recovery and the production...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following