Search results for query: *

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!

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

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

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!

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

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

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

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

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 =...

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

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

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

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!

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!

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

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

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

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!

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!

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