Outlook Contacts Automation Q.

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - limitation on string of 255 bytes??? hi i can't create a string of more than 255 bytes.... what is happening...? this don't occurred before... bye, thanks ks Tag: Outlook Contacts Automation Q. Tag: 241480
  - 2
    - Project hook There are a couple of prgs that I have to remember to run before creating the exe - e.g. initialising some tables that are stored R/O within the exe. I have never done anything with project hooks before, but believe that this is the way I should do this. Can somebody point me to a helpful article or explain simply how I set this up? Many thanks Stephen Tag: Outlook Contacts Automation Q. Tag: 241471
  - 3
    - Problems running code created by GENDBC When the app begins the function MakeRI to write store procedures, the statement CLOSE DATABASE USE "MYDBC.DBC" I got the error "File is in use" Does knows somebody this behaviour? Thanks. Alejandro Fernandez Tag: Outlook Contacts Automation Q. Tag: 241468
  - 4
    - What about Sybase iAnywhere's Advantage Database Server ? I am trying to attend South West Fox conference in Arizona in October, and one of the sponsors is Sybase. Does anybody have got an experience with their Advantage Database Server? Does it replace SQL Server? Pros? Cons? Walter Tag: Outlook Contacts Automation Q. Tag: 241464
  - 5
    - Software Development Services, Software Outsourcing Services In India Software Development services in India suggest IT Solutions for Software outsourcing services, Software Design, affordable software technology and Programming Development by frequent Software Testing. More information for visit our site http://www.itoutsourcingservices.com/software_development.htm Tag: Outlook Contacts Automation Q. Tag: 241452
  - 6
    - Quit To ... There used to be a DOS-days (Foxbase?) command QUIT TO <Some other app> where <Some other app> would start automatically after exiting Fox. I could probably replicate this by creating a batch file (using some commands I have forgotten) to start the initial app, but I have a feeling there's a way to do it inside VFP9SP2 - or maybe with a dll? Any suggestions? Steve Tag: Outlook Contacts Automation Q. Tag: 241445
  - 7
    - ActiveX Control No Visible After Form INIT Hi I have an ActiveX form on my form and despite my best attempts I cannot get the thing to display when I launch my form. The only way to 'fudge' the situation is to make it tab order 1 and force a 'TAB' character into the keyboard buffer. That's fine whilst it's the first control on the form but that's not always the case. I've seen this behaviour before with other ActiveX controls so it's not just confined to this one. I've tried: _VFP.AutoYield = .f. (program startup & form init) DOEVENTS ThisForm.Paint ThisForm.Refresh Have also tried the refresh(), redraw() events of the control but nothing works unless UNTIL the control gets the focus. Just wondered if anyone else had seen similar behaviour? Tag: Outlook Contacts Automation Q. Tag: 241439
  - 8
    - Http post Group, We need to use Http Post to send a file (I have Zero experience with it) from vfp 6 to an electronic medical claims site for processing. They sent me the 'parameters', etc. but after googling for info, I found no examples of how to do it. Can anyone point me in the right direction? I don't know Http post from a fence post. TIA, Wade Tag: Outlook Contacts Automation Q. Tag: 241435
  - 9
    - empty memo field in an sql query Hi and thanks in advance for the help... When doing an SQL query I've often used things like... space(2) as State or 000000.00 as Amount is there a construct that I can use in a query to create a memo field in the resulting table? Thanks, Jeff Tag: Outlook Contacts Automation Q. Tag: 241425
  - 10
    - rename and rename table How can I rename tables in a dbc so that the disk name and the dbcname are updated and the backlink unbroken? Tag: Outlook Contacts Automation Q. Tag: 241417
  - 11
    - Slider control... Does anyone know of a good 'slider' type control (other than the one in the "solutions" example) that I can use to change the size of my form? ________________________ | | | | | | | | | | | B | | | | | A | ____________| | | | | | | | | C | | | | | | | |__________ | ____________| The form is split in to three sections as shown above and I would like the user to be able to resize each by using the horizontal / vertical lines that separate the three panels A,B & C. Thanks in advance. Tag: Outlook Contacts Automation Q. Tag: 241415
  - 12
    - VFP - Linux? I would like to run a Foxpro COM server (9.0 sp1) on a Linux server. How could that be done? TIA Tag: Outlook Contacts Automation Q. Tag: 241399
  - 13
    - Bulleted lists in rich text format I'm trying to write a script that auto-generates RTF documents, and i would like to know how to create a bulleted list using raw rtf commands. Also, is there a good usenet group for RTF discussion? Thanks. Addison Tag: Outlook Contacts Automation Q. Tag: 241397
  - 14
    - Storing Excel, Word and other data in VFP Time has come that my customer asks me to store some Excel sheets, some Word documents, some text files and some pictures into VFP itself. Time ago, there was OLE, so I could embed or just link the file into a "general" field. But I was warned in many articles on the web not to use general fields. So my question is: what else can I use? Blob fields? What happens if the worksheet or text file changes from outside VFP? What is the best way to handle such a situation? Walter Tag: Outlook Contacts Automation Q. Tag: 241393
  - 15
    - ADir Command Hi, I'm using the ADir command to list files to an array. It's possible to list only the files updated 5 days ago and not all the files? Thanks. Ilidio Pedrosa. Tag: Outlook Contacts Automation Q. Tag: 241389
  - 16
    - How to prevent creating a big exe file. In a project having some big readonly tables I build a DLL including this tables with a class to open them. This DLL is called mdata.DLL All was fine working in the VFP IDE but when I build the main project in which these tables are used I realized that the exe file is very big and include all mdata.DLL on it. 130 Mbs. I do this because I need to encrypt these tables and the tools I had used don´t work now in VFP9 in windows vista. I use Netlib and now Cryptor4. As I dont have Cryptor5 license I choose this way to protect the tables. Can I create an exe with the readonly tables in other .DLL file? Thanks. Alejandro Fernandez Tag: Outlook Contacts Automation Q. Tag: 241388
  - 17
    - user-defined toolbar I am trying to allow users to customize a toolbar for an application. The toolbar settings would be stored in a database and read in at run time. A toolbar is easy enough to set up when it is predefined, but I'm having trouble figuring out how to do it dynamically. Should I try to set up a control array (if so, how do you do that within a class definition?) or should I do it some other way? Any help would be appreciated. Regards, Kevin Clark Tag: Outlook Contacts Automation Q. Tag: 241379
  - 18
    - Report printing Hello We use Fox 2.6 to create our Purchase Orders. What I am trying to do is have one copy of the P.O. printed locally (to the default printer) and another copy go to a printer connected to a networked PC in another part of our building. I need to do this in code. Any help appreciated. Tag: Outlook Contacts Automation Q. Tag: 241377
  - 19
    - VFP + MySQL Server foto exchange hy, i need programming code, i trying select foto from mysql into client program FoxPro,but nothing. Tag: Outlook Contacts Automation Q. Tag: 241373
  - 20
    - TEXBOX Hi to All, I've already post this question, but I can't find it. My Question: If the user inputed on a Textbox 5x5 or 5*5 the result is 25. Maybe this very simple. Any idea please help me. Thanks for the help. Tag: Outlook Contacts Automation Q. Tag: 241368
  - 21
    - Win7 & FoxPro What do you think? Can Win7 host FoxPro? Regards Tag: Outlook Contacts Automation Q. Tag: 241366
  - 22
    - Control font when MODIFY MEMO I have an application where a principal functionality is involved with editing and reading MEMO entries in FoxPro tables. I've had mixed success with changing the font when within a MEMO field. I generally change the font from Courier to Arial, and from 8 point to 12 and like it like that. Sometimes when I go back into the table it retains those settings, but sometimes not. The application uses many tables (around 200). Is there some way I can get it to retain the settings for each table, or perhaps better yet, force Arial 12 point for all tables? Sometimes the MODI MEMO is issued from code, and sometimes I get into the memo fields by double clicking on Memo in a browse window. Dan Tag: Outlook Contacts Automation Q. Tag: 241362
  - 23
    - DateTime() Q. I have a field that has the DATETIME() of the entry. How do I sql the datetime field for just the date and not the time portion? ie. SELECT * FROM xxx WHERE between(mydatetimeField,dateStart,dateStop) INTO TABLE .... Respectfully, Jonathan Morningstar Tag: Outlook Contacts Automation Q. Tag: 241361
  - 24
    - sound Hi Can I play a .wav sound on app opening. I'm using vfp8. What and where do I put the code? Thanks Sherry Tag: Outlook Contacts Automation Q. Tag: 241355
  - 25
    - Database Recovery Hi, Can FoxPro database be setup to automatically rollback transactions that terminate abnormally? Tag: Outlook Contacts Automation Q. Tag: 241341
