Search results for query: *

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

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

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

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

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

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

Does anyone have an example of Changing the Sort Order of a Access 2000 Report, I do know how to do manually. I want to do this dynamically with code... (MENU: "View" ... "Sorting and Grouping"). Many Thanks In Advance ... Regards Mark Dicken :-) England, UK

This is a good one. I am upgrading an Access System from Version 2.0 to 2000 I can upgrade everything (Tables, Forms, Queries, etc.) but I cannot import REPORTS. I can sort of Export them but they are HIDDEN from the Database Container. - I've looked in Options to show all hidden objects etc...

I use MS Access all the time and would like to write a routine to look through all my .JPG files downloaded from a Digital Camera. There is a Date and Time Created Property within the .JPG file format. If the file 100-2345_IMG.JPG has a date and time of 9-Dec-2001 on 10:14:00 then I want to...

Looking For SAP R/3 ABAP Certification Exam Test Questions Other than www.sapdomain.com does anyone know of areas for me to go for ABAP Sample Text Examination Questions, I'm sure that as with Microsoft/MCSE Certification the trick to passing the SAP R/3 ABAP Certificationj is learning the...

From within Microsoft Access 97, how can I get the Windows (or Windows Workstation 4.0 Username) I guess I need to do an API Call to Windows, if some one could point me in the right direction or CUT and PASTE a working copy then that would be great. Many Thanks In Advance Regards Mark...

He is a good one ... I have a number of Directory Shares on out NT 4.0 Server. I have setup correctly who has read and modify access rights. Now what would be really good is to let the SALES department see only the SHARES that are applicable for them and likewise for other departments. This...

I am sending email through MAPI / Outlook. How can I say reply to (for example) "Fred@bloggs.com" instead of the default email address of the profile? Many Thanks In Advance ... Mark Dicken England, UK

We have a FoxPro System, with GUI Screens. Can someone tell me is there is an automated way of finding out what Tables and Fields are possible used (or referenced) within a FoxPro GUI Form. Many Thanks In Advance . . . Regards Mark Dicken Dublin, Ireland

After having 6+ Years exp. of Microsoft Access, I am now interested in getting more involved in DYNAMIC Websites, I have 'dabbled' with HMTL, ASP, PHP, MS-SQL, MY-SQL and to be VERY honest it looks like a Simple Feature Rich Website takes too much time and effort only to get little results...

If I know the following :- Server Name Database Name Table Name Field Name How Can I find out its Data Type, e.g. Int, Char (or whatever) ?? Manually I can find out that :- SVR99.PizzaDB.tblDepartment.DeptCode is an INT How can I do this within a Stored Procedure / T-SQL ...

Basically I want to SOFTCODE "tblTable1" below:- Declare TableCursor Cursor GLOBAL DYNAMIC For Select Field1, Field2 from tblTable1 Any Ideas ??? Many Thanks In Advance ... Regards Mark Dicken Dublin, Ireland