Search results

problem only seems to occur with dates before 1/1/1930

I have a problem where I dynamically write a piece of SQL and then pass that SQL straight through to Oracle using VBA code to open a new Oracle connection. All works fine here. Oracle then returns a result set that gets written to an ADODB recordset object. All works fine here. The results...

The problem turned dout to be bad data in the underlying database. Once I figured out that Oracle has a NVL() function that does the same as the MS Access VBA NZ() function I was able to code around the problem. The object mentioned generating the error code was the recordset. the larger the...

dim strSQL as string strSQL = "INSERT INTO strSQL = strSQL & " " strSQL = strSQL & "tblschedule_lineitem strSQL = strSQL & " " strSQL = strSQL & "(" strSQL = strSQL & " " strSQL = strSQL & "labor_name" strSQL = strSQL & ", " strSQL = strSQL & "shift strSQL = strSQL & ", " strSQL =...

I'm not sure what the limiting factor is with modules. I just know that when I would write and test code in isolated modules, then copy paste them into pre-existing modules the code would get stuck on lines of code in the pre-existing module where it would not get stuck without adding the new...

I'm still wondering if it is a problem with too many lines of code in your form module. Are there any blocks of code that could be copied from the form module and pasted into a general module (aka overflow module)? This approach has worked to resolve similar problems for me many times. I...

Does the pause go away when you set these form properties outside of the VBA module or from a function call to an external code module? I've seen odd behavior similar to this when too many lines of code appear in a single module. In those instances it appeared that only the first X lines of...

You have doublequotes inside of your string. You also did not terminate your SQL statement with a double quote. You can replace quotes inside of the SQL with single quote marks, or build your SQL statement as a string variable and concatenate CHR(34) double quotes or CHR939) single quotes into...

I've got a block of code that inconsistently generates the following error when exporting data to MS Excel. ENVIRONMENT MS Access 2000 Windows XP METHOD (1) VBA module connects directly to an Oracle 11g back end table and creates a recordset. (2) Record set results are used to populate an...

always remember that you need to explicitly write your punctuation. If you are passing a value into your SQL statement make sure you wrap it in the correct characters. Here are my most frequently used ascii character codes Character Equivalent Use...

Thanks! This is very much what I have been hoping to find.

I'm trying to figure out how to create an ADO recordset object to run in MS Access 2000 on Windows XP SP2 desktops based upon a pass-through query to Oracle 11g v2.

...writing to interface with Exchange Server is so much simplier than interfacing with Lotus Domino...for reference, anyone who wants to generate and send mail through Domino I would highly recommend reviewing the following URL: http://www.fabalou.com/vbandvba/lotusnotesmail.asp This is the...

jumping back to the original ADO question...I create ADO recordset objects with the following syntax strSQL = "SELECT ...." set rst1 = New ADODB.recordset rst1.Open strsql, CurrentProject.Connection, adOpenForwardOnly,adLockOptimistic

Can anyone help me understand these arguments/parameters?

I'm trying to understand how to read/set an ODBC connection string from MS Access. Could anyone help explain the parameters that are used when establishing a connection? Here are the parameters: 'ODBC = connection type 'DSN = data source name 'DBQ = database name 'APA = 'QTO = 'FRC = 'FDL =...

For Question #2, you would dynamically build the SQL that defines the rowsource/recordsource property of the listbox. To do this you build the SELECT statement in code using values drawn from your unbound controls on the form to populate the WHERE clause of the SQL statement. I like to store...

There are several ways of handling this. Assuming that there is no actual security system, you could simply hide the login form and bind the label of the next form that opens to the control on the login form. If you want to use the Windows login account, then you would make a call to the...

DAVIDATWORK, you provided a great solution here. My assumption was that there would be that the database window was hidden and all users would be accessing the system via forms. click, mouse over, upon exit events would be the means to determine that a user is actively in the system...

This sounds a lot like an issue I've got in the VBA forum. When I copy an Oracle table into a local MS Access table everything works normal. When I connect to the linked Oracle table things fail. The going hypothesis is that the MS Query Optimizer is finding fields with indexes and optimizing...