Search results

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

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

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