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!

  • Congratulations SkipVought 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: *

  1. Jusfire

    Add Fields Based On Criteria

    Here's my SQL statement SELECT SV.EmpID, SV.PSV, ([PSV]+(Select SUM(PSV) From SV Where Employees.Boss = SV.EmpID)) AS GSV FROM Employees, SV GROUP BY SV.EmpID, SV.PSV;
  2. Jusfire

    Add Fields Based On Criteria

    What you have doesn't return the proper figures.
  3. Jusfire

    Add Fields Based On Criteria

    Here's what I have... A table of Employees (EMP) with a field that identifies who their Boss (BOSS) is. A table of Sales Volume (SV) conducted for each Employee. What I need to do... Construct a query to give me a total of their Personal Sales Volume AND the Group Sales Volume including all...
  4. Jusfire

    Setting Up Tables & Relationship

    Hey all been awhile since I've been here so here goes... I would like to set up data so it'll end up like this 101 102 103 104 105------109 106 111 107 114------115 108 116 117 110 112------118------120 113 119 Basically, it's the old boss employee thing --...
  5. Jusfire

    Design Suggestions for Time-Based DB

    Tom and Ed I appreciate your suggestions. To answer your question Tom...I'll be using Access2K. Additionally, I'd like to say that I like the idea of not storing stuff you don't immediately require. As for the sys-adjust field, that's a great idea. I've always wondered what the best solution...
  6. Jusfire

    Design Suggestions for Time-Based DB

    I would like to design a db to track hours spent on projects. The one question I have is how best to design it so that staff cannot have multiple "timecards" for a period or more importantly overlapping times. Any suggestions would be helpful. Basically it's a list of who's worked on...
  7. Jusfire

    A list of Error codes?

    Does anyone know of an error code reference list online or elsewhere? Would be helpful for debugging (for me and probably others).
  8. Jusfire

    Garbled pdf output

    One other thing I forgot to ask...which workstations are not printing correctly? The Win98, Win2K, both???
  9. Jusfire

    Garbled pdf output

    I first must say that your links to actual views of the output and the pdf are wonderful. I know dealing with pdf forms is a time saver...but when they are created by other people and you have problems with them, they can be a headache. Have you check to see if the suspect font, which I...
  10. Jusfire

    Printing Data Only onto a pre-printed form

    This may or may not be of any help...But, I've done this utilizing a pre-printed form and a simple Access Database. Scanned the form and included it in an Access Report as a View Only object. I could then choose which records I wanted to populate the form. On print preview, the data appears...
  11. Jusfire

    Garbled pdf output

    Hmmmm...can you specify what printer you are using? Various things come to the top of my head...Most of which are based on determining if the problem lies with the file(s) or the printer (or printer drivers). [ul]Does this occur when printing all pdf's or just certains ones? Have you tried...
  12. Jusfire

    Easy Combo Box Question...

    I really don't want to get in the middle of this but I have to ... Attrofy, I'll agree that you could use either (SQL/Query) to get proper results as long as data maintains proper form. Your question - how do you keep your end users from having to click several buttons ... Manipulate...
  13. Jusfire

    Adobe Acrobat 5.0

    I'm not really sure if you problem lies with the application, it's settings, or something else. But, check out Adobe's Knowledgebase Document #326346 (Unable to Print to Distiller Printer 5.x for Windows) at www.adobe.com/support/techdocs/2adaa.html ... or search for it by number on their...
  14. Jusfire

    Auto-create .pdf

    You may want to check out adobe's developer knowledgebase at support.adobe.com
  15. Jusfire

    Cant See Text

    Well, first...remember one reason why pdf's are useful. The retention of formatting (fonts, etc.) whether or not the user/viewer has them or not. Initial questions come to mind though... 1.Which versions of viewers are you using on each machine. 2.How was the pdf created and what options...
  16. Jusfire

    The file is damaged and could not be repaired

    Ok, here's everything I can find or think of...Adobe and Microsoft both appear to indicate that the plug-ins Acrobat Reader 5.0 installs may not be read properly from the registry. It also appears that they suggest re-installing the Adibe software to ensure that the plug-ins are correctly...
  17. Jusfire

    The file is damaged and could not be repaired

    Thanks for the info...I'll think about some possible culprits and get back to you later (since I'm starting to get busy).
  18. Jusfire

    The file is damaged and could not be repaired

    My question would be... First, does this happen with every pdf file, every pdf from a particular source, or with just one file. Second, what version of Reader and Internet Explorer are you using. Third, what Operating System are you using. Forth, have you searched the Adobe Support...
  19. Jusfire

    disable tab stops

    I can't think of a way off the top of my head, but if I get a chance I look for ways to completly eliminate fields in the tab order. In the mean time, some things I can offer is to force the checkbox fields to the end of the tab order. This would make the user believe that it's easier to hit...
  20. Jusfire

    pdf open not download

    I think if you click and hold it'll give you the option of saving the file.

Part and Inventory Search

Back
Top