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 TouchToneTommy 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: *

  1. powella

    Performance issue

    Can you be more specific? They are getting a blue screen or what is meant by "goes down"? Are you running 8.0.1? CF 8 has not been out a couple of years so you must have upgraded and you were having problems in 7 too. ... ?
  2. powella

    Sanitizing user input

    HTMLEditFormat() will preserve the brackets and other characters that could be valid in comments (instead of removing them). Just make sure you handle these on the display end too. http://livedocs.adobe.com/coldfusion/8/htmldocs/functions_h-im_04.html And lets not forget the harmful sql code...
  3. powella

    adding line break after x number of characters

    If you want an html break you could add or replace with <br> <cfset lineFeed = "<br />"&chr(13)&chr(10)> ok and if you wanted it every 20 characters change to a mod function and use i <cfscript> for (i=1; i lte len(myString); i=i+1) { if (i mod lineBreakPos eq 0) {...
  4. powella

    debugging cfcs

    That would give you the most control. In our production environment we have all errors emailed to the support group and just dump the error object <cfdump var="#CFCATCH#"> with SQL and other code (line numbers) that are involved.
  5. powella

    one purchase per session?

    I wouldn't take it to mean a literal session (ie CF session). You don't want them to hit the back button and submit the payment again as that would almost never be intentional and you wouldn't want the hassle of a double charge. On the other hand you don't want to prevent the user from starting...
  6. powella

    Populating a Barcode field in a PDF

    The link to the PDF is absolute, like so C:\PDFComps\Dec\blankform.pdf The barcode field is a built in form field we have added with Acrobat 8 Pro. The field appears to work just fine if you open the PDF and some validation script runs, but if you don't open it and don't cause the script to...
  7. powella

    Populating a Barcode field in a PDF

    We are using cfpdfform tag to populate a PDF. The goal will be to print these as certificates in coldfusion without needing to open them and print. In the PDF we have a barcode form field that we want to have populated. The obvious answer is to tie the value to another text field that holds the...
  8. powella

    Using VBA to populate text fields with report statistics

    David, Have you considered opening a record set in your code? If you report is not to slow you could requery the data with a group by clasue and get your totals. Dim conn as String Dim rsQuery As dao.Recordset conn1 = "Slect * from talbe1" Set rsQuery =...
  9. powella

    Input Mask Textbox

    I don't see how "design view of the table" helps us hide a password in a text field.
  10. powella

    Alternating Shading between records

    >> " However i changed the "Const XorToggle = 4144959" to "Const XorToggle = VBYellow" and I get solid blue. Did i do somehting wrong or is it because i am still useing Access 97? " you are just one step off. To get any color you want just start with an XOR for your constant. For yellow try...
  11. powella

    Excel Template to Access Report

    oops, I was wrong. Here is an MSDN document on it: http://msdn.microsoft.com/library/en-us/olfm11/html/rerefPictureSizeModeProperty1_HV03077469.asp?frame=true 0 Crops any part of the picture that is larger than the form or page (default). 1 Stretches the picture to fill the form or page. This...
  12. powella

    Excel Template to Access Report

    I believe PictureSizeMode = 1 is the zoom mode. I should expand or shrink to fill the picture box, or page as a background image.
  13. powella

    Print modified copies of a report

    Thank you ProgramError. I am close to posting my code. I have figured out a way to get the copies to print to a different tray. I have some duplicate code in two places. so I need to narrow down which cod is actually doing the work and then I can post it
  14. powella

    Remembering page margins?

    RoyVidar, Can you please look at my question? http://www.tek-tips.com/viewthread.cfm?qid=1037629&page=1 I want to alternate printer bins. Basicaly everyother page (even vs odd). It is looking for this solution that I found the link above and this posting. I just thought it might be useful to...
  15. powella

    Print modified copies of a report

    well to answer some of my own question. I can get two copies with this code: If PrintCount < 2 Then Me.NextRecord = False Printer.PaperBin = acPRBNLower Else Printer.PaperBin = acPRBNMiddle Me.NextRecord = True End If I can insert a function call to add the "copy"...
  16. powella

    Remembering page margins?

    Check out Microsoft's printer settings. will work in mde too. They have a demo DB that you can copy code from too: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_Printers.asp you can set the margins that way.
  17. powella

    Print modified copies of a report

    For record keeping purposes I want a second copy of a report to print. I want to have the original copy print and then I will load a picture or change a text box and then print again. I want this to happen when the user clicks print from the report. The goal is to have the copy say copy or...
  18. powella

    images display in print preview but not in printed report

    I had this too. I had to had the image loading code to: Report_Page() and Sub Detail1_Print(Cancel As Integer, PrintCount As Integer) so that the images would conditionaly display on the screen and on the printed page. I just created my own sub and called it from each
  19. powella

    Print a batch of checks

    or you could use a temp table. The makers of our accounting software do it this way. Then comit at the end. They have a form and when you print and return to the form it asks if the checks printed correctly. if you click no then the batches are not procesed. I.E. it pretends nothing happend
  20. powella

    Setting printing defaults in a report

    Check out Microsoft's printer settings. will work in mde too. They have a demo DB that you can copy code from too: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_Printers.asp

Part and Inventory Search

Back
Top