Search results for query: *

I am trying connect MS-Access 2007 database to Oracle SQL Developer. I used the following in tnsnames.ora file: alias = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.mycompany.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) )...

It Worked! Thank you so much PH!

I have set up a form with two text boxes which feed the search words in a query. The first text box is mandatory. The second text box is optional, it only appears if the user clicks on a check box in the form. This is how it is supposed to work: The user will enter a single word or string of...

Duane, I was getting that error because the first field of the table was the primary key. I used Me.Undo as you suggested. It works perfectly. Thanks, Mark.

Duane, I tried Me.[boxName]= Null but I get an error saying that a value should be entered in the first field of the table. Is there a refresh or reset option that can work in the place of Null or ""? The clear command button will be mostly used as a undo option before the record is actually...

I have a form which has Text, Check and Combo Boxes which are connected to corresponding fields in a table. I am trying to code a 'Clear' fields button to clear/delete contents of these boxes on the form (not table) if the user feels that the data entered was wrong or wanted to start over. I...

Thanks PH! It worked!

Thanks for your help PH but I forgot to mention in my initial question that I needed the simple query to return only the latest record based on the time and date not just the date. I tried to use your solution with time but it returns all records for the date. To return only one record the...

I am trying to write a simple Access 2007 query that returns only the latest record based on the date from a table that contains name of person, date and time of contacting the person. I have tried Max and Where <=Now() but even with these conditions running the query returns all the records in...

Thanks Duane. It worked. I went to Access Options->Current Database->Document Window Options and chose 'Overlapping Windows'. Thank you very much.

I am using Access 2007. The design view window always opens in the maximum size. Is there a way I can change this default to open in a sizable form i.e. in the view with the min, max and close options showing on the top right corners? Thanks, Mark.

Macropod, Your formula is good and simple but it has a small problem. When you try to use it for a number like 4.083 it results in 4 years 0 Months and 30 Days instead of 4 Years 1 Months 0 days. Thanks for the suggestion anyway.

Looks like it is finally figured out Cell A1: 6.196 Enforce 3 decimal places on cell A1 by using =FIXED(A1,3)[optional step] =INT(A1)&" Years " & INT(((ROUND(((A1-INT(A1))*360),0))/360)*12)& " Months " & ROUND(MOD((ROUND(((A1-INT(A1))*360),0)),30),0) & " Days " Result: 6 Years 2 Months 11...

Here's the math 1 ÷ 12 = 0.08 2 ÷ 12 = 0.17 3 ÷ 12 = 0.25 4 ÷ 12 = 0.33 5 ÷ 12 = 0.42 6 ÷ 12 = 0.50 7 ÷ 12 = 0.58 8 ÷ 12 = 0.67 9 ÷ 12 = 0.75 10 ÷ 12 = 0.83 11 ÷ 12 = 0.92 12 ÷ 12 = 1.00 So for 0.80, it should be 9 months and 18 to 24 days?

Very funny MintJulep! You know I meant 'convert'!

How can I change a number like 3.80 into 3 Years 10 Months ?? Days? Thank you all.

Skip and Lionelhill, Thank you both for all your help. Yes, Skip I am sorry I misworded the question. But your first solution did the trick with one small change i.e. changing "<0" to ">0" for the denominator...

Skip thanks for the prompt response. But, I clearly mentioned in both the postings that "I want to select the value in the first column that adjacent to the first positive value in the second column". So the first positive value in column C see is $4000 and $5000 is adjacent to it which is what...

Thanks for your responses Lionelhill and Skip! Lionelhill’s solution works but I want to select the value in the first column that adjacent to the first positive value in the second column. I am trying to create an automated payback period table which calculates the payback period. In the...

I have 2 columns of data which are a list of numbers. The second column contains a list of numbers which changes from negative values to positive values. I am trying to find a way to select the cell in the first column which is adjacent to the first positive value in the second column. Please...