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 Chriss Miller 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: DVFS
  • Order by date
  1. DVFS

    FileMaker 5.5 Data Querying?

    I am very familliar with SQL databases and am using FileMaker 5.5 for the first time. Is there any way to issue commands to query or modify large chunks of data? I am looking at the ScriptMaker from the menu but that appears to be some kind of Macro creator. I'm just not familliar with what...
  2. DVFS

    Body of E-mail Unavailable

    When trying to open sent internet e-mails from history I occasionally get the message "Body of E-mail Unavailable". Does anyone know why this occurs and how to correct it? Thanks
  3. DVFS

    Access to Others History

    I am having a problem getting the correct settings to allow users to view, edit and delete their own histories but only have access to view another users. When I take the check out of Access to Others History it sets it so they can't even view another users histoty. Please tell me the correct...
  4. DVFS

    SQL Table Linking

    Yes I realized I had an error in the statement after I posted it. However, this is exactly what I needed to know. Thank you very much for your help!
  5. DVFS

    SQL Table Linking

    BTW, I am using MS SQL 7
  6. DVFS

    SQL Table Linking

    Hi, I am new at using SQL and I made a very simple query to pull a few fields from 2 different tables. Now I need to add a field from a 3rd table but I am not sure how to link them. My statement so far is: select key1 as 'ASI#', contact1.Company, contsupp.contact as "Type", contsupref as "Web...
  7. DVFS

    Grouping / Count Problem

    I have a problem with a report I am doing where I need to get complete totals for codes but I am getting them separated by my groups. I have them grouped by Activity Code, Reference Code and then Result code. I would like the report to turn out like this - Activity Codes 1 - (count) 2 -...
  8. DVFS

    Setting a margin in Crystal?

    Is there any way that you can set a margin down the center of the report so data can continue and still stay on one page? I have 1 very narrow column that is just showing some quick totals and it is using 3 pages. They could easily fit on one page if I could make a margin. Thanks Joe
  9. DVFS

    Duplicate Records SQL

    Both samples worked great, I appreciate the help.
  10. DVFS

    Duplicate Records SQL

    Duplicate records ignoring primary keys. Sorry.
  11. DVFS

    Duplicate Records SQL

    What is a quick SQL query to simply show me a list of duplicate records that exist in a database?
  12. DVFS

    Linking Tables

    I am using Crystal Reports 9 and when I go to the Visual Linking screen not all of my tables come up with the color coded index markers indicating my indexes. They do infact have indexes but the markers only seem to appear randomly. I tried browsing to an external index but they still do not...
  13. DVFS

    Automated Roll-Over Problems

    I am having the same probelm. This only occurs with users connecting to Goldmine via VPN. It doesn't matter what user logs in, it still happens. Auto roll-over is disabled but this still occurs. I'd prefer to avoid rebooting the server. Does anyone have any other ideas what might be causing this?
  14. DVFS

    cdate conversion question

    Hi am am trying to get this string to date conversion working. When I check it it tells me there is no errors in the formula. However when I run the report I get "Bad date format string." Here is what I am trying to use: if {Contact1.ACCOUNTNO} startswith "A" then...
  15. DVFS

    Crystal Reports: Database Error

    When I am trying to run a report linked with 2 DBF files I get the error xBase error: Bad User Specified Key Expression. Does anyone have any idea of what this is and how to correct it? Thanks, Joe
  16. DVFS

    Order System

    Thanks for the tip. I'll def. check it out. Joe
  17. DVFS

    Order System

    My company currently uses Goldmine merge forms as it's order form system. We are quickly out growing this. Does anyone have any recommendations for a good (somewhat inexpensive) third party order system that 70 or so users can use. Any ideas are welcome, even if it doesn't interface 100% with...
  18. DVFS

    Parameter with Summary

    I have a report I am trying to show amount of scheduled events for a coming week based upon a parameter and summary formula. I have this formula I am doing a sum summary off of: if {CAL.ACTVCODE} = "TRN" and {CAL.ONDATE} = {?TRNSC} then +1 I simply want it to count the number of...
  19. DVFS

    Date - Time Parameter

    Hi, I have a field that I use in a parameter for a user to select the date range. The field is a date-time field and by default allows you to pick the time in addition to the date. It defaults to the current time. Is there a way to get this to default to a time I specify (ie. 12am) but still let...
  20. DVFS

    Groupwise 5.5 HTML E-mails

    Could someone please clue me in to the conditions in which Groupwise 5.5 displays HTML e-mails? It seems to sporadically display e-mails with embedded HTML. I have tried to figure out why some sites like MSNBC if sent throught Outlook can be viewed consistently but other sites cannot. Is there...

Part and Inventory Search

Back
Top