Thanks but I've tried this. I just get an error saying :the expression you entered refers to an object that is closed or doesn't exist". I've seen that reference sheet you sent and I think in that case the two subforms are nested, or else there's something about the SourceObject property. But...
I have 2 subforms (completely independent of each other) on a main form. When I click on a checkbox on subform1, I want to set the SourceObject of subform2. I've tried for a day different combinations but can not figure it out. Is this possible?I've tried putting this into the On_Click event of...
I'm getting a limit from a text box control on an EIS. When the user enters something into this textbox and then hits enter, Brio moves the cursor to the next line in the text box. Is there any way to change this behavior so the cursor moves to the next control.
Because the text box is only 1...
I'm trying to use a batch file to copy a file from a web site to my local machine. The web site is ftp: // username:password @domain.com. Do I need to reference an ftp file in the batch. I'm not really sure how to go out and grab it. The batch I've been trying is:
echo open ftp...
I am getting a error message when I try to open a bqt.document that worked fine for the last year. " An unknown error has occurred. Please restart your application." This happens when I click on the file. I assume it's corrupted. Is there any way to save it?Any thoughts would be appreciated.
Is there a way to truncate a date field in an Access SQL join statement. I'm joining a date field with a date-time and a field with just a date, but not returning anything since there are no matches. Is there a "trunc" function that can be used in the join statement, like there is in Oracle?
That bad boy works! Thanks very much. I really didn't think anyone would respond! It looks like you're concatenating a space. Can you explain why this is neccessary. I didn't see any refernce to this on Informix web sites. Thanks again
Thanks for your reply. I appreciate it. I still get ..."an illegal operation against a datetime field" . I've tried some modifications, and tried to simplify the expression to find the offending operation. I'll play with it but if anyone has suggestions... Thanks again.
I'm trying to pull records which were created in the last 30 minutes, but I'm confused with Informix datetimes. My where statement is listed below.
row_date is a date type, starttime is a small integer, a typical value for startime is 1800.
WHERE
(hvdn.row_date = today -1 and (hvdn.starttime)...
Is there an option somewhere to prevent a user from bookmarking an asp web page. I only want them to enter the web site from the home page. I don't want them getting several pages deep into the web site, bookmarking that page and using the bookmark to get into the web site next time.
I'm trying to set up an email task in a workflow to run based on a value in a transformation. i.e. In a mapping, I have a expression transformation which calculates a value. Depending on what this value is, I may want to kick off the email task. Is there a way to read the transformation value...
I'm using a VNC client to connect to a network machine with VNC services running. I can see the desktop of the remote machine, but the remote cursor does nothing. I can't open anything, I can't send a control-alt-del. Any thoughts? Your help is appreciated.
Row 1 would be replaced by row 1 of the spreadsheet. Row 2 by row 2..., row 1000 by row 1000, then row 1001 by row 1 of the spreadsheet, 1002 by row 2, etc. Now that I've thought about a little more, I'm thinking of using a sequence generator to number the rows and just recycling the 1000 rows...
I've also had this problem with Powercenter 6.2. I figure it's either a bug (we just upgraded to 7.1 and I haven't seen the problem yet) or it's some sort of firewall issue with the debugger since it runs on a different port.
I have a table of customer data with a million rows. I also have a excel table of 1000 first names. I'd like to replace all 1 million first names of in the customer table with a name from the excel table. I guess a loop to replace the first thousand names, then go back to the beginning of the...
Our Access database has several linked Oracle tables which belong to an Oracle database on another machine. When data is uploaded from native Access tables to the Oracle database using a module, is there a way to make the connection secure? Is there some kind of "trusted connection" option? Thanks
A user logged on to a web site on an intranet from his local machine. The web site contains many links to excel spreadsheets on the network. The hyperlinks to these excel files use absolute paths. i.e //server name/directory name/ excel file name. He then logged on to another machine and all the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.