• Microsoft Access Query: Use a field value as year

    I work with MS Access 2003. I have a query with parameter to show all contracts in place of a single year, specified by the parameter. The name of this column with the years, I called "Contract Year". I wish to add a criteria that then shows cancelled contracts at the end of that specific year. I...

    Eveline5 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to SQL table and vice versa through Windows service. So, please help me.

    VBNET5 pointsBadges:
  • On the AS/400 iSeries can one use SQL queries to update file

    Cobol uses some kind of IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • Connect one router and two access points

    How to connect one Router and two access points each located on separate floors?

    fernseddy15 pointsBadges:
  • Does MySQL support foreign key?

    In WAMP server when you create table there is no option for foreign key.

    arpita2345 pointsBadges:
  • Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • Oracle 10g v Sybase ASE 15

    What are the differences between the two products relating to cost, integration, database size, number of concurrent users, performance and features?

    La bodington5 pointsBadges:
  • Search Data in SQL Server database

    What can I do to prevent from the data that doesn't have in database in SQL Server alert message? Don't I have to use connection a VB.NET to SQL Server from use textbox to search?

    dara925 pointsBadges:
  • Populate Access 2007 object in form

    I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

    OhioPat5 pointsBadges:
  • Max query expression in Access 2003

    I have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?

    Mwatters5 pointsBadges:
  • PL/I DB2 stored procedure execution

    How to execute the PL/I DB2 Stored procedure in Mainframe environment?

    Swapna110 pointsBadges:
  • Website and SQL database connection

    Can anybody tell me how to connect the MS SQL database with the JSP pages. I got the IP address and username with the password. I know how to connect it in a local system but I don't know how to connect it with the database in the web server. Please help me to solve this matter.

    Advancedjava25 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • What is a good OpenSource program for CRM?

    We've been using Maximizer for years. Our company has sfound that we do not use all of the features of it. We are seeking a change to a less cumbersome CRM program. There are two people to use the program for Customer lists, contacts, e-mail, notes, calendar, word processing. Any thoughts to share?...

    Darryl6120 pointsBadges:
  • Membership login with MySQL

    Hi, I'm doing a login program which will be using MySQL. I would like to how do I do that, I have done a little but I'm stuck half way can anyone help? protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { MySqlConnection conDatabase = new...

    Blue50 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 pointsBadges:
  • Paste from Microsoft Excel cells to Microsoft Access table successfully but…

    When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

    Lpjedpp5 pointsBadges:
  • Time attendance in Microsoft Access

    How to access time attendance with MS Access?

    ZeyadZoear5 pointsBadges:
  • Script to extract files information from FTP server

    Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The...

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