Search results for query: *

One thing to note is that I'm setting this up in a macro, and the To field somehow doesn't like just Environ("username")...Is there something else that I need to put in??? I've tried &Environ("username") And I tried Environ('username')

Yes, that is my intent for them to email this report to themselves once they are done with the program. And that's why I want to use Window NT ID with @company.com Thank you

I'm using a sendobject macro to automatically send email to the user with the result from Environ("username". In the To section, I wrote Environ("username")&@company.com But that doesn't work...What am I doing wrong? thank you

Actually, I try the following code, and it displays the day of the week now instead of blank, but the data is wrong...It seems to always be a day ahead. So instead of Friday, it would have a result of Saturday. Here is my code: ENDDATE/I6YMD = REQUESTED_DATE; DAYOW/A3 = DOWK(ENDDATE,DAYOW)...

I tried using the the method where if the enddate is on a weekday, then I'll increment the result to 1, but if it lands on a Saturday or Sunday, then I'll leave it alone. However, I tried using the following function to determine the weekday, but it is not working for me. Am I doing something...

I have a problem calculating business day because it is short on one day: For example: TODAYDATE/WYYMD=&BEG; DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD'); Suppose TODAYDATE = 20041211 (Saturday) ENDDATE = 20041218 (Saturday) The diff will come out as 4; however, I wanted to come out as 5. The...

Thank you, it works great!

I figure it out on how to calculate it, but then I'm having difficulty trying to get WKDT or MTHDT into variable so that I can use it in my where statement. Example: WHERE REQUESTED_DATE LE '&ADVDATE'; Here is my code: DEFINE FILE ALLWORK4SCHED DATE1/YYMD='&RCD'; WKDT/YYMD = DATEADD(DATE1...

I even try doing this, and it still doesn't work. SELECTDT/YYMD = DATEADD(&RCD, 'D', 7)

I search for other thread concerning this issue, but it doesn't help my situation. I have a graph in (FEX1) with a requested_date as a drill down parameter into FEX2. It passes in a date with the following format: 2004/12/05 After it passes in, I want to add 7 days to it, so the result is...

I need to pass at least 3 variable along with the url string that callS the FEX(WORK). Somehow, it lets me pass the value, but not variable. Please help with the syntax. This one works: "http://servername/folder/ibi_cgi/ibiweb.exe?IBIF_ex=WORK&BDATE=20041122" However, this one doesn't...

I currently have WebFocus version 4:36, and I want to be able to incorporate two graphs into one page. I tried the following code, but it is giving me error message. And both file work okay independently; however, when I do include, it doesn't work. Here are my codes: SET GRAPHEDIT = OFF...

The reason it didn't work for me the first time was because I didn't run it in the MRE, but through Desktop Power Reporter. However, I have another question, which has to do with formatting. I tried to make the hyperlink to have the white color, but instead it default to blue. Is there a way...

I have an html page with form that ask the users for unit# & password. Let's call this page htmlPg1. After I submit this htmlPg1 page, it would go to another html page called htmlPage2 & ask for more criteria. However, I want save unit# and password in a variable & hopefully carry it to...

I tried the later piece of code, and I got error msg: FOC227: THE FOCEXEC PROCEDURE CANNOT BE FOUND: TEMP0037FOCEXEC*

I have a simple FEX that lists out all the reports name. 3 of the reports will run another FEX when clicked; however, the last one is either getting an Excel file in the server or link to a website somewhere out in the Internet. But I can't seem to get it to work because I got an error message...

Error Msg: Could not use 'BackEndData.mdb'; file already in use. This error message only pop up for one of my users, and I'm not sure why it is the case when other users open the application just fine? Is there a reason why it happen to this particular user? Please help, thank you!!!

I have an edit check where they can't click next button until they enter the result. But it turns out there's a loop hole where the user can use the scroll in their mouse to go to the next record w/o clicking the next button. If I can't prevent this, then there's no purpose in doing the edit...

Like I said, I don't receive any error message, it ran without the graph showing up. I have a feeling that it might cause by different version of the web browser.

Let's see if I understand correctly. When I run the FEX, it takes me to a web browser screen, and I'll replace the address that's already in there with the address you mention above except replace it with my server name. Then I enter my criteria & parameter. If that's the case, then i did...