Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DaveL
  • Content: Threads
  • Order by date
  1. DaveL

    Listbox Positioning

    Is there a way to position in a listbox using more than one character... in other words, I would like to start typing out a word and have the listbox positioned based on ALL of the characters that have been typed, not just the first character... similar to the way it works for a combo box.
  2. DaveL

    E-mail Updated Word Document as Attachment

    After having the user populate fields on a form, I would like to allow the user to click on a button that would merge the data from the fields on the form with a Microsoft Word Template, save the updated Word document to a predetermined path and name, then open up a new e-mail (email address is...
  3. DaveL

    Is Outlook Open?

    Using Access 2000 and Outlook 2000 I am trying to create a new task in Outlook from within Access. I have it working if Outlook is already open. Can anyone share with me the code that will check to see if Outlook is open, and if not, open Outlook in order to create the new task? Thanks!
  4. DaveL

    Form List with Numbers?

    I have four products on a form where the user will enter the prices for products. If they input a comma with the price (when the price > 999.99), the resulting form list sees the extra comma as a delimeter and my results are messed up: My list entries look like the following: PRICE equals...
  5. DaveL

    Run-time error ‘3211’

    I am trying to populate a subform in my form using a make-query based on the value selected in a combo box on the form. When the value selected in the combo box changes, I want to change the data in the subform. I am then allowing the user to select or deselect individual records on the...
  6. DaveL

    TextArea Formatting

    Can anyone give me ideas on editing tools I can use to allow users to enter content in one or more textareas on a form and give them the ability to apply a nice format to the content? I know about ewebeditpro and activedit. Are there others? Thanks!
  7. DaveL

    Simple Search String Stored Procedure?

    I have a simple search string being passed from a form that can contain multiple words separated by spaces.... "word1 word2 word3". Can anyone give me ideas on the simplest way to create a stored procedure that will select any records in a table (table1) where a specific column...
  8. DaveL

    Popup help?

    Can anybody tell me what I am doing wrong here? I am trying to create a simple popup. It works fine in IE, but not in Netscape 4.72. In Netscape it is giving me the error &quot;The parameter is incorrect&quot;. Following is the code I am using: Code for the driver: <html> <head>...
  9. DaveL

    CF_Counter_Image Custom Tag

    Can anybody who has used the CF_Counter_Image Custom Tag tell me if it works for them?
  10. DaveL

    Passing Variables?

    I have a shopping cart checkout form with multiple image submit buttons on it including &quot;update count&quot;, &quot;calculate shipping&quot; and &quot;finalize order&quot;. My problem is... what is the best way to hold onto the checkout form values such as name, address, email address...
  11. DaveL

    Reattach CDX files?

    Is there an easy way to reattach CDX files to the free tables in my database? I am trying to convert the data from the tables in a previous version of our application into the newly formatted tables in our new application. What I have done is copied the DBF files from the old application...
  12. DaveL

    Passing Variable from form to form?

    What is wrong with this code? I know it something basic, but I cannot figure it out? I am just trying to figure out how to pass a field value from one form to another. In this case when the button for TestForm0 is clicked, the program opens up TestForm1. I am trying to get TestForm1 to...
  13. DaveL

    Local Parameters

    I am trying to set and pass a local parameter from a form to a program that runs an SQL / report. Click Event Code parm1 = ThisForm.formvar1.Value parm2 = ThisForm.formvar2.Value parm3 = ThisForm.formvar3.Value DO procedure1 WITH parm1, parm2, parm3 Program Code PROCEDURE procedure1...
  14. DaveL

    Passing Parameters?

    I have a form that collects user input to be used for producing a report. When the &quot;Print&quot; button is clicked, I want to call an external program to print the requested report. How do I pass parameters to and receive parameters in the print program? [code] ** Call report program from...
  15. DaveL

    Update during SCAN / ENDSCAN ?

    How do I update the current record while looping through a SCAN / ENDSCAN? select * from filea SCAN update filea.field1 = 999 ENDSCAN Thanks!
  16. DaveL

    File is not open ???

    Why am I getting a &quot;File is not open&quot; error? The following code inserts 1 record into the dave_test table but when it hits the endscan command, it gives me the error. I am trying to get it to loop through cursor4??? Thanks! use next_nbr in 2 use dave_test1 in 3 select * from...
  17. DaveL

    VFP 6.0 Report with Cursor - No Records Found???

    I am creating very simple reports that are populated by cursors. My problem is that when there are no records in the cursor, the report does not execute. I need the report to print with a message such as &quot;No Records Found&quot;. I know it is a simple concept, but I can't seem to find an...
  18. DaveL

    SQL Problem ?

    I am trying to update a column in FileA (field1) with a column from FileB (field1) where the key fields, field2 and field3, match. The program is updating the field, but with blanks instead of the value from fileB.field1. Any ideas on what I am doing wrong? Thanks! UPDATE fileA; SET...
  19. DaveL

    Basic Update SQL

    Can anyone tell me what I am doing wrong with this basic Update SQL statement? It seems like a pretty simple problem. I am trying to update a column in FileA (field1) with a column from FileB (field1) where the key fields, field2 and field3, match. What am I missing? Thanks! UPDATE FileA ...
  20. DaveL

    SubQuery Error

    Can someone please point out where I am going wrong in this basic SQL statement? In FoxPro 6.0, I am trying to write a simple query program. When I run the following SQL, I am getting an error that reads &quot;SQL: Subquery is invalid&quot;. select *; from cont_det; where cont_det.contract in...

Part and Inventory Search

Back
Top