Search results

TeeJay, This kind of data structure is not that uncommon. Look at any HL7 or X.12 data file. If you think about it this kind of structure makes sense. For example you might want to store a complete address in a single field. The address is defined as a collection of other elements such as...

I suspect your type mismatch is due to Lotus expecting an array of type variant. Here's the reference I've used before http://www.fabalou.com/VBandVBA/lotusnotesmail.asp Here's the code I wrote about 10 years ago Option Compare Database Option Explicit Private Const gstrObject =...

For the record, here are the values when the error occurs with my original code strFileExtension: xls strFilePath: H:\Book2.xls lng_Position: 3 strLaunch_Path: """C:\Program Files\Microsoft Office\Office\EXCEL.EXE"" ""H:\Book2.xls""" Error: 53: File not found Here's the code change...

The only way I've ever gotten this to work is to have the path to the executable is wrapped in double quotes, and the path to the file is wrapped in double quotes, and a single quote wrapped around the entire concatenated string. Here is what the debug.print outputs to the immediate window...

Arghhh.."Upload of attachment failed" Here's code to determine the executable file and path: Function apicFindExecutable(strDataFile As String, strDir As String) As String 'Resturns exectuable for passed data file. Dim lngApp As Long Dim strApp As String strApp = Space(260)...

I'm having to recode some old MS Access DBs so they will run in the following environments: Office 2000 on WinXP Office 2003 on WinXP Office 2010 on WinXP Office 2000 on Win7 Office 2003 on Win7 Office 2010 on Win7 When I wrote my code for Office 2000 on WinXP things were simple because...

Did you ever participate in SysOpt/TechIMO? Your name looks familliar to me. I used to visit those forums a lot back in the late 90's and early 00's

Dave, Excellent post. This is very elegant. I'd add to your reputation on this post if I could, but the forum tells me I need to spread thanks around a bit more before I can thank you again. I haven't spent much time in the meta tables of MS Access. This is one more reminder that I need...

I've read the page and see no column rename syntax. Does this mean that the column cannot be changed through the ALTER TABLE method? Is there another method I should consider?

Is there a way to rename a column in VBSQL? I've tried using Oracle/MySQL syntax without luck. Any help with syntax would be appreciated. ALTER TABLE tblTest RENAME COLUMN MyMemo TO MyMemoRenamed; I need to rename a column as part of an update and was hoping to put all of the updates in...

Bob, I was thinking of something more like this. (1) define function public function fnAddNumbers(varArray as double) as double fnAddNumbers= varArray(0) + varArray(1) +varArray(2) + varArray(3) + varArray(4) + varArray(5) +varArray(6) + varArray(7) + varArray(8) + varArray(9)...

Just out of curiosity, would a rewrite of the function to receive an array as the only argument resolve the original question where a function fails when it receives more than 29 arguments? An array could easily hold more than 29 values. I realize that this question is a step removed from the...

Google can be your friend *GRIN* http://www.vbforums.com/showthread.php?424399-RESOLVED-Populating-a-listbox-with-queries

RainLover, I second your last comment. I was always marked down for coming up with the correct solution using methods that did not match what had been recently taught throughout my primary and secondary education. <RANT>When I got to college I found that there was marked shift in tolerance for...

To learn how to reference a form control in VBA I would recommend you open a blank query, open the expression builder and browse to the form and control you want. You will be using the expression builder to write your syntax correctly. copy and paste the syntax from the expression builder into...

I'm not familliar with the Application.Index method, but suspect you may need to add a prefix to this method to make sure MS Access can find the correct MS Excel object. No MS Excel libraries will ever be found without first making a reference to them. MS Office 2000 uses the "Microsoft Excel...

What error do you get if you copy/paste the code and try to compile it? What version of Office are you using?

Before you are able to get any kind of integratino to work you need to make sure you have the MS Excel libraries referenced in the VBA environment. With older versions of MS Access you would go into the VBA editor and select TOOLS ==> REFERENCES.

Michael, Here's the solution: Within the function that builds the dynamic SQL I added the following line: "NVL(TO_CHAR(DECD_BRTH_DT,'MM/DD/YYYY'),' ') AS DOB" Thanks for your help. You've taught me more about working with Oracle than anyone to date. *GRIN*

Michael, thanks again for the quick response. I have placed watches in and have learned the following: (1) Oracle is returning dates in a string format similar to '31-Dec-29'. This is the value being stored in the array. I suspect that this is where the century is being altered. Is there a...