Recent content by cglisc

Thank you all for the answers, although down the road this became an excel thread. What I am actually looking for is something similar to oracle's months_between function, and then devide by 12. If you do this in in oracle sql prompt select months_between( to_date('1-11-2006','dd-mm-yyyy')...

Hello, We are looking for a VBA function to calculate the exact difference in years between 2 dates. The problem at hand is to calculate the years of service of a employee with a company, which is the year difference between now and hire date. DateDiff will not do, since it returns a long...

We have this statement in our database: select <primary key> from <table> where <primary key> = 1 for update. Issuing the above statement in 9i, results in a ROW-S (SS) shared type of lock on the table. However, in an identical database in 10g, it results in ROW-X (SX)type of lock. we see all...

Hello, I have a case when if a report is opened in normal mode, ie sent to the printer, the records included in the report must be marked as "printed". Updating the records is the easy part. The difficult part is: How do I know that the report is being sent to the printer and not to preview...

I have a situation where from FORMS I call a store procedure in a package that has a sys ref cursor in/out variable. When I open the cursor, and test foe %ISOPEN, it returns false. Does Oracle Forms runtime closes the sysref cursor? Testing from sql/plus works fine and the cursor is opened...

>Why do you have required items >if the block is not based on a >database object? Because we eventually update database tables with data in the unbound blocks. We set the required property to true to certain fields and let forms do this validation for us.

Hello, We have a situation where a form has 2 blocks: A "Main" block and a child, detail block showing multiple records. When a value in a certain field changes on the main block, we open a cursor and populate the child block. GO_BLOCK('child'); open cursor loop and populate child block...

Would anyone know if MS plans to incorporate .NET into the new Access 2007 development environment? Of will we have to continue with VBA? The reason I am asking is that we have an MS access application that we plan to convert to .NET. If access 2007 will be ".NETified" we might as well...

Hello, We are having a problem sizing a text box in a report. The text box is actually a vertical black line, width should be excatly 0.05 cm. We turned off snap to grid options on the report, right-click on the field and choose Object Size and Position from the shortcut menu. In the width...

Hello, I need to print a field on page 1 of a report only if the total number of pages in the current group exceeds 5. Is there a way to know while I am on page 1 the total number of pages in a group. To complicate matter more, the page count is calculated using a formula and is not the...

Hello, Is there a way to show Contacts from my personal exchange account to a global address list that everyone in the organization can see? Thanks, Chris.

Hello, We have an application that was developed in MS Access, with the a front end access mdb and a database back end. We use ADO 2.7 to do the SQL work. We are now requried to have 2 versions of this application, both using MS Access and SQL server as the back end database, depending on...

I forgot to mention that we do not refresh the links, but we actually recreate them. This is because due to security reasons we are required to remove the links as soon as the MDE exists. Probably this is the peoblem?

Hello, I am looking for advice as to how to speed up attaching tables from an mdb on the network. Our application is separated in 2 parts: an MDE acting as the user interface and an mdb database for data. At startup of the mde, through VB code, we refresh the links to the tables in the MDB...

Hello, I noticed that in Outlook, there is a checkbox to mark a contact as Private. Where do *non* private contacts appear? We are actually looking for a way to share contacts among our exchange users. What is the &quot;best&quot; way to do that? Chris