Search results for query: *

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

Nevermind... I got it...

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.

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...

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.

Disregard... I got it. I took the number and divided it by 365 and have the desired results...

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.

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!!!

I tried this formula and when I check it, I get an error that says a date id required here where I replared the fild for the date. Can you help??? WhileReadingRecords; DateVar Birth:= {NC_05.DOB}; // Replace this with your field for Date Of Birth DateVar Ann := CurrentDate; // Replace this...

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

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...

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

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...

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...

I just did a find and replace on the table and it worked like a champ. Thanks for the help...

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.

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

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

Thanks to both of you. I got it to work with your help. Now I know I have to use the imediate if with queries. Again, thanks a million... herschelrj

Here is the SQL. SELECT LT9_FEB2005.crs_dt, Count(LT9_FEB2005.ID) AS CountOfID FROM LT9_FEB2005 GROUP BY LT9_FEB2005.crs_dt; I am looking for something like: If CountOfID > 95 THEN "Course is Full"