• View a concise list of all Job Schedules SQL Server 2000

    I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can't be sure. The number jobs I have makes this an onerous task. Is there a way to query the...

    Cyphersimian30 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • Generating Contracts Documents Automatically in Microsoft Access

    I am in a project that is expected to build a Contracts system.. The idea is that because of standard format of contracts documents (Schedules , amendment, letter.. etc), the system is supposed to use these standards documents to generate customized contracts, edit them, provide choices of some...

    MuathBinhussain10 pointsBadges:
  • Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control

    How can I join 2 tables in MS Access (e.g,tbl1 and tbl2)and Searching & Retrieving records using ComboBox and will display in a textbox after i click Search button in VB? I am using ADODC control as datasource

    Pisceaneffect5 pointsBadges:
  • In-Memory Processing Storage options

    Is "in-memory"processing a reality? I am researching the viability of  IMDS (IN-MEMORY DATABASE SYSTEM).  RDBMs is rapid failing its ability to storage the data receive.  This is just in the discussion stage.  I am looking for evidence that is a viable possiblity in today's business world.  

    Twolittlehorses4me10 pointsBadges:
  • QMF results display as Excel sheet (line feed characters within data fields)

    When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X'0A' characters within the data fields are causing: fields to split (multiple fields) where the where the LineControl characters occur and, the field and record to be continued [strong][em]on the following...

    Girwin505 pointsBadges:
  • SQL for Microsoft Access

    I have crated the below SQL statement. I works fine. and it gives me the required "RTCDate" I need, that which is difined at the Where statement of 3 - 2010. The other constraints are that I need all my 79 product line numbers. and the "1" is those product line numbers that are active...

    CompEng1,240 pointsBadges:
  • 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:
  • Issue With Buttons in Access

    I'm building an Access DB and would like to have people interact with it through forms and command buttons.  Adding command buttons should be very straight forward with the wizard, and it is until I test the button - the buttons I create don't work and give me this error message: A problem...

    JTB15 pointsBadges:
  • php and mysql

    How can we create a family tree map using php and mysql?

    Sanasher5 pointsBadges:
  • MS Access Datasheet sorting using Runtime

    In Access 2000 runtime is it possible to enable some quick an easy sorting on a DataSheet view in a subform?  I am currently using a ComboBox to achive this, but it would be more intuitive for the users to just be able to click on the column heading like one would do in Windows Explorer..  Thanks!

    TJay85 pointsBadges:
  • MS Access 2002 Previously updated fields revert to previous values

    I have a single user application where I update a status table through VB code using DAO. This particular table has 1 record and 66 fields. As part of the processing, two of these fields are updated after which the table is closed. Later in the processing, I update a different field again for this...

    Rbrucejones60 pointsBadges:
  • Look up values

    I am creating a datbase for a lawyer. Some clients have multiple charges under their name. I have created a look up value for the name of the charges to make the process quicker, but so far I am only able to choose and display one charge. Is their a way to add more charges within the row? does...

    Aguet0015 pointsBadges:
  • Ajax based multiserver GUI for MySQL?

    I am looking for Web 2.0 product that allows me to manage multiple MySQL servers at the same time. I did found one proct that seem to do the job, but I would like to compare it with some other ones! (the product is located at http://novaquantum.com )

    Mysqldba5 pointsBadges:
  • Creation of array for input of data

    Hi, I am using access 07. I have created an input form (forms.Base) with an input field of source_code. Below this there are options for other fields to be updated in a record set. There would be multiple entries in the source_code field, seperated by ';'. There would be a maximum number of 10...

    Rponsford15 pointsBadges:
  • Calculating drive volumes and data usage on servers

    Ok i'm a newbie.  I need to calculate drive volumes and data usage on about 75 Sun and HP servers to obtain planning data for a complete update and conversion to NetBackup for all servers. How can I calculate Total Disk Space and Disk Space used without having to...

    ITrUS5 pointsBadges:
  • sst and dst login?

    who can enter in to the SST and DST? means only QSECOFR or any other with authorities can enter in to sst and dst?

    Flakek60 pointsBadges:
  • Should we use Web services to develop this integrated application?

    We are developing an integrated application that will incorporate excel application, access databases and pda applications using visual basic 2005. Problem is whether to use web services to develop the project. This request for help was originally submitted to the Research Assistant on WhatIs.com.

    ResearchAssistant855 pointsBadges:
  • Distributed transaction error after upgrading to windows server 2003 SP2

    Hi, After upgrading a win 2003 server from SP1 to SP2 we're receiving a "[Microsoft][ODBC SQL Server driver]Distributed transaction error". When we roll it back to SP1 everything works fine again. As far as I can see the MSDTC looks enabled, but are there any settings that are different between...

    Po33mkqr5 pointsBadges:
  • HOW TO READ A CSV FILE IN OBJECT STAR (O*)

    I have to requirements, 1) I need to extract data present in column A from a O* table, which is of of two columns 'A' and 'B'. The field value can be between 14 to 19 in length and numeric and the file should have a comma at the end of each record  ( e.g - the file extract should look like...

    Ari200940 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