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 bkrike 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: herschelrj
  • Content: Threads
  • Order by date
  1. herschelrj

    IF THEN Question

    I am adding an IF THEN Statement to a display string. IF Count ({PS_EMPLOYEES.EMPLID}, {PS_EMPLOYEES.JOBCODE}) > 100 THEN "Needs Attention" ELSE CurrentFieldValue I can't get the current field value to display if less than 100. It is coming up blank... Please HELP!!! Thanks herschelrj
  2. herschelrj

    Close window behavior

    I need to have a link to close the browser popup when clicked and one that will go to a url in a new window and close the current window. Any ideas??? I know it can be done. I just am not too sure how.
  3. herschelrj

    Posting form data to access database

    I am trying to take some form data and put it into an Access database on the webserver. Any help??? I was using Frontpage but now Dreamweaver. Here is the code for the form... <form method="POST" action="sh_reg.asp" name="FrontPage_Form1" language="JavaScript" onSubmit="return...
  4. herschelrj

    Tabs

    I saw a website that uses tabs as navigation. Does anyone know if this is an applet or can this be done with dreamweaver delivered??? http://sandi.net/staff/staffbull/2006/1103/index.html is the site.
  5. herschelrj

    Getting Number of years from subtracting dates

    I have two date fields, a hire date and a term date. I would like to subtract the hire date from the term date and come up with the nuber of years or partial years. Any help appreciated.
  6. herschelrj

    Pointer Hand on Pop-up Link

    I created a pop-up browser link. But when you run the cursor over it, it does not show a hand. It stays as an I beam. Help!!!
  7. herschelrj

    Date to Age

    I need a formula that will convert the date of birth to their current age. Any help would be appreciated... Crystal Reports 10
  8. herschelrj

    Publish Finished Website

    All, I have just completed a website with dynamic pages. Everything looks and works great on my local machine. Now I am ready to place it on the production webserver. When I place the folder on the server, everything breaks. I end up the code being displayed instead of my data. I know it is...
  9. herschelrj

    Not resize in browser

    Where do I find the setting or how do I get a page to not resize in the browser when you change the size of the browser? Should I set the pages to 100%? Any ideas appreciated... herschelrj
  10. herschelrj

    Dynamic Drop Down list

    Anyone know how to populate a drop down list in a form using data from a query and still have it insert when the form is submitted? Thanks for any ideas...
  11. herschelrj

    Database Results

    HELP!!! I have a registration page that shows when a class is available or closed. It worked like a charm. I used the wizard to get it working. IT restarted the server and now my results page no longer works. The for works. The database connection works. But the Database Results returns the...
  12. herschelrj

    Remove dashes in ssn

    Can some help me with a query that will remove the dashes from the ssn. The field type is text so I can retain the leading zeros.
  13. herschelrj

    Submitting a form and checking a query before submitting

    I am trying to learn how to submit a form and have it check to see if a particular course is full by checking a query that will give it the information and return an error "Class is full, please choose another date" without having to re input all previous form information. Any ideas??? herschelrj
  14. herschelrj

    Check qry before submitting

    I have a registration page that needs to check to see if the course is available before submitting for confirmation and bringing back an error if the course is not open. Anyway to have the form run that check before submitting to the database? Any help is appreciated... herschelrj
  15. herschelrj

    IF THEN With a string in a query

    I am trying to do the following. I created a query that gives me a count of employees and grouped by a registration date for training. I would like to display "Session Full" if the count is greater than 95. I tried to use an IF THEN statement in the criteria but keep getting a syntax error. Can...
  16. herschelrj

    Stacking Subreports

    Question... I wouls like to display the information from one subreport. But if that report is blank, I wouls likw to display the second subreport. Some of the records have information in both. I want to display the first one only if both contain data. Any ideas? Display CTY Credentials. If...
  17. herschelrj

    Bring in Records with a Null Value or no Value

    I am running a report in version 10. I need to include the records that have no values. Just have them there for reference. Any Ideas??? Example... I am bringing in all Nurses, Librians and Counselors for aprox 20 school sites. Some of these sited do not have librians, or maybe no counselors. I...

Part and Inventory Search

Back
Top