• 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,380 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:
  • DB2 Automated Utilities – Vendor selection

    We use the IBM utilities suite and our own in-house utilities automation for DB2 v7. Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would...

    Galvtx0 pointsBadges:
  • Oracle 9i Designer

    Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.

    Pegasusdba0 pointsBadges:
  • DBF to FDF

    I am wondering if anyone can help me out with converting a DBF file to FDF to be imported into a PDF document. OR a direct way to import DBF into a PDF?

    Drokkenian5 pointsBadges:
  • Using a Linked Table to Create Auto Updating Excel Sheets

    I am having trouble figuring out if I can have one master spreadsheet in excel, link it to a database in access, apply filters to the master database, save the table, export it to excel, and still have it be linked to the master database? So I would only have to update the one master excel sheet.

    Caveman425 pointsBadges:
  • Output Microsoft Access Report as PDF WITHOUT borders (around the edges of the page)

    In PowerPoint, if i save the presentation as a PDF, it does so without annoying white borders around the outside of the page. In Access, I cannot reduce the borders to 0, or seemingly do anything else to output a report as PDF without at least a 0.166" white border around the page. I want to output...

    cvandenburg5 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