Search results for query: *

HEllo all. I appreciate any help you may be able to provide in this matter. I have an Access table that someone made to capture the results of a survey. They used a lot of yes/no fields and I need to capture all percentages on one report. I am not sure of Access has this functionality built in...

The code for the TotalTime is a VBA function and yes, sorry the dbo_ITRequestView is a table. (Going from Oracle, mySQL to Access has been a stretch.) The query worked fine this morning with no changes made except the addition of the OpenDateTime in the select statement. The VBA function...

Hi. I have a query that should ask the user for 3 parameters: OpenDateTime, CloseDateTime and Department. I run the query and I am prompted properly for the parameters. The query runs for a minute and then I get propmpted for the date paramters AGAIN! I pasted the query below and as you can...

Hi all. I am a bit of a programmer but this is the first function in Access VBA. I need som help desperately. I need to calculate hours between an open and a close time for a trouble ticket. The problem is I need to discard times after 4:30 PM and before 6:00 AM and I also have to discard...

Sorry if this is redundant. The search is not working right at the moment. I am preforming maintenance and prep work at a small company that purchased ACCPAC Advantage Series 5.1a with System manager, GL, A/R with the LAN pack. They are only using it with a single user and the LAN pack should...

I would suggest that if you want to use SO in production enviorment then you really should use 6.0. They made it a commercial product so that companies who wished an alternative to M$ Office could switch and be sure that they are getting a product with support. I run 6.0 on WinXP as well as...

For Oracle use something like this to get the last 7 days... SELECT somefields FROM sometable WHERE somedate BETWEEN (sysdate-7) and sysdate That will give you all the results for the time period between today and 7 days ago. And I disagree that Oracle is like SQL Server. Oracle has a lot of...

You definately have to redefine the columnname. There isn't a workaround for the date reserved word(s) in Oracle.

I think what he is getting at is he wants the text doc to open in a frame based app LIKE when you open a PDF. I agree with meadandale though. This seems irrelevant since browsers can already open text docs.

Which version of the Oracle Universal Installer are you using? If you have a Pentium 4 with a CPU of 1.6 GIG+ then you need to make sure that at least UI version 2.2 is used. Don't ask me why. Metalink has a few entries about this as well. We had a heck of a time trying to install this for a...

I have another suggestion that would make your life a little easier. If you are NOT a linux pro then try out ClarkConnect (http://www.clarkconnect.org). You can download for free a boot disk maker. Put the bootdisk in the PC you want to act as a server or g'way. The PC will reboot, connect to...

I use JDeveloper, which is an Oracle product. Free download (you have to register). Go to http://technet.oracle.com There are a lot of good features like code coach. I used that a lot when I was learning. It is a sort of autocomplete. It is pretty hard to remember all the methods and variables...

Finally Java has a somewhat decent answer to regex!

Although I can completely understand compiling with a JRE, I can not understand why you would want to compile Java to .exe. Can you explain why and maybe we can put you on a different path. The main reason you would want to use Java is for portability which you lose when you compile .exe. Not...

jdbc:oracle:thin:@<hostname>:<port>:<dbname>,&quot;uname&quot;,&quot;passwd&quot; Is the correct form of URL. I use the one above to connect to my database, all the blanks are filled in of course

Actually now that I look further at it....You DO NEED to use a thin driver for Applets.

I believe that this is an interesting issue that can not be easily fixed. M$ is a huge $$$ amking corporation that believe that nothing should be given away and, as such we see such blatant disregard for the M$ customer base who really has no where else to go. You might say, &quot;Well you...

I know it doesn't make any sense. Why would you want to nail one foot to the floor that way? The true beauty of the Java platform is that it is portable...no other language does that. If you want to use .exe then perhaps C++ would be a better suited language to your needs.

Yes I agree....the fact that you threw an SQLEXception rather than a driver not found error seems to corroborate that theory. However you are NOT using Oracle or you wouldn't be using an ODBC:JDBC bridge. Which database are you using? Adabas? I am trying to figure out which driver you got from...

YES!!!! Praise MySQL. I am actually an Oracle developer but for the majority of my clients I suggest and use MySQL. In recent benchmarking between all the &quot;production level&quot; databases for web applications, MySQL beat even Oracle for speed in databases with less than 1 million records...