Search results

  1. B

    Question Only the network admin can get the MS Access 2007 database to connect to the Oracle?

    We were attempting to connect Oracle database from Access 2007. We installed MDAC 2.8 and created the DSNs and everything seems to be working fine when the network admin is logged in. Once he logs off and the normal user logs in the ODBC connection doesn't seem to work. I get the following...
  2. B

    Display results of a query in a textbox

    I have a form in which a lot of data is related with the case number. What I want to achieve is when the user enters the case number all related information should be pulled from the linked tables and displayed in the texboxes and it works fine if I change the textbox into listbox and make the...
  3. B

    Converting user defined oracle function into Access syntax

    I have a user defined Oracle Function that need to be converted to access syntax. Can someone help me with this. If you could guide me in the right direction(like right resources to read or similar examples), I can take a first stab at it. Asking someone to do it for me without attempting...
  4. B

    Different access levels within a table

    I have a table with 5 columns that needs to be accessed by multiple users. The 5th column is read only for common users and only the admins should have write access to that column. How can I implement this. I am building an access 2003 app using ms access 2007. Any help is greatly appreciated.
  5. B

    Vertical lines that grow with the fields

    I have a report that has a "comments" field that can grow along with few other fields that do not grow. I need to get vertical lines between the headers to form columns. How can I make the vertical lines grow with the fields so that it looks like one continuous line from top to bottom? I used...
  6. B

    Sharing same table between two different forms.

    I have one table that has data that I want the user to access through two different forms .The initial data entry (create record which enters data in field 1,2,3)work will be done in the in main form but the later updates (updates to filed 3,4,5) to the record will be done through the second...
Back
Top Bottom