Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: drtree
  • Content: Threads
  • Order by date
  1. drtree

    Learning Teradata

    Hi All, I searched the forum and didn't find this question being asked, so I hopefully it hasn't been yet! I'm relatively new to Teradata (most of my database related work has been done in SQL Server 2000/2005/2008) and was wondering what the best place to get started would be. I've done some...
  2. drtree

    Filemaker and Vista

    Hi All, We're using Filemaker Pro and Filemaker Server for a variety of different databases where I work. We're also taking advantage of the external authentication features of Filemaker so that we can get single sign on for our Windows machines (we use Active Directory too). We recently...
  3. drtree

    Postal Image Transfer - Any Solutions?

    Hi All, I've been asked to do some try and find a solution to a printing problem we've been having here (and from what it sounds like, it's a problem everyone's dealing with) - postal image transfer. The envelopes go out fine, but once the constituents get them, they're smudged or the letters...
  4. drtree

    Open URL - Open link in current browser window

    Hi, First, thanks for any help I get in advance. I have been playing with Instant Web Publishing. It's pretty cool, and I've been playing with the Open URL script step to jump between database files. I was just wondering - it seems like the default behavior for this step is to open the link in...
  5. drtree

    Record Navigation using a Drop-Down List?

    Hi All, First, thanks in advance for any help I may receive. I have a database full of job applicants and the application process consists of several steps. My boss has asked me to put together a form that will allow the HR people to track this process using FileMaker Pro. I put the form...
  6. drtree

    Report Documentation

    Hi All, I was checking out some of the documentation tools for Crystal Reports (Report Miner and Report Analyzer) and just wondering if anyone had used either product (and if so, what did you think of it?). I'm also considering making up my own app in Visual Basic - has anyone given this a...
  7. drtree

    Detecting Open Database Connection

    Hi All, I'm creating a web application using JavaScript and have created a function that returns a recordset based on the contents of one of the parameters - a SQL statement. To get the recordset to work properly after it's been returned from the function, I've had to leave the database...
  8. drtree

    Detecting Open Database Connection

    Hi All, I'm creating a web application using Javascript and have created a function that returns an recordset based on the contents of one of the parameters - a SQL statement. To get the recordset to work properly after it's been returned from the function, I've had to leave the database...
  9. drtree

    SQL Server to Access Question

    Hi, I have an Access database that serves as the database for a website. It is an Online Community type website, where users can update their information, search for other users, etc. Each morning, a data entry person will come in, run some reports (in Access) and get a list of all the...
  10. drtree

    Report Design Question

    Hi All, This is more of a general question but I was just wondering if anyone had read any books on general report design (things like how one should layout data, what elements to emphasize, repeat, etc)? If so, can you recommend any? I am finding that at times, my reports, although they...
  11. drtree

    DTS and Microsoft Access

    Hi all, I have an Access database that is password protected that I need to update every night. I want to use DTS to do this, but was wondering how I could set it up so that I only update certain rows, how do I go about this? It looks like, at least on the surface, that the only thing I...
  12. drtree

    IIS Locking Files?

    Hi, I'm having issues with a database frontend (connects to a remote SQL Server DB) that uses IIS to 'present itself' (all of its pages are done in ASP/HTML). We run reports through this package, in PDF format, and every so often a user will not be able to delete an old report and/or the...
  13. drtree

    Linked Server Help

    Hi, I have a SQL Server 2000 box that is attempting to connect to a local Access 2003 database. When setting this database up as a linked server, where do I fill in the credentials? This database is not set up for multiple users; it is just password protected. Thanks, Doc Tree
  14. drtree

    Crystal Reports 9 Label issue

    Hi, I'm working on a report that will be used to print a set of 3.25 in by 4 in labels (6 labels per page). There's approximately 1 inch of pre-printed text at the top of each label. To account for this text, I have added an additional section (Detail A) above my initial data section...
  15. drtree

    Grouping Issue

    Hi, I have a report that lists people according to their country. I have given the country its own group, and due to the way the report is set up, I have put the person's name and address in the details section. For some countries, there is only 1 person, and at times, the report will put the...
  16. drtree

    FileMaker 6 Pro - Word Wrap

    Hey All, I'm a newbie when it comes to FileMaker and have been recently inherited a database where I work. One of the forms has a text field that handles variable length strings, and when the text wraps, the size of the field does not grow accordingly. How can I go about setting up the field...
  17. drtree

    Exporting Data with Field Names From Crystal

    Hey, in my office I have several users who export from our current report writer (R & R Report Writer version 6.5.x) to Excel, and then use that data to do a mail merge. The cool thing about this is that the field names were exported (in the first row) along with the data. I've tried to same...
  18. drtree

    Printing the Same Report Multiple Times

    I'm trying to print a report 3 times on a single page (its a receipt type report), and was wondering if this was possible in Crystal, or if I should just duplicate the report 3 times (recreate all the sections, place the appropriate fields in them, etc). Any help/advice is much appreciated. Doc...
  19. drtree

    Count and Query Problem

    Hi, I'm trying to write a query that will return the list of all stores that have had a specific type of sale 2 days in a row. For example, if store x sold 3 red dresses yesterday and 2 today, I'd want it returned, whereas if it'd only sold 3 yesterday I wouldn't care. I've tried using a...
  20. drtree

    Best Way to Store Constants

    Hey all, as usual, thanks for any help/advice. I am going through an old application I built in Access 2000, which relied heavily on VBA. I'm moving a lot of the functionality to Access (hey - I'm a newbie, its ok to reinvent the wheel, right :) ), and have a question regarding constant...

Part and Inventory Search

Back
Top