• Using ‘IF’ statements in query/400

    I need to create a work field that will be populated differently, dependin on a series of 'If' statements. Ex: If TMRPER = 'M', use TMRFRQ value. If TMRPER = 'D', then use TMRFRQ divided by 30, rounded to the nearest whole number. Any idea how to do this?

    HTLFTMP5 pointsBadges:
  • non paged pool memory

    the server running exchange 2003 sp2 on hp dl380 G5 OWA stops working. Upon cheking logs I found 1_Connections_Refused - errors Can somebody please assist.

    Shiv120 pointsBadges:
  • top values and ranking

    What function do i use to give a field a ranking based on it's current sorted position in a query. I do not want to use a running sum on a report - it needs to be in the underlying query as I am going to have to join several together.

    PenguinWaddle5 pointsBadges:
  • Update Microsoft Access database from VB6

    Using an MS Access database. From a list box I get a record into a text box. Once it is edited it shows in the listbox but the original is there. I have a refresh button which removes the newest record in the list (before the one I am updating) and leaves the original and the new version there? I...

    Codeless5 pointsBadges:
  • grid view connection to a data in a table ?!

    Hello , I'm julien , beginner in visual studio 2008 using c# language I Have this task that I seem to be stuck in ! I've created a database using sql server express 2005 of 4 tables :"BOOKS , AUTHORS , CATEGORIES and PUBLISHERS ". I've connected this database to my gridview in visual studio , it...

    Julien5110 pointsBadges:
  • Query showing vbCRLF in string data

    Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....

    Sandisk25 pointsBadges:
  • Disconnecting a Crystal 8.5 report while report is open in VB6

    Hi I am developing an application which is written in VB6 and uses Crystal Reports 8.5 and has MSAccess as its database. The Users connect to the database via ODBC and the reports also use ODBC to connect to the data source. I have simply added the Crystal Report object to the forms which require...

    Slscheer5 pointsBadges:
  • SQL script to disable views after a demo period.

    Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...

    Katiekat5 pointsBadges:
  • Using MySQL message API on Windows

    I am new to MySQL message API. I want to use MySQL message API on Windows platform. But MySQL message API is tested and developed on open source platform (Linux, Unix, etc). I think MySQL message API is nothing but a udf, which uses spread toolkit (spread daemon). So I tried to build a dll for the...

    Linux - Ask the Expert270 pointsBadges:
  • Execute a query on table in different db that will make a table in currentdb

    Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places... The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I can...

    Rjwilcox45 pointsBadges:
  • Kix Script

    Does anyone know the script to set the ie proxy via a logon script written in kix?

    Lyntons5 pointsBadges:
  • Extract all instances of a search between two symbols

    Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....

    Gotovamsee5 pointsBadges:
  • Printing VB results on Excel sheet

    How can i print the output of the Visual basic progam on excel sheets?

    Bhupiirari5 pointsBadges:
  • Import data from Lotus notes into Openoffice

    I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to Open...

    Silvius5 pointsBadges:
  • App that allows URLs with associated usernames and passwords

    I would like to create an application that enables a user to store multiple urls with associated usernames and passwords. When a user clicks on a link the application automatically logs the user into the associated url. Unfortunately I cant seem to search for this type of application because all...

    Ess200010 pointsBadges:
  • update query

    in vb 6.0 and accesswhat is the problem in this query = "update Technician_time_trn set tech=" & num & " , hrs=" & hrs & " , min=" & mins & " , sec=" & sec & " where task_cd='" & task_cd & "'"

    Kalpa10 pointsBadges:
  • BAPI_PROCORD_GET_DETAIL in Visual Basic

    I want read data from SAP using VIsual Basic. I am Using "BAPI_PROCORD_GET_DETAIL" bapi for this purpose. While executing this BAPI in SAP , i am getting the records. But when I tried it from VB i am ub\nable to Get data. Following is the code i am trying in VB.Please check and give me feedback....

    Rujuta25 pointsBadges:
  • error code 70 when making Package Vb6.0

    My question is when i using the package to make the setup file, but the error code 70 appeared and failed to continued. anyone can help me to find out the problem. the vb file can complied in vb6.0 and make a exe file. Only error occurred in Package wizard. thank you for your help!!

    Gary19915 pointsBadges:
  • Conversion of table into XML

    How to load a table into XML in a CLOb using Oracle 8.1.4

    SBK20095 pointsBadges:
  • Crystal Reports Duplicating Records

    Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...

    Simonlevey5 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