VFP running Access Query/Macro

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
    - micration tool What is the best migration tool for VFP 6.0 ? -- George Malekkos ________ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: VFP running Access Query/Macro Tag: 189191
  - 2
    - Printing statements to Adobe files I would like to print statements to individual adobe print files for emailing. I have developed a process that runs the statement report for each customer. When I change the printer to Adode it asks the name of the file. I would like to send the name of the file for Adobe to use so I don't have to type it in for each customer. I am not finding an approach to send the name to Adobde. Any ideas? Tag: VFP running Access Query/Macro Tag: 189189
  - 3
    - How Add a CommandButton on 1 Activex Dear All, I wants to add a CommandButton (Setup impression) on 1 Activex (CRviewer of CrystalREport). This AcTivex is on a Form. There is not method "Addobject" for this Activex. I use the addobject of Form but as you suspect it the button comes to be placed below the activex and is thus not visible. The method Zorder(X) does not arrange anything . It would be necessary to be able to say to the button "Always One Top"...... thank you in advance for the assistance brought. Bernhart Tag: VFP running Access Query/Macro Tag: 189183
  - 4
    - Hardware Control via Printer-port ? Hi All, I've bought an "On-Off" relay control board with source code written by "VB" and "C++", actually I don't know the above 2 languages, can someone tell me VFP can do the same thing ? Thanks ! Regards Sammy Tag: VFP running Access Query/Macro Tag: 189182
  - 5
    - Sending faxes using foxpro and windows 2003 sbs Dear All I am having problems with mapi sending faxes with Outlook 2000 sp3, xp and 2003. Early version are ok. I am getting to a point where I think it may be a security issue. Sending a normal fax is ok, but if I attach a *.tif file it comes up undeliverable with the message The Microsoft Fax transport failed to deliver the message to the recipient. Not all attachments can be rendered. Here is my code, I have changed the fax number. objSession = CreateObject("Mapi.Session") objSession.Logon () MESSAGEBOX("CDO version installed is "+trans(objSession.Version)) objMessage = objSession.Outbox.Messages.Add objMessage.Subject = "Test" objMessage.Text = "This is a test with an attachment" objRecipient = objMessage.Recipients.Add objRecipient.Name = "[FAX:5555555555]" objRecipient.Type = 1 objRecipient.Resolve () objAttachment = objMessage.Attachments.Add() objAttachment.Position = 0 objAttachment.Type = 1 objAttachment.ReadFromFile("C:\B.TIF") objAttachment.Source = "C:\B.TIF" objAttachment.Name = "B.TIF" objMessage.Send () objSession.Logoff Thank you for any help David Anagram Systems Limited work email: david@anagram-sys.co.uk Tag: VFP running Access Query/Macro Tag: 189181
  - 6
    - System Clock Hi Is it possible for VFP to hide the system clock so that no one ca change the time of the computer Thanks Abe Tag: VFP running Access Query/Macro Tag: 189179
  - 7
    - Incorrect page footer information problem env: O/S 2000 sp4 vfp7 sp1 on report designer, 1.data grouping is set, new page when group change 2.fields on group footer band is set "Stretch with overflow" If fields stretch with overflow on group footer and it overflow to next page, it affect the result of field on page footer on current group and next group. Steps to Reproduce: Create table by following code: create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('A','') insert into table1 (f1,f2) value ('B',repl('X'+ chr (13),200)) && overflow to next page insert into table1 (f1,f2) value ('C','') create report testbug add data grouping expression "f1" : set "Reset page number to 1 for each group" add report variables "vf1" with Expression : f1 on page header band : add a field Expression : f1 on detail band : add a field Expression : f1 on "group footer : f1" band : add a field Expression : f2, set "Stretch with overflow". on page footer band : add a field Expression : f1 Save report do a command : report form testbug preview Or report form testbug to print result : Assume Group A is printed on page1, Group B is printed on page2 and 3 because for group footer overflow to next page, Group C is printed on page4 on page footer band when f1 group B : field "f1" display C && incorrent field "vf1" display B && corrent on page footer band when f1 group C : field "f1" display C && correct field "vf1" display B && incorrent Is it a bug? thanks. Ray Tag: VFP running Access Query/Macro Tag: 189178
  - 8
    - Foxpro 6 Tutorial Hi All, I am the very beginner of Foxpro. Currently, I have Foxpro 6.0 installed in my computer(windows ME 2000). I would be very appreciated if some one can tell me the websites which contain the Foxpro 6 Tutorial. Have a nice weekend! Best Regards Richard Tag: VFP running Access Query/Macro Tag: 189175
  - 9
    - Graphical editing of a class Hi all, If I define a class in a program (not is the class designer), how could I edit it in the class designer? Thanks Hutch Tag: VFP running Access Query/Macro Tag: 189173
  - 10
    - not insert to table Dear All, I have 2 tables, sales and salesdetail here is my source: sales set to buffering-3 salesdetail set to buffering-5 begin transaction insert into sales(...blah blah blah) insert into salesdetail(...blah blah blah) if (tableupdate(0, .f., "sales") and tableupdate(1, .f., "salesdetail")) end transaction strange thing is, I got salesdetail updated but sales always got nothing. no error message pop out. Can't figure what's wrong. Many thanks. Regards, Wandy Tang Tag: VFP running Access Query/Macro Tag: 189170
  - 11
    - change page per group on report vfp.6 start each group on a new page reprint group headers are on design mode of a report can i have it on a variable with a choice of a user on the same report ? -- Thanks George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: VFP running Access Query/Macro Tag: 189159
  - 12
    - Ask for method for copying file from one folder to another Dear all, I would like to ask is there any method for Foxpro 6.0 to copy file from one folder to another? Thanks a lot, Ray Tag: VFP running Access Query/Macro Tag: 189150
  - 13
    - Mailmerge Wolfgang, Thanks for your kind response. I changed DFC() and got past the error but I got a message from WORD: Error in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source. I am wondering if the message prior (Unable to find FoxPro File ODBCDriver) is the cause? I have tried putting the ODBC drivers I could find in the Windows and Windows32 folders but it didn't help. Do you know the proper name of the driver and where it should be located? I found this code in mailmergeword8 and it seems to be wanting the driver. Why would it be needing the ODBC driver and connection string when the data source is a local view? *- attach data file oDoc.MailMerge.OpenDataSource(THIS.cDataSrc,0,0,0,0,0,"","",0,"","",m.cODBCSource,; THIS.csqlstmt, THIS.csqlstmt2) Tag: VFP running Access Query/Macro Tag: 189146
  - 14
    - SEEKING LIST OF COMMON WORDS I'm seeking a list of words one would find in an english dictionary (ie 'bank', 'cat', 'symphony', etc.) All I need is a comprehensive list of these common words. If anyone can send to me or direct me to a such a list I WOULD BE VERY GREATFULL !!! Thx Mike Farnesi San Diego Tag: VFP running Access Query/Macro Tag: 189141
  - 15
    - simple procedure question Hi, I'm new to Foxpro, and I'm trying to create a stored procedure that returns a set of records. The following does not return records: procedure GetRecords select * from customer endproc Do I need to create a cursor or something? If so, what does that look like? tia, John Tag: VFP running Access Query/Macro Tag: 189138
  - 16
    - CHECKBOX QUESTION I have a form that has three buttons 1. File Check 2. Run Program 3. Exit File check does what it says, looks to see if files are present. If they are present, it updates the chkbox/label with a CHECK. I then want to run the program in accordance with which boxes are checked. I tried you thisform.check.value but it doesn't work. Is there an easy to do this. I am getting I need to pass a value at some point? Thanks in advance. Tag: VFP running Access Query/Macro Tag: 189133
  - 17
    - Trying to force Outlook msg window to foreground I have an e-mail address field on a form whose right-click event will open up a new Outlook message to that recipient. The automation part of it works like a charm. However, there are times when the new Untitled message window will flash in the taskbar and not be the foreground window and other times when the new message will indeed get the foreground (which is the desired result). Using both the mail item's Display() and Activate() methods produces the same results. Is there a way to make sure that the new message window always hits the foreground and has focus? I'm assuming that the WinAPI has to come into play for this.. Jon Tag: VFP running Access Query/Macro Tag: 189125
  - 18
    - XML in Visual FoxPro 6.0, is it possible Is it possible to read and write from XML files from Visual FoxPro 6.0? Thanks Peace in Christ Marco Napoli http://www.ourlovingmother.org Tag: VFP running Access Query/Macro Tag: 189121
  - 19
    - .memo I need some help. I am a programer but not FoxPro Pro. I can't handle .mem file, can't change. Do I have to create a new one and how? I read about this file in the Book but .. Thanks, Maria Tag: VFP running Access Query/Macro Tag: 189120
  - 20
    - 1a and eof?? So accordingly to what was mentioned in this forum I could found a lot of 1a marks in the header of the dbf. What I would like to know is how to repair a dbf if it is broken using an hexadecimal editor? Which is the 1a mark I have to take into account??? Does anybody experience a broken table and has to repair??? Thanks in advance, Mariano Tag: VFP running Access Query/Macro Tag: 189110
  - 21
    - OLE-Drag'nDrop in COM-Object Hello In my application I use OLE-Drag&Drop. It's working ok. But one part of my app ist a COM-Object, also written in VFP8, using the same classes as the rest of the app. This COM-Object shows controls in a top-level-form. In this form OLE-Drag&Drop doesn't work. It's not starting, no matter, if I let VFP do the work (OLDEDragMode = 1 (Automatic)) or if I start it myself with OLEDrag (.t.) in MouseDown-Event. As soon, as I press the left mouse button, the control is in editing mode, means if I move the mouse with left button pressed, I mark text under the mouse. It's not entering the OLEDrag&Drop-mode. Some ideas? I've written a litte test application, which shows my problem. You can download it from www.ksoft.ch/download/oletest.zip. It's only 17k. Unzip it and build an exe in order to register the COM-Class. If you start the exe, you will see 2 Forms. Both are the same top-level-form, but one is opened from within the exe using do form, the other is shown from a COM-Object. In the form opened with do from OLEDrag&Drop is working, in the other form it is not. Funny, isn't it? Thank's a lot for every help I can get. Kurt ------------------------------------------- K-Soft Informatik Kurt Kleindienst Rietwisstr. 32 CH-9100 Herisau Telefon: +41 (0)71 / 351 78 80 Fax: +41 (0)71 / 351 78 81 Mobil: +41 (0)79 / 377 31 40 E-Mail: info@ksoft.ch Internet: http://www.ksoft.ch ------------------------------------------- Tag: VFP running Access Query/Macro Tag: 189109
  - 22
    - Resize MonthView? Is it possible to resize MonthView? Tag: VFP running Access Query/Macro Tag: 189107
  - 23
    - grid content gone Dear All, I have make a menu on a parent form, two command on the menu, each command trigger one child form, each child form have a grid on it, one grid show customer information, the other grid show salesman information. But now, whenever the second grid show up, the content of the first grid will all gone. i have been using the .recordsource to set up the sql statement, no cursor name is duplicate for testing purpose. no relation between two form. am i doing somthing silly? Many thanks. Regards, Wandy Tang Tag: VFP running Access Query/Macro Tag: 189106
  - 24
    - decimal val n int val hi all, currently working on a project tat was done by someone else, n now having a problem. when i first init a form, i haf a txtbox called txtqty. if i try to enter a decimal val, say 2.23, it works perfectly well... however, on d same form, i haf a grid tat retrieves vals fr a database table. when i select a row from d grid, the afterrowcolchange() method of d grid will change d val of txtqty to d database val, for example 1. the problem is i cannot change d val 1 to a decimal say 2.23, but i can change it to int vals say 5 or 6. can anyone give me any solutions on wat may b causing this? the database field type is of n(6,3) and i haf chked all d valid() n refresh methods to c if they prevent any decimal input but found none. Pls help!! Thanx Tag: VFP running Access Query/Macro Tag: 189105
  - 25
    - Ask for the method for moving file to other directory again Hi, I would like to ask how to move all the file in one directory to another directory using Foxpro 6.0? I have already tried to use dos command "run move e:\test1\*.* e:\test" and also "run copy e:\test1\*.* e:\test", but they are both not ok. Only can use command "run del e:\test\*.*" but I would like to move the file. Is there any method in Foxpro 6.0 that can be used? Thanks a lot, Ray Tag: VFP running Access Query/Macro Tag: 189101
