Search results for query: *

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

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

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

How does one find a row on a child view by the findbykey mothod? This is what I have: A master view called Individuals A child view called Telephones If i try to find a telephone by the telephoneid, and then navigate to the individual, it does not work. It seems like the rowset in the...

Hellow, I need to create a jsp component similar to dataTableComponent.jsp, only in edit mode. That is, instead of having plain values in the table cells, display input fields. In addition, display 5 empty rows for the user to enter new records. I am doing this by first iterating thru the...

Hello, We have a server connected to the internet and an oracle database on one of our internal servers with ip 192.168.0.1 We want to open Oracle to the outside. How do we configure Oracle networking to redirect any requests from the internet to the internal server? Chris Lambrou

Hello, I have just started developing a web application in Jdeveloper 9.0.3. I like all the nice code generation fautures, but does jdev generate java script validation code for required fields? PS: I see a lot of similarities in features with .net. Who copied who? MS copied oracle or vice...

Hello, I suspect that my ISP is now blocking port 135. Is there a command in XP that I can type to prove this? Thanks

Howdy, Is there an API access to Windows XP's winzip compression? I would love to use this in my VB apps, but searching the net produced no results. Thanks, Chris.

Howdy, Whats is the best way to handle number (currecy) storage? Access stores Currency values with 4 digis precision. So if you have 4 currency fields and you do a sum of them using SQL, you will not neccessarily get the expected result. The way I see it, there's 2 ways: 1. Round the number...

Howdy, We have an MSSQL 7 datafile on a win2k machine that crashed on us a couple of weeks ago (hardware problems). We setup another machine, but we are know using SQL2K. Is there a way to get SQL2k to read/use SQL7 datafile? Thanks, Chris Lambrou