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!

Register Log in
  • 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: DarrenWard
  • Order by date
  1. DarrenWard

    Using a function with with sub totals on report

    I set up a variable within the report (something id not used or concidered before) and now its working fine. Thank you both. Darren. GuiltyMaggot - The best rock band in the world!
  2. DarrenWard

    Using a function with with sub totals on report

    Just to clarify, the report is grouped on the 'name' field with a sub total summing the 'number' field with the function wrapped around it. I assumed that the number would be totaled and then have the function applied to it, but it appears that it works the other way around. Darren...
  3. DarrenWard

    Using a function with with sub totals on report

    Mike, Thank you for your help so far, can you do me a favour; CREATE CURSOR _temp(name c(1), number n(5)) SELECT _temp APPEND BLANK REPLACE name WITH "A", number WITH 12345 APPEND BLANK REPLACE name WITH "A", number WITH 23456 APPEND BLANK REPLACE name WITH "B&quot...
  4. DarrenWard

    DIR function

    The DIR command is used to return information on FocPro data files, to receive information on other types of files use the ADIR() command. Darren GuiltyMaggot - The best rock band in the world!
  5. DarrenWard

    Using a function with with sub totals on report

    Cheers Mike, I thats pretty much what I thought at first but making the field on the report as large as you like makes no difference, I still just get the same about of stars. If I just have the sum of the field it print the value fine, but if I put SecondsToTime(_TimeTaken) as a summed field...
  6. DarrenWard

    Using a function with with sub totals on report

    I have a function that turns seconds into a time string. ie. you put in 12365 and get out "03:26:05" I use it in a report and it works fine on the Detail of the report, but when I use it on the sum in the Group Footer, I just get three stars print out. Is there a problem with using a...
  7. DarrenWard

    E-mails

    I do the same thing at the moment using the MAPIMessages and MAPISession controls, using this instead of the outlook control allows the software to work on the computers in my organisation that have either Outlook or Groupwise installed. I have a timer that reads through unread emails in the...
  8. DarrenWard

    Strange report error

    All code is running on my machine, there is definately something wrong with this form and the reports data session, it prints perfectly to the screen using the data expected but then closes the wrong table, I can get it to work if I cut and paste the code again, store the current record pointer...
  9. DarrenWard

    Strange report error

    I have an ActiveX on a form and also an ActiveX Bound Control. And the following code; CREATE CURSOR _report (bcText c(50), BC g) SELECT _report APPEND BLANK REPLACE bcText WITH "123456789" APPEND GENERAL BC CLASS TBarCode5.TBarCode5 WITH THISFORM.BoundControl .CONTROLSOURCE =...
  10. DarrenWard

    Putting picture in report at runtime

    If I use the above I get a OLE Invalid class string error. Darren GuiltyMaggot - The best rock band in the world!
  11. DarrenWard

    Putting picture in report at runtime

    Thanks mike, This is kinda where I was going, but I cant seem to get the picture into the General field of the cursor, any chance of a quick bit of pseudo code to point me in the right direction. I have worked out that I need to use something like; APPEND GENERAL myCursor.Picture Class...
  12. DarrenWard

    Putting picture in report at runtime

    Sorry to be a pain, I was playing with this over the weekend and still cannot get this to work, can it be done? I came across some sample code that used a bound control in conjuction with an ocx and the a general field in a table but I couldnt make it work. Darren GuiltyMaggot - The best rock...
  13. DarrenWard

    Putting picture in report at runtime

    Wouldnt there be a way to drop the picture into a General field in a table then access the picture within the form from there? Darren GuiltyMaggot - The best rock band in the world!
  14. DarrenWard

    Putting picture in report at runtime

    The control has a picture property as stated in the original post, the same as an Image control, in VB I could use something like; Printer.PaintPicture oleControl.Picture, XPos, YPos Darren GuiltyMaggot - The best rock band in the world!
  15. DarrenWard

    Putting picture in report at runtime

    Griff, The barcode font is definately the easiest way to go, there is going to be a cost involved no matter which way I go as this is software that will be utilised on various different client machines, so that is not really an issue. Is there an wasy way to get get a controls picture into a...
  16. DarrenWard

    Putting picture in report at runtime

    I am trying out a barcode ocx that has a picture property, I want to print a report or run off lables and put the barcode on them, the barcode will be different for every page/label, I have bound the ocx to the data but am struggling to get the picture into the report, help! On a slightly wider...
  17. DarrenWard

    Want empty cell if no find

    I have three tables, table one has a relation set to table two and table two has a relation set to table three. On my form I have a grid, all but the last column set is to a field out of table one, the last column is populated by a field out of table three. Most of the time the data in table...
  18. DarrenWard

    Is Expression String or Value

    Thanks Brian, this was driving me mad, have been looking though the help for over an hour looking for a 'IsNumeric' or simular, thanks again. Darren GuiltyMaggot - The best rock band in the world!
  19. DarrenWard

    Is Expression String or Value

    How can I tell if an Expression is a String or a Value? e.g. I could either do; _TmpVar = "Darren" or _TmpVar = 123456 But I cant find a way of telling what was done in the help. Darren GuiltyMaggot - The best rock band in the world!
  20. DarrenWard

    MAPI .msgNoteText Problem

    I have just written some code that reads in-comming emails and replies to them with attached files, but I am getting weird results with the .msgNoteText property. THIS WORKS; thisform.MAPIMessages.Reply thisform.MAPIMessages.msgNoteText = " " thisform.MAPIMessages.AttachmentIndex = 0...

Part and Inventory Search

Back
Top