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

    ok. I hope you excuse me if I mis understood. I did change the order, I put the date and amount last, however the order of the dates really dont matter at this stage. I am too bad at doing this foxpro programming stuf, but not anywhere near as good as you guys. I had to get this thing done and...
  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

    I received an error 'script outside defined range'. Any idea how to get past this? it happened at this point: Scan h = h + 1 atem[i,h] = temp.pdate h = h + 1 atem[i,h] = temp.amount Select temp Endscan ************************ Clear All Use...
  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

    Hmm.. first time I have ever hung up my entire computer... I created the code you suggested as follows, Windows reported that 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...
  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

    I used Ramanis' code I found in the FAQ to add to a command button in my form. The form hangs up and email is attempting to send in the backgound. I must use task manager to end the program. What can I add to this code to make it work for me? Thanks for your help...
  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