• 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:
  • Importing from an Excel worksheet to Access form

    I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How...

    Horses5 pointsBadges:
  • How do I run Excel Reports?

    Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?

    Lysprice5 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 pointsBadges:
  • Access 2007 IIF statement in query criteria

    This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought. It seems like I'm getting close but can't...

    Scubacy25 pointsBadges:
  • How to make Access 2007 database GUI

    I need help. I have created a small database, now my problem is I would like to build it in a more software-like interface. No more tools or any options of some sort from MS Access to display but only the navigation form which I designed. Is there any developer tools required? Thank you in advance!...

    Curiousnoob15 pointsBadges:
  • Access 2007 Database – Security Warning

    This database has come back to haunt me.... We recently changed out a computer and added a shortcut to the Access database. Actually it was the shortcut copied from the previous computer. When they double click the short cut, it takes them into the database menu as before. However, now it displays...

    LeChat80 pointsBadges:
  • How do I create an OEM-style bootable recovery partition?

    Very simple question, but not so simple of an answer. I would like to create a hidden recovery partition on all of my companies laptops so that if/when it gets destroyed in the field, when the user boots up, they insert a cd that says, basically "press 1 to restore your system to factory defaults"...

    swinehart68031,050 pointsBadges:
  • Connect DB2 from MS-Excel

    Hi all! I'm trying to connect the AS/400 DB2 from MS-Excel but I'm Getting Communication link failure .comm rc=10061 - CWBO1049 - The IBM i server application is not started or the connection was blocked by a firewall. I have tried STRTCPSVR *ALL STRHOSTSVR *ALL and PING from PC to SERVER is ok....

    Sureyz2,475 pointsBadges:
  • Difference between DDL and DDS

    What is the difference between DDL and DDS. How to use DDL in AS/400

    rajeshece1,215 pointsBadges:
  • Combo box automation

    How do I get a combo box to take on a value automatically?

    depatterson015 pointsBadges:
  • Viewing index data in DDL

    I have created index. It shows Type as *FILE and Attribute as LF. but I'm unable to view the data. How do I view index's data?

    rajeshece1,215 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