- Next
  - 1
    - Import from csv to dbf Hi All, Did anybdoy created a code that can import the specific fields from a CSV file? I may need to deal with 8GB of csv files and I would rather import fileds to several tables for normaliztion purpose as well. Thanks, Joe Tag: Outlook Contacts Automation Q. Tag: 241334
  - 2
    - Saving preferences for .PRG editing I have had trouble with this for quite a while VFP6 - VFP9. I want to set editing preferences on .TXT and .PRG files such that when I open one to edit, it will inherit the conditions specified in the dialog. I am using a resource file (foxuser) and if I set the preferences on an individual file, they are retained. I would rather not set every file in a type but rather set defaults for that file type. I've clicked save preferences and Apply to .PRG files but no matter what I do I can't make this global. Can anyone help with this? Do I need to manually edit the foxuser file? Tag: Outlook Contacts Automation Q. Tag: 241333
  - 3
    - Can I put a control on a VFP form that will display a JPG? Any version of VFP including 9.0. I want to catalogue and manipulate collections of JPGs using VFP. Flag for deletion, name change, possibly other things. It's important to be able to have a good look at the JPGs, and it would be convenient if I could resize them in doing so. Dan Tag: Outlook Contacts Automation Q. Tag: 241328
  - 4
    - SET NULL ON does not work with views I have a case in which I want to create a non-updating view in which certain fields should accept nulls, even though the corresponding fields in the source table do not accept nulls. It seems to me that SET NULL ON prior to creating the view ought to do the trick, but it does not. I have to resort to using CAST or other tricks. Am I misunderstanding the use of SET NULL? Tag: Outlook Contacts Automation Q. Tag: 241323
  - 5
    - From Excel to VFP9 SP2 I am trying to import an Excel worksheet into VFP9 with the command "IMPORT FROM xxx-sheet TYPE xls", but since my worksheet is in the format of Excel 2003, I get the error message "Microsoft Excel file format in invalid". The same thing happens when worksheet was created with Excel 2007. It works fine if sheet is saved in Excel 5.0/95 format. I don't want to open each Excel file and have it saved with a "lower" format. How can I import from newer Excel formats, such as 2003 or 2007 ? Tag: Outlook Contacts Automation Q. Tag: 241322
  - 6
    - VFP9 Word 2003 merge problem I have some code that merges data into a Word merge document and prints it automatically. It works great on pcs with Word 2000. However my client has some pcs with Word 2003 and although the code runs through with no errors, gobbledygook prints where the merge fields are supposed to be. Any clues as to how I fix this? I'm going to try getting them to save separate versions of the merge documents in Word 2003 but I wondered if there's any other suggestions. Shoulf the automation code work no matter what version of Word the user has? I've posted some sample code below. Regards, Bernie Beattie *******Sample code********** local loword, lcfile, lcdatafile, lodoc, lodocactive, llerror, lcprinter * Get user's choice of printer lcPrinter = GETPRINTER() IF EMPTY(lcPrinter) WAIT WINDOW "no printer" RETURN .F. ENDIF SET PRINTER TO NAME (lcPrinter) TRY loWord = CREATEOBJECT("word.application") CATCH WAIT WINDOW "word not instantiated" llerror=.t. ENDTRY IF NOT llerror * Now try to open the document lcFile = "c:\cast\test2.doc" TRY loDoc = loWord.Documents.Open(lcFile) CATCH WAIT WINDOW "file not opened" llerror=.t. ENDTRY ENDIF lcDatafile = "c:\cast\data.txt" IF NOT llerror TRY * Attach the data source loDoc.MailMerge.OpenDataSource(lcDataFile) * Run the mailmerge loDoc.Mailmerge.Destination = 0 && send mailmerge to a new doc loDoc.Mailmerge.Execute * The mailmerge doc is now the active doc loDocactive = loWord.ActiveDocument * Go ahead and print it loWord.ActivePrinter = lcPrinter loDocactive.Printout() CATCH TO loError WAIT WINDOW "file not printed" ENDTRY ENDIF * Close both documents (without prompting to save changes) loDoc.Close(0) loDocactive.Close(0) Tag: Outlook Contacts Automation Q. Tag: 241316
  - 7
    - How to tell if an app is running. Hi All. I am looking at integrating x-charge for credit card authorization. It uses a simple call to it's exe along with some parameters. It's only requirement is that you cannot have another session running. (VFP will hang if it is) Is there a way to test to see if "xcharge.exe" is currently running? TIA Mike Tag: Outlook Contacts Automation Q. Tag: 241300
  - 8
    - Storing a table in the exe I want to include a free table as a read-only file within the exe. It has an FPT file associated with it. Do I need to add the FPT file to the project, or is vfp intelligent enough to include it if I simply add the .DBF file and mark as Include. I note that I only have to include the DBC for the views dbc rather than the DBT file as well, so presume it is the same for a table? Sincerely Stephen Tag: Outlook Contacts Automation Q. Tag: 241297
  - 9
    - SET SKIP TO Hi all, I have 2 tables both with So_No field and index tag So_No. 1 is the Master file and the other is secondary table. Both have duplicate or more records with the same So_No. I have set the Master file, and SET RELATION So_No INTO Secondary. My problem is, there are 2 fields that I need to insert into Master table. Example : - Master File : 4 records of So_No = 1 and empty field of Image_No and Text Secondary File 4 records os So_No = 1 and vales of field of Image and Text (different values). I want to replace the Master.Image_No and Text with Secondary.Image_No and Text. Thanks. Maxman Tag: Outlook Contacts Automation Q. Tag: 241296
  - 10
    - True VFP multi-threading (MTmyVFP3) A new version of MTmyVFP (True VFP multi-threading) using Calvin Hsia's latest MT class including a few tweaks: http://www.codeplex.com/mtmyvfp There's still room for improvement, though. Instead of a count-down while the thread(s) is going, a nice Progress bar like the one in VFPX could probably be used. Also, it probably wouldn't take much to make this backward compatible to VFP7. However I'll leave these improvements to others. Calvin Hsia's original source and background info: http://blogs.msdn.com/calvin_hsia/archive/2006/05/23/605465.aspx Tag: Outlook Contacts Automation Q. Tag: 241295
  - 11
    - It's All Too Much Hello and thanks for the help. It has just dawned on me that I need a database of my forms, prgs, classes, projects, etc. I am a one man shop and I have this problem so I imagine that larger shops have it worse than I do and I'm sure that someone must have solved the problem. What I'm dealing with is not being able to remember the name of the form, program, report, project, class, etc. that I'm looking for even though I use fairly descriptive names. Is there a feature of VFP that I'm not using that would help me with this? Is there some other tool that some of you are using to catalog your development? I don't think I need a VCS. The ones that I've looked at are more oriented to managing versions and not cataloging software. What, if anything, are you doing if you have a large number of code files that you need to organize? Thanks, Jeff Tag: Outlook Contacts Automation Q. Tag: 241290
  - 12
    - Modified Structure of DBF file Hello, I modified Structure of a DBF table by changing names of a few fields or changing field type from Currency to Number for a few fields, the sequence of fields was not changed. However as I browse the table the name changed fields and Type changed fields are visible on the right. Their position is right as previously if I see the structure by "Modify Structure", however visually in browse mode the modified fields are visible on right. I will look forward to your guidance for resetting the view to normal, so that the fields appear in the same sequence in browse mode as in the Modify structure mode. With Rgards S Bans Tag: Outlook Contacts Automation Q. Tag: 241282
  - 13
    - Multiple monitor support Trying to write a custom presentation application.. In a dual or multiple monitor system, is it possible to direct a form to a specific monitor at runtime? Any help appreciated John Davy Tag: Outlook Contacts Automation Q. Tag: 241279
  - 14
    - SQL Calling Methods I am doing some grouping in SQL with the grouping determined by a method call (because the grouping is user-defined and quite arbitrary). So far, so good. Are there any pitfalls that I need to watch for? I do not need to do this, but is it still dangerous to move a table pointer even if one restores it? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Outlook Contacts Automation Q. Tag: 241275
  - 15
    - CDO logs? I am using CDO to send mail. Does anyone know the default mail server it uses? Is there a log file associated with the messages? All of the mail I sent is HTML and upon delivery a few of the href links are getting a blank space before a character and an exclamation point after which breaks the link. I notices this occurring after a K9 and a D3 combination. I am trying to pinpoint where this is breaking. I did keep a text file of the html messages that were sent and the characters in the text file are fine. I would like to see the actual message as it went out. Tag: Outlook Contacts Automation Q. Tag: 241269
  - 16
    - Visual Fox Pro 9 - Text is messed up. I am trying to help a friend who is a developer. She is on version 9, and has service pack 2. She is running on Vista. Any way her text on the screen looked like it was "melting" for lack of a better term. I've had her run a virus scan. It had none. The text on the left side of the screen is fine, as the text goes across the screen it droops lower on the screen. This is true of menus as well. Any help? Thanks. Lee Tag: Outlook Contacts Automation Q. Tag: 241264
  - 17
    - progress bar Hi I have a large app with lots of pictures and pages. It takes 10 -15 seconds to be visible. To keep users from clicking and clicking, I want to display a progress bar. My problem is if I run the program for the progress bar at start, the form still doesn't show (10-15 sec) until after the progress bar is done. How can I run both at the same time? I have a start program that calls the form. Thanks Sherry Tag: Outlook Contacts Automation Q. Tag: 241258
  - 18
    - Extracting user/password from ODBC *.ODC file? We have several programs that connect to our backend SQL Server using VFP 6.0 as the front end. In each of these programs, we created a configuration requirement to enter the ODBC data source name, the username and password for the SQL connection, all of which is used in the connection string to the SQL server. In an effort simplify the installation requirements for each program, it would be nicer if we could just specify the data source name, or perhaps select the ODBC *.odc file, then have the program itself get the username/password from the *.odc file. Has anyone ever done this? Can anyone provide code samples or links to same that would let us parse an *.odc file or extract the username/password from a configured ODBC connection in VFP 6.0 some other way? Thanks. Tag: Outlook Contacts Automation Q. Tag: 241257
  - 19
    - Totals under 500 using SQL I have a table of donations, all random amounts but each one is under 10.00 I need to create a cursor that aggregates these into totals, each of which must be under £500. In manual terms, go through the list, adding up each donation with a calculator until the next donation would take it over £500, then put the entry into the cursor then continue through the list. The resulting cursor might have 8 records in it, each with a total of between 490 and 500. As a cherry on the cake it would be nice if the cursor also showed how many donations had made up each total. Is there any way these can be done via SQL - at the moment I am disappearing down a black hole of do while, skips and exits Sincerely Stephen Tag: Outlook Contacts Automation Q. Tag: 241256
  - 20
    - Embed Acrobat in a Form - DoVerb problems When doing an AddObject with an olecontrol and I use the Acrobat reader so that it is embedded in my form something strange has occurred. For some reason, I cannot type in textboxes and I cannot type in combo boxes. I can select using the down arrow of a combo box but I can't seem to typed. Is as if the olecontrol as somehow locked the form. In fact, even if I place a different form over that form and it is covering the Acrobat ole object, it seems to disable the textboxes until I move the second form. Has anyone else experienced anything like this with any OLE objects? I'm still using VFP 6/sp3. Is there anything I can do or set or change so that this does not happen? Perhaps there is another way to embed an acrobat object in a form not using doverb or maybe some other way? Thanks, Mike Tag: Outlook Contacts Automation Q. Tag: 241243
  - 21
    - VFP9: Parsing a String Is there a function for parsing a comma-delimited string into an array of substrings? I thought there was, but I can not find it in the docs. Example: "abc,,def,ghi," would return an array of elements: "abc" "" "def" "ghi" "" Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Outlook Contacts Automation Q. Tag: 241242
  - 22
    - padl() gaff refresher needed I know I'm supposed to use transform(nVar, "@L 99") to turn 1 into "01" instead of padl(nVar, 2, '0') .... but I just ran into "1." and I don't remember what setting causes the padl() idea to fail. Please remind me. Tag: Outlook Contacts Automation Q. Tag: 241239
  - 23
    - Date field update Sir, I have a table with 2 fields as data type date. I have to append the records from text file with date shown in the file as 01-JUN-2008. I tried different date settings but date fileds are not updated and kept blank only. I tried with short date settings in the control panel also. Which shows the date i want as 01-Jun-2008 but still the fields are not updated & has the value blank. This is very unusal as we may require the different date setting during the programme execution. Bankim Tag: Outlook Contacts Automation Q. Tag: 241236
  - 24
    - Validating a DBC After opening a DBC I issue: VALIDATE DATABASE RECOVER I got the message: Tag not found (structural CDX). Do you want eliminate it or cancel validation? I realize that the father table primary key and a sister table CDX are lost. How I can by code reindex these tables and rebuild the proper relations and IR ? Thanks. Alejandro Fernandez Tag: Outlook Contacts Automation Q. Tag: 241233
  - 25
    - DBC internal consistency error - FP crash I got this immediately after issuing VALIDATE DATABASE (which reported no problems). Now in the database designer, all the field names are shown as "??". Before validating, everything seemed fine. Some "validation"! Now I cannot get rid of the message, keeps popping up again after I click OK. Nothing to do but kill FP with the Task Manager. Too bad too, because I have unsaved changes in a prg file. If anyone has advice, that's fine, but mostly I'm venting. Dammit! VFP9SP2 Tag: Outlook Contacts Automation Q. Tag: 241231

Greetings,
How can you create an additional address book inside the Outlook contacts
folder via VFP code? I know how to add contacts from VFP into Outlook but I
need them to go into a new folder in the Outlook contacts.

Respectfully,

Jonathan Morningstar
Greenville, South Carolina USA

Top