• Find Due Date From X months in Access 2007

    I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date?...

    Desnyder200155 pointsBadges:
  • How to use lookup query to return only entries matching the related field of active record

    I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

    YesMayhem5 pointsBadges:
  • Help Creating a Training Record Database

    We have an employee database that the managers want to use to track mandatory and option training. We already have an employee table, and I added two more. tblEmployee   (EmpID,EmpName,EmpProgram,EmpStatus,HireDate)  Has the basic employee information tblCourse      ...

    RaeLyn10 pointsBadges:
  • Need to modify an existing form in Access 2007

    I have just migrated to Access 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.

    Mantis5 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 pointsBadges:
  • What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:
  • What is the difference between physical and logical reads in DB2/400?

    When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?

    Kajeeva10 pointsBadges:
  • Display records in ascending order in DB2/400 physical file

    I have created one physical file with 1 key field. After that I added some data in that file. Records in the file are displayed in arrival order. While viewing the records using DSPPFM, STRSQL commands. As per my assumption, it should be ascending order. Why it is not displaying in ascending order?

    rajeshece1,215 pointsBadges:
  • What is the difference between DB2 and DB2/400?

    What is the difference between DB2 and DB2/400?

    Allampriya5 pointsBadges:
  • Access path and open data path in DB2/400

    When will an access path be created, and when will an open data path be created?

    TNKR130 pointsBadges:
  • Access 2007 creating a menu

    I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access...

    LeChat80 pointsBadges:
  • Migrate application from UNISYS to AS/400

    How can we migrate an application currently running on the UNISYS platform to AS/400 platform. A major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database.

    126170 pointsBadges:
  • SQL query to find out policy numbers

    There are 2 tables POLICY and NAME. The relationship between POLICY and NAME is only the policy number. and their relationship is like many to one. I mean several policy numbers can have same name in the name table with that many records. Now my question is to find out the policy numbers having the...

    Deyyam0 pointsBadges:
  • DBA’s on a project delivering a packaged solution.

    I am the test manager on a major implementation of the Guidewire Policy Centre product. I requested a DBA to join the project. They play a fundamental role in the whole process of ensuring quality. As testers we have no idea what is done to the database in respect of quality, duplication, bad...

    Eish5 pointsBadges:
  • VB6 with too many SQL Select Statements

    Hi Team, hope you can help me out here.. I have a VB6 form that is populated using VB6 and Access being the Repository. The problem is that I am opening and closing the Database for every query I have.. Approx 87 queries. In short I have 12 Rooms that I need stats for.. Ie Grades & Size...

    witsendestate225 pointsBadges:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • Backups failing due to VSS errors

    On a Windows Server 2003 standard SP2 virtual machine, set up for 3rd party (Syncsort) backup to run daily. this has been running for a while, but now every single one fails. If I go to event Viewer I get: EventID:12289 Volume Shadow Copy Service error: Unexpected error...

    Biyogi20 pointsBadges:
  • Query by character length in Access 2007

    I want to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

    Skb195510 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Relational Database

    What kind of tables are used in a membership database other than name & address.

    4jab15 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