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

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

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

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

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.

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

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