Search results for query: *

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

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

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

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

Last time, when I take away the SET GRAPHEDIT = OFF code off my fex, the graph print & show up just fine. But now, it's quite the opposite where it didn’t show up anything except a box with X on it. So when I put the line of code above back in my fex, then the graph shows back up. But my...

In SQL, I can use GROUP BY Work Code and it would give me a list of all the work codes within that table. Is there a same functionality in WebFocus

I have a history FOCUS file save in the F drive, which I tend to use every quarter for history reporting. However, this quarter, one of the field got bigger, so now I have to change the master file to reflect the change. But if I change my old HIST master file, then the HIST focus file won't...

I have an Access (.mdb) database called (LocalData.mdb) with just tables & no form. When it opens, I want it to append the record to another database, which happen to be connected to the SQL Server. What I did was create an append query. Down at the bottom I clicked Another Database. And it...

I have an Access database (.mdb) file from the vendor, which support one of the application. However, I want to the back-end converts to SQL Server instead. So I've done two ways: First: I have tables already created in SQL Server. So I create an Access project with those tables. So when...

I have an Access (.mdb) database called (LocalData.mdb) with just tables & no form. When it opens, I want it to append the record to another database, which happen to be connected to the SQL Server. What I did was create an append query. Down at the bottom I clicked Another Database. And it...

When I create a new project (.adp) file, I get my table from SQL Server. However, I can't seem to create view. It said "You do not have exclusive access to the database at this time. Your design changes will not be saved" Is there a way for me to create View in Access Project file or it has...

Is there a way that I can change this date format into the standard. For example: My current format is '200403261200' I want to change to the following: 03/26/2004 Is this possible?

I have two Access application. One is a regular database that I've created. Another is using Access project to connect to the SQL Server. How can I combine this two together meaning how can I get information from SQL Server into my database that I've created? Thank you for any suggestion.

The error states: (FOC1070) Value for join ‘from’ field out of sequence. Retrieval ended. Thank you

The situation is this.. I have two fields. One is in regular time & another is in military time For example: 4:35 regular 16:56 military So how can I convert one or the other into regular or military time. I need for it to be consistent in order for me to do computation like subtracting them...