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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jonathanmb

  1. jonathanmb

    Print double sided form

    Maybe look at the Duplex Property of the Printer object? -- Jonathan
  2. jonathanmb

    I need help about code to send email from vb6

    Recent thread discussing sending e-mail... thread222-734914. There are quite a few threads in this forum if you just do a search for sending e-mail. As far as command line arguments, take a look at the Command$ function. Here's a thread on it... thread222-684007. -- Jonathan
  3. jonathanmb

    Data from form at top of Datareport??

    I should have mentioned... replace DataReport in the above code with the name of your DataReport. It's just like any other object or control... objName.xxx. -- Jonathan
  4. jonathanmb

    Data from form at top of Datareport??

    You can set the label's caption equal to a control's value, yes. -- Jonathan
  5. jonathanmb

    Data from form at top of Datareport??

    This can be done using something like... DataReport.Sections("ReportHeader").Controls("lblFillMeIn").Caption = "Filled In" Of course, you'd need to change the section and control names accordingly. -- Jonathan
  6. jonathanmb

    Hardcoded Server Path

    Don't harcode it? Maybe store the path in an outside file or in the registry? -- Jonathan
  7. jonathanmb

    Trying to avoid huge If/Case statements!!!

    Well if there's only 1 of 3 options for an output, wouldn't you only have a need for 3 conditions rather than 64? -- Jonathan
  8. jonathanmb

    Losing digit when converting string to double if = 00

    You could use the Format function to force your expression into a certain format (i.e. Format("0","00") returns "00"). -- Jonathan
  9. jonathanmb

    Advanced programming style discussion

    For those interested, there was a paper written by Wulf and Shaw in 1973 titled "Global Variable Considered Harmful." I had difficulty finding it online anywhere other than in the ACM Digital Library. http://portal.acm.org/citation.cfm?id=953355&jmp=references&dl=ACM&dl=ACM Some of...
  10. jonathanmb

    Sub Total in Access Datareport

    I'm not a heavy Access Report designer myself... my first thought would be to add a Group Footer band. My initial reply was only to redirect others who might wish to respond to a post that already had responses. Good luck. -- Jonathan
  11. jonathanmb

    Sub Total in Access Datareport

    thread222-747042 -- Jonathan
  12. jonathanmb

    returning value of a folder (directory)

    Perhaps this might help... http://www.andreavb.com/tip030001.html -- Jonathan
  13. jonathanmb

    HOW TO SETUP "REPORT WIDTH" & "WIDTH" PROPERTIES OF DATA

    Unfortunately, I think DataReports are limited to only 8.5" x 11" in size. Someone please correct me if I'm wrong. -- Jonathan
  14. jonathanmb

    HOW TO SETUP "REPORT WIDTH" & "WIDTH" PROPERTIES OF DATA

    ReportWidth deals with the width of the report. Width deals with the width of the print preview window's size. -- Jonathan
  15. jonathanmb

    Add New not occuring, even though AddNew function executes error free.

    Check for an error after you update the recordset. Is there one? Comment out On Error Resume Next to see what is happening? I don't believe you're handling error 3265 correctly. My ADO Error Reference is saying that a field is probably misspelled. If that's the case, you're not handling the...
See more

Part and Inventory Search

Back
Top