Search results

I know this is an old question but when I had a similar problem and searched I found this post. After scratching my head for some time I figured out the solution. In future if anyone is looking, my reply may help them. In the sql the field name he has used [Name] is a reserved word in access...

It was an issue with incorrect installation. The environment path variable was not set up correctly. When we entered the Oracle client location in the environment path variable it worked correctly. Looks like for admin user this was not necessary somehow.

The problem in the kb article doesn't seem to the issue in my case. As I can connect when logged in as a network admin. Moreover this problem is applicable to MDAC 2.7 . I have MDAC 2.8 sp1.

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

I couldn't get it without using recordset . Given below is the code that worked for me. Just putting it here in case it may help someone in the future. Private Sub CLAIMEDCASEID_AfterUpdate() Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim StrSQL As String Set cnn =...

The result of the query is indeed a single value.

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

You were right on. I realised later that some of the data types got changed when linked into access especially the caseid changed to string. Based on that I tried to tweak the code you sent to something like this and it worked like a charm. Public Function abs_get_issues(pn_CaseId As...

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

Thanks. I had thought about 2 separate forms method. I wasn't aware of the join type method. Looks like 2 separate forms is easier to implement. I am going to go with that.

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.

That's exactly what I was missing. I was using the report view. I should have used the print preview instead as you suggested. It's an on print event. Thanks a lot.

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

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

Do you still remember how you did this? I am in a similar situation. I have a report in which the text controls are aranged horizontally one below the other. These text contols can grow and shrink. I want to draw a line below each control that would move down or up as the control grows or...