- Next
  - 1
    - automation server This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C3E692.5EA60C60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable what is the automation server name for paintbrush application which i = can use with create object () command? Thanks sp ------=_NextPart_000_000D_01C3E692.5EA60C60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>what is the automation server name for = paintbrush=20 application which i can use with create object () command?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML> ------=_NextPart_000_000D_01C3E692.5EA60C60-- Tag: VFP running Access Query/Macro Tag: 189099
  - 2
    - SQL processing If I issue an SQL query and there is no index based on the key item to the query but other indexes should narrow down the search (and I call that info to help it), but the process is taking about 1 minute to come up with the results. The actual query process is only about 10 seconds, but bring up the query meter is taking forever. Any suggestions? Rusty Gallo OGES Systems ogallo@columbus.rr.com Tag: VFP running Access Query/Macro Tag: 189094
  - 3
    - Printing on a form 8.5 x 5.5 problems I have an application that prints on 8.5 x 5.5 forms. After I issue the print job to a single order or any odd number of orders to print, the dot matrix printer ejects a second form. I have tried setting the form length on the printer and that does not work. I don't see how to set the form length for (example Okidata ML320 printer) 5.5 through the windows printer set up. Rusty OGES Systems ogallo@columbus.rr.com Tag: VFP running Access Query/Macro Tag: 189093
  - 4
    - 'Executing' code in PRG files. When editing a 'prg' file one can hightlight 1 or more rows, then right-click and select 'execute selection' - thats great. But is there a short-cut w/out having to right-click? THX Mike Farnesi Tag: VFP running Access Query/Macro Tag: 189092
  - 5
    - Moving from VFP7/SP1 to VFP8/SP1 Hi all! I have a view which works just fine in VFP7. But VFP8 complains "View definition has been changed". The view is of the type; Select ... join ... join ... where &lcWhereExpr1 union all Select ... join ... join ... where &lcWhereExpr2 My app has many views of this very flexible type and all except one works fine i VFP8 too. The view is added to a form´s DE with no data on load. The view´s requery command is in a page's activate. If I close and open the view before the requery it works in VFP8 too but then there occures other undesired things. Enginbehavior is set to 70. What´s this about? Is there somebody who has experienced something similar? I want a solution without having to close and reopen teh view. Any help would be very apprecitated. Regards Christina Tag: VFP running Access Query/Macro Tag: 189090
  - 6
    - What new will be in VFP9? Where to learn (find out)? Tag: VFP running Access Query/Macro Tag: 189071
  - 7
    - Windows form design guide - where? Isn't there a document (I think by Microsoft) that discusses guidelines to be followed when designing forms? Some sort of windows design guidelines? We have a person that likes to change the default colors of controls, and he sometimes comes up with some nasty color combinations. I believe that default colors should be left alone, and the document I'm looking for discusses the rationale behind this a well as other standards to follow when designing forms. Tag: VFP running Access Query/Macro Tag: 189063
  - 8
    - Foxpro and Open Files and Backup and Win 2000 Server Hello - I have a client who has problems with backup because files from my VFP application remain open even after users exit the application. He has made sure that all workstations have exited my application and yet the server still shows that files are open. He is blaming my application. I say it is the responsibility of the server or workstation to properly close out files when users exit my application. I have noticed that when a workstation is accidentally reset or when it freezes some servers will keep files open (like phantom files). Why doesn't the server close these files? I have heard there is a setting in Win 2000 that may be applied so that if a workstation is reset or logs off - all related files are closed. This specific client has Win 2000 server sp4 and win 2000 workstations. All ideas appreciated. Thanks, Mike Tag: VFP running Access Query/Macro Tag: 189061
  - 9
    - VFP6 on XP & WinServer 2003 Anybody know if there are any compatibility issues with VFP6 on XP or WinServer 2003? We're still deploying VFP6 (mostly because of the fact that we don't want to lose the built in install set creation tool) and are concerned that we'll eventually run into a wall with one of these OS's. Thanks for any input you can provide. -- tom c Tag: VFP running Access Query/Macro Tag: 189048
  - 10
    - ODBC Date format Hello, another ODBC question; can I change the date format for queries via ODBC? In fox itself I'd use DATE=BRITISH in the config.fpw or SET DATE BRITISH in code. Can I do anything similar via ODBC? In fact, is there a good resource/document on using ODBC with fox? I'm using the VFP ODBC driver that came with MDAC 2.6 on FPW2.6 tables. -- TIA Andrew Howell Tag: VFP running Access Query/Macro Tag: 189047
  - 11
    - Printer error to a HP PSC 950 from FPw 2.6 application on 98 I keep getting an error when trying to print from a FPW 2.6 application to a HP PSC 950. This printer is an inkjet printer and I'm sending a 100 page document. I'm 99% sure it is error #125, printer not ready. The machine is running Windows 98. Any ideas about what to do here. Also, it is working OK from MS Word. TIA. Boyd Tag: VFP running Access Query/Macro Tag: 189044
  - 12
    - Reindex, Pack pukuzen@bih.net.ba Will Microsoft ever remove FoxPro commands such as Reindex and Pack? Tag: VFP running Access Query/Macro Tag: 189037
  - 13
    - moving file Dear All, Can I moving file from one directory to another by source? if file("backupdb.arj") move to backup directory endif How to write up properly? Many thanks. Regards Wandy Tang Tag: VFP running Access Query/Macro Tag: 189032
  - 14
    - how to move a file from a directory to another directory Dear all, I would like to ask how can I use Foxpro 6.0 to move a file from a directory to another directory? I have tried the dos command "run move e:\test\*.* e:\test1", but it is not ok in foxpro. Please help. Thanks a lot, Ray Tag: VFP running Access Query/Macro Tag: 189031
  - 15
    - SQL join count field MS SQL 2000, VFP 8 2 tables 1.parent: employee_id first_name last_name etc. 2.child: child_id employee_id checked (L) etc. I'd like to get remote view all records from parent table (left outer join) columns: first_name,last_name,(count total related records in child),(count related records in child where not checked) How to do this? Tag: VFP running Access Query/Macro Tag: 189030
  - 16
    - Mailmerge in VFP8 Hello all Iâ??m having a problem using mailmerge from VFP8 trying to use a view as the source Using a table works fine but the fields I need are in different tables. The code Iâ??m using is from the samples in the solution database SELECT (cTable WITH THISFORM.mailmerge .cAppTitle = "DPRS" && application name, used in Alerts .nWordProc = 1 && word processor (1 = Word 6+; 2 = CommaDelim; or user- defined(see below); default = 1 .nNewDoc = 2 && is it a new doc (1 = new, 2 = existing; default = 1 .cDocName = "c:\mailtest.doc .nTemplate = 1 && type of main document (Word only, 1 = form letter; 2 = label; 3 = envelope; 4 = catalog; default = 1 ---------> .cAlias = "roster" && alias of source table or view ****************** .cDBCTable = DBF() && table name if table is part of a DB .cDBCName = DBC() && DBC name if source table is part of a DB ACOPY(gaTemp, .aAutoFields) && fill in array of field names to be use .MakeOutput() && do the merg ENDWIT cTable is set earlier in the code and contains â??rosterâ??. (without the apostrophes. The error I get is Error #1562 in getsqlst(13); cannot find object c:\docume~1\Richard\local~1\temp\FXI4002X.tmp in the databas I also get a message when using the tables that work that FoxPro Files ODBC driver canâ??t be found. I have OBDC32.dll and VFPODBC.dll in the Windows directory Can views be used with Word? Is rthere code somewhere showing how views can be used Any help would be appreciated TIA - Richar Tag: VFP running Access Query/Macro Tag: 189023
  - 17
    - Application Launcher Hi, Currently my vfp application has about 15 users and exe and database is on network. Now I would like to install exe on each work station for better performance. But how do I update changes automatically on each workstation which I make time to time. I know this topic has been discussed many times but could not find it. It will be helpfull if someone can give me the link on the issue. Thanks. Tag: VFP running Access Query/Macro Tag: 189020
  - 18
    - Microsoft Access and Remote Access Views Hello - I'm trying to read an Access database into VFP so that I can convert it to VFP. I start by specifying the connection as Microsoft Access and enter the database name. I'm leaving the UserID and Password blank. From the project manager I then click the New button for a new remote view and select the connection I created. It then asks me to select a database name. I'm not sure why it asks me this since I already specified the database name in the connection. Then it shows me the tables in the database and when I select one I get the error: Connectivity Error: Microsoft ODBC Microsoft Access Driver Record(s) annote be read; no read permission on 'Current' All help appreciated, Thanks. Mike Tag: VFP running Access Query/Macro Tag: 189010
  - 19
    - Are Report Commands Modal? Thanks in advance for any replies. Is the REPORT command modal when it is issued without NOWAIT modal? What I mean is if I have the following code: 1. SELECT CLIENTS 2. SCAN 3. SELECT * FROM INVOICES WHERE CLIENTNUM = CLIENTS.CLIENTNUM INTO CURSOR CLIENTINVOICES 4. SELECT CLIENTINVOICES 5. REPORT FORM INVOICEREPORT TO PRINTER NOCONSOLE 6. SELECT CLIENTS 7. ENDSCAN Does the report finish processing before line 6 is executed? This seems to me to be a basic and obvious question but I have some code that is essentially the same as the code above and sometimes the first report is failing with a "Variable Not Found" error for a variable that is in the query. The other reports are printing correctly. Previously I had this code being called from a form with a private data session and the error occurred every time. I was advised to change the form to use the default data session. At first I thought this had solved the problem but what I've discovered is that the problem still occurs but only about 1 in 10 times instead of every time. Also the code is contained in a PRG that is being called from a menu. When I ran the code with the debugger on it never failed. Also when I ran the code from a button on the form instead of from a menu on the form it didn't fail. If anyone has any clues as to what is going on here I'd appreciate hearing about it. Thanks, Jeff Tag: VFP running Access Query/Macro Tag: 189001
  - 20
    - Returning array from control back to form through property Is it possible to return an array to a form from a custom control? I have an array i need to pass back to the parent form of the control that created it... thanks Tag: VFP running Access Query/Macro Tag: 189000
  - 21
    - Beginner book Hey all, Yes, Hentzenwerke.com. That assumption made, I've got a new developer with a lot of web dabbling and not much formal training are large app experience. Hentzenwerke suggests Fundamentals as the first book. I know it covers 6, but the basics have not changed a lot since then so that makes some sense to me. Anyone have any experience w/ this book or another recommendation as to which to start a newbie off with? TIA, John Tag: VFP running Access Query/Macro Tag: 188998
  - 22
    - Returning Arrays Does anyone know how to return an array using the unload event of a modal form? I keep getting a data type mismatch error. Is there a way to pass the array by value rather than by reference? Thanks in advance, Royce. Tag: VFP running Access Query/Macro Tag: 188996
  - 23
    - odd cursor I have the following query: SELECT ; invoice_value; IIF(DATE() > due_date , invoice_value, 0.00) AS to_pay ; FROM myInvoices ; INTO CURSOR qTmpInvoices I.e. : If I have 2 invoices: Invoice 1: invoice_value = 50, due_date = 03.01.2004 Invoice 2: invoice_value = 7000, due_date = 01.01.2004 my resulting cursor after the query will contains: 50, 0 7000,*** If I replace 0.00 with the 0000.00 my resulting cursor after the query will contains: 50, 0 7000, 7000 Is that possible? I am using VFP 8 SP1 on Windows 2000 SP4. Thanks in advance Sanjin Tag: VFP running Access Query/Macro Tag: 188995
  - 24
    - Strange situation with AFIELDS() function I am running the AFIELDS function in a class in my program. It works on every situation but one, and it acts very strangely. It will only create the array with 16 columns, this causes a problem because then the 17th and 18th column get put into the row 2 column 1 and 2, and then the next field gets pushed back 2 columns. Any Ideas what is causing this? Tag: VFP running Access Query/Macro Tag: 188991
  - 25
    - Centralised/distributed database system via VSAT Have you ever seen any Centralised System via V-SAT, that is developed in Visual Foxpro? Is Vfp supports for Centralised Database System? If Yes, please give tips/guidelines/hints about how is it can be achieved? PUSHPAK. Tag: VFP running Access Query/Macro Tag: 188984

Hi

Do you know of a way to run an Access query/macro from within VFP. No ODBC
Similar to usin

loXL = getobject('','Excel.Application'
loWB2 = loXL.Workbooks.open('c:\earnedvalue\module\earned_value_data_shell.xls'
loWB2.Application.Run('earned_value_data_shell.xls!import_data'

to run an Excel macro

Thanks
Ga

Top

Re: VFP running Access Query/Macro by Rick

Rick
Tue Feb 03 07:56:14 CST 2004

Gar,
You might want to ask this question in an Access forum. They'd probably =
better know how (and whether) you can automate Access's "macros" - I =
believe these are fundamentally different from Office (Word, Excel, =
Powerpoint, Outlook) macros.One you have the technique it should be =
trivial to write the code in VFP - especially with the Intellisense in =
VFP 7/8.

Rick

"Gar" <anonymous@discussions.microsoft.com> wrote in message =
news:B541F939-F204-498E-B0E6-1410BB5537C3@microsoft.com...
> Hi,
>=20
> Do you know of a way to run an Access query/macro from within VFP. No =
ODBC.
> Similar to using
>=20
> loXL =3D getobject('','Excel.Application')
> loWB2 =3D =
loXL.Workbooks.open('c:\earnedvalue\module\earned_value_data_shell.xls')
> loWB2.Application.Run('earned_value_data_shell.xls!import_data')
>=20
> to run an Excel macro.
>=20
> Thanks,
> Gar
>

Top