Recent content by BPlenge

I have a program that I’m attempting to get counts using ADO. The code is below. Global Const ConnString = "ODBC;UID=user;PWD=passwd;DSN=ORA" Dim OraD As ADODB.Connection Dim rsPreSample As ADODB.Recordset Set OraD = CreateObject("ADODB.Connection") OraD.CommandTimeout = 0 OraD.Open...

From what I've learned, Access 2007 does not allow you to use ODBCDirect anymore. Our system has Oracle 10-g installed, which is what we've had for a while. I have not had any errors telling me to install a new driver.

:confused:I have found that 2007 does not have ADO as a default reference which causes problems elsewhere. Does 2007 have a form of DAO that it supports. Is there a better method of opening an Oracle file? Thanks so much.

I have a query, and one of the fields has a prompt for user input. Is there a way for the prompt to take multiple values?

I have a database with forms that use ADO to access data files. In the design stage, I went into Tools/References and checked "Microsoft ActiveX Data Objects 2.1 Library", which made the ADO work. For each “case” that is run, the application creates a separate database and copies all forms...

I've seem references to DAO, but it will no longer allow the use of ODBCdirect. "dbuseODBC" is the statement refering to ODBCdirect. I've seen suggestions to make a reference to MSDAO objects under tools References, but I'm unable to find anything pertaining to MADAO. Does anyone have...

In Access 2007, when I attempt to read from an Oracle database, I get the following message: Error 3847 - odbcDirect is no longer supported. Change your code to use ADO instead of DBO. I am attempting to change the code from: Dim sql as string Dim rsProv As Recordset Dim OraD As Database...

I have the running sum in group 3. It resets when group 2 changes values. Is there a way to get it to reset when group 1 changes values? Thanks.

Doc_Man - Thanks for your reply. I don't want the counter to necessarily reset at every page. Basically, what I'm trying to do is a running sum within a group. The report has three groups. I tried the regular running sum function on the report, but the report is basing the count on group...

I am using the following code to generate a sequence number. It works, but my issue is that it starts numbering on the second record. IE: record two shows a 1; record three shows a 2, etc. Can some one tell me how to make the first record show a 1, etc? Dim DtlSRecipIDCurrent...