Search results for query: *

CajunCenturion, Yes it is supposed to be:- oBO.showcollection(oCollection) Well done on picking up the error I'm basically trying to use MS Access in a DOT NET OO sort of way... ANY IDEAS ??? (other than using a global Collection) EstuardoSierra, Thanks for the Suggestion, your suggestion...

Hi All, I am trying to Pass A Collection To A FUNCTION ??? (Access 2000) I have a Class called BO (for Business Objects) Within BO I have a Function called ShowCollection Public Sub showcollection(colCollection As Collection) MsgBox "colCollection(2)=" & colCollection(2) End...

How to change Field Properties using ADOX I am trying to use ADOX to create fields in a Table. I cannot see how to modify the following properties :- * Required (Yes/No) * Unicode Compression (Yes/No) * Allow Zero Length (Yes/No) Thanks In Advance Mark Dicken http://www.MarkDicken.com

How to change Field Properties using ADOX I am trying to use ADOX to create fields in a Table. I cannot see how to modify the following properties :- * Required (Yes/No) * Unicode Compression (Yes/No) * Allow Zero Length (Yes/No) Thanks In Advance Mark Dicken http://www.MarkDicken.com

Thankyou - It Helped me Also REF: replicate('0', 10 - len(fieldname)) + fieldname Regards Mark Dicken, England, UK (http://www.MarkDicken.com)

Another good one ... I want to create a number of MS Outlook 2002 Inbox Rules from withn MS Access. Does anyone have some any sample code ??? or can they point me in the right direction ??? Many Thanks In Advance . . . Regards Mark Dicken England, UK

Larryww (and ALL), Actually this is what I ended up doing. I even did the 1 line table as you suggested, so it would be easier to look at in the future. And to concatinate the 2 Temp files together, I have a read the file(s) in line by line and created the final text file. No need to Blush...

Hello All, Another good one ... I need to export a table in a defined format to satisfy another system. The problem is that it requires a Header Record. The Import/Export Specification looks like is does not cater for Header Record Requirements. Now I could write the whole thing manually...

For ABAP questions I have used www.SAPDomain.com it does cost a little bit. Regards Mark Dicken England, UK

Phil, I have used ASPMail for a webserver in the past - very good tool from ServerObjects Inc. - I assumed that many people have also had the same problem, but it looks like everyone is being quiet ... :-( - Many Thanks, Mark Dicken, England, UK

Anyone else having these problems ?

I Would Like To Know How To Modify The Outlook 2002 Security To Allow My MS Access 2002 Program To Send Email. I get the following message :- A program is trying to automatically send-email on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should...

JFischer, Thanks for the hyperlink, I can read the value and at least be able to pop up a Message Box telling the user that they need to ask their Technical Support Person to Add or Alter a Registry Key. I was using code from 'Dev Ashish & Terry Kreft' already but wanted to Write/Update the...

I need to Check and Possibally Modify the following Registry Key:- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions Becuase I need to TransferText (Import) files with a .STA extension. The .STA File Extension is not a reconised Text File Format so I need to Lookup...

I found the resolution ... Basically I had to add a registery entry of (My File Extension STA) to:- HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions as explained below from :- http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q239471 Jet 4.0 Text...

I found the resolution ... Basically I had to add a registery entry of (My File Extension STA) to:- HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions as explained below from :- http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q239471 Jet 4.0 Text...

I found the resolution ... Basically I had to add a registery entry of (My File Extension STA) to:- HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions as explained below from :- http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q239471 Jet 4.0 Text...

I found the resolution ... Basically I had to add a registery entry of (My File Extension STA) to:- HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions as explained below from :- http://support.microsoft.com/directory/article.asp?ID=kb;en-us;Q239471 Jet 4.0 Text...

I have upgraded Access 2 to 2000 and get the following error Message. Run-time error '3027'; Cannot Update. Database or objects is read only. The code is :- Dim strFile strFile = "c:\import.csv" DoCmd.TransferText acImportDelim, "AA", "tblImport", strFile Anyone...

I have upgraded Access 2 to 2000 and get the following error Message. Run-time error '3027'; Cannot Update. Database or objects is read only. The code is :- Dim strFile strFile = "c:\import.csv" DoCmd.TransferText acImportDelim, "AA", "tblImport", strFile Anyone...