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 John Tel 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: gfrlaser
  • Order by date
  1. gfrlaser

    insert record

    I needed to use this again... :-)
  2. gfrlaser

    Replacement for VFP

    Forgive my ignorance. Can someone explain the basics/benefits/fallbacks of Unicode database products versus say, my favorte, Foxpro. What is and where can I research a Unicode product?
  3. gfrlaser

    Why the retreat from VFP in a budget conscious economy?

    Add to that, so many people making very, very complicated programs using Access. I have three projects going now that were created in Acess that are now hopelessly broken and no one can fix. Patches galore over time. I am simply rewriting the entire projects in Fox. Takes only a few hours, easy...
  4. gfrlaser

    collecting varible data per person in table

    ...because they hold more than one policy. OK.. the code I used to fix the first problem... Please don't laugh, I had to do something QUICK. ***************************** set safety off use members copy to table1 set dele on select 1 use table1 copy to table1bak close all select 1 use...
  5. gfrlaser

    collecting varible data per person in table

    I feel like I might be getting somewhere. here are the revisions. However at this point..... *** Insert Into donationsconsolidated; Values (m.CName, m.Ca1, m.Ca2, m.Ccity, m.Czip, m.Ccountry, m.Cdate, m.Ccode, m.Camount) *** I recieve a data type mismatch error... I can see no errors in...
  6. gfrlaser

    collecting varible data per person in table

    I have 6220 records. This is one of things that just drive me nuts. I have too many jobs to work on I guess. No wonder I am burning the midnight oil.
  7. gfrlaser

    collecting varible data per person in table

    ...Scan h = h + 1 atem[i,h] = temp.pdate h = h + 1 atem[i,h] = temp.amount Select temp Endscan ************************ Clear All Use table1 Select Distinct cName,city, state From table1 Order By 1,2,3 Into Cursor discursor i = 0 h = 3 Select...
  8. gfrlaser

    collecting varible data per person in table

    Glad I gave you a chuckle <grin>. At least you didnt break my puter. LOL If I had my way I would be using a report but I am required to give the data to another department who will carry the ball from there however they want. I will be working on this code this morning. I really appreciate...
  9. gfrlaser

    collecting varible data per person in table

    ...the .tmp file was too large at the line; Insert values into donationsconsoldated; Values(m.Cname,m.Cad1) Etc. here is the code... any ideas? ****2/9/09 ****code to create donor table for merge to letter Select Name,a1,a2,city,st,zip,country,Date,Code,amount; from members.Dbf; order By...
  10. gfrlaser

    collecting varible data per person in table

    Ok. Makes sense. Someone else told me I could not use SQL to make this work. I knew I would have to considate the data somehow though. It's a one time job and I just need to get the data together and send it to the laser printing department for print. I will try to pull together what you suggest...
  11. gfrlaser

    collecting varible data per person in table

    I have a table of donors, the name and address is repeated up to 10 times with the date of the gift and the dollar amount of the gift different in each record. John Adams 123 anystreet 9/10/08 $100 John Adams 123 anystreet 6/06/08 $50 John Adams 123 anystreet 3/15/08 $100 John Adams...
  12. gfrlaser

    Automating email

    Thanks. I think I got it going ok now. Took more than I thought it was going to.
  13. gfrlaser

    Automating email

    I checked out the above link. Thanks. Upon copying pasting the code from berezniker's post to the command button (to edit the send, attachments etc.) I receive the following error. "Methods and Events cannot contain nested procedures error" Does this require to be run from a prg only as...
  14. gfrlaser

    Automating email

    ...for your help. o=createobject("outlook.application") oitem=o.createitem(0) oitem.subject="Email From VFP6" oitem.to="someone@testing.com" ** To send copy to addresses.. oitem.body="This mail was sent from vfp using Microsoft Outlook" ** To attach a file...
  15. gfrlaser

    interactive pdf's

    Thanks. I will look at third party software then. Will
  16. gfrlaser

    interactive pdf's

    I currently use live cycle to create an interactive PDF form for our department schedules. What I want to do is create a form for data entry and export that from a report form to a PDF. Is there a way to create that PDF form to be interactive similar to the way Live Cycle allows me to do? Can I...
  17. gfrlaser

    Random populate a field

    I have not seen the letter of the law. I am under the assumption that if I were to generate 1,000,000 seperate strings or characters that they would need to be unique and not sequential, hence random. To test it I simply indexed unique. Duplicates were generated about a rate of 48 or so each...
  18. gfrlaser

    append check digits

    I see. Thanks. The 128C is the barcode most likely to be used in this project.
  19. gfrlaser

    Random populate a field

    I've read somewhere else about that point, starting with rand(-1). Fortunately this is not for a lottery. Its for a retail chain that is going to hold a sweepstakes. the law says the numbers must be random, that is not a problem now with the above code supplied by Mike. I will add the -1 to the...
  20. gfrlaser

    append check digits

    I didnt think anything that easy would work! So if my data contains a field bnum with "F6X32K3AA"... replace field chk with Left(SYS(2007,bnum),1) will give me a valid check digit, right? Its critical I am right about this. Thanks for your reply. Happy new year!!

Part and Inventory Search

Back
Top