• AS400 – SQL

    I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries    

    rajeshece1,215 pointsBadges:
  • Active Access Database on Sharepoint

    How can I load an active Access Database onto a Sharepoint Site? I need to make it open a new page and have each individual be able to enter information into it when they click on the link.

    Feeneyp5 pointsBadges:
  • Get your free IT book: The Rails 3 Way

    Here's your chance to win "The Bible for Ruby on Rails Application Development"! There are two ways to get your copy of the book that "strips complexity from the development process," answer one of four questions and post the link to your answer in the discussion section below. Another way to enter...

    MelanieYarbrough6,345 pointsBadges:
  • In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups

    How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

    2010475 pointsBadges:
  • Access 2003 IIF Function?

    I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

    Hld111025 pointsBadges:
  • Linking Fields from different tables (one table empty)

    So I have 3 tables (table 3 being the issue but I have to explain the relationships for clarity): Table 1: Information is provided by Home Realtors into our online database and updated automatically to an access database on my computer. Info given: Home Serial # Home sq footage Home Location Table...

    JRob15 pointsBadges:
  • Earning Badges Pays Off – Literally!

    We told you that payoffs were coming, and they're finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we're doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to...

    MelanieYarbrough6,345 pointsBadges:
  • Wireless Access Point

    My Organisation is looking for some software or a way to monitor our open wireless network. We have a few access points spread around the building and we woud like a method of tracking and keeping a record of IP addresses leased and associated Mac addresses for at least 10 days.  Any suggestions...

    Barcagunner5 pointsBadges:
  • How do I upload an image or images at runtime in Visual Basic 6

    I have designed an interface by which users are soppose to UPLOAD their thier pictures but they cannot do that at RUN TIME. Please help me with the CODE. am using VB6. It is a library registration form with Name, Index, Picture. we are able to update the name and index but unable to UPDATE the...

    Okappaw55 pointsBadges:
  • ODBC connection and IP address

    Is there a way to get the IP address of a client/server job attached to QZDASOINIT?  I can see message CPIAD02 in the QZDASOINIT job log which lists the user and IP address and I need to get this information into a CL program which runs each time the user connects to the QZDASOINIT process. ...

    BISHT321245 pointsBadges:
  • Daylight Savings Time Change

    Does anyone know how the daylight savings time change works on the AS400 in V5R3? I changed the required system values, etc and the time changed on our system just fine...but I thought the time was supposed to gradually speed up/slow down (depending on the time change) until the desired time was...

    Crazyrosie0 pointsBadges:
  • Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • Web development course and Microsoft qualifications

    I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web...

    Tobeeornot25 pointsBadges:
  • TWO Free IT Books: Multicore Application Programming & The Rails 3 Way

    We've got two free IT books this week. Since nobody won last week's The Rails 3 Way, we're piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive,...

    MelanieYarbrough6,345 pointsBadges:
  • MySQL vs SQL server

    If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do...

    Katy20 pointsBadges:
  • Crystal Reports XI formula problem

    Hi everyone,     It's been an while since I have used Crystal Reports and am having trouble with a formula... If paid by2/26/2011  12:00:00AM is what I see when I run my program, I don't need the time, just the date. Here is the formula: "If paid by" & DateAdd...

    Kamim5 pointsBadges:
  • Failover clustering in windows 2003 environment.

    A SearchStorage.com reader recently asked: I want to test a failover clustering in windows 2003 environment. As am doing this at home, I don't have a SAN or Shared SCSI with me. Am struck at Shared Quorum. If am using Majority Node Cluster, is it possible to test with the IDE hard disks of these...

    aburton195 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:
  • Password in Delete Button in MS Access 2007

    How to set a password in command button "Delete" in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !! :)

    Tipsdawn10 pointsBadges:
  • How to count data in Access 2003 stored database

    hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you

    Tlosom55 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